Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing System
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.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms 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
LocOfDSDReceiptDesc:LocOfDSDReceiptDesc * 0 1 Provide an extension hook to localize DSDReceipt. NA NA NA NA NA NA

XML-Schema Name:DSDReceipt Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms 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. 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.
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

XML-Schema Name:DSDDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For DSDDtl
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 Not Yet Available shipsku item null null Yes Item that was received for the DSD.
qty_received number12_4 1 1 Contains the number of items already received for the SKU / Shipment combination. shipsku qty_received null null Yes Contains the number of items already received for the SKU / shipment combination.
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. ordloc unit_cost null null No This field contains the cost for the SKU from the supplier/ origin country. This field is stored in the supplier's currency.
weight number12_4 0 1 Contains the actual weight of the item on received. shipsku weight_received null null No Contains the actual weight of the item received.
weight_uom varchar24 0 1 Contains the unit of measure of the received weight (e.g. pounds, kilograms). shipsku weight_received_uom null null No Contains the unit of measure (such as pounds or kilograms) of the received item.
ExtOfDSDReceiptDesc:ExtOfDSDDtl * 0 1 Provide an extension hook to customize DSDDtl. NA NA NA NA NA NA
LocOfDSDReceiptDesc:LocOfDSDDtl * 0 1 Provide an extension hook to localize DSDDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfDSDDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfDSDDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfDSDDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfDSDDtl
Table Name Column Name API Type Column Length API Required API Description
InDSDReceiptDesc:InDSDDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrDSDReceiptDesc:BrDSDDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:DSDNonMerch Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms 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. invc_non_merch_temp non_merch_code varchar2 6 Yes Code identifying a non-merchandise cost that can be added to an invoice.
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. invc_non_merch_temp non_merch_amt number 20 Yes Amount of the non-merchandise cost (specified by the non-merchandise code) that has been invoiced. This field is held in the invoice currency.
vat_code varchar26 0 1 Code identifying the VAT rate that should be applied to the non_merch_amt entered. invc_non_merch_temp vat_code varchar2 6 No Code identifying the VAT rate that should be applied to the non_merch_amt entered.
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). invc_non_merch_temp service_perf_ind varchar2 1 Yes Indicates whether a service non-merchandise cost has actually been performed. Valid values are Y (service has been performed) and N (service has not been performed, or non-merchandise cost is not a service cost).
ExtOfDSDReceiptDesc:ExtOfDSDNonMerch * 0 1 Provide an extension hook to customize DSDNonMerch. NA NA NA NA NA NA
LocOfDSDReceiptDesc:LocOfDSDNonMerch * 0 1 Provide an extension hook to localize DSDNonMerch. NA NA NA NA NA NA

XML-Schema Name:ExtOfDSDNonMerch Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfDSDNonMerch
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfDSDNonMerch Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfDSDNonMerch
Table Name Column Name API Type Column Length API Required API Description
InDSDReceiptDesc:InDSDNonMerch * 0 unbounded India Localization. NA NA NA NA NA NA
BrDSDReceiptDesc:BrDSDNonMerch * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfDSDReceipt Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfDSDReceipt
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfDSDReceipt Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfDSDReceipt
Table Name Column Name API Type Column Length API Required API Description
InDSDReceiptDesc:InDSDReceipt * 0 unbounded India Localization. NA NA NA NA NA NA
BrDSDReceiptDesc:BrDSDReceipt * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfDSDReceiptDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfDSDReceiptDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfDSDReceiptDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfDSDReceiptDesc
Table Name Column Name API Type Column Length API Required API Description
InDSDReceiptDesc:InDSDReceiptDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrDSDReceiptDesc:BrDSDReceiptDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA