| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItemLocVirt 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 |
| loc |
number10 |
1 |
1 |
Location where the item is to be found. This field may contain a store or a warehouse. |
repl_item_loc |
location |
number |
10,0 |
Yes |
Location that is on replenishment. Will hold only virtual warehouse in the multi-channel environment. |
| loc_type |
varchar21 |
1 |
1 |
Type of location in the "loc" field. Valid values are 'S' (store) and 'W' (warehouse). |
repl_item_loc |
loc_type |
varchar2 |
1 |
Yes |
Contains the type of the location on replenishment. Valid values include 'S'tore, 'W'arehouse. |
| local_item_desc |
varchar2250 |
1 |
1 |
NA |
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 |
Not Yet Available |
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. |
| 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 item at the store. |
| primary_supp |
number10 |
0 |
1 |
Not Yet Available |
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 |
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 identifier of the origin country which will be considered the primary country for the specified 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 |
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 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 |
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. |
| 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 |
number |
20,4 |
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 |
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 |
Selling Unit of measure. Only published for Create not update. |
item_loc |
selling_uom |
varchar2 |
4 |
No |
Contains the selling unit of measure for an items single-unit retail. |
| store_price_ind |
varchar21 |
0 |
1 |
Indicates if the location can modify the item's price. |
item_loc |
store_price_ind |
varchar2 |
1 |
Yes |
This field indicates if an item at a particular store location can have the unit retail marked down by the store. |
| purchase_type |
varchar26 |
0 |
1 |
Purchase Type |
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. |
| 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 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. |
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. |
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. |
| ranged_ind |
varchar21 |
1 |
1 |
An indicator to differentiate between user ranged locations and RMS program ranged locations. Values are 'Y' or 'N'. |
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. |
|
CustFlexAttriVo:CustFlexAttriVo
|
*
|
0
|
unbounded
|
References a collection of customer flexible attributes.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
| 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 |
ID 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. |
| 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_ord_mult |
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. |
| 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. |
| meas_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. |
| meas_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. 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. |
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. |
| inbound_handling_days |
number2 |
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. |
| regular_unit_retail |
number20_4 |
0 |
1 |
This field holds the unit retail in the standard unit of measure for the item/location (zone) combination. This field is stored in the local currency. |
item_loc |
regular_unit_retail |
number |
20,4 |
No |
This field holds the unit retail in the standard unit of measure for the item/location (zone) combination. This field is stored in the local currency. |
| multi_units |
number12_4 |
0 |
1 |
This field contains the multi-units for the item/location (zone) combination. |
item_loc |
multi_units |
number |
12,4 |
No |
This field contains the multi-units for the item/location (zone) combination. |
| multi_unit_retail |
number20_4 |
0 |
1 |
This field holds the multi-unit retail in the multi-selling unit of measure for the item/location (zone) combination. This field is stored in teh local currency. |
item_loc |
multi_unit_retail |
number |
20,4 |
No |
This field holds the multi-unit retail in the multi-selling unit of measure for the item/location (zone) combination. This field is stored in teh local currency. |
| multi_selling_uom |
varchar24 |
0 |
1 |
This field holds the selling unit of measure for this item/location (zone) combinations multi-unit retail. |
item_loc |
multi_selling_uom |
varchar2 |
4 |
No |
This field holds the selling unit of measure for this item/location (zone) combinations multi-unit retail. |
| clear_ind |
varchar21 |
0 |
1 |
"Indicates if item is on clearance at the store. Valid values are: Y = Yes, the item is on clearance N = No, the item is not on clearance". |
item_loc |
clear_ind |
varchar2 |
1 |
Yes |
Indicates if item is on clearance at the store. |
| costing_loc |
number10 |
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 |
|
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. |
| currency_code |
varchar23 |
0 |
1 |
This field contains the currency code under which the store/wh operates. |
store |
currency_code |
varchar2 |
3 |
Yes |
This field contains the currency code under which the store operates. |
| 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_clubs |
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 |
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. |
| req_shelf_life_on_receipt |
number4 |
0 |
1 |
Holds the required shelf life for an item on receipt in days. |
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. |
| store_reorderable_ind |
varchar21 |
0 |
1 |
This field 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. |
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. 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. |
| 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. |
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. |
| 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 |
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 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 |
| 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 |
| unit_cost |
number20_4 |
0 |
1 |
This field contains the current unit cost of the item |
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. |
| pickup_lead_time |
number4 |
0 |
1 |
Contains the time it takes to get the item from the Supplier to the Initial Receiving Location. |
item_supp_country_loc |
pickup_lead_time |
number |
4,0 |
No |
Contains the time it takes to get the item from the Supplier to the Initial Receiving Location. |
| 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. |
| 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. |
| 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. |
