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/SORef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:SORef 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 SORef 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
distro_nbr varchar212 1 1 N/A stock_allocation distro_nbr varchar2 10 Yes *
document_type varchar21 1 1 N/A stock_order document_type varchar2 1 Yes *
dc_dest_id varchar210 1 1 N/A transshipment_setup dc_dest_id varchar2 10 Yes *
loc_type varchar21 0 1 N/A 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 N/A Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
stockholding_ind varchar21 0 1 N/A Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
SODtlRef * 0 unbounded Description is not available.
distro_parent_no varchar212 0 1 N/A Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:SODtlRef 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 SODtlRef 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 N/A stock_allocation dest_id varchar2 10 Yes *
loc_type varchar21 0 1 N/A 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 N/A Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
stockholding_ind varchar21 0 1 N/A Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
item_id varchar225 1 1 N/A stock_allocation item_id varchar2 25 Yes *