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

XML-Schema Name:ItemLocDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemLocDesc
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 Not Yet Available item_loc item varchar2 25 Yes Unique identifier for the item.
ItemLocPhys * 1 unbounded Description is not available.
ExtOfItemLocDesc:ExtOfItemLocDesc * 0 1 Provide an extension hook to customize ItemLocPhys. NA NA NA NA NA NA
LocOfItemLocDesc:LocOfItemLocDesc * 0 1 Provide an extension hook to localize ItemLocPhys. NA NA NA NA NA NA

XML-Schema Name:ItemLocPhys Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemLocPhys
Table Name Column Name API Type Column Length API Required API Description
physical_loc number10 1 1 If the loc_type is 'W', this is the physical warehouse that is assigned to the virtual wh where the item is located. If the loc_type is an 'S' then this is the store where the item is located. wh, item_loc physical_wh, loc null null Yes If loc_type is W, this value is the physical warehouse that is assigned to the virtual warehouse at which the item is located. If loc_type is S, this value is the store at which the item is located.
ItemLocVirt * 0 unbounded Description is not available.
ItemLocVirtRepl * 0 unbounded Description is not available.
ExtOfItemLocDesc:ExtOfItemLocPhys * 0 1 Provide an extension hook to customize ItemLocPhys. NA NA NA NA NA NA
LocOfItemLocDesc:LocOfItemLocPhys * 0 1 Provide an extension hook to localize ItemLocPhys. NA NA NA NA NA NA

XML-Schema Name:ItemLocVirt Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemLocVirt
Table Name Column Name API Type Column Length API Required API Description
loc number10 1 1 Location where the item is to be found. This field may contain a store or a warehouse. item_loc loc number 10 Yes Location where the item is to be found. This field may contain a store or a warehouse.
loc_type varchar21 1 1 Type of location in the "loc" field. Valid values are 'S' (store) and 'W' (warehouse). item_loc loc_type varchar2 1 Yes Type of location in the "loc" field. Valid values are 'S' (store) and 'W' (warehouse).
local_item_desc varchar2250 1 1 NA item_loc local_item_desc varchar2 250 Yes Contains the local description of the item.
local_short_desc varchar2120 0 1 Not Yet Available item_loc local_short_desc varchar2 120 No Contains the local short description of the item.
status varchar21 1 1 Current status of the item at the store (valid values are 'A' (active), 'I' (inactive), 'C' (discontinued) and 'D' (deleted). item_loc status varchar2 1 Yes Current status of the item at the store (valid values are 'A' (active), 'I' (inactive), 'C' (discontinued) and 'D' (deleted).
primary_supp number10 0 1 Not Yet Available item_loc primary_supp number 10 No Primary supplier for the item/location.
primary_cntry varchar23 0 1 Contains the origin country which will be considered the primary country for the item/location. item_loc primary_cntry varchar2 3 No Contains the origin country which will be considered the primary country for the item/location.
receive_as_type varchar21 0 1 Determines whether the stock on hand for a pack component item or the buyer pack itself will be updated when a buyer pack is received at a warehouse. Valid values are 'E'ach or 'P'ack. item_loc receive_as_type varchar2 1 No Determines whether the stock on hand for a pack component item or the buyer pack itself will be updated when a buyer pack is received at a warehouse. Valid values are 'E'ach or 'P'ack.
taxable_ind varchar21 1 1 Indicates whether the item is taxable at the store. Valid values are 'Y' (yes) and 'N' (No). item_loc taxable_ind varchar2 1 Yes Indicates whether the item is taxable at the store. Valid values are 'Y' (yes) and 'N' (No).
source_method varchar21 0 1 Determines the source method for a requested item at a store. Valid values: 'W'(warehouse) and 'S'(supplier), default value is 'S'. item_loc source_method null null No Determines the source method for a requested item at a store. Valid values: 'W'(warehouse) and 'S'(supplier), default value is 'S'.
source_wh number10 0 1 If the source_method is 'W', this field contains the source warehouse for fulfilling item requests at a store. item_loc source_wh number 10 No If the source_method is 'W', this field contains the source warehouse for fulfilling item requests at a store.
unit_retail number20_4 0 1 Unit retail of the item in the selling Unit of Measure. Only published for create not modify. item_loc unit_retail null null No Unit retail of the item in the selling Unit of Measure. Only published for create not modify.
selling_unit_retail number20_4 0 1 Selling unit retail in selling unit of measure. Only published for create, not update item_loc selling_unit_retail null null No Selling unit retail in selling unit of measure. Only published for create, not update
selling_uom varchar24 0 1 Selling Unit of measure. Only published for Create not update. item_loc selling_uom null null No Selling Unit of measure. Only published for Create not update.
store_price_ind varchar21 0 1 Not Yet Available item_loc store_price_ind null null Yes Indicates if the location can modify the item's price
purchase_type varchar26 0 1 Purchase Type NA NA NA NA NA NA
uin_type varchar26 0 1 This attribute will contain the type of the unique identification number (UIN) used to identify instances of the item at the location. Valid values for this attribute should be user-definable on the RMS code tables. This attribute should be nullable. NA NA NA NA NA NA
uin_label varchar26 0 1 This attribute will contain the label for the UIN when displayed in SIM. Valid values should be user-definable on the RMS code tables. This attribute should be nullable but a value is required when a UIN Type is specified. NA NA NA NA NA NA
capture_time varchar26 0 1 This attribute will indicate when the UIN should be captured for an item during transaction processing. There are 2 valid values for this field which should be stored on the RMS code tables: Sale and Store Receiving. This attribute should be nullable. NA NA NA NA NA NA
ext_uin_ind varchar21 0 1 This Yes/No indicator indicates if UIN is being generated in the external system (e.g. SIM). This value will always be N (no) when the Capture Time attribute is set to Sale. NA NA NA NA NA NA
ExtOfItemLocDesc:ExtOfItemLocVirt * 0 1 Provide an extension hook to customize ItemLocVirt. NA NA NA NA NA NA
LocOfItemLocDesc:LocOfItemLocVirt * 0 1 Provide an extension hook to localize ItemLocVirt. NA NA NA NA NA NA

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

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

XML-Schema Name:ItemLocVirtRepl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemLocVirtRepl
Table Name Column Name API Type Column Length API Required API Description
loc number10 1 1 Location that is on replenishment. Will hold only virtual warehouse in the multi-channel environment. repl_item_loc location null null Yes Location that is on replenishment. Will hold only virtual warehouse in the multi-channel environment.
loc_type varchar21 1 1 Contains the type of the location on replenishment. Valid values include 'S'tore, 'W'arehouse. repl_item_loc loc_type varchar2 1 Yes Contains the type of the location on replenishment. Valid values include 'S'tore, 'W'arehouse.
primary_repl_supplier number10 0 1 Contains the numeric identifier of the supplier from which the specified location will source the replenishment demand for the specified item location. Used for items on Direct to Store/Warehouse or Cross-docked replenishment. repl_item_loc primary_repl_supplier number 10 No Contains the numeric identifier of the supplier from which the specified location will source the replenishment demand for the specified item location. Used for items on Direct to Store/Warehouse or Cross-docked replenishment.
repl_method varchar26 0 1 Contains the character code for the algorithm that will be used to calculate the recommended order quantity for the item location. Valid values include 'C'onstant, 'M'in/Max, 'F'loating point, 'T'ime Supply, 'D'ynamic, 'SO' Store Orders. repl_item_loc repl_method null null Yes Contains the character code for the algorithm that will be used to calculate the recommended order quantity for the item location. Valid values include 'C'onstant, 'M'in/Max, 'F'loating point, 'T'ime Supply, 'D'ynamic, 'SO' Store Orders.
reject_store_order_ind varchar21 0 1 Contains an indicator that determines if uploaded store orders should be rejected. If the indicator is 'N', then store orders for all need dates are valid. If 'Y', store orders with needs date on or after the NEXT_DELIVERY_DATE are valid." repl_item_loc reject_store_ord_ind varchar2 1 No Contains an indicator that determines if uploaded store orders should be rejected. If the indicator is 'N', then store orders for all need dates are valid. If 'Y', store orders with needs date on or after the NEXT_DELIVERY_DATE are valid."
next_delivery_date xs:dateTime 0 1 Contains the next delivery date calculated for the next review cycle. If, for the next review cycle, an order will be created that is calculated to arrive on Thursday, this field will be updated with Thursday's date. repl_item_loc next_delivery_date RIBDate * No Contains the next delivery date calculated for the next review cycle. If, for the next review cycle, an order will be created that is calculated to arrive on Thursday, this field will be updated with Thursday's date.
multiple_runs_per_day_ind varchar21 0 1 Indicates if the item-location is replenished multiple times per day. NA NA NA NA NA NA
ExtOfItemLocDesc:ExtOfItemLocVirtRepl * 0 1 Provide an extension hook to customize ItemLocVirtRepl. NA NA NA NA NA NA
LocOfItemLocDesc:LocOfItemLocVirtRepl * 0 1 Provide an extension hook to localize ItemLocVirtRepl. NA NA NA NA NA NA

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

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

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

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

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

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