Retail Integration Bus Mappings Report Release:13.2.0 (Retail Warehouse Management System)
Application Retail Warehouse Management 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 rwms 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. stock_allocation distro_nbr or cust_order_nbr number 10 Yes *
doc_type varchar21 1 1 Specifies the type of document. This value will always be 'A' to signify an allocation. * * varchar2 1 * *
physical_wh number10 1 1 Description is not available. transshipment_setup dc_dest_id number 10 Yes *
wh number10 1 1 Contains the number of the warehouse loaction where the allocation will originate. * * number 10 * *
item varchar225 1 1 Description is not available. stock_allocation item_id varchar2 25 Yes *
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. * * RIBDate * * *
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. * * RIBDate * * *
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. * * varchar2 9 * *
order_no varchar210 0 1 Description is not available. * * varchar2 10 * *
order_doc_type varchar21 1 1 Description is not available. * * varchar2 1 * *
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. * * varchar2 6 * *
event_description varchar21000 0 1 Description is not available. * * varchar2 1000 * *
priority number4 0 1 A value which indicates the priority of an allocation. This value will always be 1. * * number 4 * *
ticket_type_id varchar24 0 1 This field contains a character string which uniquely identifies the ticket type which is associated with the item. stock_allocation ticket_type_id varchar2 4 No *
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 * * varchar2 6 * *
context_value varchar225 0 1 Description is not available. * * varchar2 25 * *
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 rwms 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. * * number 10 * *
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. stock_allocation dest_id varchar2 10 Yes *
loc_type varchar21 1 1 This field contains the type of location in the loctaion field. Valid values are 'S'tore and 'W'arehouse. * * varchar2 1 * *
qty_allocated number12_4 1 1 Description is not available. stock_allocation requested_unit_qty number 12 Yes *
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. stock_allocation retail_price number 20 No *
selling_uom varchar24 0 1 This field holds the selling unit of measure for an item's single-unit retail. stock_allocation selling_uom varchar2 4 No *
priority number4 0 1 A value which indicates the priority of an allocation. This value will always be 1. stock_allocation priority number 4 Yes *
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. stock_allocation store_ord_mult varchar2 1 Yes *
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 rwms Mapping For AllocDtlTckt
Table Name Column Name API Type Column Length API Required API Description
comp_item varchar225 1 1 Description is not available. component_ticketing component_item_id varchar2 25 Yes *
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. component_ticketing retail_price number 20 Yes *
comp_selling_uom varchar24 1 1 This field holds the selling unit of measure for an item's single-unit retail. component_ticketing selling_uom varchar2 4 Yes *
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 rwms 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 rwms 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 rwms 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 rwms 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 rwms 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 rwms 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