| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim 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. |
AS_ITM_RTL_STR |
Id_str_rt |
number |
10,0 |
null |
Store_id |
| loc_type |
varchar21 |
1 |
1 |
Type of location in the "loc" field. Valid values are 'S' (store) and 'W' (warehouse). |
AS_ITM |
ITEM_TYPE |
NUMBER |
2,0 |
Yes |
Consignment = 5
Consession = 10
Non inventory = 12
simple pack = 15
complex = 20
breakable pack = 25 |
| local_item_desc |
varchar2250 |
1 |
1 |
NA |
AS_ITM_RTL_STR |
RK_LONG_DESC |
varchar2 |
400 |
Yes |
Local Store long description |
| local_short_desc |
varchar2120 |
0 |
1 |
Not Yet Available |
AS_ITM_RTL_STR |
SHORT_DESC |
VARCHAR2 |
255 |
Yes |
Local Store short description |
| status |
varchar21 |
1 |
1 |
Current status of the item at the store (valid values are 'A' (active), 'I' (inactive), 'C' (discontinued) and 'D' (deleted). |
AS_ITM_RTL_STR |
SC_ITM |
VARCHAR2 |
20 |
Yes |
NONE(" ", "No Status"),
ACTIVE("A", "Active"),
DISCONTINUED("C", "Discontinued"),
INACTIVE("I", "Inactive"),
DELETED("D", "Deleted"), AUTO_STOCKABLE("Q", "Auto Stockable"),
NON_RANGED("N", "Non-Ranged") |
| primary_supp |
number10 |
0 |
1 |
Not Yet Available |
AS_ITM_RTL_STR |
ID_SPR |
VARCHAR2 |
128 |
Yes |
Primary supplier |
| primary_cntry |
varchar23 |
0 |
1 |
Contains the origin country which will be considered the primary country for the item/location. |
|
|
|
|
null |
NOT USED IN SIM |
| 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. |
|
|
|
|
null |
NOT USED IN SIM |
| taxable_ind |
varchar21 |
1 |
1 |
Indicates whether the item is taxable at the store. Valid values are 'Y' (yes) and 'N' (No). |
|
|
|
|
null |
NOT USED IN SIM |
| 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'. |
|
|
|
|
null |
NOT USED IN SIM |
| source_wh |
number10 |
0 |
1 |
If the source_method is 'W', this field contains the source warehouse for fulfilling item requests at a store. |
|
|
|
|
null |
NOT USED IN SIM |
| unit_retail |
number20_4 |
0 |
1 |
Unit retail of the item in the selling Unit of Measure. Only published for create not modify. |
|
|
|
|
null |
NOT USED IN SIM |
| selling_unit_retail |
number20_4 |
0 |
1 |
Selling unit retail in selling unit of measure. Only published for create, not update |
AS_ITM_RTL_STR |
RP_SLS_CRT |
varchar2 |
75 |
No |
Not available. |
| selling_uom |
varchar24 |
0 |
1 |
Selling Unit of measure. Only published for Create not update. |
|
|
|
|
null |
NOT USED IN SIM |
| store_price_ind |
varchar21 |
0 |
1 |
Not Yet Available |
AS_ITM_RTL_STR |
STR_CTL_PRICING |
NUMBER |
1,0 |
No |
Not available. |
| purchase_type |
varchar26 |
0 |
1 |
Purchase Type |
NA |
NA |
NA |
NA |
NA |
NA |
| 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. |
NA |
NA |
NA |
NA |
NA |
NA |
| 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. |
NA |
NA |
NA |
NA |
NA |
NA |
| 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. |
NA |
NA |
NA |
NA |
NA |
NA |
| 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. |
NA |
NA |
NA |
NA |
NA |
NA |
|
ExtOfItemLocDesc:ExtOfItemLocVirt
|
*
|
0
|
1
|
Provide an extension hook to customize ItemLocVirt.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
LocOfItemLocDesc:LocOfItemLocVirt
|
*
|
0
|
1
|
Provide an extension hook to localize ItemLocVirt.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
