Retail Integration Bus Mappings Report
Release: 13.0.1
Application Name: Retail
Merchandising System
Version 13.0.1
XML-Schema or Node
Name:SOStatusDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
dc_dest_id
tsfhead, alloc_detail
to_loc, store
No
Contains the
location number of the stock order receiving location.
distro_nbr
alloc_header, tsfhead
alloc_no, tsf_no
No
Contains the
stock order number. This is either the transfer or allocation number in
RMS.
distro_document_type
n/a
n/a
Yes
Specifies
whether the stock order status pertains to an allocation 'A', or transfer
'T'. Types 'D'C Created Stock Order,'C'ustomer Order, and 'V'irtual Distro
are also valid document types but will be ignored by the RMS
API.
SOStatusDtl
*
*
*
*
Application Name: Retail
Merchandising System
Version 13.0.1
XML-Schema or Node
Name:SOStatusDtl
Tag Name
Table Name
Column Name
API Req
Description
cust_order_nbr
n/a
n/a
No
Not used by
RMS.
dest_id
tsfhead, alloc_detail
to_loc, store
No
Contains the
location number of the stock order receiving location.
item_id
tsfdetail, alloc_header
item
Yes
Unique
identifier for the item.
order_line_nbr
n/a
n/a
No
Not used by
RMS.
unit_qty
alloc_detail, tsfdetail
qty_allocated, tsf_qty
Yes
The quantity of
the item pertaining to the stock order status message.
status
n/a
n/a
Yes
The status of
the stock order. Valid values are: 'DS' - Details Selected, 'DU' - Details
Un-Selected, 'NI' - Line Cancellation, 'PP' - Distributed, 'PU' -
Un-Distributed, 'RS' - Return To Stock, 'EX' - Expired, 'SR' - Store
Reassign, 'SC' - Store Cancellation.