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

XML-Schema Name:AllocDesc 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 AllocDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's 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 n/a n/a Yes Specifies the type of document. This value will always be 'A' to signify an allocation.
physical_wh number10 1 1 The physical warehouse location from which the allocation will originate. wh physical_wh number 10 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 Unique alphanumeric value that identifies the item. 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 Fill column length. 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 n/a n/a 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 type of the order. Allocations created before PO approval are marked as PREDIST order types. Allocations created after PO approval are marked as PO order types.
order_no varchar212 0 1 Contains the order number to which the allocation applies. alloc_header order_no number 12 No Contains the order number to which the allocation applies.
order_doc_type varchar21 1 1 Description is not available. n/a n/a n/a n/a 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 promo_event_id varchar2 6 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 This field contains the description of the promotional event. rpm_promo_event description varchar2 1000 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 n/a n/a 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 varchar2 4 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 varchar2 6 No This field contains the functional area code to which the transfer relates to (for example, PROM - Promotion).
context_value varchar225 0 1 Contains the value relating to the context type. alloc_header context_value varchar2 25 No Contains the value relating to the context type.
alloc_status varchar21 0 1 Contains the value relating to the allocation status. alloc_header status varchar2 10 Yes This contains the status of the allocation. Valid values are: W = Worksheet, R = Reserved, A = Approved, C = Closed, X = Allocation is being externally closed.

XML-Schema Name:AllocDtl 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 AllocDtl in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's 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 to_loc 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).
store_type varchar21 0 1 Indicates the store type of the to_loc store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. store store_type varchar2 6 No Indicates the store type of the to_loc store. Only populated if loc_type is 'S'. Valid values are
stockholding_ind varchar21 0 1 Indicates if the to_loc store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. store stockholding_ind varchar2 1 No Indicates if the to-location is stockholding or not. Only populated if loc_type is 'S'. Valid values are 'Y' = yes, 'N' = no.
qty_allocated number12_4 1 1 Contains the total number of items allocated. 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 number 20 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 varchar2 4 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 n/a n/a 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 Contains the date to be included in the RMS publication to the RIB for communication to the warehouse. alloc_detail in_store_date RIBDate Fill column length. No Contains the date to be included in the RMS publication to the RIB for communication to the warehouse.
rush_flag varchar21 0 1 Contains the rush flag indicator to be included in the RMS publication to the RIB for communication to the warehouse. alloc_detail rush_flag varchar2 1 No Contains the rush flag indicator to be included in the RMS publication to the RIB for communication to the warehouse.
AllocDtlTckt * 0 unbounded Description is not available.

XML-Schema Name:AllocDtlTckt 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 AllocDtlTckt in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
comp_item varchar225 1 1 This field contains an alphanumeric value that identifies the item within the pack. 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 number 20 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 varchar2 4 Yes This field contains the selling unit of measure for an item's single-unit retail.