| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ProdGrpCriVo 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 |
| group_id |
number10 |
0 |
1 |
Returns only product groups that match this unique identifier. Results will be limited to a single product group. |
PRODUCT_GROUP_ITEM |
PRODUCT_GROUP_ID |
NUMBER |
10,0 |
No |
unique identifying number for the product group within the system. this number is generated by the system when a new product group is created. |
| store_id |
number10 |
0 |
1 |
Returns only product groups that match this store. |
PRODUCT_GROUP |
STORE_ID |
NUMBER |
10,0 |
No |
the unique identifier of the store that this product group is for. if the all store option was selected when creating the product group this value will be blank. |
| group_type |
group_type |
1 |
1 |
Returns only product groups that match this group type. Valid values are STOCK_COUNT_UNIT, STOCK_COUNT_UNIT_AMOUNT, STOCK_COUNT_PROBLEM_LINE, STOCK_COUNT_WASTAGE, STOCK_COUNT_RMS_SYNC, SHELF_REPLENISHMENT, ITEM_REQUEST, AUTO_TICKET_PRINT, UNKNOWN, NO_VALUE. |
PRODUCT_GROUP |
TYPE |
NUMBER |
3,0 |
Yes |
Indicates the type of product group that was created.
1 - Unit,
2 - Unit and Amount,
3 - Problem Line,
4 - Wastage,
5 - RMS Inventory Sync,
6 - Shelf Replenishment,
7 - Item Request |
| description |
varchar2250 |
0 |
1 |
Returns only product groups that contain this text in its description. |
ITEM |
SHORT_DESCRIPTION |
VARCHAR2 |
255 |
Yes |
the textural description of the item and its characteristics. |
| item_id |
varchar225 |
0 |
1 |
Returns only product groups that contains this sku number. |
PRODUCT_GROUP_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
No |
unique identifying number for the item that is attached to the product group. |
| department_id |
number10 |
0 |
1 |
Include only product groups with this merchandise hierarchy department identifier. |
ITEM |
DEPARTMENT_ID |
NUMBER |
12,0 |
No |
hierarchy department id |
| class_id |
number10 |
0 |
1 |
Include only product groups items with this merchandise hierarchy class identifier. |
ITEM |
CLASS_ID |
NUMBER |
12,0 |
No |
hierarchy class id |
| subclass_id |
number10 |
0 |
1 |
Include only product groups items with this merchandise hierarchy subclass identifier |
ITEM |
SUBCLASS_ID |
NUMBER |
12,0 |
No |
hierarchy subclass id |
