XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for PrGpSchHdrDesc 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 |
schedule_id |
number8 |
0 |
1 |
Schedule unique identifier. |
PRODUCT_GROUP_SCHEDULE |
ID |
NUMBER |
8,0 |
No |
the unique identifier of product group schedule. this is assigned by the system. |
description |
varchar2250 |
0 |
1 |
Description of the schedule. |
PRODUCT_GROUP_SCHEDULE |
DESCRIPTION |
VARCHAR2 |
250 |
No |
the description of product the product group schedule. |
status |
schedule_status |
1 |
1 |
Schedule Status. Valid values are OPEN, CLOSED, UNKNOWN, NO_VALUE. |
PRODUCT_GROUP_SCHEDULE |
STATUS |
VARCHAR2 |
1 |
Yes |
the current status of the product group schedule. valid values: o - open c - closed |
group_id |
number12 |
0 |
1 |
Unique identifier of product group associated with the schedule. |
PRODUCT_GROUP_SCHEDULE |
PRODUCT_GROUP_ID |
NUMBER |
12,0 |
No |
the unique identifier of the product group that this schdule is for. |
group_description |
varchar2100 |
0 |
1 |
Description of product group associated with the schedule. |
PRODUCT_GROUP |
DESCRIPTION |
VARCHAR2 |
100 |
No |
the description of product group which is assigned by the user. |
group_type |
schedule_group_type |
1 |
1 |
Type of product group associated with the schedule. 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" |
store_id_col |
number10 |
0 |
1000 |
Collection of store identifiers. |
PRODUCT_GROUP_SCHEDULE |
STORE_ID |
NUMBER |
10,0 |
Yes |
the unique identifier of the store that belongs to this product group schedule. |
store_count |
number10 |
0 |
1 |
Count of store for which the schedule was generated. |
PRODUCT_GROUP_SCHED_STORE |
STORE_ID |
NUMBER |
Fill column length. |
No |
Count of the stores for which schedule is created |