Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing System
Target Name Space http://www.oracle.com/retail/integration/base/bo/XAllocDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:XAllocDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XAllocDesc
Table Name Column Name API Type Column Length API Required API Description
XAlloc * 1 unbounded Description is not available.
ExtOfXAllocDesc:ExtOfXAllocDesc * 0 1 Provide an extension hook to customize XAlloc. NA NA NA NA NA NA
LocOfXAllocDesc:LocOfXAllocDesc * 0 1 Provide an extension hook to localize XAlloc. NA NA NA NA NA NA

XML-Schema Name:XAlloc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XAlloc
Table Name Column Name API Type Column Length API Required API Description
alloc_no number10 1 1 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_header alloc_no number 10 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 varchar2300 1 1 Contains the user defined description of the Allocation. This field is always editable. alloc_header alloc_desc varchar2 300 Yes Contains the user defined description of the allocation. This field is always editable.
order_no number8 0 1 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. alloc_header order_no varchar2 10 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 varchar225 1 1 Contains the transaction level item that is being allocated. This field is not editable once the allocation has been created in RMS. alloc_header item varchar2 25 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 number10 1 1 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. alloc_header wh null null 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 xs:dateTime 0 1 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. alloc_header release_date RIBDate * 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 * 0 unbounded Description is not available.
ExtOfXAllocDesc:ExtOfXAlloc * 0 1 Provide an extension hook to customize XAlloc. NA NA NA NA NA NA
LocOfXAllocDesc:LocOfXAlloc * 0 1 Provide an extension hook to localize XAlloc. NA NA NA NA NA NA

XML-Schema Name:XAllocDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XAllocDtl
Table Name Column Name API Type Column Length API Required API Description
to_loc number10 1 1 Contains the to location of the allocation. This must be an active store previously defined in RMS. alloc_detail to_loc varchar2 10 Yes Contains the to location of the allocation. This must be an active store previously defined in RMS.
to_loc_type varchar21 1 1 Contains the location type of the to location. Since only stores can be allocated to, this value should always be 'S'. alloc_detail to_loc_type varchar2 1 Yes Contains the location type of the to location. Since only stores can be allocated to, this value should always be 'S'.
qty_allocated number12_4 1 1 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. alloc_detail qty_allocated null null 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.
ExtOfXAllocDesc:ExtOfXAllocDtl * 0 1 Provide an extension hook to customize XAllocDtl. NA NA NA NA NA NA
LocOfXAllocDesc:LocOfXAllocDtl * 0 1 Provide an extension hook to localize XAllocDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfXAllocDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXAllocDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXAllocDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXAllocDtl
Table Name Column Name API Type Column Length API Required API Description
InXAllocDesc:InXAllocDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrXAllocDesc:BrXAllocDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfXAlloc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXAlloc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXAlloc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXAlloc
Table Name Column Name API Type Column Length API Required API Description
InXAllocDesc:InXAlloc * 0 unbounded India Localization. NA NA NA NA NA NA
BrXAllocDesc:BrXAlloc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfXAllocDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXAllocDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXAllocDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXAllocDesc
Table Name Column Name API Type Column Length API Required API Description
InXAllocDesc:InXAllocDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrXAllocDesc:BrXAllocDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA