| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for Item_Loc in BDI-RMS application. |
| BDI-RMS's Table Name |
BDI-RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
BDI-RMS's Column Length |
Is Column Required in BDI-RMS's API? |
BDI-RMS's API Description |
| loc_type |
varchar21 |
1 |
1 |
Describes the type of location. Valid values include S (store), W (warehouse) and E (external finisher). Data will always be present in this field. |
ITEM_LOC |
LOC_TYPE |
VARCHAR2 |
1 |
Yes |
Type of location in the location field.Valid values are S (store), W (warehouse), and E (external finisher). |
| location |
number10_0 |
1 |
1 |
Numeric ID of location. The intersection of location and item is a distinct entity. Data will always be present in this field. |
ITEM_LOC |
LOC |
NUMBER |
10,0 |
Yes |
Numeric identifier of the location in which the item is to be found. This field may contain a store, warehouse, or external finisher. |
| item |
varchar225 |
1 |
1 |
ID of item. The intersection of location and item is a distinct entity. Data will always be present in this field. |
ITEM_LOC |
ITEM |
VARCHAR2 |
25 |
Yes |
Unique alphanumeric value that identifies the item. |
| 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_LOC |
ITEM_PARENT |
VARCHAR2 |
25 |
No |
Alphanumeric value that uniquely identifies the item/group at the level above the item. |
| item_grandparent |
varchar225 |
0 |
1 |
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. |
ITEM_LOC. |
ITEM_GRANDPARENT |
VARCHAR2 |
25 |
No |
Alphanumeric value that uniquely identifies the item/group two levels above the item. |
| currency_code |
varchar23 |
0 |
1 |
This field contains the currency code under which the store/wh operates. |
STORE, WH, PARTNER |
CURRENCY_CODE |
VARCHAR2 |
3 |
Yes |
This field contains the currency code under which the warehouse operates. |
| initial_unit_retail |
number20_4 |
0 |
1 |
Contains the unit retail price in the standard unit of measure for the item/location combination. This field is stored in the local currency. |
ITEM_LOC |
UNIT_RETAIL |
NUMBER |
20,4 |
No |
Contains the unit retail price in the standard unit of measure for the item/location combination. This field is stored in the local currency. |
| selling_unit_retail |
number20_4 |
0 |
1 |
Contains the unit retail price in the selling unit of measure for the item/location combination. This field is stored in the local currency. |
ITEM_LOC |
SELLING_UNIT_RETAIL |
NUMBER |
20,4 |
No |
Contains the unit retail price in the selling unit of measure for the item/location combination. This field is stored in the local currency. |
| selling_uom |
varchar24 |
0 |
1 |
Contains the selling unit of measure for an items single-unit retail. |
ITEM_LOC |
SELLING_UOM |
VARCHAR2 |
4 |
No |
Contains the selling unit of measure for an items single-unit retail. |
| taxable_ind |
varchar21 |
0 |
1 |
Indicates if item is taxable at the store. |
ITEM_LOC |
TAXABLE_IND |
VARCHAR2 |
1 |
Yes |
"Indicates if item is taxable at the store. Valid values are, Y = Yes, the item is taxable N = No, the item is not taxable |
| local_item_desc |
varchar2250 |
1 |
1 |
Contains the local description of the item. This may be the same as the primary description of the item, a regional description of the item (e.g. jimmies vs sprinkles in the US or roll vs bap vs cob vs bun in the UK), or a value in a local language (e.g. Overlay dress true black knit at US stores vs Lagenkleid - Strick, tiefschwarz at stores in Germany). The intent is that this string is appropriate to print description on signage/receipts at this location. |
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. |
| local_short_desc |
varchar2120 |
0 |
1 |
Contains the local short description of the item. |
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. |
| ti |
number12_4 |
0 |
1 |
Number of shipping units (cases) that make up one tier of 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). |
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. |
| store_order_multiple |
varchar21 |
0 |
1 |
This column contains the multiple in which the item needs to be shipped from a warehouse to the location. |
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. |
| status |
varchar21 |
0 |
1 |
Current status of item at the store. |
ITEM_LOC |
STATUS |
VARCHAR2 |
1 |
Yes |
Current status of item at the store. Valid values are,A = Active, item is valid and can be ordered and sold I = Inactive, item is valid but cannot be ordered or sold C = Discontinued, item is valid and sellable but no longer orderable D = Delete, item is invalid and cannot be ordered or sold |
| 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. |
| measure_of_each |
number12_4 |
0 |
1 |
Size of an each in terms of the uom_of_price. For example 12 oz. Used in ticketing. |
ITEM_LOC |
MEAS_OF_EACH |
NUMBER |
12.4 |
No |
Size of an each in terms of the uom_of_price. For example 12 oz. Used in ticketing. |
| measure_of_price |
number12_4 |
0 |
1 |
Size to be used on the ticket in terms of the uom_of_price. |
ITEM_LOC |
MEAS_OF_PRICE |
NUMBER |
12,4 |
No |
Size to be used on the ticket in terms of the uom_of_price.For example, if the user wants the ticket to have the label print the price per ounce, this value would be 1. If the user wanted the price per 100 grams this value would be 100. Used in ticketing. |
| uom_of_price |
varchar24 |
0 |
1 |
Unit of measure that will be used on the ticket for this item. |
ITEM_LOC |
UOM_OF_PRICE |
VARCHAR2 |
4 |
No |
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. |
ITEM_LOC |
PRIMARY_VARIANT |
VARCHAR2 |
25 |
No |
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. Valid
choices will be any transaction level item that is a child of this item. In order to select a transaction level item as the primary variant, the item/location relationship must exist at the transaction level. Both the transaction level item (i.e. UPC) and the higher than transcation level item (i.e. PLU) will be sent to the POS to allow the store to sell the PLU. The information sent for the PLU will be the same information sent for the Transaction level item (i.e. UPC). |
| 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. |
ITEM_LOC |
PRIMARY_COST_PACK |
VARCHAR2 |
25 |
No |
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. |
| primary_supplier |
number10_0 |
0 |
1 |
Numeric identifier of the supplier who will be considered the primary supplier for the specified item/loc. |
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_origin_country |
varchar23 |
0 |
1 |
Contains the identifier of the origin country which will be considered the primary country for the specified item/location. |
ITEM_LOC |
PRIMARY_CNTRY |
VARCHAR2 |
3 |
No |
Contains the identifier of the origin country which will be considered the primary country for the specified item/location. |
| receive_as_type |
varchar22 |
0 |
1 |
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. |
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. |
| inbound_handling_days |
number2_0 |
0 |
1 |
This field indicates the number of inbound handling days for an item at a warehouse type location. |
ITEM_LOC |
INBOUND_HANDLING_DAYS |
NUMBER |
2,0 |
No |
This field indicates the number of inbound handling days for an item at a warehouse type location. |
| source_method |
varchar21 |
0 |
1 |
This value will be used to specify how the adhoc PO/TSF creation process should source the item/location request. |
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 |
0 |
1 |
This value will be used by the ad-hoc PO/Transfer creation process to determine which warehouse to fill the stores request from. |
ITEM_LOC |
SOURCE_WH |
VARCHAR2 |
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. |
| uin_type |
varchar26 |
0 |
1 |
This column will contain the unique identification number (UIN) used to identify the instances of the item at the location. |
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 column will contain the label for the UIN when displayed in SIM. |
ITEM_LOC |
UIN_LABEL |
VARCHAR2 |
6 |
No |
This column will contain the label for the UIN when displayed in SIM. |
| capture_time_in_proc |
varchar26 |
0 |
1 |
This column will indicate when the UIN should be captured for an item during transaction processing. |
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 |
EXT_UIN_IND This Yes/No indicator indicates if UIN is being generated in the external system. |
ITEM_LOC |
EXT_UIN_IND |
VARCHAR2 |
1 |
Yes |
This Yes/No indicator indicates if UIN is being generated in the external system. |
| intentionally_range_ind |
varchar21 |
0 |
1 |
This column determines if the location is ranged intentionally by the user for replenishment/selling or incidentally ranged by the RMS programs when item is not ranged to a specific location on the transaction. |
ITEM_LOC |
RANGED_IND |
VARCHAR2 |
1 |
Yes |
This column determines if the location is ranged intentionally by the user for replenishment/selling or incidentally ranged by the RMS programs when item is not ranged to a specific location on the transaction. |
| costing_location |
number10_0 |
0 |
1 |
Numeric identifier of the costing location for the franchise store. This field may contain a store or a warehouse. |
ITEM_LOC |
COSTING_LOC |
NUMBER |
10,0 |
No |
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. |
ITEM_LOC |
COSTING_LOC_TYPE |
VARCHAR2 |
1 |
No |
This field holds the type of costing location in the costing location field. |
| launch_date |
xs:dateTime |
0 |
1 |
Holds the date that they item should first be sold at the location. |
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. |
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. |
ITEM_LOC_TRAITS |
MANUAL_PRICE_ENTRY |
VARCHAR2 |
6 |
No |
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 or removed as needed. This value will be downloaded to the POS. |
| deposit_code |
varchar26 |
0 |
1 |
Indicates whether a deposit is associated with this item at the location. |
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 |
Holds the value associated of the packaging in items sold by weight at the location. |
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 value associated of the packaging in items sold by weight at the location. |
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. |
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. |
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. |
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 |
Holds the return policy for the item at the location. Valid values for this field belong to the code_type RETP. |
ITEM_LOC_TRAITS |
RETURN_POLICY |
VARCHAR2 |
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). |
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_mtk_club |
varchar26 |
0 |
1 |
Holds the code that represents the marketing clubs to which the item belongs at the location. |
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. |
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 |
0 |
1 |
Holds the required shelf life for an item on receipt in days. |
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. |
| ib_shelf_life |
number4_0 |
0 |
1 |
This column will hold the Investment Buyspecific 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_orderable_ind |
varchar21 |
0 |
1 |
STORE_REORDERABLE_IND 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. |
ITEM_LOC_TRAITS |
STORE_REORDERABLE_IND |
VARCHRA2 |
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. This field is not required. Valid values for the field can be found and defined in the code_type RACK. |
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 |
Indicates whether a store must reorder an item in full pallets only. |
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 |
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. |
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. |
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. |
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 Yes 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 Yes when the item is refundable at the location. |
ITEM_LOC_TRAITS |
REFUNDABLE_IND |
VARHCAR2 |
1 |
No |
This field will contain a value of Yes when the item is refundable at the location. |
| backorder_ind |
varchar21 |
0 |
1 |
This field will contain a value of Yes 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 |
| merchandise_ind |
varchar21 |
0 |
1 |
Indicates if the item is a merchandise item (Y, N). |
ITEM_MASTER |
MERCHANDISE_IND |
VARCHAR2 |
1 |
Yes |
Indicates if the item is a merchandise item (Y, N). |
