Retail Integration Bus Mappings Report Release:13.1 (Retail Merchandizing System)
Application Retail Merchandizing 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.

XML-Schema Name:DSDDealsDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For DSDDealsDesc
Table Name Column Name API Type Column Length API Required API Description
DSDDeals * 1 unbounded Not used by SIM
ExtOfDSDDealsDesc:ExtOfDSDDealsDesc * 0 1 Provide an extension hook to customize DSDDealsDesc. NA NA NA NA NA NA

XML-Schema Name:DSDDeals Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For DSDDeals
Table Name Column Name API Type Column Length API Required API Description
order_no number8 1 1 Not used by SIM ordhead order_no null null Yes The order number that 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 that the shipment will be delivered to.
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) or '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 Any given 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 will be 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 will be 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 procedure APPLY_DEALS_TO_ORDER will be called.
shipment number10 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 Inidcates whether an invoice was created for this receipt by the supplier.
vdate xs:dateTime 1 1 Not used by SIM period vdate null null Yes Contains the current 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 field will be held in the invoice currency.
ext_receipt_no varchar217 1 1 Description is not available. NA NA NA NA NA NA
ExtOfDSDDealsDesc:ExtOfDSDDeals * 0 1 Provide an extension hook to customize DSDDeals. NA NA NA NA NA NA

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

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