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/DSDDealsDesc/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:DSDDealsDesc 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 DSDDealsDesc 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
DSDDeals * 1 unbounded Not used by SIM

XML-Schema Name:DSDDeals 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 DSDDeals 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
order_no number12 1 1 Not used by SIM ordhead order_no number 12 Yes The order number to which the deal should be applied.
supplier varchar210 1 1 Not used by SIM invc_head supplier null null Yes Invoice supplier's number.
store number10 1 1 This field contains the location that the shipment will be delivered to. shipment to_loc number 10 Yes This field contains the location to which the shipment will be delivered.
dept number4 0 1 Not used by SIM n/a n/a null null No Not used by RMS.
currency_code varchar23 1 1 Not used by SIM n/a n/a null null Yes Not used by RMS.
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 if 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 used by SIM 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 null null 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 null null 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 that 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 that the invoice was paid from the POS system. This field is populated when the invoice is interfaced through ReSA.
deals_ind varchar21 1 1 Specifies whether deals will be applied to the generated order. If set to 'Y', the procedure APPLY_DEALS_TO_ORDER will be called. n/a n/a null null Yes Specifies whether deals will be applied to the generated order. If set to Y, the APPLY_DEALS_TO_ORDER procedure is called.
shipment number12 1 1 The corresponding shipment for the order that was applied by the deal. shipment shipment null null No The corresponding shipment for the order that was applied by the deal.
invc_id number10 1 1 Contains the invoice number for the purchase order of this deal. invc_head invc_id null null No Contains the invoice number for the purchase order of this deal.
invc_ind varchar21 1 1 Inidcates whether an invoice was created for this receipt by the supplier. n/a n/a null null Yes Indicates whether an invoice was created for this receipt by the supplier.
receipt_date xs:dateTime 1 1 Not used by SIM shipment ship_date null null Yes Contains the receipt date of the RMS application.
qty_sum number12_4 1 1 Not used by SIM invc_head total_qty null null No Total quantity of items on the order to be invoiced.
cost_sum number20_4 1 1 Total merchandise cost for the invoice. This field will be held in the invoice currency. invc_head total_merch_cost null null No Total merchandise cost for the invoice. This value is expressed in currency used in the invoice.
ext_receipt_no varchar217 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.