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/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.2.0 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
LocOfDSDDealsDesc:LocOfDSDDealsDesc * 0 1 Provide an extension hook to localize DSDDealsDesc. NA NA NA NA NA NA

XML-Schema Name:DSDDeals Version:13.2.0 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 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 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 Indicates 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 value is expressed in currency used in the invoice.
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
LocOfDSDDealsDesc:LocOfDSDDeals * 0 1 Provide an extension hook to localize DSDDeals. NA NA NA NA NA NA

XML-Schema Name:ExtOfDSDDeals Version:13.2.0 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:LocOfDSDDeals Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfDSDDeals
Table Name Column Name API Type Column Length API Required API Description
InDSDDealsDesc:InDSDDeals * 0 unbounded India Localization. NA NA NA NA NA NA
BrDSDDealsDesc:BrDSDDeals * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfDSDDealsDesc Version:13.2.0 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

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