Retail Integration Mappings Report Release:16.0.030 (Store Inventory Management)
Application Store Inventory Management
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.
XSD Structure

XML-Schema Name:ItemLocDesc Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemLocDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
item varchar225 1 1 Not Yet Available Store_Item_Stock ITEM_ID VARCHAR2 25 No Unique identifier for the item.
ItemLocPhys * 1 unbounded Description is not available.

XML-Schema Name:ItemLocPhys Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemLocPhys in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
physical_loc number10 1 1 Identifier of the physical location where the item is located. STORE_ITEM STORE_ID NUMBER 10,0 Yes Warehouse or Store id
loc_type varchar21 1 1 Type of location in the physical_loc field. Valid values are: S = Store, W = Warehouse, E = Finisher. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Possible value LOC_TYPE_STORE "S"
store_type varchar21 0 1 Indicates the store type of the physical_loc store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes possible values STORE_TYPE_COMPANY("C"), STORE_TYPE_FRANCHISE("F"),
stockholding_ind varchar21 0 1 Indicates if the physical_loc store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Possible values are "Y" or "N"
returnable_ind varchar21 0 1 This field will contain a value of Yes when the item can be returned to the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes This field will contain a value of Yes when the item can be returned to the location.
ItemLocVirt * 0 unbounded Description is not available.
ItemLocVirtRepl * 0 unbounded Description is not available.

XML-Schema Name:ItemLocVirt Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemLocVirt in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
loc number10 1 1 Location where the item is to be found. This field may contain a store or a warehouse. STORE_ITEM STORE_ID NUMBER 10,0 No STORE_ID
loc_type varchar21 1 1 Type of location in the "loc" field. Valid values are 'S' (store) and 'W' (warehouse). ITEM ITEM_TYPE NUMBER 2,0 Yes item type
local_item_desc varchar2250 1 1 NA STORE_ITEM LONG_DESCRIPTION varchar2 400 No The long description for the item.
local_short_desc varchar2120 0 1 Not Yet Available STORE_ITEM SHORT_DESCRIPTION VARCHAR2 255 No The short description for the item used at this location.
status varchar21 1 1 Current status of the item at the store (valid values are 'A' (active), 'I' (inactive), 'C' (discontinued) and 'D' (deleted). STORE_ITEM STATUS VARCHAR2 A - Active, item is valid and can be ordered, transferred in, and sold C - discontinued, item is sellable, can not be ordered from a supplier, can be transferred in from a warehouse or store. I - inactive, item is sellable, can not be ordered, can not be transferred in from a warehouse or store. D - delete, item is invalid and cannot be ordered, transferred in, or sold. (im a bit skeptical on the deleted status. Q - automatically stocked by sim. the item was not originally ranged for the store, but sim created a location and stock records to do a stock event coming to the store. N - Non-ranged No the code defines the current state of an item within the retail store. for example include active inactive discontinued, pending, etc. valid values are
primary_supp number10 0 1 Not Yet Available STORE_ITEM PRIMARY_SUPPLIER_ID VARCHAR2 128 No The unique identifier of the supplier that is the default primary supplier for the item at this location.
primary_cntry varchar23 0 1 Contains the origin country which will be considered the primary country for the item/location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
taxable_ind varchar21 1 1 Indicates whether the item is taxable at the store. Valid values are 'Y' (yes) and 'N' (No). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
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'. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
source_wh number10 0 1 If the source_method is 'W', this field contains the source warehouse for fulfilling item requests at a store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
unit_retail number20_4 0 1 Unit retail of the item in the selling Unit of Measure. Only published for create not modify. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
selling_unit_retail number20_4 0 1 Selling unit retail in selling unit of measure. Only published for create, not update Fill application table name. Fill table column name. varchar2 Fill column length. No NOT AVAILABLE
selling_uom varchar24 0 1 Selling Unit of measure. Only published for Create not update. STORE_ITEM SELLING_UNIT_OF_MEASURE VARCHAR2 4 No the unit of measure that the items package is. (not currently used by sim)
store_price_ind varchar21 0 1 Indicates if the location can modify the item's price. STORE_ITEM STORE_CONTROL_PRICING NUMBER 1,0 No A flag indicating if the item price can be controlled by the store.
purchase_type varchar26 0 1 Purchase Type ITEM ITEM_TYPE Number 2,0 Yes if value is S set CONSIGNMENT(5, "Consignment"), type of item. 0 - Item, 5 - Consignment, 12 - Non Inventory, 15 - Simple, 20 - complex, 25 - Pack breakable if value is C set CONCESSION(10, "Concession"),
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. STORE_UIN_ADMIN_ITEM UIN_TYPE Number serial Yes uin type. ex
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. STORE_UIN_ADMIN_ITEM LABEL_ID Number 12,0 Yes reference to uin_label table
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. STORE_UIN_ADMIN_ITEM CAPTURE_TIME_ID Number 2 No times of sales or store receiving
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. STORE_UIN_ADMIN_ITEM EXTERNAL_CREATE_ALLOWED VARCHAR2 y,n Yes an indicate to allow external system to create uin. values
ranged_ind varchar21 1 1 An indicator to differentiate between user ranged locations and RMS program ranged locations. Values are 'Y' or 'N'. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes An indicator to differentiate between user ranged locations and RMS program ranged locations. Values are 'Y' or 'N'.
CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA
item_parent varchar225 0 1 ID identifies the item/group at the level above the item. This value must exist as an item in another row on the item_master table.
item_grandparent varchar225 0 1 ID identifies the item/group two levels above the item. This value must exist as both an item and an item parent in another row on the item_master table.
ti number12_4 0 1 Number of shipping units (cases) that make up one tier of a pallet.
hi number12_4 0 1 Number of tiers that make up a complete pallet (height).
store_ord_mult varchar21 0 1 This column contains the multiple in which the item needs to be shipped from a warehouse to the location.
daily_waste_pct number12_4 0 1 Average percentage lost from inventory on a daily basis due to natural wastage.
meas_of_each number12_4 0 1 Size of an each in terms of the uom_of_price. For example 12 oz. Used in ticketing.
meas_of_price number12_4 0 1 Size to be used on the ticket in terms of the uom_of_price.
uom_of_price varchar24 0 1 Unit of measure that will be used on the ticket for this item.
primary_variant varchar225 0 1 This field is used to address sales of PLUs (i.e. above transaction level items) when inventory is tracked at a lower level (i.e. UPC). This field will only contain a value for items one level higher than the transaction level.
primary_cost_pack varchar225 0 1 This field contains an item number that is a simple pack containing the item in the item column for this record. If populated, the cost of the future cost table will be driven from the simple pack and the deals and cost changes for the simple pack.
inbound_handling_days number2 0 1 This field indicates the number of inbound handling days for an item at a warehouse type location.
regular_unit_retail number20_4 0 1 This field holds the unit retail in the standard unit of measure for the item/location (zone) combination. This field is stored in the local currency.
multi_units number12_4 0 1 This field contains the multi-units for the item/location (zone) combination.
multi_unit_retail number20_4 0 1 This field holds the multi-unit retail in the multi-selling unit of measure for the item/location (zone) combination. This field is stored in teh local currency.
multi_selling_uom varchar24 0 1 This field holds the selling unit of measure for this item/location (zone) combinations multi-unit retail.
clear_ind varchar21 0 1 "Indicates if item is on clearance at the store. Valid values are: Y = Yes, the item is on clearance N = No, the item is not on clearance".
costing_loc number10 0 1 Numeric identifier of the costing location for the franchise store.This field may contain a store or a warehouse.
costing_loc_type varchar21 0 1 This field holds the type of costing location in the costing location field.
currency_code varchar23 0 1 This field contains the currency code under which the store/wh operates.
launch_date xs:dateTime 0 1 Holds the date that they item should first be sold at the location.
qty_key_options varchar26 0 1 Determines whether the qty key on a POS should be used for this item at the location.
manual_price_entry varchar26 0 1 Determines whether the price can/should be entered manually on a POS for this item at the location.
deposit_code varchar26 0 1 Indicates whether a deposit is associated with this item at the location.
food_stamp_ind varchar21 0 1 Indicates whether the item is approved for food stamps at the location. This value will be downloaded to the POS.
wic_ind varchar21 0 1 Indicates whether the item is approved for WIC at the location. This value will be downloaded to the POS.
proportional_tare_pct number12_4 0 1 Holds the value associated of the packaging in items sold by weight at the location.
fixed_tare_value number12_4 0 1 Holds the value associated of the packaging in items sold by weight at the location.
fixed_tare_uom varchar24 0 1 Holds the unit of measure value associated with the tare value. The only processing RMS does involving the fixed tare value and UOM is downloading it to the POS.
reward_eligible_ind varchar21 0 1 Holds whether the item is legally valid for various types of bonus point/award programs at the location.
natl_brand_comp_item varchar225 0 1 Holds the nationally branded item to which you would like to compare the current item.
return_policy varchar26 0 1 Holds the return policy for the item at the location. Valid values for this field belong to the code_type RETP.
stop_sale_ind varchar21 0 1 Indicates that sale of the item should be stopped immediately at the location (i.e. in case of recall etc).
elect_mtk_clubs varchar26 0 1 Holds the code that represents the marketing clubs to which the item belongs at the location.
report_code varchar26 0 1 Code to determine which reports the location should run.
req_shelf_life_on_selection number4 0 1 Holds the required shelf life for an item on receipt in days.
req_shelf_life_on_receipt number4 0 1 Holds the required shelf life for an item on receipt in days.
store_reorderable_ind varchar21 0 1 This field indicates whether the store may re-order the item.This field is required to be either= Y - yes or N - no. The field will default to N.
rack_size varchar26 0 1 Indicates the rack size that should be used for the item. This field is not required. Valid values for the field can be found and defined in the code_type RACK.
full_pallet_item varchar21 0 1 Indicates whether a store must reorder an item in full pallets only.
in_store_market_basket varchar26 0 1 Holds the in store market basket code for this item/location combination. Valid values for the field can be found in the code_type STMB.
storage_location varchar27 0 1 Holds the current storage location or bin number for the item at the location.
alt_storage_location varchar27 0 1 Holds the preferred alternate storage location or bin number for the item at the location.
refundable_ind varchar21 0 1 This field will contain a value of Yes when the item is refundable at the location.
back_order_ind varchar21 0 1 This field will contain a value of Yes when the item can be back ordered to the location.
promotable_ind varchar21 0 1 This field will indicates,if the item can be included on promotions or not.
unit_cost number20_4 0 1 This field contains the current unit cost of the item
pickup_lead_time number4 0 1 Contains the time it takes to get the item from the Supplier to the Initial Receiving Location.
cost_uom varchar24 0 1 Unit of measure associated with the item cost. It is held to allow costs to be managed in a separate UOM from the standard UOM.
calculation_basis varchar21 0 1 This indicates if the cost for the consignment/concession item will be managed either based on cost per unit or as a percentage of retail. Valid values are C - Cost per Unit, P - Purchase Rate.
purchase_rate number12_4 0 1 This column contains the percentage of the retail price which will determnie the cost paid to the supplier for a consignment or concession item.
rfid_ind varchar21 0 1 This indicates if the item is RFID tagged or not. Valid values are Yes (Y) and No (N).

XML-Schema Name:CustFlexAttriVo Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
name varchar230 1 1 Holds the attribute name. NA NA NA NA NA NA
value varchar2250 0 1 Holds the numeric or string value of the attribute. NA NA NA NA NA NA
value_date xs:dateTime 0 1 Holds the date value of the attribute. NA NA NA NA NA NA

XML-Schema Name:ItemLocVirtRepl Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemLocVirtRepl in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
loc number10 1 1 Location that is on replenishment. Will hold only virtual warehouse in the multi-channel environment. STORE_ITEM STORE_ID NUMBER 10,0 No STORE_ID
loc_type varchar21 1 1 Contains the type of the location on replenishment. Valid values include 'S'tore, 'W'arehouse. ITEM ITEM_TYPE NUMBER 2,0 Yes item type
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. Fill application table name. null number 10 null not used in SIM
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. STORE_ITEM REPLENISHMENT_TYPE VARCHAR2 6 No contains the character code for the algorithm that will be used to calculate the recommended order quantity for the item location. valid values
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." STORE_ITEM STORE_ORDER_ALLOWED CHAR 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. STORE_ITEM NEXT_DELIVERY_DATE DATE Fill column length. No The next delivery date of this item based on the replinishment type. obtained from rms
multiple_runs_per_day_ind varchar21 0 1 Indicates if the item-location is replenished multiple times per day. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes values are "Y" or "N"