| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 3 |
PRCSINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 4 |
PROBINST |
Character(20) |
VARCHAR2(20) NOT NULL |
Optimization Problem Instance
|
| 5 |
PL_RECORD_DTTM |
DateTime(26) |
TIMESTAMP |
a record timestamp used by PL_RECORD_COUNTS
|
| 6 |
PL_PASSED_FILTER |
Character(1) |
VARCHAR2(1) NOT NULL |
PL_PASSED_FILTER
|
| 7 |
PL_START_DTTM |
DateTime(26) |
TIMESTAMP |
PL_START_DTTM
|
| 8 |
INCL_BOM_COMP_EFF |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 9 |
INCL_EXS_LMT_EXCD |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 10 |
INCL_INVLD_BOM |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 11 |
INCL_INVLD_REC_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 12 |
INCL_INVLD_SHP_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 13 |
INCL_PL_SPLY_EF |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 14 |
INCL_PROD_OPT_EFF |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 15 |
INCL_QTYABOVEMAX |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 16 |
INCL_QTYBELOWMIN |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 17 |
INCL_QTYNOTINCR |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 18 |
INCL_REC_CUR_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 19 |
INCL_SPLYPHASEOUT |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 20 |
INCL_SUB_COMP_EFF |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 21 |
INCL_VND_CAP_EXCD |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 22 |
INCL_MSD_REQ_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 23 |
INCL_SUBS |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 24 |
PL_EXCP_COUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
PL_EXCP_COUNT_TYPE
A=Filtered and Total Counts
F=Filtered Counts Only
T=Total Counts Only
Default Value: T
|
| 25 |
INCL_CUSTOMER_ORD |
Character(1) |
VARCHAR2(1) NOT NULL |
INCL_CUSTOMER_ORD
Y/N Table Edit
Default Value: Y
|
| 26 |
INCL_MSR_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
jnw 10/01/99 (cn# mg800-12) added field
Y/N Table Edit
Default Value: Y
|
| 27 |
INCL_PL_PROD_ORD |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: Y
|
| 28 |
INCL_PL_PURCH_ORD |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: Y
|
| 29 |
INCL_PLAN_XFER |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned Transfers
Y/N Table Edit
Default Value: Y
|
| 30 |
INCL_PROD_ORDERS |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 31 |
INCL_PURCH_ORDERS |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: Y
|
| 32 |
INCL_TRANSFERS |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Orders
Y/N Table Edit
Default Value: Y
|
| 33 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 34 |
PL_EXCP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Type
|