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/AllocDesc/v1
Version 1.1
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:AllocDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For AllocDesc
Table Name Column Name API Type Column Length API Required API Description
alloc_no number10 1 1 Contains the number that uniquely identifies the allocation within the system. alloc_header alloc_no number 10 Yes Contains the number that uniquely identifies the allocation within the system.
doc_type varchar21 1 1 Specifies the type of document. This value will always be 'A' to signify an allocation. n/a n/a null null Yes Specifies the type of document. This value will always be 'A' to signify an allocation.
physical_wh number10 1 1 Description is not available. wh physical_wh null null Yes The physical warehouse location from which the allocation will originate.
wh number10 1 1 Contains the number of the warehouse loaction where the allocation will originate. alloc_header wh number 10 Yes Contains the number of the warehouse location from which the allocation will originate.
item varchar225 1 1 Description is not available. alloc_header item varchar2 25 Yes Unique alphanumeric value that identifies the item.
pick_not_before_date xs:dateTime 0 1 Contains the date on which the allocation should be released from the warehouse for delivery to the store locations. alloc_header release_date RIBDate * No Contains the date on which the allocation should be released from the warehouse for delivery to store locations.
pick_not_after_date xs:dateTime 0 1 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. n/a n/a null null 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 is a day before pick_not_before_date.
order_type varchar29 0 1 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. alloc_header order_type varchar2 9 No This field identifies the order associated with the PO. Allocations created before PO approval are marked as PREDIST order types. Allocations created after PO approval are marked as PO order types.
order_no varchar210 0 1 Description is not available. alloc_header order_no varchar2 10 No Contains the order number to which the allocation applies.
order_doc_type varchar21 1 1 Description is not available. n/a n/a null null Yes This value will always be P.
event varchar26 0 1 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. rpm_promo_event prom_event_id null null No This field contains the event to which the promotion belongs. This is an optional field that provides a method to group promotions together for tracking and reporting purposes.
event_description varchar21000 0 1 Description is not available. rpm_promo_event description null null No This field contains the description of the promotional event.
priority number4 0 1 A value which indicates the priority of an allocation. This value will always be 1. n/a n/a null null Yes Indicates the priority of an allocation. This value will always be 1.
ticket_type_id varchar24 0 1 This field contains a character string which uniquely identifies the ticket type which is associated with the item. item_ticket ticket_type_id null null No This field contains a character string to uniquely identify the ticket type associated with the item.
AllocDtl * 0 unbounded Description is not available.
context_type varchar26 0 1 This field holds the functional area code to which the transfer relates to for example Promotions. Valid value is: PROM - Promotion alloc_header context_type null PROM - Promotion No This field contains the code for the functional area to which the transfer relates (for example, Promotions).
context_value varchar225 0 1 Description is not available. alloc_header context_value varchar2 25 No The value for the context type.
ExtOfAllocDesc:ExtOfAllocDesc * 0 1 Proide an extention hook to customize AllocDesc. NA NA NA NA NA NA
LocOfAllocDesc:LocOfAllocDesc * 0 1 Proide an extention hook to localize AllocDesc. NA NA NA NA NA NA

XML-Schema Name:AllocDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For AllocDtl
Table Name Column Name API Type Column Length API Required API Description
physical_to_loc number10 1 1 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. alloc_detail to_loc number 10 Yes This field contains the physical location to which the allocation is being sent. The loc_type field indicates if the location is a store or a warehouse.
to_loc varchar210 1 1 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. alloc_detail to_loc varchar2 10 Yes This field contains the location to which the allocation is being sent. The loc_type field indicates if the location is a store or a warehouse.
loc_type varchar21 1 1 This field contains the type of location in the loctaion field. Valid values are 'S'tore and 'W'arehouse. item_loc loc_type varchar2 1 Yes This field contains the type of location in the location field. Valid values are S (store) and W (warehouse).
qty_allocated number12_4 1 1 Description is not available. alloc_detail qty_allocated number 12 Yes Contains the total number of items allocated.
price number20_4 0 1 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. item_loc selling_unit_retail null null No This field contains the unit retail in the selling unit of measure for the item/zone combination. This field is stored in the local currency.
selling_uom varchar24 0 1 This field holds the selling unit of measure for an item's single-unit retail. item_loc selling_uom null null No This field contains the selling unit of measure for an item's single-unit retail.
priority number4 0 1 A value which indicates the priority of an allocation. This value will always be 1. n/a n/a null null Yes Indicates the priority of an allocation. This value will always be 1.
store_ord_mult varchar21 1 1 This column contains the multiple in which the item needs to be shipped from a warehouse to the location. item_loc store_ord_mult varchar2 1 Yes This column contains the multiple in which the item must be shipped from a warehouse to the location.
in_store_date xs:dateTime 0 1 Description is not available. NA NA NA NA NA NA
rush_flag varchar21 0 1 Description is not available. NA NA NA NA NA NA
AllocDtlTckt * 0 unbounded Description is not available.
ExtOfAllocDesc:ExtOfAllocDtl * 0 1 Proide an extention hook to customize AllocDtl. NA NA NA NA NA NA
LocOfAllocDesc:LocOfAllocDtl * 0 1 Proide an extention hook to localize AllocDtl. NA NA NA NA NA NA

XML-Schema Name:AllocDtlTckt Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For AllocDtlTckt
Table Name Column Name API Type Column Length API Required API Description
comp_item varchar225 1 1 Description is not available. packitem_breakout item varchar2 25 Yes This field contains an alphanumeric value that identifies the item within the pack.
comp_price number20_4 1 1 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. item_loc selling_unit_retail null null Yes This field contains 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 varchar24 1 1 This field holds the selling unit of measure for an item's single-unit retail. item_loc selling_uom null null Yes This field contains the selling unit of measure for an item's single-unit retail.
ExtOfAllocDesc:ExtOfAllocDtlTckt * 0 1 Provide an extension hook to customize AllocDtlTckt. NA NA NA NA NA NA
LocOfAllocDesc:LocOfAllocDtlTckt * 0 1 Provide an extension hook to localize AllocDtlTckt. NA NA NA NA NA NA

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

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

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

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

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

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