Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ItemLocVirt |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
loc |
number10 |
1 |
1 |
Location where the item is to be found. This field may contain a store or a warehouse. |
item_loc |
loc |
number |
10 |
Yes |
Location where the item is to be found. This field may contain a store or a warehouse. |
loc_type |
varchar21 |
1 |
1 |
Type of location in the "loc" field. Valid values are 'S' (store) and 'W' (warehouse). |
item_loc |
loc_type |
varchar2 |
1 |
Yes |
Type of location in the "loc" field. Valid values are 'S' (store) and 'W' (warehouse). |
local_item_desc |
varchar2250 |
1 |
1 |
NA |
item_loc |
local_item_desc |
varchar2 |
250 |
Yes |
Contains the local description of the item. |
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. |
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 the item at the store (valid values are 'A' (active), 'I' (inactive), 'C' (discontinued) and 'D' (deleted). |
primary_supp |
number10 |
0 |
1 |
Not Yet Available |
item_loc |
primary_supp |
number |
10 |
No |
Primary supplier for the item/location. |
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 origin country which will be considered the primary country for the 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 |
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. |
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 |
null |
null |
No |
Determines the source method for a requested item at a store. Valid values: 'W'(warehouse) and 'S'(supplier), default value is 'S'. |
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 |
No |
If the source_method is 'W', this field contains the source warehouse for fulfilling item requests at a store. |
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 |
null |
null |
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 |
null |
null |
No |
Selling unit retail in selling unit of measure. Only published for create, not update |
selling_uom |
varchar24 |
0 |
1 |
Selling Unit of measure. Only published for Create not update. |
item_loc |
selling_uom |
null |
null |
No |
Selling Unit of measure. Only published for Create not update. |
store_price_ind |
varchar21 |
0 |
1 |
Not Yet Available |
item_loc |
store_price_ind |
null |
null |
Yes |
Indicates if the location can modify the item's price |
purchase_type |
varchar26 |
0 |
1 |
Purchase Type |
NA |
NA |
NA |
NA |
NA |
NA |
ExtOfItemLocDesc:ExtOfItemLocVirt
|
*
|
0
|
1
|
Provide an extension hook to customize ItemLocVirt.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|