XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ProdGrpHdrDesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
product_group_id |
number10 |
1 |
1 |
Product group identifier internal to SIM. |
PRODUCT_GROUP |
ID |
NUMBER |
12,0 |
Yes |
unique identifying number for the product group within the system. this number is generated by the system when a new product group is created. |
group_type |
group_type |
1 |
1 |
Product 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, 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 |
1 |
1 |
A full description of the product group. |
PRODUCT_GROUP |
DESCRIPTION |
VARCHAR2 |
100 |
Yes |
the description of product group which is assigned by the user. |
store_id |
number10 |
0 |
1 |
Unique store identifier. |
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. |
|