Application
|
Store Inventory Management
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/DSDReceiptDesc/v1
|
Version
|
1.0
|
Description
|
This is root element of this document which contains name space definitions for the document elements.
|
|
|
|
XML-Schema Name:DSDReceiptDesc
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For DSDReceiptDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
DSDReceipt
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfDSDReceiptDesc:ExtOfDSDReceiptDesc
|
*
|
0
|
1
|
Provide an extension hook to customize DSDReceipt.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:DSDReceipt
|
Version:13.1.1
|
Return to Top
|
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. |
|
null |
null |
null |
null |
null |
origin_country_id |
varchar23 |
1 |
1 |
The identifier of the country from which the item is being sourced. |
|
null |
null |
null |
null |
null |
store |
number10 |
1 |
1 |
Not Yet Available |
DO_CTL_INV |
ID_PRTY_FM_ICD |
NUMBER |
128 |
No |
Not Yet Available |
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 |
ID_STRC_MR |
NUMBER |
128 |
No |
Not Yet Available |
currency_code |
varchar23 |
1 |
1 |
Contains a code identifying the currency the supplier uses for business transactions. |
|
null |
varchar2 |
3 |
null |
null |
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). |
|
null |
varchar2 |
1 |
null |
null |
ext_ref_no |
varchar230 |
0 |
1 |
Not Yet Available |
DO_CTL_INV |
ID_CNTRT |
VARCHAR2 |
128 |
No |
Not Yet Available |
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. |
|
null |
varchar2 |
30 |
null |
null |
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 |
|
null |
varchar2 |
16 |
null |
null |
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. |
|
null |
RIBDate |
* |
null |
null |
invc_ind |
varchar21 |
1 |
1 |
Inidcates whether an invoice was created for this receipt by the supplier. |
|
null |
null |
null |
null |
null |
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. |
|
null |
null |
null |
null |
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. |
DO_CTL_INV |
ID_ICD |
VARCHAR2 |
128 |
Yes |
Not Yet Available |
ExtOfDSDReceiptDesc:ExtOfDSDReceipt
|
*
|
0
|
1
|
Provide an extension hook to customize DSDReceipt.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:DSDDtl
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For DSDDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
item |
varchar225 |
1 |
1 |
Not Yet Available |
TR_LTM_ICD_MR |
ID_ITM |
VARCHAR2 |
128 |
Yes |
Not Yet Available |
qty_received |
number12_4 |
1 |
1 |
Contains the number of items already received for the SKU / Shipment combination. |
TR_LTM_ICD_MR |
QU_ITM |
NUMBER |
20,4 |
No |
Not Yet Available |
unit_cost |
number20_4 |
0 |
1 |
This field contains the cost for the SKU from the supplier/ origin country. This field is stored in the supplier's currency. |
|
null |
null |
null |
null |
null |
weight |
number12_4 |
0 |
1 |
Contains the actual weight of the item on received. |
|
null |
null |
null |
null |
null |
weight_uom |
varchar24 |
0 |
1 |
Contains the unit of measure of the received weight (e.g. pounds, kilograms). |
|
null |
null |
null |
null |
null |
ExtOfDSDReceiptDesc:ExtOfDSDDtl
|
*
|
0
|
1
|
Provide an extension hook to customize DSDDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfDSDDtl
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfDSDDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:DSDNonMerch
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For DSDNonMerch |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
non_merch_code |
varchar26 |
1 |
1 |
Code identifying a non-merchandise cost that can be added to an invoice. |
|
null |
varchar2 |
6 |
null |
null |
non_merch_amt |
number20 |
1 |
1 |
Amount of the non-merchandise cost, specified by the non-merchandise code, that has been invoiced for. This field will be held in the invoice currency. |
|
null |
number |
20 |
null |
null |
vat_code |
varchar26 |
0 |
1 |
Code identifying the VAT rate that should be applied to the non_merch_amt entered. |
|
null |
varchar2 |
6 |
null |
null |
service_perf_ind |
varchar21 |
1 |
1 |
Indicates if a service non-merchandise cost has actually been performed. Valid values are 'Y' (service has been performed) or 'N' (service has not been performed or non-merchandise cost is not a service cost). |
|
null |
varchar2 |
1 |
null |
null |
ExtOfDSDReceiptDesc:ExtOfDSDNonMerch
|
*
|
0
|
1
|
Provide an extension hook to customize DSDNonMerch.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfDSDNonMerch
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfDSDNonMerch |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfDSDReceipt
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfDSDReceipt |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfDSDReceiptDesc
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfDSDReceiptDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|