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

XML-Schema Name:ItemLocDesc 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 ItemLocDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
item varchar225 1 1 Not Yet Available item_master item_id RIB 25 Yes Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc.
ItemLocPhys * 1 unbounded Description is not available.

XML-Schema Name:ItemLocPhys 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 ItemLocPhys in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
physical_loc number10 1 1 Identifier of the physical location where the item is located. transshipment_setup dc_dest_id varchar2 10 Yes Used to derive facility 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 or/and RSL Fill column length. Yes Fill this description.
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 or/and RSL Fill column length. Yes Fill this description.
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 or/and RSL Fill column length. Yes Fill this description.
returnable_ind varchar21 0 1 This field will contain a value of Yes when the item can be returned to the location. item_master returnable_flag varchar2 1 Yes Flag to determine if the Item is returnable to the warehouse for a consumer direct order.
ItemLocVirt * 0 unbounded Description is not available.
ItemLocVirtRepl * 0 unbounded Description is not available.

XML-Schema Name:ItemLocVirt 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 ItemLocVirt in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
loc number10 1 1 Location where the item is to be found. This field may contain a store or a warehouse. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Fill this description.
loc_type varchar21 1 1 Type of location in the "loc" field. Valid values are 'S' (store) and 'W' (warehouse). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Fill this description.
local_item_desc varchar2250 1 1 NA Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Fill this description.
local_short_desc varchar2120 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Fill this description.
status varchar21 1 1 Current status of the item at the store (valid values are 'A' (active), 'I' (inactive), 'C' (discontinued) and 'D' (deleted). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Fill this description.
primary_supp number10 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Fill this description.
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 or/and RSL Fill column length. No Fill this description.
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 or/and RSL Fill column length. No Fill this description.
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 or/and RSL Fill column length. No Fill this description.
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 or/and RSL Fill column length. No Fill this description.
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 or/and RSL Fill column length. No Fill this description.
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 or/and RSL Fill column length. No Fill this description.
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. RIB or/and RSB or/and RSL Fill column length. No Fill this description.
selling_uom varchar24 0 1 Selling Unit of measure. Only published for Create not update. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Fill this description.
store_price_ind varchar21 0 1 Indicates if the location can modify the item's price. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Fill this description.
purchase_type varchar26 0 1 Purchase Type Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
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 or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:ItemLocVirtRepl 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 ItemLocVirtRepl in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
loc number10 1 1 Location that is on replenishment. Will hold only virtual warehouse in the multi-channel environment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Fill this description.
loc_type varchar21 1 1 Contains the type of the location on replenishment. Valid values include 'S'tore, 'W'arehouse. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Fill this description.
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. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Fill this description.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Fill this description.
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." Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Fill this description.
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. Fill application table name. Fill table column name. RIBDate * No Fill this description.
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 or/and RSL Fill column length. Yes Fill this description.