Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Retail Merchandising System
Version 13.0.1
XML-Schema or Node Name:CustSaleDesc.xsd
Tag Name Table Name Column Name API Req Description
wh item_loc_soh loc 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 item_loc_soh loc 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 item_loc_soh item Yes Unique alphanumeric value that identifies the item.
shipped_quantity item_loc_soh stock_on_hand Yes This will hold the number of units being sold for customer orders.