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 RSL) |
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 |
null |
null |
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. |
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 |
'W'(warehouse) and 'S'(supplier), default value is 'S'. |
No |
Determines the source method for a requested item at a store. Valid values |
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 |
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 |
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 |
Indicates if the location can modify the item's price. |
item_loc |
store_price_ind |
varchar2 |
1 |
Yes |
Indicates if the location can modify the item's price |
purchase_type |
varchar26 |
0 |
1 |
Purchase Type |
Fill application table name. |
Fill table column name. |
varchar2 |
6 |
Yes |
Fill this description. |
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 |
Yes |
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 |
Yes |
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 |
Sale and Store Receiving. |
No |
This column 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 |
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. |