PL_POST_AET

(SQL Table)
 Index Back

PL Post Update State Record

02/25/02 EGS (CN#PL900-1): Added

# 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
4 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
5 BU_GROUP Character(6) VARCHAR2(6) NOT NULL 08/16/01 EGS (CN#PL880-1.0): Added
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 PL_DISTRIB_PLAN Character(1) VARCHAR2(1) NOT NULL Distribution Plan
8 PL_MASTER_PLAN Character(1) VARCHAR2(1) NOT NULL Master Plan
9 PL_MATERIAL_PLAN Character(1) VARCHAR2(1) NOT NULL Material Plan
10 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
11 PROCESS_DTTM DateTime(26) TIMESTAMP Process Date Time
12 DATE_WRK Date(10) DATE Date Work Field
13 PL_POST_INIT_TYPE Character(1) VARCHAR2(1) NOT NULL Initialize Data Types
1=All Data Types
2=Posted Data Types
14 PL_POST_INIT_ITEM Character(1) VARCHAR2(1) NOT NULL Initialize Items
1=All by Selected Planned By
2=Selected by Planning Instance
15 PL_IGNORE_CUTOFF Character(1) VARCHAR2(1) NOT NULL Ignore Cutoff Fence
16 PL_TOLERANCE_OPT Character(1) VARCHAR2(1) NOT NULL Inside Tolerance
1=Approve
2=Error
3=Ignore
4=Accept
17 PL_APPROVAL_OPTION Character(1) VARCHAR2(1) NOT NULL Approval Options
1=Manual
2=Auto All
3=Auto Horiz
18 SPL_PEG_APPRV_OPT Character(1) VARCHAR2(1) NOT NULL Pegged Approval Option
1=Approve
2=Error
3=Ignore
4=Accept
19 FROM_DATE Date(10) DATE From Date
20 TO_DATE Date(10) DATE To Date
21 PL_APPROVE_ODATE Character(1) VARCHAR2(1) NOT NULL Based on
1=Order Start Date
2=Order End Date
3=Both
22 PL_APPROVE_SCHED Character(1) VARCHAR2(1) NOT NULL Approve Schedules
23 INCL_SALES_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: N

24 INCL_QUOTES Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

25 INCL_BUYING_AGREE Character(1) VARCHAR2(1) NOT NULL 05/02/02 JNW (CN#PL900-1): Added

Y/N Table Edit

Default Value: N

26 INCL_TFR_DEMAND Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

27 INCL_TFR_PL_DEMAND Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

28 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: N

29 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: N

30 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: N

31 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: N

32 INCL_STOCK_REQUEST Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

33 INCL_USEUP Character(1) VARCHAR2(1) NOT NULL 10/29/02 EGS (CN#PL880-1): Added

Y/N Table Edit

Default Value: N

34 MG Character(1) VARCHAR2(1) NOT NULL Manufacturing
35 PO Character(1) VARCHAR2(1) NOT NULL Purchasing
36 OM Character(1) VARCHAR2(1) NOT NULL Order Management
37 PL_POST_DATA_TYPE Character(4) VARCHAR2(4) NOT NULL Data Type
010=Purchases
020=Production
030=Transfers
040=Planned Purchases
050=Planned Production
060=Planned Transfers
070=Stock Requests
080=Quotes
090=Sales Orders
100=Buying Agreements
110=Projected Useup
38 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause
39 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
40 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause
41 UPDATE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Meta SQL
42 SELECT_CLAUSE Character(254) VARCHAR2(254) NOT NULL Select Clause
43 SELECT_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Select Clause 2
44 SELECT_CLAUSE3 Character(254) VARCHAR2(254) NOT NULL Select Clause 3
45 FROM_CLAUSE Character(254) VARCHAR2(254) NOT NULL From Clause
46 CK_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
47 TRANSACTION_LOCKED Character(1) VARCHAR2(1) NOT NULL "An internal work field that
48 DUMMY_FIELD Character(1) VARCHAR2(1) NOT NULL Dummy Field for Hiding Groups
49 MIN_DATE Date(10) DATE 10/09/01 EGS (CN#PL900-1): Added
50 MAX_DATE Date(10) DATE 10/09/01 EGS (CN#PL900-1): Added.
51 PL_BU_LIST Character(254) VARCHAR2(254) NOT NULL Business Unit List
52 SETID_INV_ITEM Character(5) VARCHAR2(5) NOT NULL Inv Items SETID
53 MESSAGE_PARM Character(254) VARCHAR2(254) NOT NULL Message Parameter Text
54 SEQ_NBR_TR Number(15,0) DECIMAL(15) NOT NULL 01/09/02 EGS (CN#PL900-1): Added
55 SEQ_NBR_SO Number(15,0) DECIMAL(15) NOT NULL 03/09/02 JNW (CN#PL900-1): Added
56 SEQ_NBR_PRDN Number(15,0) DECIMAL(15) NOT NULL 01/09/02 EGS (CN#PL900-1): Added
57 SEQ_NBR_PO Number(15,0) DECIMAL(15) NOT NULL 01/09/02 EGS (CN#PL900-1): Added
58 NUMROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.
59 NUMROWS2 Number(15,0) DECIMAL(15) NOT NULL 04/19/02 EGS (CN#PL900-1): Added.
60 LAST_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Last Sequence number in list
61 APPROVED_FLG Character(1) VARCHAR2(1) NOT NULL Approved by Auditor
D=Denied
N=Not Approved
Y=Approved
62 PL_APPR_OPT_PO Character(1) VARCHAR2(1) NOT NULL 04/01/02 PCL (CN#PL900-1): Added.
63 PL_APPR_OPT_PLTR Character(1) VARCHAR2(1) NOT NULL 03/20/02 EGS (CN#PL900-1): Added
64 PL_APPR_OPT_TR Character(1) VARCHAR2(1) NOT NULL 03/20/02 EGS (CN#PL900-1): Added.
65 PL_APPR_OPT_SR Character(1) VARCHAR2(1) NOT NULL 03/20/02 EGS (CN#PL900-1): Added.
66 PL_APPR_OPT_PLPO Character(1) VARCHAR2(1) NOT NULL 04/01/02 PCL (CN#PL900-1): Added.
67 PL_APPR_OPT_PLPR Character(1) VARCHAR2(1) NOT NULL 04/16/02 EGS (CN#PL900-1): Added
68 PL_APPR_OPT_PR Character(1) VARCHAR2(1) NOT NULL 04/16/02 EGS (CN#PL900-1): Added
69 PL_IGN_CUT_PLPO Character(1) VARCHAR2(1) NOT NULL 04/01/02 PCL (CN#PL900-1): Added.
70 PL_IGN_CUT_PO Character(1) VARCHAR2(1) NOT NULL 04/01/02 PCL (CN#PL900-1): Added.
71 PL_IGN_CUT_PLTR Character(1) VARCHAR2(1) NOT NULL 03/20/02 EGS (CN#PL900-1): Added.
72 PL_IGN_CUT_TR Character(1) VARCHAR2(1) NOT NULL 03/20/02 EGS (CN#PL900-1): Added.
73 PL_IGN_CUT_SR Character(1) VARCHAR2(1) NOT NULL 03/20/02 EGS (CN#PL900-1): Added.
74 PL_IGN_CUT_PLPR Character(1) VARCHAR2(1) NOT NULL 04/16/02 EGS (CN#PL900-1): Added.
75 PL_IGN_CUT_PR Character(1) VARCHAR2(1) NOT NULL 04/16/02 EGS (CN#PL900-1): Added.
76 PL_IGN_CUT_SO Character(1) VARCHAR2(1) NOT NULL 10/07/02 EGS (CN#PL900-1): Added.
77 PL_IGN_CUT_QUO Character(1) VARCHAR2(1) NOT NULL 10/07/02 EGS (CN#PL900-1): Added.
78 PL_IGN_CUT_BA Character(1) VARCHAR2(1) NOT NULL 10/07/02 EGS (CN#PL900-1): Added.
79 PL_APPR_ODATE_PLPO Character(1) VARCHAR2(1) NOT NULL 04/01/02 PCL (CN#PL900-1): Added.
80 PL_APPR_ODATE_PO Character(1) VARCHAR2(1) NOT NULL 04/01/02 PCL (CN#PL900-1): Added.
81 PL_APPR_ODATE_PLTR Character(1) VARCHAR2(1) NOT NULL 03/20/02 EGS (CN#PL900-1): Added.
82 PL_APPR_ODATE_TR Character(1) VARCHAR2(1) NOT NULL 03/20/02 EGS (CN#PL900-1): Added.
83 PL_APPR_ODATE_SR Character(1) VARCHAR2(1) NOT NULL 03/20/02 EGS (CN#PL900-1): Added.
84 PL_APPR_ODATE_PLPR Character(1) VARCHAR2(1) NOT NULL 04/16/02 EGS (CN#PL900-1): Added.
85 PL_APPR_ODATE_PR Character(1) VARCHAR2(1) NOT NULL 04/16/02 EGS (CN#PL900-1): Added.
86 FROM_DATE_PLPO Date(10) DATE 04/02/02 PCL (CN#PL900-1): Added.
87 FROM_DATE_PO Date(10) DATE 04/02/02 PCL (CN#PL900-1): Added.
88 FROM_DATE_PLTR Date(10) DATE 03/20/02 EGS (CN#PL900-1): Added.
89 FROM_DATE_TR Date(10) DATE 03/20/02 EGS (CN#PL900-1): Added.
90 FROM_DATE_SR Date(10) DATE 03/20/02 EGS (CN#PL900-1): Added.
91 FROM_DATE_PLPR Date(10) DATE 04/16/02 EGS (CN#PL900-1): Added.
92 FROM_DATE_PR Date(10) DATE 04/16/02 EGS (CN#PL900-1): Added.
93 TO_DATE_PLPO Date(10) DATE 04/02/02 EGS (CN#PL900-1): Added.
94 TO_DATE_PO Date(10) DATE 04/02/02 EGS (CN#PL900-1): Added.
95 TO_DATE_PLTR Date(10) DATE 03/20/02 EGS (CN#PL900-1): Added.
96 TO_DATE_TR Date(10) DATE 03/20/02 EGS (CN#PL900-1): Added.
97 TO_DATE_SR Date(10) DATE 03/20/02 EGS (CN#PL900-1): Added.
98 TO_DATE_PLPR Date(10) DATE 04/16/02 EGS (CN#PL900-1): Added.
99 TO_DATE_PR Date(10) DATE 04/16/02 EGS (CN#PL900-1): Added.
100 PL_TOL_OPT_PO Character(1) VARCHAR2(1) NOT NULL 04/02/02 EGS (CN#PL900-1): Added
1=Auto Approve
2=Generate Error
3=Ignore Message
101 PL_TOL_OPT_TR Character(1) VARCHAR2(1) NOT NULL 03/27/02 EGS (CN#PL900-1): Added
1=Do Not Approve
2=Generate Error
3=Note Violation
102 PL_TOL_OPT_SR Character(1) VARCHAR2(1) NOT NULL 03/27/02 EGS (CN#PL900-1): Added
1=Do Not Approve
2=Generate Error
3=Note Violation
103 PL_TOL_OPT_PR Character(1) VARCHAR2(1) NOT NULL 04/16/02 EGS (CN#PL900-1): Added
1=Do Not Approve
2=Generate Error
3=Note Violation
104 PL_TOL_OPT_SO Character(1) VARCHAR2(1) NOT NULL 10/07/02 EGS (CN#PL900-1): Added
1=Do Not Approve
2=Generate Error
3=Note Violation
105 PL_TOL_OPT_QUO Character(1) VARCHAR2(1) NOT NULL 10/07/02 EGS (CN#PL900-1): Added
1=Do Not Approve
2=Generate Error
3=Note Violation
106 PL_TOL_OPT_BA Character(1) VARCHAR2(1) NOT NULL 10/07/02 EGS (CN#PL900-1): Added
1=Do Not Approve
2=Generate Error
3=Note Violation
107 PL_APPR_SCHED_PLPO Character(1) VARCHAR2(1) NOT NULL Approve Supplier Plnd POs
108 PL_APPR_SCHED_PO Character(1) VARCHAR2(1) NOT NULL Approve Supplier Scheduled POs
109 START_DATE Date(10) DATE Start Date for Gen Standing PO
110 MULTI_PROC Character(1) VARCHAR2(1) NOT NULL 06/11/02 EGS (CN#PL900-1): Added.
111 SELECT_OPTION Character(1) VARCHAR2(1) NOT NULL Select Option

Y/N Table Edit

Default Value: N

112 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
113 PL_RCV_CHG_TIME Character(1) VARCHAR2(1) NOT NULL Track Time Changes
114 ALLOW_VLTN_APP Character(1) VARCHAR2(1) NOT NULL Allow Violation Approval
115 ALLOW_VLTN_PLPR Character(1) VARCHAR2(1) NOT NULL 07/25/03 EGS
116 ALLOW_VLTN_PLTR Character(1) VARCHAR2(1) NOT NULL 07/25/03 EGS
117 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
118 PI_STATUS Signed Number(4,0) DECIMAL(3) NOT NULL 11/11/02 EGS (CN#PL880-1): Added
119 SHUTDOWN_PI_FLG Character(1) VARCHAR2(1) NOT NULL 01/29/03 EGS (CN#PL880-1): Added
120 STARTUP_PI_FLG Character(1) VARCHAR2(1) NOT NULL 01/29/03 EGS (CN#PL880-1): Added.
121 PL_EXPEDITE_OPTION Character(1) VARCHAR2(1) NOT NULL 12/12/2007 JAA 9.1 Apply Planning Updates. Field used for PO expedite option in Post Update
1=Planning Time Fence
2=Supplier Lead Time
122 PL_EXPEDITE_PLPO Character(1) VARCHAR2(1) NOT NULL 12/21/2007 jaa Expedite Option for Planned Purchase Order
1=Planning Time Fence
2=Supplier Lead Time