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/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.2.0 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 field contains the stockholding location to which the item is sold. This field may indicate a store or a warehouse. The item and warehouse combination must be valid in 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 This field contains the non-stockholding location ID for the location from which the item is sold. This field may indicate a store or a warehouse. The item and store combination must be valid in the item_loc table.
item varchar225 1 1 Unique alphanumeric value that identifies the item. string item_loc_soh xs item 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 field contains 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
LocOfCustSaleDesc:LocOfCustSaleDesc * 0 1 Provide an extension hook to localize CustSaleDesc. NA NA NA NA NA NA

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

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