Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing 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.

XML-Schema Name:AllocRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For AllocRef
Table Name Column Name API Type Column Length API Required 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 null null 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 null null 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.
ExtOfAllocRef:ExtOfAllocRef * 0 1 Provide an extension hook to customize AllocRef. NA NA NA NA NA NA
LocOfAllocRef:LocOfAllocRef * 0 1 Provide an extension hook to localize AllocRef. NA NA NA NA NA NA

XML-Schema Name:AllocDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For AllocDtlRef
Table Name Column Name API Type Column Length API Required API Description
to_loc varchar210 1 1 This field contains the location to which the allocation is being sent. The loc_type field determines if the location is a store or a warehouse. 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.
ExtOfAllocRef:ExtOfAllocDtlRef * 0 1 Provide an extension hook to customize AllocDtlRef. NA NA NA NA NA NA
LocOfAllocRef:LocOfAllocDtlRef * 0 1 Provide an extension hook to localize AllocDtlRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfAllocDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfAllocDtlRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfAllocDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfAllocDtlRef
Table Name Column Name API Type Column Length API Required API Description
InAllocRef:InAllocDtlRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrAllocRef:BrAllocDtlRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfAllocRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfAllocRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfAllocRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfAllocRef
Table Name Column Name API Type Column Length API Required API Description
InAllocRef:InAllocRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrAllocRef:BrAllocRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA