Retail Integration Bus Mappings Report Release:13.1 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemLocDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:ItemLocDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ItemLocDesc
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 Not Yet Available AS_ITEM_RTL_STR ID_ITEM VARCHAR2 128 No Not Yet Available
ItemLocPhys * 1 unbounded Description is not available.
ExtOfItemLocDesc:ExtOfItemLocDesc * 0 1 Provide an extension hook to customize ItemLocPhys. NA NA NA NA NA NA

XML-Schema Name:ItemLocPhys Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim 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. AS_ITEM_RTL_STR ID_STR_RT NUMBER 128 No Not Yet Available
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

XML-Schema Name:ItemLocVirt Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim 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. null number 10 null null
loc_type varchar21 1 1 Type of location in the "loc" field. Valid values are 'S' (store) and 'W' (warehouse). null varchar2 1 null null
local_item_desc varchar2250 1 1 NA null varchar2 250 null null
local_short_desc varchar2120 0 1 Not Yet Available AS_ITEM_RTL_STR SHORT_DESC VARCHAR2 20 No Not Yet Available
status varchar21 1 1 Current status of the item at the store (valid values are 'A' (active), 'I' (inactive), 'C' (discontinued) and 'D' (deleted). AS_ITEM_RTL_STR SC_ITM VARCHAR2 20 No Not Yet Available
primary_supp number10 0 1 Not Yet Available AS_ITEM_RTL_STR ID_SPR NUMBER 128 No Not Yet Available
primary_cntry varchar23 0 1 Contains the origin country which will be considered the primary country for the item/location. null varchar2 3 null null
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. null varchar2 1 null null
taxable_ind varchar21 1 1 Indicates whether the item is taxable at the store. Valid values are 'Y' (yes) and 'N' (No). null varchar2 1 null null
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'. null null null null null
source_wh number10 0 1 If the source_method is 'W', this field contains the source warehouse for fulfilling item requests at a store. null number 10 null null
unit_retail number20_4 0 1 Unit retail of the item in the selling Unit of Measure. Only published for create not modify. null null null null null
selling_unit_retail number20_4 0 1 Selling unit retail in selling unit of measure. Only published for create, not update AS_ITEM_RTL_STR RP_SLS_CRT NUMBER 75 No Not Yet Available
selling_uom varchar24 0 1 Selling Unit of measure. Only published for Create not update. null null null null null
store_price_ind varchar21 0 1 Not Yet Available AS_ITEM_RTL_STR STR_CTL_PRICING VARCHAR2 1 No Not Yet Available
purchase_type varchar26 0 1 Purchase Type NA NA NA NA NA NA
ExtOfItemLocDesc:ExtOfItemLocVirt * 0 1 Provide an extension hook to customize ItemLocVirt. NA NA NA NA NA NA

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

XML-Schema Name:ItemLocVirtRepl Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim 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. AS_ITEM_RTL_STR ID_STR_RT NUMBER 128 No Not Yet Available
loc_type varchar21 1 1 Contains the type of the location on replenishment. Valid values include 'S'tore, 'W'arehouse. null varchar2 1 null null
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. null number 10 null null
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. AS_ITEM_RTL_STR REPN_TYPE VARCHAR2 4 No Not Yet Available
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." AS_ITEM_RTL_STR STR_ORD_REJECT VARCHAR2 1 No Not Yet Available
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. AS_ITEM_RTL_STR NEXT_DELIVERY_DATE RIBDate * No Not Yet Available
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

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

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

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