| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For DSDDeals |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
| order_no |
number8 |
1 |
1 |
Not used by SIM |
n/a |
n/a |
null |
null |
Yes |
Not used by SIM. |
| supplier |
varchar210 |
1 |
1 |
Not used by SIM |
n/a |
n/a |
null |
null |
Yes |
Not used by SIM. |
| store |
number10 |
1 |
1 |
This field contains the location that the shipment will be delivered to. |
n/a |
n/a |
null |
null |
Yes |
Not used by SIM. |
| dept |
number4 |
0 |
1 |
Not used by SIM |
n/a |
n/a |
null |
null |
No |
Not used by SIM |
| currency_code |
varchar23 |
1 |
1 |
Not used by SIM |
n/a |
n/a |
null |
null |
Yes |
Not used by SIM. |
| 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) |
n/a |
n/a |
null |
null |
Yes |
Not used by SIM. |
| ext_ref_no |
varchar230 |
0 |
1 |
Not used by SIM |
n/a |
n/a |
null |
null |
No |
Not used by SIM. |
| 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. |
n/a |
n/a |
null |
null |
No |
Not used by SIM. |
| 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. |
n/a |
n/a |
null |
null |
No |
Not used by SIM. |
| 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. |
n/a |
n/a |
null |
null |
No |
Not used by SIM. |
| 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 |
Not used by SIM. |
| shipment |
number10 |
1 |
1 |
The corresponding shipment for the order that was applied by the deal. |
n/a |
n/a |
null |
null |
No |
Not used by SIM. |
| invc_id |
number10 |
1 |
1 |
Contains the invoice number for the purchase order of this deal. |
n/a |
n/a |
null |
null |
No |
Not used by SIM. |
| invc_ind |
varchar21 |
1 |
1 |
Inidcates whether an invoice was created for this receipt by the supplier. |
n/a |
n/a |
null |
null |
Yes |
Not used by SIM |
| vdate |
xs:dateTime |
1 |
1 |
Not used by SIM |
n/a |
n/a |
null |
null |
Yes |
Not used by SIM. |
| qty_sum |
number12_4 |
1 |
1 |
Not used by SIM |
n/a |
n/a |
null |
null |
No |
Not used by SIM. |
| cost_sum |
number20_4 |
1 |
1 |
Total merchandise cost for the invoice. This field will be held in the invoice currency. |
n/a |
n/a |
null |
null |
No |
Not used by SIM. |
| ext_receipt_no |
varchar217 |
1 |
1 |
Description is not available. |
NA |
NA |
NA |
NA |
NA |
NA |
|
ExtOfDSDDealsDesc:ExtOfDSDDeals
|
*
|
0
|
1
|
Provide an extension hook to customize DSDDeals.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
LocOfDSDDealsDesc:LocOfDSDDeals
|
*
|
0
|
1
|
Provide an extension hook to localize DSDDeals.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
