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/PORef/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:PORef 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 PORef 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
doc_type varchar21 1 1 Indicates the type of document this message is for. This field will always have a value of 'P'. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used by SIm
order_no varchar212 1 1 Contains the number that uniquely identifies an order within the system. PURCHASE_ORDER EXTERNAL_ID VARCHAR2 128 Yes Fill this description.
PODtlRef * 0 unbounded Not Yet Available

XML-Schema Name:PODtlRef 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 PODtlRef 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
item varchar225 1 1 Unique alphanumeric value to identify the item. PURCHASE_ORDER_LINE_ITEM ITEM_ID VARCHAR2 25 Yes the unique identifier of the item that is on the purchase order.
physical_location_type varchar21 1 1 Type of location in the physical_location field. Valid values are: S = Store, W = Warehouse. 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"),
physical_location number10 1 1 Identifier of the physical location. PURCHASE_ORDER STORE_ID NUMBER 10 Yes the unique identifier of the location for which the inventory will be delivered to for the order.
physical_store_type varchar21 0 1 Indicates the store type of the physical_location store. Only populated if physical_location_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"),
physical_stockholding_ind varchar21 0 1 Indicates if the physical_location store is stockholding or not. Only populated if physical_location_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 either "Y" or "N"