Retail Integration Bus Mappings Report Release:13.1 (Store Inventory Management)
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 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 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 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 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 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 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 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 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