Retail Integration Bus Mappings Report Release:13.1.1

(Retail Merchandising System)

Application	Retail Merchandising System
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.
	ItemLocDesc ItemLocPhys ItemLocVirt ExtOfItemLocVirt ItemLocVirtRepl ExtOfItemLocVirtRepl ExtOfItemLocPhys ExtOfItemLocDesc

XML-Schema Name:ItemLocDesc

Version:13.1.1

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

XML-Schema Name:ItemLocPhys

Version:13.1.1

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 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.
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.1

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
ExtOfItemLocDesc:ExtOfItemLocVirt	*	0	1	Provide an extension hook to customize ItemLocVirt.	NA	NA	NA	NA	NA	NA

XML-Schema Name:ExtOfItemLocVirt

Version:13.1.1

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:ItemLocVirtRepl

Version:13.1.1

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

XML-Schema Name:ExtOfItemLocVirtRepl

Version:13.1.1

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:ExtOfItemLocPhys

Version:13.1.1

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:ExtOfItemLocDesc

Version:13.1.1

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