Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For XItemLocTrt |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
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 |
null |
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 |
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. |
item_loc_traits |
manual_price_entry |
null |
null |
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 |
null |
null |
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. |
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 |
null |
null |
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. |
item_loc_traits |
fixed_tare_value |
null |
null |
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 |
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. |
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). |
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. |
item_loc_traits |
return_policy |
null |
null |
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. |
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'. |
item_loc_traits |
elect_mtk_clubs |
null |
null |
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'. |
item_loc_traits |
report_code |
null |
null |
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. |
item_loc_traits |
req_shelf_life_on_selection |
null |
null |
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 |
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 |
item_loc_traits |
ib_shelf_life |
null |
null |
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. |
item_loc_traits |
store_reorderable_ind |
null |
null |
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. |
item_loc_traits |
rack_size |
null |
null |
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. |
item_loc_traits |
full_pallet_item |
null |
null |
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. |
item_loc_traits |
in_store_market_basket |
null |
null |
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. |
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 |
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 |
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. |
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 |
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. |
item_loc_traits |
create_datetime |
null |
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. |
item_loc_traits |
last_update_id |
null |
null |
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. |
item_loc_traits |
last_update_datetime |
null |
null |
No |
The time and date of the last update of the record. |
ExtOfXItemLocDesc:ExtOfXItemLocTrt
|
*
|
0
|
1
|
Provide an extension hook to customize XItemLocTrt.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfXItemLocDesc:LocOfXItemLocTrt
|
*
|
0
|
1
|
Provide an extension hook to localize XItemLocTrt.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|