XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for DSDDeals in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
order_no |
number12 |
1 |
1 |
Not used by SIM |
ordhead |
order_no |
number |
12 |
Yes |
The order number to which the deal should be applied. |
supplier |
varchar210 |
1 |
1 |
Not used by SIM |
invc_head |
supplier |
null |
null |
Yes |
Invoice supplier's number. |
store |
number10 |
1 |
1 |
This field contains the location that the shipment will be delivered to. |
shipment |
to_loc |
number |
10 |
Yes |
This field contains the location to which the shipment will be delivered. |
dept |
number4 |
0 |
1 |
Not used by SIM |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
currency_code |
varchar23 |
1 |
1 |
Not used by SIM |
n/a |
n/a |
null |
null |
Yes |
Not used by RMS. |
paid_ind |
varchar21 |
1 |
1 |
Indicates if the invoice has already been paid. Valid values are 'Y' (invoice has already been paid) or 'N' (invoice should be paid in AP system) |
invc_head |
paid_ind |
varchar2 |
1 |
Yes |
Indicates if the invoice has already been paid. Valid values are Y (invoice has already been paid) and N (invoice should be paid in AP system). |
ext_ref_no |
varchar230 |
0 |
1 |
Not used by SIM |
invc_head |
ext_ref_no |
varchar2 |
14 |
No |
Supplier-generated invoice number. |
proof_of_delivery_no |
varchar230 |
0 |
1 |
Proof of delivery or service number, given at the time of receipt at the store. This field will be populated when the invoice is interfaced through ReSA. |
invc_head |
proof_of_delivery_no |
null |
null |
No |
Proof of delivery or service number, given at the time of receipt at the store. This field is populated when the invoice is interfaced through ReSA. |
payment_ref_no |
varchar216 |
0 |
1 |
Reference number attached to the invoice payment, used when the invoice is paid from the POS system and interfaced through ReSA. |
invc_head |
payment_ref_no |
null |
null |
No |
Reference number attached to the invoice payment; used when the invoice is paid from the POS system and interfaced through ReSA. |
payment_date |
xs:dateTime |
0 |
1 |
Date that the invoice was paid from the POS system. This field will be populated when the invoice is interfaced through ReSA. |
invc_head |
payment_date |
RIBDate |
* |
No |
Date that the invoice was paid from the POS system. This field is populated when the invoice is interfaced through ReSA. |
deals_ind |
varchar21 |
1 |
1 |
Specifies whether deals will be applied to the generated order. If set to 'Y', the procedure APPLY_DEALS_TO_ORDER will be called. |
n/a |
n/a |
null |
null |
Yes |
Specifies whether deals will be applied to the generated order. If set to Y, the APPLY_DEALS_TO_ORDER procedure is called. |
shipment |
number12 |
1 |
1 |
The corresponding shipment for the order that was applied by the deal. |
shipment |
shipment |
null |
null |
No |
The corresponding shipment for the order that was applied by the deal. |
invc_id |
number10 |
1 |
1 |
Contains the invoice number for the purchase order of this deal. |
invc_head |
invc_id |
null |
null |
No |
Contains the invoice number for the purchase order of this deal. |
invc_ind |
varchar21 |
1 |
1 |
Inidcates whether an invoice was created for this receipt by the supplier. |
n/a |
n/a |
null |
null |
Yes |
Indicates whether an invoice was created for this receipt by the supplier. |
receipt_date |
xs:dateTime |
1 |
1 |
Not used by SIM |
shipment |
ship_date |
null |
null |
Yes |
Contains the receipt date of the RMS application. |
qty_sum |
number12_4 |
1 |
1 |
Not used by SIM |
invc_head |
total_qty |
null |
null |
No |
Total quantity of items on the order to be invoiced. |
cost_sum |
number20_4 |
1 |
1 |
Total merchandise cost for the invoice. This field will be held in the invoice currency. |
invc_head |
total_merch_cost |
null |
null |
No |
Total merchandise cost for the invoice. This value is expressed in currency used in the invoice. |
ext_receipt_no |
varchar217 |
1 |
1 |
Description is not available. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |