Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Retail Merchandising System
Version 13.0.1
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
Version 13.0.1
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
Version 13.0.1
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.