XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for DSDReceipt 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 |
supplier |
varchar210 |
1 |
1 |
Unique identifying number for a supplier
for the receipt. |
ordhead |
supplier |
null |
null |
Yes |
Number to uniquely identify a supplier for the receipt. |
origin_country_id |
varchar23 |
1 |
1 |
The identifier of the country from which
the item is being sourced. |
ordsku |
origin_country_id |
null |
null |
Yes |
The identifier of the country from which the item is being sourced. |
store |
number10 |
1 |
1 |
Not Yet Available
|
store |
store |
number |
10 |
Yes |
Contains the number that uniquely identifies the store. |
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. |
deps |
dept |
null |
null |
No |
The department to which all the items on the order belong. This field is required if the system enforces single department ordering. |
currency_code |
varchar23 |
1 |
1 |
Contains a code identifying the currency
the supplier uses for business transactions.
|
sups |
currency_code |
varchar2 |
3 |
Yes |
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). |
invc_head |
paid_ind |
varchar2 |
1 |
Yes |
Indicates whether 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 Yet Available
|
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 |
varchar2 |
30 |
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 |
varchar2 |
16 |
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 when 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 on which the invoice was paid in the POS system. This field is populated when the invoice is interfaced through ReSA. |
invc_ind |
varchar21 |
1 |
1 |
Inidcates whether an invoice was created
for this receipt by the supplier. |
n/a |
n/a |
null |
null |
Yes |
Inidcates whether an invoice was created for this receipt by the supplier. |
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.
|
n/a |
n/a |
null |
null |
Yes |
This field determines whether deals must be applied to the order. Valid values are Y and NULL. |
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. |
shipment |
ext_ref_no_in |
null |
null |
No |
This field contains the external transaction sequence number for the receipt. |
receipt_date |
xs:dateTime |
0 |
1 |
Description is not available
|
shipment |
receive_date |
RIBDate |
Fill column length. |
No |
Date on which the direct store delivery is received. RMS will use vdate if not defined. |