| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table:
PRCSRUNCNTL
|
| 4 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 5 |
PROBINST |
Character(20) |
VARCHAR2(20) NOT NULL |
Optimization Problem Instance
|
| 6 |
RUN_REPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
01/14/03 NRA (CN#PL880-1): Defined
|
| 7 |
RUN_MAINTENANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
01/14/03 NRA (CN#PL880-1): Defined
|
| 8 |
START_PLUGIN |
Character(1) |
VARCHAR2(1) NOT NULL |
START_PLUGIN
|
| 9 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|
| 10 |
PI_STATUS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
11/11/02 EGS (CN#PL880-1): Added
|
| 11 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 12 |
CURRENT_DTTM |
DateTime(26) |
TIMESTAMP |
08/27/01 EGS (CN#PL900-1.0): Added
|
| 13 |
MESSAGE_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Message Parameter Text
|
| 14 |
TRANSACTION_LOCKED |
Character(1) |
VARCHAR2(1) NOT NULL |
"An internal work field that
|
| 15 |
CK_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 16 |
UPDATE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Meta SQL
|
| 17 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 18 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 19 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 20 |
TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 21 |
TABLE_NAME2 |
Character(30) |
VARCHAR2(30) NOT NULL |
TABLE_NAME2
|
| 22 |
FIELD_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name
|
| 23 |
REPORT_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Report Title
|
| 24 |
CONS_TEMP_TBL |
Character(19) |
VARCHAR2(19) NOT NULL |
Consolidation Temp Table
|
| 25 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 26 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|
| 27 |
PL_SEQ_NBR_BEGIN |
Number(9,0) |
DECIMAL(9) NOT NULL |
01/09/02 EGS (CN#PL900-1): Added
|
| 28 |
PL_SEQ_NBR_END |
Number(9,0) |
DECIMAL(9) NOT NULL |
01/09/02 EGS (CN#PL900-1): Added
|
| 29 |
STEP |
Number(2,0) |
SMALLINT NOT NULL |
Step
|
| 30 |
PL_MAINT_ACTIVITY |
Character(2) |
VARCHAR2(2) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
01=Freeze
02=Unfreeze
03=Include Quantity
04=Exclude Quantity
05=Freeze Substitutes
06=Unfreeze Substitutes
07=Approve
08=Unapprove
09=Consume Forecast
10=Unconsume Forecast
11=Cancel
12=Uncancel
21=Set Demand Priority
22=Set Order Status
31=Reschedule Forward
32=Reschedule Backward
33=Consolidate/Reschedule Fwd
34=Consolidate/Reschedule Bkwd
41=Change Sourcing Option
|
| 31 |
PL_XACTION_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
11/15/02 NRA - Created for Set Value actions
Prompt Table:
PL_XACTION_TBL
|
| 32 |
DATE_DAYS_SLCT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
T=Date
Y=Days Offset
Default Value: T
|
| 33 |
TARGET_DATE |
DateTime(26) |
TIMESTAMP |
12/10/02 NRA (CN#PL880-1): Defined
|
| 34 |
TARGET_DAY |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
TARGET_DAY
|
| 35 |
TO_PRIORITY_RANK |
Number(3,0) |
SMALLINT NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
|
| 36 |
TO_ORDER_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
05=Planned
15=Firmed
90=Cancelled
|
| 37 |
TO_INTERUNIT_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
C=Cancelled
O=Open
|
| 38 |
TO_BOM_CODE |
Number(2,0) |
SMALLINT NOT NULL |
anna 06/30- changing the name as per Lori's code review
11/24/99 LAJ...Changed short name from Bcode to BOM. Removed leading blank on long name.
|
| 39 |
TO_RTG_CODE |
Number(2,0) |
SMALLINT NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
|
| 40 |
TO_VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_PI_VNDSET_VW
|
| 41 |
TO_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
New Supplier ID
Prompt Table:
PL_PI_VNDID_VW
|
| 42 |
TO_VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_PI_VNDLOC_VW
|
| 43 |
TO_SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_PI_BU_IN_VW
|
| 44 |
TO_SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via selection
|
| 45 |
BU_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
LIKE=LIKE
Prompt Table:
PL_OPER_T_VW
|
| 46 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
PL_PI_BU_IN_VW
|
| 47 |
ITM_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 48 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
%EDITTABLE2
|
| 49 |
PLANNER_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 50 |
PLANNER_CD |
Character(12) |
VARCHAR2(12) NOT NULL |
Planner Code
Prompt Table:
PL_PI_PLNR_VW
|
| 51 |
CFG_CODE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Configuration Code Generation
B=Both
N=No
Y=Yes
Default Value: B
|
| 52 |
BUYER_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 53 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
Prompt Table:
PL_PI_BUYER_VW
|
| 54 |
GROUP_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 55 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
Prompt Table:
PL_PI_ITMGRP_VW
|
| 56 |
PL_DISTRIB_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Plan
Y/N Table Edit
Default Value: Y
|
| 57 |
PL_MASTER_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Master Plan
Y/N Table Edit
Default Value: Y
|
| 58 |
PL_MATERIAL_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Material Plan
Y/N Table Edit
Default Value: Y
|
| 59 |
FAMILY_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 60 |
INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
Prompt Table:
%EDITTABLE4
|
| 61 |
CATEGORY_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 62 |
CATEGORY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category ID
|
| 63 |
UTILIZ_CD_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 64 |
UTILIZ_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Utilization Type
Prompt Table:
PL_PI_UTILIZ_VW
|
| 65 |
CONFIG_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 66 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
Prompt Table:
%EDITTABLE5
|
| 67 |
PL_MAKE_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
12/09/02 JC (CN#PL880-1): Added
Y/N Table Edit
|
| 68 |
PL_BUY_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
12/09/02 JC (CN#PL880-1): Added
Y/N Table Edit
|
| 69 |
PL_PLANNING_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Y/N Table Edit
Default Value: Y
|
| 70 |
APPLIES_TO_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
Applies to BU
D=Destination Unit
S=Source Unit
|
| 71 |
ORDER_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 72 |
ORDER_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Order ID
|
| 73 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table:
PL_ORD_HEADER
|
| 74 |
BU_OPRTN2 |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 75 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
|
| 76 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 77 |
SETID_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 78 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 79 |
START_DT_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
BTW=BETWEEN
Prompt Table:
PL_OPER_D_VW
|
| 80 |
PLAN_START_DTTM |
DateTime(26) |
TIMESTAMP |
08/29/01 EGS (CN#PL900-1): Added.
|
| 81 |
PLN_START_DT_TO |
DateTime(26) |
TIMESTAMP |
12/10/02 NRA (CN#PL880-1): Defined
|
| 82 |
END_DT_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_D_VW
|
| 83 |
PLAN_END_DTTM |
DateTime(26) |
TIMESTAMP |
08/29/01 EGS (CN#PL900-1): Added.
|
| 84 |
PLN_END_DT_TO |
DateTime(26) |
TIMESTAMP |
12/10/02 NRA (CN#PL880-1): Defined
|
| 85 |
START_FROM_DAY |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
START_FROM_DAY
|
| 86 |
START_TO_DAY |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
START_TO_DAY
|
| 87 |
END_FROM_DAY |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
END_FROM_DAY
|
| 88 |
END_TO_DAY |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
END_TO_DAY
|
| 89 |
PRODUCTION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown
Default Value: PR
|
| 90 |
PRODAREA_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
PRODAREA_OPRTN
Prompt Table:
PL_OPER_T_VW
|
| 91 |
PRDN_AREA_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area
|
| 92 |
PROD_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Production Status
10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled
|
| 93 |
BOM_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_N_VW
|
| 94 |
BOM_CODE |
Number(2,0) |
SMALLINT NOT NULL |
CN# EN800-3.0, anna 09/21
added new field to database
|
| 95 |
RTG_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_N_VW
|
| 96 |
RTG_CODE |
Number(2,0) |
SMALLINT NOT NULL |
Routing Code
|
| 97 |
PRIORITY_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_N_VW
|
| 98 |
PRIORITY_RANK |
Number(3,0) |
SMALLINT NOT NULL |
Priority rank value of demand prioritization rule
|
| 99 |
PL_FAMILY_FORECAST |
Character(1) |
VARCHAR2(1) NOT NULL |
11/01/01 PCL (CN#PL900-1): Added
12/10/02 NRA (CN#PL880-1): Defined xlats 'Yes, No, and Both'
B=Both
N=No
Y=Yes
Default Value: B
|
| 100 |
FROZEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Frozen Flag
B=Both
N=No
Y=Yes
Default Value: B
|
| 101 |
INCL_QTY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Quantity
B=Both
N=No
Y=Yes
Default Value: B
|
| 102 |
APPROVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approved
B=Both
N=No
Y=Yes
Default Value: B
|
| 103 |
FROZEN_SUBSTITUTES |
Character(1) |
VARCHAR2(1) NOT NULL |
Frozen Substitutes
B=Both
N=No
Y=Yes
Default Value: B
|
| 104 |
PL_PLAN_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
11/01/01 PCL (CN#PL900-1): Added
05=Planned
15=Firmed
90=Canceled
Default Value: 05
|
| 105 |
PEG_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
|
| 106 |
VNDR_SETID_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 107 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table:
PL_PI_VNDSET_VW
|
| 108 |
VENDOR_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 109 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
PL_PI_VNDID_VW
|
| 110 |
VNDR_LOC_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 111 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
PL_PI_VNDLOC_VW
|
| 112 |
INTERUNIT_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit Status
C=Cancelled
I=In-Transit
O=Open
P=Picked
R=Received
Default Value: O
|
| 113 |
SOURCE_BU_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 114 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
Prompt Table:
PL_PI_BU_IN_VW
|
| 115 |
SHIP_TYPE_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
SHIP_TYPE_OPRTN
Prompt Table:
PL_OPER_T_VW
|
| 116 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
|
| 117 |
CONSUME_FCST |
Character(1) |
VARCHAR2(1) NOT NULL |
09/11/02 EGS (CN#PL880-1): Added.
B=Both
N=No
Y=Yes
Default Value: B
|
| 118 |
SHIPPED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipped
B=Both
N=No
Y=Yes
Default Value: B
|
| 119 |
RESERVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reserved Flag
B=Both
N=No
Y=Yes
Default Value: B
|
| 120 |
CANCEL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel PO
B=Both
N=No
Y=Yes
Default Value: B
|
| 121 |
PRODUCT_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 122 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 123 |
CUSTOMER_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 124 |
CUSTOMER |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer
|
| 125 |
ORD_SCH_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled
Default Value: O
|
| 126 |
SHIP_ID_OPRTN |
Character(4) |
VARCHAR2(4) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_T_VW
|
| 127 |
SHIP_ID_EST |
Character(10) |
VARCHAR2(10) NOT NULL |
Estimated Ship ID
|
| 128 |
SUCCESS_OPRTN |
Character(3) |
VARCHAR2(3) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
Prompt Table:
PL_OPER_N_VW
|
| 129 |
SUCCESS_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Success Percent
|