Retail Integration Mappings Report Release:15.0.0 (Integration Gateway Services)
Application Integration Gateway Services
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.
XSD Structure

XML-Schema Name:XAllocDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XAllocDesc in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
XAlloc * 1 unbounded Description is not available.

XML-Schema Name:XAlloc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XAlloc in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's 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. RMS.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. RMS.alloc_header alloc_desc varchar2 300 Yes Contains the user defined description of the allocation. This field is always editable.
order_no number12 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. RMS.alloc_header order_no varchar2 12 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. 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. RMS.alloc_header wh number 10 Yes Contains the number of the warehouse location from where the allocation originates. 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. RMS.alloc_header release_date RIBDate Fill column length. 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.
origin_ind varchar26 0 1 Indicates the source application that sends the allocation. Valid values are 'AIP' and 'EG'. It will be defaulted to 'EG' in RMS if not defined. RMS.alloc_header origin_ind varchar2 6 No Identifies the origin point of the allocation. Valid values are AIP, EG, RMS, ELC. If this is null, the value is defaulted to EG.
XAllocDtl * 0 unbounded Description is not available.

XML-Schema Name:XAllocDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XAllocDtl in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
to_loc number10 1 1 Contains the to location of the allocation. This must be an active store or warehouse previously defined in RMS. 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. Valid values are 'S' (store) and 'W' (warehouse). RMS.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. RMS.alloc_detail qty_allocated number 12 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.
in_store_date xs:dateTime 0 1 Contains the date the item is to be in store. This date will be included in the RMS publication to the RIB for communication to the warehouse. RMS.alloc_detail in_store_date date Fill column length. No Contains the date the item is to be in store. This date will be included in the RMS publication to the RIB for communication to the warehouse.