 |
Retail Integration Bus Mappings Report
|
 |
|
| Application Name: Store Inventory Management |
|
XML-Schema or Node Name:SOStatusDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| dc_dest_id | DO_CTL_INV | ID_PRTY_TO_ICD | No | Contains the location number of the stock order receiving location |
| distro_nbr | DO_CTL_INV | ID_ICD | Yes | Contains the stock order number. this is inventory control document number for a transfer or return in SIM |
| 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: Store Inventory Management |
|
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 SIM |
| dest_id | ||||
| item_id | TR_LTM_ICD_MR | ID_ITM | Yes | An identifier which represents an ITEM. |
| order_line_nbr | n/a | n/a | No | Not used by SIM |
| unit_qty | TR_LTM_ICD_MR | QU_UN_SHP | No | The difference beween the number of ITEM units shipped versus the receiving count for the given ITEM. This is subtracted from the document-line-item-unit-count to yield an over/under variance between what a supplier said was shipped and what was counted and received at by the store's staff. |
| 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 SIM |
| updated_date | n/a | n/a | No | Not used by SIM |