Retail Integration Bus Mappings Report

Application Name: Retail Merchandising System

XML-Schema or Node Name:AllocDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
alloc_no	alloc_header	alloc_no	Yes	Contains the number that uniquely identifies the allocation within the system.
doc_type	n/a	n/a	Yes	Specifies the type of document. This value will always be 'A' to signify an allocation.
physical_wh	wh	physical_wh	Yes	The physical wh location where the allocation will originate.
wh	alloc_header	wh	Yes	Contains the number of the warehouse loaction where the allocation will originate.
item	alloc_header	item	Yes	Unique alphanumeric value that identifies the item.
pick_not_before_date	alloc_header	release_date	No	Contains the date on which the allocation should be released from the warehouse for delivery to the store locations.
pick_not_after_date	n/a	n/a	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	alloc_header	order_type	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	alloc_header	order_no	No	Contains the order number to which the allocation applies.
order_doc_type	n/a	n/a	Yes	This value will always be 'P'.
event	rpm_promo_event	prom_event_id	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	rpm_promo_event	description	No	This field contains the description of the promotional event.
priority	n/a	n/a	Yes	A value which indicates the priority of an allocation. This value will always be 1.
ticket_type_id	item_ticket	ticket_type_id	No	This field contains a character string which uniquely identifies the ticket type which is associated with the item.
AllocDtl	*	*	*	*
context_type	alloc_header	context_type	No	This field holds the functional area code to which the transfer relates to for example Promotions. Valid value is: PROM - Promotion
context_value	alloc_header	context_value	No	The value for the context type

Application Name: Retail Merchandising System

XML-Schema or Node Name:AllocDtl

Tag Name	Table Name	Column Name	API Req	Description
physical_to_loc	alloc_detail	to_loc	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	alloc_detail	to_loc	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	item_loc	loc_type	Yes	This field contains the type of location in the loctaion field. Valid values are 'S'tore and 'W'arehouse.
qty_allocated	alloc_detail	qty_allocated	Yes	Contains the total number of items allocated.
price	item_loc	selling_unit_retail	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	item_loc	selling_uom	No	This field holds the selling unit of measure for an item's single-unit retail.
priority	n/a	n/a	Yes	A value which indicates the priority of an allocation. This value will always be 1.
store_ord_mult	item_loc	store_ord_mult	Yes	This column contains the multiple in which the item needs to be shipped from a warehouse to the location.
AllocDtlTckt	*	*	*	*

Application Name: Retail Merchandising System

XML-Schema or Node Name:AllocDtlTckt

Tag Name	Table Name	Column Name	API Req	Description
comp_item	packitem_breakout	item	Yes	Alphanumeric value that identifies the item within the pack.
comp_price	item_loc	selling_unit_retail	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	item_loc	selling_uom	Yes	This field holds the selling unit of measure for an item's single-unit retail.