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/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 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
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 RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
order_no varchar212 1 1 Contains the number that uniquely identifies an order within the system. po po_nbr number 12 Yes Unique Purchase Order identifier.
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 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
item varchar225 1 1 Unique alphanumeric value to identify the item. po_detail item_id varchar2 25 Yes Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc.
physical_location_type varchar21 1 1 Type of location in the physical_location field. Valid values are: S = Store, W = Warehouse. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used in RWMS
physical_location number10 1 1 Identifier of the physical location. n/a n/a RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used in RWMS
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. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used in RWMS