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/AllocDesc/v1
Version	1.0
Description	This is root element of this document which contains name space definitions for the document elements.
	AllocDesc AllocDtl AllocDtlTckt ExtOfAllocDtlTckt ExtOfAllocDtl ExtOfAllocDesc

XML-Schema Name:AllocDesc

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For AllocDesc
					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	Description is not available.	wh	physical_wh	null	null	Yes	The physical wh location where the allocation will originate.
wh	number10	1	1	Contains the number of the warehouse loaction where the allocation will originate.	alloc_header	wh	number	10	Yes	Contains the number of the warehouse loaction where the allocation will originate.
item	varchar225	1	1	Description is not available.	alloc_header	item	varchar2	25	Yes	Unique alphanumeric value that identifies the item.
pick_not_before_date	xs:dateTime	0	1	Contains the date on which the allocation should be released from the warehouse for delivery to the store locations.	alloc_header	release_date	RIBDate	*	No	Contains the date on which the allocation should be released from the warehouse for delivery to the store locations.
pick_not_after_date	xs:dateTime	0	1	This value is calculated by adding code_detail.code desc for code 'DATE' and code_type 'DEFT' to alloc_header.release_date. If the allocation is closed, pick_not_after_date will be a day before pick_not_before_date.	n/a	n/a	null	null	No	This value is calculated by adding code_detail.code desc for code 'DATE' and code_type 'DEFT' to alloc_header.release_date. If the allocation is closed, pick_not_after_date will be a day before pick_not_before_date.
order_type	varchar29	0	1	This field identifies the order associated with the PO. Allocations created before PO approval will be marked as 'PREDIST' ordertypes. Allocations created after PO approval will be marked as 'PO' order types.	alloc_header	order_type	varchar2	9	No	This field identifies the order associated with the PO. Allocations created before PO approval will be marked as 'PREDIST' ordertypes. Allocations created after PO approval will be marked as 'PO' order types.
order_no	varchar210	0	1	Description is not available.	alloc_header	order_no	varchar2	10	No	Contains the order number to which the allocation applies.
order_doc_type	varchar21	1	1	Description is not available.	n/a	n/a	null	null	Yes	This value will always be 'P'.
event	varchar26	0	1	This field contains the event to which the promotion belongs to. This is an optional field that provides a method to group promotions together for tracking and reporting purposes.	rpm_promo_event	prom_event_id	null	null	No	This field contains the event to which the promotion belongs to. This is an optional field that provides a method to group promotions together for tracking and reporting purposes.
event_description	varchar21000	0	1	Description is not available.	rpm_promo_event	description	null	null	No	This field contains the description of the promotional event.
priority	number4	1	1	A value which indicates the priority of an allocation. This value will always be 1.	n/a	n/a	null	null	Yes	A value which indicates the priority of an allocation. This value will always be 1.
ticket_type_id	varchar24	0	1	This field contains a character string which uniquely identifies the ticket type which is associated with the item.	item_ticket	ticket_type_id	null	null	No	This field contains a character string which uniquely identifies the ticket type which is associated with the item.
AllocDtl	*	0	unbounded	Description is not available.
context_type	varchar26	0	1	This field holds the functional area code to which the transfer relates to for example Promotions. Valid value is: PROM - Promotion	alloc_header	context_type	null	null	No	This field holds the functional area code to which the transfer relates to for example Promotions. Valid value is: PROM - Promotion
context_value	varchar225	0	1	Description is not available.	alloc_header	context_value	varchar2	25	No	The value for the context type
ExtOfAllocDesc:ExtOfAllocDesc	*	0	1	Proide an extention hook to customize AllocDesc.	NA	NA	NA	NA	NA	NA

XML-Schema Name:AllocDtl

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For AllocDtl
					Table Name	Column Name	API Type	Column Length	API Required	API Description
physical_to_loc	number10	1	1	This field contains the physical location to which the allocation is being sent. The loc_type field determinds if the location is a store or a warehouse.	alloc_detail	to_loc	number	10	Yes	This field contains the physical location to which the allocation is being sent. The loc_type field determinds if the location is a store or a warehouse.
to_loc	varchar210	1	1	This field contains the location to which the allocation is being sent. The loc_type field determinds 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 determinds if the location is a store or a warehouse.
loc_type	varchar21	1	1	This field contains the type of location in the loctaion field. Valid values are 'S'tore and 'W'arehouse.	item_loc	loc_type	varchar2	1	Yes	This field contains the type of location in the loctaion field. Valid values are 'S'tore and 'W'arehouse.
qty_allocated	number12_4	1	1	Description is not available.	alloc_detail	qty_allocated	number	12	Yes	Contains the total number of items allocated.
price	number20_4	0	1	This field holds the unit retail in the selling unit of measure for the item/zone combination. This field is stored in the local currency.	item_loc	selling_unit_retail	null	null	No	This field holds the unit retail in the selling unit of measure for the item/zone combination. This field is stored in the local currency.
selling_uom	varchar24	0	1	This field holds the selling unit of measure for an item's single-unit retail.	item_loc	selling_uom	null	null	No	This field holds the selling unit of measure for an item's single-unit retail.
priority	number4	1	1	A value which indicates the priority of an allocation. This value will always be 1.	n/a	n/a	null	null	Yes	A value which indicates the priority of an allocation. This value will always be 1.
store_ord_mult	varchar21	1	1	This column contains the multiple in which the item needs to be shipped from a warehouse to the location.	item_loc	store_ord_mult	varchar2	1	Yes	This column contains the multiple in which the item needs to be shipped from a warehouse to the location.
in_store_date	xs:dateTime	0	1	Description is not available.	NA	NA	NA	NA	NA	NA
rush_flag	varchar21	0	1	Description is not available.	NA	NA	NA	NA	NA	NA
AllocDtlTckt	*	0	unbounded	Description is not available.
ExtOfAllocDesc:ExtOfAllocDtl	*	0	1	Proide an extention hook to customize AllocDtl.	NA	NA	NA	NA	NA	NA

XML-Schema Name:AllocDtlTckt

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For AllocDtlTckt
					Table Name	Column Name	API Type	Column Length	API Required	API Description
comp_item	varchar225	1	1	Description is not available.	packitem_breakout	item	varchar2	25	Yes	Alphanumeric value that identifies the item within the pack.
comp_price	number20_4	1	1	This field holds the unit retail in the selling unit of measure for the item/zone combination. This field is stored in the local currency.	item_loc	selling_unit_retail	null	null	Yes	This field holds the unit retail in the selling unit of measure for the item/zone combination. This field is stored in the local currency.
comp_selling_uom	varchar24	1	1	This field holds the selling unit of measure for an item's single-unit retail.	item_loc	selling_uom	null	null	Yes	This field holds the selling unit of measure for an item's single-unit retail.
ExtOfAllocDesc:ExtOfAllocDtlTckt	*	0	1	Provide an extension hook to customize AllocDtlTckt.	NA	NA	NA	NA	NA	NA

XML-Schema Name:ExtOfAllocDtlTckt

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For ExtOfAllocDtlTckt
					Table Name	Column Name	API Type	Column Length	API Required	API Description

XML-Schema Name:ExtOfAllocDtl

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For ExtOfAllocDtl
					Table Name	Column Name	API Type	Column Length	API Required	API Description

XML-Schema Name:ExtOfAllocDesc

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For ExtOfAllocDesc
					Table Name	Column Name	API Type	Column Length	API Required	API Description