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

XML-Schema Name:SOStatusDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms 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. transshipment_setup dc_dest_id xs:string * Yes *
distro_nbr varchar210 0 1 Contains the stock order number. This is either the transfer or allocation number in RMS. stock_order_info_upload distro_nbr xs:string * No *
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. stock_order distro_document_type xs:string * Yes *
SOStatusDtl * 1 unbounded Description is not available.
context_type varchar26 0 1 This field holds the functional area code to which the transfer relates to. Valid values are PROM and REPAIR. * Yes *
context_value varchar225 0 1 This field holds the value relating to the context type like Promotion number. * Yes *
ExtOfSOStatusDesc:ExtOfSOStatusDesc * 0 1 Provide an extension hook to customize SOStatusDesc. NA NA NA NA NA NA
LocOfSOStatusDesc:LocOfSOStatusDesc * 0 1 Provide an extension hook to localize SOStatusDesc. NA NA NA NA NA NA

XML-Schema Name:SOStatusDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms 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. * * varchar2 * * *
dest_id varchar210 1 1 Description is not available. stock_allocation dest_id varchar2 10 * *
item_id varchar225 1 1 Description is not available. stock_allocation item_id varchar2 25 * *
order_line_nbr number3 1 1 Derived as ROWNUM. stock_allocation_cid order_line_nbr number 3 No Derived as ROWNUM.
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. stock_allocation requested_unit_qty number 12 * *
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. stock_allocation item_status varchar2 1 * *
user_id varchar230 0 1 Description is not available. * * varchar2 * * *
updated_date xs:dateTime 0 1 Description is not available. * * RIBDate * * *
ExtOfSOStatusDesc:ExtOfSOStatusDtl * 0 1 Provide an extension hook to customize SOStatusDtl. NA NA NA NA NA NA
LocOfSOStatusDesc:LocOfSOStatusDtl * 0 1 Provide an extension hook to localize SOStatusDtl. NA NA NA NA NA NA

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

XML-Schema Name:LocOfSOStatusDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocOfSOStatusDtl
Table Name Column Name API Type Column Length API Required API Description
InSOStatusDesc:InSOStatusDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrSOStatusDesc:BrSOStatusDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

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

XML-Schema Name:LocOfSOStatusDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocOfSOStatusDesc
Table Name Column Name API Type Column Length API Required API Description
InSOStatusDesc:InSOStatusDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrSOStatusDesc:BrSOStatusDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA