Retail Integration Mappings Report Release:15.0.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.
XSD Structure

XML-Schema Name:SOStatusDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for SOStatusDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
dc_dest_id varchar210 1 1 Contains the location number of the stock order source location. transshipment_setup dc_dest_id varchar2 10 Yes Fill this description.
loc_type varchar21 1 1 Type of location in the dc_dest_id field. Valid values are: S = Store, W = Warehouse, E = Finisher. NA NA varchar2 1 Yes Always W
store_type varchar21 0 1 Indicates the store type of the dc_dest_id store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. NA NA varchar2 1 Yes Populated with NULL
stockholding_ind varchar21 0 1 Indicates if the dc_dest_id store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. NA NA varchar2 1 Yes Populated with NULL
distro_nbr varchar212 0 1 Contains the stock order number. This is either the transfer or allocation number in RMS. stock_order_info_upload distro_nbr varchar2 12 Yes A number which uniquely identifies a distribution order.
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 or stock_order_info_upload document_type varchar2 1 Yes IF stock_order.document_type is NULL use stock_order_info_upload.document_type. If that is null default to E
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. stock_order order_type RIB or/and RSB or/and RSL * No NULL or REPAIR based on Stock Order
context_value varchar225 0 1 This field holds the value relating to the context type like promotion number. NA NA RIB or/and RSB or/and RSL * No Populated with NULL
inventory_type varchar26 0 1 This field indicates if a transfer is made from the available or unavailable inventory. NA NA RIB or/and RSB or/and RSL Fill column length. No Populated with NULL
cust_order_nbr varchar248 0 1 For a stock order associated with a customer order, this field holds the master customer order number from OMS. stock_order cust_order_nbr varchar2 48 Yes Valid Customer Order Number
fulfill_order_nbr varchar248 0 1 For a stock order associated with a customer order, this field holds the number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. stock_order fulfill_order_nbr varchar2 48 Yes Fill this description.

XML-Schema Name:SOStatusDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for SOStatusDtl in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
dest_id varchar210 1 1 Contains the location number of the stock order receiving location. stock_order_info_upload dest_id varchar2 10 Yes *
loc_type varchar21 1 1 Type of location in the dest_id field. Valid values are: S = Store, W = Warehouse, E = Finisher. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
store_type varchar21 0 1 Indicates the store type of the dest_id store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. ship_dest store_type varchar2 1 Yes Fill this description.
stockholding_ind varchar21 0 1 Indicates if the dest_id store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. ship_dest stockholding_ind varchar2 1 Yes Fill this description.
item_id varchar225 1 1 Unique identifier for the item. stock_order_info_upload item_id varchar2 25 Yes *
original_item_id varchar225 0 1 The ID of the item being replaced. Populated only when this record is for a substitute item on a customer order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
order_line_nbr number3 1 1 Derived as ROWNUM. stock_order_info_upload order_line_nbr number 4 Yes Fill this description.
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_order_info_upload unit_qty number 12 Yes *
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_order_info_upload status varchar2 2 Yes *
user_id varchar230 0 1 Description is not available. * * varchar2 * No Populated with NULL
updated_date xs:dateTime 0 1 Description is not available. * * RIBDate * No Populated with NULL