Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For DSDReceipt |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
supplier |
varchar210 |
1 |
1 |
Unique identifying number for a supplier for the receipt. |
RK_SHIPMENTS |
FROM_LOCATION_ID |
VARCHAR2 |
128 |
No |
|
origin_country_id |
varchar23 |
1 |
1 |
The identifier of the country from which the item is being sourced. |
RK_ITEM_SUPP_COUNTRY |
COUNTRY_ID |
VARCHAR2 |
3 |
Yes |
|
store |
number10 |
1 |
1 |
Not Yet Available |
RK_SHIPMENTS |
STORE_ID |
NUMBER |
10 |
Yes |
|
dept |
number4 |
0 |
1 |
The department in which are all the items on the order. This field is required if the system enforces single department ordering. |
AS_ITM |
DEPT_ID |
NUMBER |
12 |
No |
|
currency_code |
varchar23 |
1 |
1 |
Contains a code identifying the currency the supplier uses for business transactions. |
|
|
|
|
No |
Contains a code identifying the currency the supplier uses for business transactions. |
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). |
|
|
|
|
No |
Populated by SIM with an empty value |
ext_ref_no |
varchar230 |
0 |
1 |
Not Yet Available |
RK_SHIPMENTS |
INVOICE_ID |
VARCHAR2 |
128 |
No |
|
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. |
|
|
|
|
No |
Populated by SIM with an empty value |
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 |
|
|
|
|
No |
Populated by SIM with an empty value |
payment_date |
xs:dateTime |
0 |
1 |
Date when the invoice was paid from the POS system. This field will be populated when the invoice is interfaced through ReSA. |
|
|
|
|
No |
Populated by SIM with a null value |
invc_ind |
varchar21 |
1 |
1 |
Inidcates whether an invoice was created for this receipt by the supplier. |
|
|
|
|
No |
'Y' if RK_SHIPMENTS.INVOICE_ID exists else 'N'. |
deals_ind |
varchar21 |
1 |
1 |
Valid values are 'Y' and NULL. This field decides whether deals need to be applied to the order or not. |
|
|
|
|
No |
SIM sets the constant value 'Y' |
DSDDtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
DSDNonMerch
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ext_receipt_no |
varchar217 |
0 |
1 |
This field holds the external transaction sequence number for the receipt. |
RK_SHIPMENTS |
SHIPMENT_ID |
VARCHAR2 |
128 |
Yes |
|
ExtOfDSDReceiptDesc:ExtOfDSDReceipt
|
*
|
0
|
1
|
Provide an extension hook to customize DSDReceipt.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfDSDReceiptDesc:LocOfDSDReceipt
|
*
|
0
|
1
|
Provide an extension hook to localize DSDReceipt.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|