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:XAllocDesc.xsd
Tag Name Table Name Column Name API Req Description
XAlloc * * * *

Application Name: Retail Merchandising System
Version 13.0.1
XML-Schema or Node Name:XAlloc
Tag Name Table Name Column Name API Req Description
alloc_no alloc_header alloc_no Yes Contains the unique identifier of the Allocation. This field is not editable once the allocation is created in RMS. This should fall within the range of RMS ids already designated for allocations.
alloc_desc alloc_header alloc_desc Yes Contains the user defined description of the Allocation. This field is always editable.
order_no alloc_header order_no No Contains the purchase order with which the allocation is associated in order to perform a cross-dock allocation. This field is not editable once the allocation has been created in RMS.
item alloc_header item Yes Contains the transaction level item that is being allocated. This field is not editable once the allocation has been created in RMS.
from_loc alloc_header wh Yes Contains the location that is the source of the allocation. This must be a valid stockholding store or warehouse predefined in RMS. This field is not editable once the allocation has been created in RMS.
release_date alloc_header release_date No Contains the earliest date on which the warehouse should ship the allocation. This field is editable assuming that the warehouse has not yet started processing on the Allocation. This date cannot be in the past.
XAllocDtl * * * *

Application Name: Retail Merchandising System
Version 13.0.1
XML-Schema or Node Name:XAllocDtl
Tag Name Table Name Column Name API Req Description
to_loc alloc_detail to_loc Yes Contains the to location of the allocation. This must be an active store previously defined in RMS.
to_loc_type alloc_detail to_loc_type Yes Contains the location type of the to location. Since only stores can be allocated to, this value should always be 'S'.
qty_allocated alloc_detail qty_allocated Yes Contains the allocated quantity of the item to the to location. When the allocation is being created this value must be a positive integer. If this value is being modified, it will contain the quantity adjusted (positive or negative), rather than an override value.