Retail Integration Mappings Report Release:15.0.0 (Store Inventory Management)
Application Store Inventory Management
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 SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
distro_nbr varchar212 1 1 N/A ALLOCATION EXTERNAL_ID Number 12 Yes The allocation identifier from external system.
document_type varchar21 1 1 N/A n/a n/a varchar2 1 Yes Specifies whether the stock order status pertains to an allocation (A) or transfer T. Types D (Created Stock Order),C (Customer Order), and V (Virtual Distro) are also valid document types. But they are ignored by the RMS API.
dc_dest_id varchar210 1 1 N/A WAREHOUSE,PARTNER ID VARCHAR2,NUMBER 10 Yes Unique Partner/Warehouse identifier.
loc_type varchar21 0 1 N/A TSF_ALLOCATION SOURCE_TYPE RIB or/and RSB or/and RSL NUMBER(2,0) Yes
store_type varchar21 0 1 N/A TSF_ALLOCATION SOURCE_TYPE RIB or/and RSB or/and RSL NUMBER(2,0) 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 SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
dest_id varchar210 1 1 N/A TSF_ALLOCATION STORE_ID Number 10 Yes the unique identifier of the store where this item is will be delivered to.
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 possible value LOC_TYPE_STORE("S"),
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 values are STORE_TYPE_COMPANY("C"), STORE_TYPE_FRANCHISE("F"),
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 values are either "Y" or "N"
item_id varchar225 1 1 N/A TSF_ALLOCATION ITEM_ID VARCHAR2 25 Yes the unique identifier of the item that this allocation is for.