 |
Retail Integration Bus Mappings Report
|
 |
|
| Application Name: Retail Merchandising System |
|
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 |
|
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. |
| user_id | n/a | n/a | No | Not used by RMS. |
| updated_date | n/a | n/a | No | Not used by RMS. |