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/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 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
dc_dest_id varchar210 1 1 Contains the location number of the stock order source location. WAREHOUSE,PARTNER ID NUMBER,VARCHAR2 10 No Partner/Warehouse identifier
loc_type varchar21 1 1 Type of location in the dc_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 possible value LOC_TYPE_STORE("S"),
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. 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 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Possible value "Y"
distro_nbr varchar212 0 1 Contains the stock order number. This is either the transfer or allocation number in RMS. ALLOCATION EXTERNAL_ID Number 12 Yes The allocation identifier from external system.
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 (Created Stock Order),C (Customer Order), and V (Virtual Distro) are also valid document types. But they are ignored by the RMS API.
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. TRANSFER, RETURN CONTEXT_TYPE_ID 15 VARCHAR2 No This field hods the functional area code to which the transfer relates to. For example promotions. e.g PROM - Promotion
context_value varchar225 0 1 This field holds the value relating to the context type like promotion number. TRANSFER, RETURN CONTEXT_VALUE 25 VARCHAR2 No This field holds value relating to the context type, e.g promotin number.
inventory_type varchar26 0 1 This field indicates if a transfer is made from the available or unavailable inventory. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
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. FUL_ORD CUST_ORDER_ID VARCHAR2 128 Yes External identifier of the customer order being fulfilled.
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. FUL_ORD EXTERNAL_ID VARCHAR2 128 No External identifier for the fulfillment order.

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 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 Contains the location number of the stock order receiving location. TSF_ALLOCATION STORE_ID Number 10 Yes the unique identifier of the store where this item is will be delivered to.
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 possible value LOC_TYPE_STORE("S"),
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. 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 Indicates if the dest_id store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes possible values "Y" or "N"
item_id varchar225 1 1 Unique identifier for the item. TSF_ALLOCATION ITEM_ID VARCHAR2 25 Yes the unique identifier of the item that this allocation is for.
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. FUL_ORD_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Item identifier for this line 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. TSF_ALLOCATION QUANTITY Number 20,4 No this is the quantity of the item in this allocation.
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 '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. Yes The status of the stock order. Valid values are SI (stock order status stock increase) SD(Stock order status stock decrease)
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. TSF_ALLOCATION DELIVERY_DATE DATE Fill column length. No the date that the allocation is expected to be delivered from the warehouse.