Retail Integration Mappings Report Release:14.1.0 (Store Inventory Management)
Application Store Inventory Management
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:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DSDDealsDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
DSDDeals * 1 unbounded Not used by SIM

XML-Schema Name:DSDDeals Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DSDDeals in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
order_no number12 1 1 Not used by SIM n/a n/a null null Yes Not used by SIM.
supplier varchar210 1 1 Not used by SIM n/a n/a null null Yes Not used by SIM.
store number10 1 1 This field contains the location that the shipment will be delivered to. n/a n/a null null Yes Not used by SIM.
dept number4 0 1 Not used by SIM n/a n/a null null No Not used by SIM
currency_code varchar23 1 1 Not used by SIM n/a n/a null null Yes Not used by SIM.
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) n/a n/a null null Yes Not used by SIM.
ext_ref_no varchar230 0 1 Not used by SIM n/a n/a null null No Not used by SIM.
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. n/a n/a null null No Not used by SIM.
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. n/a n/a null null No Not used by SIM.
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. n/a n/a null null No Not used by SIM.
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 Not used by SIM.
shipment number12 1 1 The corresponding shipment for the order that was applied by the deal. n/a n/a null null No Not used by SIM.
invc_id number10 1 1 Contains the invoice number for the purchase order of this deal. n/a n/a null null No Not used by SIM.
invc_ind varchar21 1 1 Inidcates whether an invoice was created for this receipt by the supplier. n/a n/a null null Yes Not used by SIM
receipt_date xs:dateTime 1 1 Not used by SIM n/a n/a null null Yes Not used by SIM.
qty_sum number12_4 1 1 Not used by SIM n/a n/a null null No Not used by SIM.
cost_sum number20_4 1 1 Total merchandise cost for the invoice. This field will be held in the invoice currency. n/a n/a null null No Not used by SIM.
ext_receipt_no varchar217 1 1 Description is not available. NA NA NA NA NA NA