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.