XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItemLocVirt in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
loc |
number10 |
1 |
1 |
Location where the item is to be found. This field may contain a store or a warehouse. |
STORE_ITEM |
STORE_ID |
NUMBER |
10,0 |
No |
STORE_ID |
loc_type |
varchar21 |
1 |
1 |
Type of location in the "loc" field. Valid values are 'S' (store) and 'W' (warehouse). |
ITEM |
ITEM_TYPE |
NUMBER |
2,0 |
Yes |
item type |
local_item_desc |
varchar2250 |
1 |
1 |
NA |
STORE_ITEM |
LONG_DESCRIPTION |
varchar2 |
400 |
No |
The long description for the item. |
local_short_desc |
varchar2120 |
0 |
1 |
Not Yet Available |
STORE_ITEM |
SHORT_DESCRIPTION |
VARCHAR2 |
255 |
No |
The short description for the item used at this location. |
status |
varchar21 |
1 |
1 |
Current status of the item at the store (valid values are 'A' (active), 'I' (inactive), 'C' (discontinued) and 'D' (deleted). |
STORE_ITEM |
STATUS |
VARCHAR2 |
A - Active, item is valid and can be ordered, transferred in, and sold
C - discontinued, item is sellable, can not be ordered from a supplier, can be transferred in from a warehouse or store.
I - inactive, item is sellable, can not be ordered, can not be transferred in from a warehouse or store.
D - delete, item is invalid and cannot be ordered, transferred in, or sold. (im a bit skeptical on the deleted status.
Q - automatically stocked by sim. the item was not originally ranged for the store, but sim created a location and stock records to do a stock event coming to the store.
N - Non-ranged |
No |
the code defines the current state of an item within the retail store.
for example include active inactive discontinued, pending, etc.
valid values are |
primary_supp |
number10 |
0 |
1 |
Not Yet Available |
STORE_ITEM |
PRIMARY_SUPPLIER_ID |
VARCHAR2 |
128 |
No |
The unique identifier of the supplier that is the default primary supplier for the item at this location. |
primary_cntry |
varchar23 |
0 |
1 |
Contains the origin country which will be considered the primary country for the item/location. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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). |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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'. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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 |
Fill application table name. |
Fill table column name. |
varchar2 |
Fill column length. |
No |
NOT AVAILABLE |
selling_uom |
varchar24 |
0 |
1 |
Selling Unit of measure. Only published for Create not update. |
STORE_ITEM |
SELLING_UNIT_OF_MEASURE |
VARCHAR2 |
4 |
No |
the unit of measure that the items package is. (not currently used by sim) |
store_price_ind |
varchar21 |
0 |
1 |
Indicates if the location can modify the item's price. |
STORE_ITEM |
STORE_CONTROL_PRICING |
NUMBER |
1,0 |
No |
A flag indicating if the item price can be controlled by the store. |
purchase_type |
varchar26 |
0 |
1 |
Purchase Type |
ITEM |
ITEM_TYPE |
Number |
2,0 |
Yes |
if value is S set CONSIGNMENT(5, "Consignment"),
type of item.
0 - Item, 5 - Consignment,
12 - Non Inventory,
15 - Simple,
20 - complex,
25 - Pack breakable
if value is C set CONCESSION(10, "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. |
STORE_UIN_ADMIN_ITEM |
UIN_TYPE |
Number |
serial |
Yes |
uin type. ex |
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. |
STORE_UIN_ADMIN_ITEM |
LABEL_ID |
Number |
12,0 |
Yes |
reference to uin_label table |
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. |
STORE_UIN_ADMIN_ITEM |
CAPTURE_TIME_ID |
Number |
2 |
No |
times of sales or store receiving |
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. |
STORE_UIN_ADMIN_ITEM |
EXTERNAL_CREATE_ALLOWED |
VARCHAR2 |
y,n |
Yes |
an indicate to allow external system to create uin. values |
ranged_ind |
varchar21 |
1 |
1 |
An indicator to differentiate between user ranged locations and RMS program ranged locations. Values are 'Y' or 'N'. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
An indicator to differentiate between user ranged locations and RMS program ranged locations. Values are 'Y' or 'N'. |