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/AllocRef/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:AllocRef 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 AllocRef 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
alloc_no number10 1 1 Contains the number that uniquely identifies the allocation within the system. alloc_header alloc_no number 10 Yes Contains the number that uniquely identifies the allocation within the system.
doc_type varchar21 1 1 Specifies the type of document. This value will always be 'A' to signify an allocation. n/a n/a n/a n/a Yes Specifies the type of document. This value is always A (to signify an allocation).
physical_wh number10 1 1 Contains the number of the physical warehouse location where the allocation will originate. wh physical_wh number 10 Yes Contains the number of the physical warehouse location from which the allocation originates.
wh number10 1 1 Contains the number of the warehouse location where the allocation will originate. alloc_header wh number 10 Yes Contains the number of the warehouse location from which the allocation originates.
item varchar225 1 1 Unique alphanumeric value that identifies the item. alloc_header item varchar2 25 Yes Unique alphanumeric value that identifies the item.
AllocDtlRef * 0 unbounded Description is not available.

XML-Schema Name:AllocDtlRef 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 AllocDtlRef 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
to_loc varchar210 1 1 This field contains the location to which the allocation is being sent. alloc_detail to_loc varchar2 10 Yes This field contains the location to which the allocation is being sent. The loc_type field indicates if the location is a store or a warehouse.
loc_type varchar21 0 1 This field contains the type of location in the to_loc field. Valid values are 'S'tore and 'W'arehouse. n/a n/a n/a n/a No Not used by RMS.
store_type varchar21 0 1 Indicates the store type of the to_loc store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. store store_type varchar2 6 No Indicates the store type of the to_loc store. Only populated if loc_type is 'S'. Valid values are 'C' = company store, 'F' = franchise store.
stockholding_ind varchar21 0 1 Indicates if the to_loc store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. store stockholding_ind varchar2 1 No Indicates if the to_loc store is stockholding or not. Only populated if loc_type is 'S'. Valid values are 'Y' = yes, 'N' - no.