Retail Integration Mappings Report Release:15.0.0 (Integration Gateway Services)
Application Integration Gateway Services
Target Name Space http://www.oracle.com/retail/integration/base/bo/XItemLocDesc/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:XItemLocDesc 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 XItemLocDesc in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
item varchar225 1 1 The identifier for the item. RMS.item_loc item varchar2 25 Yes The identifier for the item.
hier_level varchar22 1 1 The level of the organizational hierarchy to which the hier_value field pertains. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), and W (warehouse). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes The level of the organizational hierarchy to which the hier_value field pertains. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), and W (warehouse).
XItemLocDtl * 1 unbounded Child node.

XML-Schema Name:XItemLocDtl 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 XItemLocDtl in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
hier_value number10 1 1 The same value as in the hier_level field. RMS.* * null null Yes The same value as in the hier_level field.
primary_supp number10 1 1 The primary supplier for the item at the location. If not populated on a create message this will default from the primary supplier on the ITEM_SUPPLIER table. RMS.item_loc primary_supp number 10 No The primary supplier for the item at the location. If not populated on a create message this will default from the primary supplier on the ITEM_SUPPLIER table.
primary_cntry varchar23 1 1 The primary country for the item at the location. If not populated on a create message this will default from the primary country on the ITEM_SUPP_COUNTRY table. RMS.item_loc primary_cntry varhcar2 3 No The primary country for the item at the location. If not populated on a create message this will default from the primary country on the ITEM_SUPP_COUNTRY table.
local_item_desc varchar2250 0 1 Local description for the item at the location. If not populated on the message this will default from the ITEM_MASTER table. RMS.item_loc local_item_desc varchar2 350 No Local description for the item at the location. If not populated on the message this will default from the ITEM_MASTER table.
status varchar21 1 1 The status of the item at the location. This value must be 'A' (active) on a create message. On a modify messge it can be 'I' (inactive), 'C' (discontinued), or 'D' (deleted). RMS.item_loc status varchar2 1 Yes The status of the item at the location. This value must be A (active) on a create message. On a modify messge it can be I (inactive), C (discontinued), or D (deleted).
store_ord_mult varchar21 1 1 The unit type of the item shipped from the warehouse to the location. Valid values are C (cases), I (inners), and E (eaches). Eaches will default if left null on a create message. RMS.item_loc store_ord_mult varchar2 1 No The unit type of the item shipped from the warehouse to the location. Valid values are C (cases), I (inners), and E (eaches). Eaches will default if left null on a create message.
receive_as_type varchar21 1 1 The unit in which the warehouse will receive goods. Valid values are E (eaches) and P (pack). This field only applies to buyer packs. If the item is not a buyer pack this field should be null. RMS.item_loc receive_as_type varchar2 1 No The unit in which the warehouse will receive goods. Valid values are E (eaches) and P (pack). This field only applies to buyer packs. If the item is not a buyer pack this field should be null.
taxable_ind varchar21 1 1 Indicates if the item is taxable at the location. Valid values are 'Y' and 'N'. If not populated on the message it will default to 'Y'. RMS.item_loc taxable_ind varchar2 1 No Indicates whether the item is taxable at the location. Valid values are Y and N. If not populated in the message, it will default to Y.
ti number12_4 0 1 Number of shipping units (cases) that make up one tier of a pallet. Multiply TI x HI to get total number of cases for a pallet. RMS.item_loc ti number 12 No Number of shipping units (cases) that make up one tier of a pallet. Multiply TI by HI for the total number of cases for a pallet.
hi number12_4 0 1 Number of tiers that make up a complete pallet (height). Multiply TI x HI to get total number of cases for a pallet. RMS.item_loc hi number 12 No Number of tiers that make up a complete pallet (height). Multiply TI by HI for the total number of cases for a pallet.
daily_waste_pct number12_4 0 1 Average percentage lost from inventory on a daily basis due to natural wastage. RMS.item_loc daily_waste_pct number 12 No Average percentage lost from inventory on a daily basis due to natural wastage.
local_short_desc varchar2120 0 1 The local short description of the item. Will default to the item's short description. Will be downloaded to the POS. RMS.item_loc local_short_desc varchar2 120 No The local short description of the item. Will default to the item's short description. Will be downloaded to the POS.
XItemLocTrt * 0 1 Child node.
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. RMS.item_loc uin_type varchar2 6 No 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.
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. RMS.item_loc uin_label varchar2 6 No 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.
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. RMS.item_loc capture_time varchar2 6 No 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
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. RMS.item_loc ext_uin_ind varchar2 1 Yes 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.
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'. RMS.item_loc source_method varchar2 1 No This value will be used to specify how the ad-hoc PO/TSF creation process should source the item/stores request. If the value is Warehouse, the process will attempt to fill the request by creating a transfer from the item/locations primary sourcing warehouse. If this warehouse doesnt have enough inventory to fill the request a purchase order will be created for the item/locations primary supplier.
source_wh number10 0 1 If the source_method is 'W', this field contains the source warehouse for fulfilling item requests at a store. RMS.item_loc source_wh number 10 No This value will be used by the ad-hoc PO/Transfer creation process to determine which warehouse to fill the stores request from. A value will be required in this field if the sourcing method is Warehouse.

XML-Schema Name:XItemLocTrt 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 XItemLocTrt in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
launch_date xs:dateTime 0 1 The date the item should first be sold at the location. Value will be downloaded to the POS. No internal processing occurs from this field. RMS.item_loc_traits launch_date date null No The date on which the item should first be sold at the location. Value will be downloaded to the POS. No internal processing occurs from this field.
qty_key_options varchar26 0 1 Determines whether the qty key on a POS should be used for this item at the location. Valid values are in the code_type 'RPO'. Current values include 'R - required', 'P - Prohibited', and 'O - Optional'. Additional values can be added to the code type RMS.item_loc_traits qty_key_options varchar2 6 No Determines whether the quantity key on a POS should be used for this item at the location. Valid values are in the code_type, RPO. Valid values are R (required), P (prohibited), and O (optional). Additional values can be added to the code type
manual_price_entry varchar26 0 1 Determines whether the price can/should be entered manually on a POS for this item at the location. Valid values are in the code_type 'RPO'. Current values include 'R - required', 'P - Prohibited', and 'O - Optional'. Additional values can be added. RMS.item_loc_traits manual_price_entry varchar2 6 No Determines whether the price can or should be entered manually on a POS for this item at the location. Valid values are in the code_type, RPO. Valid values include R (required), P (prohibited), and O (optional). Additional values can be added.
deposit_code varchar26 0 1 Indicates whether a deposit is associated with this item at the location. Values are in the code_type 'DEPO'. The only processing in RMS is downloading it to the POS RMS.item_loc_traits deposit_code varchar2 6 No Indicates whether a deposit is associated with this item at the location. Values are in the code_type, DEPO. The only processing in RMS is downloading it to the POS.
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. RMS.item_loc_traits food_stamp_ind varchar2 1 No 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. RMS.item_loc_traits wic_ind varchar2 1 No 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 For items sold by weight, this is the proportion of the total weight of a unit of an item that is packaging. RMS.item_loc_traits proportional_tare_pct number 12,4 No For items sold by weight, this is the proportion of the total weight of a unit of an item that is packaging.
fixed_tare_value number12_4 0 1 Holds the weight of the packaging in items sold by weight at the location; i.e. if the tare item is bulk candy, this is weight of the bag and twist tie). The only processing RMS does is to download it to POS. RMS.item_loc_traits fixed_tare_value number 12,4 No Holds the weight of the packaging in items sold by weight at the location. If the tare item is bulk candy, for example, this is weight of the bag and twist tie. The only processing RMS does is download it to POS.
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. Fixed tare is not subtracted from items sold by weight when sales are uploaded to RMS, etc RMS.item_loc_traits fixed_tare_uom varchar2 4 No 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. Fixed tare is not subtracted from items sold by weight when sales are uploaded to RMS.
reward_eligible_ind varchar21 0 1 Holds whether the item is legally valid for various types of bonus point/award programs at the location. This value will be downloaded to the POS. RMS.item_loc_traits reward_eligible_ind varchar2 1 No Indicates whether the item is legally valid for various types of bonus point/award programs at the location. This value will be downloaded to the POS.
natl_brand_comp_item varchar225 0 1 Holds the nationally branded item to which you would like to compare the current item. This nationally branded item must exist as an item in RMS (i.e. on the item_master table). RMS.item_loc_traits natl_brand_comp_item varchar2 25 No Holds the nationally branded item to which you would like to compare the current item. This nationally branded item must exist as an item in RMS (on the item_master table).
return_policy varchar26 0 1 The return policy for the item at the location. Valid values are in the code_type 'RETP'. This value will be downloaded to the POS. RMS.item_loc_traits return_policy varhcar2 6 No The return policy for the item at the location. Valid values are in the code_type, RETP. This value will be downloaded to the POS.
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). This value will be downloaded to the POS. RMS.item_loc_traits stop_sale_ind varchar2 1 No Indicates that sale of the item should be stopped immediately at the location (in case of recall, for example). This value will be downloaded to the POS.
elect_mkt_clubs varchar26 0 1 Code for the marketing clubs to which the item belongs at the location. Valid values are in the code_type 'MTKC'. RMS.item_loc_traits elect_mtk_clubs varchar2 6 No Code for the marketing clubs to which the item belongs at the location. Valid values are in the code_type, MTKC.
report_code varchar26 0 1 Code to determine which reports the location should run. Values are in the code type 'REPC'. RMS.item_loc_traits report_code varchar2 6 No Code to determine the reports the location should run. Values are in the code type, REPC.
req_shelf_life_on_selection number4 0 1 Holds the required shelf life for an item on selection in days. This field is not required. No RMS processing is based on the value in this field. It is clients responsibility to communicate this value to external systems that may need it. RMS.item_loc_traits req_shelf_life_on_selection number 4 No Holds the required shelf life for an item on selection in days. This field is not required. No RMS processing is based on the value in this field. It is clients responsibility to communicate this value to external systems that may need it.
req_shelf_life_on_receipt number4 0 1 Holds the required shelf life for an item on receipt in days. This field is not required. No RMS processing is based on the value in this field. It is clients responsibility to communicate this value to external systems that may need it for processing RMS.item_loc_traits req_shelf_life_on_receipt number 4 No Holds the required shelf life (in days) for an item on receipt. This field is not required. No RMS processing is based on the value in this field. It is the retailer's responsibility to communicate this value to external systems that may need it for processing.
ib_shelf_life number4 0 1 The Investment Buy-specific shelf life for the item/location RMS.item_loc_traits ib_shelf_life number 4 No The Investment Buy-specific shelf life for the item/location.
store_reorderable_ind varchar21 0 1 A code (Y or N) to indicate whether the store may re-order the item. Will default to N. No RMS processing is based on the value in this field. It is clients responsibility to communicate this value to external systems. RMS.item_loc_traits store_reorderable_ind varchar2 1 No Indicates whether the store may re-order the item. Valid values are Y and N. The field defaults to N. No RMS processing is based on the value in this field. It is the retailer's responsibility to communicate this value to external systems.
rack_size varchar26 0 1 Indicates the rack size that should be used for the item. Valid values for the field are in the code_type 'RACK'. No RMS processing is based on the value in this field. It is clients responsibility to communicate to external systems. RMS.item_loc_traits rack_size varchar2 6 No Indicates the rack size that should be used for the item. Valid values for the field are in the code_type, RACK. No RMS processing is based on the value in this field. It is the retailer's responsibility to communicate to external systems.
full_pallet_item varchar21 0 1 A code (Y or N) to indicate whether a store must reorder an item in full pallets only. Will default to N. No RMS processing is based on the value in this field. It is clients responsibility to communicate to external systems. RMS.item_loc_traits full_pallet_item varchar2 1 No A code to indicate whether a store must reorder an item in full pallets only. Valid values are Y and N. The field defaults to N. No RMS processing is based on the value in this field. It is the retailer's responsibility to communicate to external systems.
in_store_market_basket varchar26 0 1 The in store market basket code for this item/location. Valid values for the field are in the code_type 'STMB'. No RMS processing is based on the value in this field. It is clients responsibility to communicate this value to external systems. RMS.item_loc_traits in_store_market_basket varchar2 6 No The in store market basket code for this item/location. Valid values for the field are in the code_type, STMB. No RMS processing is based on the value in this field. It is the retailer's responsibility to communicate this value to external systems.
storage_location varchar27 0 1 Holds the current storage location or bin number for the item at the location. No RMS processing is based on the value in this field. It is clients responsibility to communicate this value to external systems that may need it for processing. RMS.item_loc_traits storage_location varchar2 7 No Holds the current storage location or bin number for the item at the location. No RMS processing is based on the value in this field. It is the retailer's responsibility to communicate this value to external systems that may need it for processing.
alt_storage_location varchar27 0 1 Holds the preferred alternate storage location or bin number for the item at the location. No RMS processing is based on the value in this field. It is clients responsibility to communicate this value to external systems that may need it for processing RMS.item_loc_traits alt_storage_location varchar2 7 No Holds the preferred alternate storage location or bin number for the item at the location. No RMS processing is based on the value in this field. It is the retailer's responsibility to communicate this value to external systems that may need it for processing.
returnable_ind varchar21 0 1 This field will contain a value of 'Y'es when the item can be returned to the location RMS.item_loc_traits returnable_ind varchar2 1 No This field will contain a value of Y when the item can be returned to the location.
refundable_ind varchar21 0 1 This field will contain a value of 'Y'es when the item is refundable at the location. RMS.item_loc_traits refundable_ind varchar2 1 No This field will contain a value of Y when the item is refundable at the location.
back_order_ind varchar21 0 1 This field will contain a value of 'Y'es when the item can be back ordered to the location RMS.item_loc_traits back_order_ind varchar2 1 No This field will contain a value of Y when the item can be back ordered to the location.
create_datetime xs:dateTime 0 1 The the time and date of record creation. RMS.item_loc_traits create_datetime date null No The time and date of record creation.
last_update_id varchar230 0 1 The user id of the last user to update the record. RMS.item_loc_traits last_update_id varchar2 30 No The user ID of the last user to update the record.
last_update_datetime xs:dateTime 0 1 The time and date of the last update of the record. RMS.item_loc_traits last_update_datetime date null No The time and date of the last update of the record.