Retail Integration Bus Mappings Report Release:13.1.1

(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.
	AllocRef AllocDtlRef ExtOfAllocDtlRef ExtOfAllocRef

XML-Schema Name:AllocRef

Version:13.1.1

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 will always be '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 where the allocation will originate.
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 where the allocation will originate.
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

XML-Schema Name:AllocDtlRef

Version:13.1.1

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 determines 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

XML-Schema Name:ExtOfAllocDtlRef

Version:13.1.1

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:ExtOfAllocRef

Version:13.1.1

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