Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising System
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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS'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'. n/a n/a null null Yes Indicates the type of document this message is for. Value is always P.
order_no varchar212 1 1 Contains the number that uniquely identifies an order within the system. string ordhead number 12 order_no Contains the number that uniquely identifies an order within the system.
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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
item varchar225 1 1 Unique alphanumeric value to identify the item. item_master item varchar2 25 Yes Unique alphanumeric value to identify the item.
physical_location_type varchar21 1 1 Type of location in the physical_location field. Valid values are: S = Store, W = Warehouse. ordloc loc_type varchar2 1 Yes Type of location in the physical_location field. Valid values are S = Store, W = Warehouse.
physical_location number10 1 1 Identifier of the physical location. ordloc location number 10 Yes Identifier of the physical location.
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. store store_type varchar2 1 No 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.
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. store stockholding_ind varchar2 1 Yes 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.