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/CustSaleDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:CustSaleDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For CustSaleDesc
Table Name Column Name API Type Column Length API Required API Description
wh number10 1 1 This contains the stockholding location to which the item is sold. This field may contain a store or a warehouse. The item and wh combination must be valid on the item_loc table. item_loc_soh loc null null Yes This contains the stockholding location to which the item is sold. This field may contain a store or a warehouse. The item and wh combination must be valid on the item_loc table.
store number10 1 1 The contains the non-stockholding location ID in which the item is sold. This field may contain a store or a warehouse. The item and store combination must be valid on the item_loc table. item_loc_soh loc null null Yes The contains the non-stockholding location ID in which the item is sold. This field may contain a store or a warehouse. The item and store combination must be valid on the item_loc table.
item varchar225 1 1 Unique alphanumeric value that identifies the item. item_loc_soh item xs:string * Yes Unique alphanumeric value that identifies the item.
shipped_quantity number12_4 1 1 This will hold the number of units being sold for customer orders. item_loc_soh stock_on_hand null null Yes This will hold the number of units being sold for customer orders.
ship_confirmed_date xs:dateTime 1 1 Description is not available. NA NA NA NA NA NA
ExtOfCustSaleDesc:ExtOfCustSaleDesc * 0 1 Provide an extension hook to customize CustSaleDesc. NA NA NA NA NA NA

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