Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising 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.
XSD Structure

XML-Schema Name:DSDReceiptDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DSDReceiptDesc 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
DSDReceipt * 1 unbounded Description is not available.

XML-Schema Name:DSDReceipt Version:15.0.0 Return to Top
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.

XML-Schema Name:DSDDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DSDDtl 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
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.
DSDDtlUin * 0 unbounded Collection of UIN(s) associated to the item.

XML-Schema Name:DSDDtlUin Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DSDDtlUin 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
uin varchar2128 1 1 Universal Identification Number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
status number4 1 1 Status associated with the UIN. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:DSDNonMerch Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DSDNonMerch 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
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).