Retail Integration Mappings Report Release:16.0.030 (Retail Merchandising System)
Application Retail Merchandising System
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:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItemLocDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
item varchar225 1 1 The identifier for the item. item_loc item varchar2 25 Yes Unique alphanumeric value that identifies 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). * * * * No
XItemLocDtl * 1 unbounded Child node.

XML-Schema Name:XItemLocDtl 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 XItemLocDtl in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
hier_value number10 1 1 The same value as in the hier_level field. * * * * No
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. item_loc primary_supp number 10,0 No Numeric identifier of the supplier who will be considered the primary supplier for the specified item/loc. The supplier/origin country combination will determine the value of the unit cost field on item_loc. If the supplier is changed and ELC = N, the unit cost field on item_loc will be updated with the new suppliers cost.
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. item_loc primary_cntry varhcar2 3 No Contains the identifier of the origin country which will be considered the primary country for the specified item/location.
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. item_loc local_item_desc varchar2 250 Yes Contains the local description of the item. This field will default to the items description but will be over-ridable. This value will be downloaded to the POS.
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). item_loc status varchar2 1 Yes Current status of item at the store.
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. item_loc store_ord_mult varchar2 1 Yes This column contains the multiple in which the item needs to be shipped from a warehouse to the location.
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. item_loc receive_as_type varchar2 1 No This column 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 Each or Pack.
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'. item_loc taxable_ind varchar2 1 Yes Indicates if item is taxable at the store.
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. item_loc ti number 12,4 No 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.
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. item_loc hi number 12,4 No Number of tiers that make up a complete pallet (height). Multiply TI x HI to get 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. item_loc daily_waste_pct number 12,4 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. item_loc local_short_desc varchar2 120 No Contains the local short description of the item. This field will default to the items short description but will be over-ridable. This value 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. item_loc uin_type varchar2 6 No This column will contain the unique identification number (UIN) used to identify the instances of the item at the location.
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. item_loc uin_label varchar2 6 No This column will contain the label for the UIN when displayed in SIM.
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. item_loc capture_time varchar2 6 No This column will indicate when the UIN should be captured for an item during transaction processing.
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. item_loc ext_uin_ind varchar2 1 Yes This Yes/No indicator indicates if UIN is being generated in the external system.
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 varchar2 1 No This value will be used to specify how the ad-hoc PO/TSF creation process should source the item/location request. If the value is Warehouse, the process will attempt to fill the request by creating a transfer from the warehouse mentioned in the source_wh field. If this warehouse doesn't have enough inventory to fill the request, a purchase order will be created for the item/location's primary supplier. For warehouses, it is used by Oracle Retail Allocation to determine the valid sources and destinations for warehouse to warehouse allocations.
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,0 No This value will be used by the ad-hoc PO/Transfer creation process to determine which warehouse to fill the stores request from. It will also be used by the Allocation process to support warehouse to warehouse allocations. A value will be required in this field if the sourcing method is Warehouse.
CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA
unit_cost number20_4 0 1 The current corporate unit cost for the item in the location's currency. This field will only be used to establish the item\supplier\country\loc unit cost; it cannot be modified. item_supp_country_loc unit_cost number 20,4 Yes The current unit cost of the item for the item/supplier/origin_country combination. This field is stored in the suppliers currency.
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. item_supp_country_loc cost_uom varchar2 4 No A cost UOM is held to allow costs to be managed in a separate UOM than the standard UOM. The unit cost stored in standard UOM is converted to cost UOM for display in the Item Supplier Country Loc screen. Likewise, if the user enters or updates the unit cost via the Item Supplier Country Loc screen, it is converted to standard UOM before being saved to the table.
purchase_type varchar21 0 1 This contains a code to indicate whether the item is normal merchandise (i.e. owned by the retailer), consignment stock or a concession item. Valid values are 0 - Owned, 1 - Consignment, 2 - Concession. item_supp_country_loc purchase_type number 1,0 No This contains a code to indicate whether the item is normal merchandise (i.e. owned by the retailer), consignment stock or a concession item. Valid values are 0 - Owned, 1 - Consignment, 2 - Concession.
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. item_supp_country_loc calculation_basis varchar2 1 No 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. item_supp_country_loc purchase_rate number 12,4 No This column contains the percentage of the retail price which will determine the cost paid to the supplier for a consignment or concession item.
promotable_ind varchar21 0 1 This field will indicates,if the item can be included on promotions or not. item_loc promotable_ind varchar2 1 Yes This field indicates if the retailer ia allowed to specify if the item is promotable or not
rfid_ind varchar21 0 1 This indicates if the item is RFID tagged or not. Valid values are Yes (Y) and No (N). item_loc rfid_ind varchar2 1 Yes This field allows the retailer to specify if the item should be RFID tagged or not.

XML-Schema Name:XItemLocTrt 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 XItemLocTrt in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS'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. item_loc_traits launch_date date * No Holds the date that they item should first be sold at the location. This 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 item_loc_traits qty_key_options varchar2 6 No 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 as needed. This value will be downloaded to the POS as needed.
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. 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 item_loc_traits deposit_code varchar2 6 No Indicates whether a deposit is associated with this item at the location. Valid values are in the code_type DEPO. Additional values may be added or removed as needed. The only processing in RMS involving the deposit code is downloading it to the POS. Deposits are not subtracted from the retail of an item uploaded to RMS, etc. This kind of processing is the responsibility of the client and should occur before sales are sent to any Oracle Retail application.
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. 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. 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. item_loc_traits proportional_tare_pct number 12,4 No Holds the value associated of the packaging in items sold by weight at the location. The proportional tare is the proportion of the total weight of a unit of an item that is packaging (i.e. if the tare item is bulk candy, this is the proportional of the total weight of one piece of candy that is the candy wrapper). The only processing RMS does involving the proportional tare percent is downloading it to the POS. Proportional tare is not subtracted from items sold by weight when sales are uploaded to RMS, etc. This kind of processing is the responsibility of the client and should occur before sales are sent to any Oracle Retail application.
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. item_loc_traits fixed_tare_value number 12,4 No Holds the value associated of the packaging in items sold by weight at the location. Fixed tare is the tare of the packagine used to (i.e. if the tare item is bulk candy, this is weight of the bag and twist tie). The only processing RMS does involving the fixed tare value is downloading it to the POS. Fixed tare is not subtracted from items sold by weight when sales are uploaded to RMS, etc. This kind of processing is the responsibility of the client and should occur before sales are sent to any Oracle Retail application.
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 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, etc. This kind of processing is the responsibility of the client and should occur before sales are sent to any Oracle Retail application.
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. item_loc_traits reward_eligible_ind varchar2 1 No 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.
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). 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 (i.e. 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. item_loc_traits return_policy varhcar2 6 No Holds the return policy for the item at the location. Valid values for this field belong to the code_type RETP. Additional values can be added or removed from the code type as needed. 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. item_loc_traits stop_sale_ind varchar2 1 No 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.
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'. item_loc_traits elect_mtk_clubs varchar2 6 No Holds the code that represents the marketing clubs to which the item belongs at the location. Valid values can belong to the code_type MTKC. Additional values can be added or removed from the code type as needed. This value will be downloaded to the POS.
report_code varchar26 0 1 Code to determine which reports the location should run. Values are in the code type 'REPC'. item_loc_traits report_code varchar2 6 No Code to determine which reports the location should run. Valid values are defined in the code type REPC. Values may be added and removed as necessary. 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.
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. item_loc_traits req_shelf_life_on_selection number 4,0 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 for processing.
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 item_loc_traits req_shelf_life_on_receipt number 4,0 No 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.
ib_shelf_life number4 0 1 The Investment Buy-specific shelf life for the item/location item_loc_traits ib_shelf_life number 4,0 No This column will hold 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. item_loc_traits store_reorderable_ind varchar2 1 No 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. 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.
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. item_loc_traits rack_size varchar2 6 No 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. 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.
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. item_loc_traits full_pallet_item varchar2 1 No Indicates whether a store must reorder an item in full pallets only. This field is required to be either Y - yes or N - no. The field 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 that may need it for processing.
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. item_loc_traits in_store_market_basket varchar2 6 No 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. 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.
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. 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 clients 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 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 clients 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 item_loc_traits returnable_ind varchar2 1 No This field will contain a value of Yes 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. item_loc_traits refundable_ind varchar2 1 No 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 'Y'es when the item can be back ordered to the location item_loc_traits back_order_ind varchar2 1 No This field will contain a value of Yes when the item can be back ordered to the location
create_datetime xs:dateTime 0 1 The the time and date of record creation. item_loc_traits create_datetime date * Yes This field will hold the time and date stamp of record creation.
last_update_id varchar230 0 1 The user id of the last user to update the record. item_loc_traits last_update_id varchar2 30 Yes This field holds the oracle 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. item_loc_traits last_update_datetime date * Yes This field holds the time and date stamp of the last update of the record.

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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.