Retail Integration Bus Mappings Report Release:13.1.1 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/SOStatusDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:SOStatusDesc Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For SOStatusDesc
Table Name Column Name API Type Column Length API Required API Description
dc_dest_id varchar210 1 1 Description is not available. DO_CTL_INV ID_PRTY_TO_ICD null null No Contains the location number of the stock order receiving location
distro_nbr varchar210 0 1 Contains the stock order number. This is either the transfer or allocation number in RMS. DO_CTL_INV ID_ICD null null Yes Contains the stock order number. this is inventory control document number for a transfer or return in SIM
distro_document_type varchar21 1 1 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. n/a n/a null null 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 * 1 unbounded Description is not available.
ExtOfSOStatusDesc:ExtOfSOStatusDesc * 0 1 Provide an extension hook to customize SOStatusDesc. NA NA NA NA NA NA

XML-Schema Name:SOStatusDtl Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For SOStatusDtl
Table Name Column Name API Type Column Length API Required API Description
cust_order_nbr varchar210 1 1 Description is not available. n/a n/a null null No Not used by SIM
dest_id varchar210 1 1 Description is not available. null null null null null
item_id varchar225 1 1 Description is not available. TR_LTM_ICD_MR ID_ITM null null Yes An identifier which represents an ITEM.
order_line_nbr number3 1 1 Derived as ROWNUM. n/a n/a null null No Not used by SIM
unit_qty number12_4 1 1 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. TR_LTM_ICD_MR QU_UN_SHP null null 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 varchar22 1 1 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. n/a n/a null null 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 varchar230 0 1 Description is not available. n/a n/a null null No Not used by SIM
updated_date xs:dateTime 0 1 Description is not available. n/a n/a null null No Not used by SIM
ExtOfSOStatusDesc:ExtOfSOStatusDtl * 0 1 Provide an extension hook to customize SOStatusDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfSOStatusDtl Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfSOStatusDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfSOStatusDesc Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfSOStatusDesc
Table Name Column Name API Type Column Length API Required API Description