XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for PrGpSchCriVo 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 |
store_id |
number10 |
0 |
1 |
Include only schedules for this store. |
PRODUCT_GROUP_SCHED_STORE |
STORE_ID |
NUMBER |
10,0 |
No |
the unique identifier of the store that belongs to this product group schedule. |
next_date |
xs:dateTime |
0 |
1 |
Include only schedules with the next schedule date as this date. |
PRODUCT_GROUP_SCHEDULE |
START_DATE |
DATE |
Fill column length. |
No |
the beginning date of the time span which the schedule covers. |
last_date |
xs:dateTime |
0 |
1 |
Include only schedules with the final schedule date as this date. |
PRODUCT_GROUP_SCHEDULE |
END_DATE |
DATE |
Fill column length. |
No |
the ending date of the time span which the schedule covers. |
group_id |
number12 |
0 |
1 |
Include only schedules associated with this product group. |
PRODUCT_GROUP_SCHEDULE |
PRODUCT_GROUP_ID |
NUMBER |
12,0 |
No |
the unique identifier of the product group that this schedule is for. |
group_type |
schedule_group_type |
1 |
1 |
Include only schedules of 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 |
Include only schedules that contain this text within its description. |
PRODUCT_GROUP_SCHEDULE |
DESCRIPTION |
VARCHAR2 |
250 |
No |
the description of product the product group schedule. |
status |
schedule_status |
1 |
1 |
Include only schedules matching this 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 |