# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
PROBINST |
Character(20) |
VARCHAR2(20) NOT NULL |
Optimization Problem Instance
|
2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
3 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
4 |
PLAN_END_DTTM |
DateTime(26) |
TIMESTAMP |
08/29/01 EGS (CN#PL900-1): Added.
|
5 |
PL_SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
PL_SYSTEM_SOURCE
|
6 |
PLAN_START_DTTM |
DateTime(26) |
TIMESTAMP |
08/29/01 EGS (CN#PL900-1): Added.
|
7 |
QTY_FORECAST |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
11/01/01 PCL (CN#PL900-1): Added
|
8 |
VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|