XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for DSDReceipt in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
supplier |
varchar210 |
1 |
1 |
Unique identifying number for a supplier
for the receipt. |
DSD |
SUPPLIER_ID |
VARCHAR2 |
128 |
Yes |
the unique identifier of the supplier that shipped the items. |
origin_country_id |
varchar23 |
1 |
1 |
The identifier of the country from which
the item is being sourced. |
STORE |
LOCALE_COUNTRY |
VARCHAR2 |
2 |
No |
The 2-letter country code from ISO-3166. |
store |
number10 |
1 |
1 |
Not Yet Available
|
DSD |
STORE_ID |
NUMBER |
10 |
Yes |
the unique identifier of the store that this direct delivery is for. |
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. |
ITEM |
DEPARTMENT_ID |
NUMBER |
12 |
No |
hierarchy department id |
currency_code |
varchar23 |
1 |
1 |
Contains a code identifying the currency
the supplier uses for business transactions.
|
SUPPLIER |
CURRENCY_CODE |
VARCHAR2 |
3 |
No |
a code that identifies the currency most widely used by the supplier. |
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
|
|
null |
null |
null |
No |
SIM sets null value |
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 |
not used in SIM |
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. |
DSD |
ID |
NUMBER |
12 |
Yes |
the unique identifier of the direct delivery record. this value is generated by the application. |
receipt_date |
xs:dateTime |
0 |
1 |
Description is not available
|
|
|
RIBDate |
|
|
|