|
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
|