PL_POST_PO_AET (SQL Table)	Index Back
Planned Orders from Red Pepper This record is the PeopleSoft representation of the Red Pepper PLANNED_ORDERS_RPS table exported from the Red Pepper system. It contains planned purchase order information generated by the Red Pepper system. It is used by the Purchasing module to setup these purchase orders in the PeopleSoft system. CN#6.01-08 JJO Added new fields due_time, planned_order, pl_po_lead_time, release_time CN#PL800-31.0 RAG Added field PL_PO_TYPE, CHNG_SOURCE 08/03/99 EGS (CN#PL800-8) Added OVERRIDE_SUGG_VNDR and BUYER_ID. 09/29/99 CEL (CN#PL800-32.0) Added EP_GROUP_CODE. 01/10/02 EGS(CN#PL900-1): Added PROBINST and PL_SEQ_NBR.

PL_POST_PO_AET

(SQL Table)

Planned Orders from Red Pepper

This record is the PeopleSoft representation of the Red Pepper PLANNED_ORDERS_RPS table exported from the Red Pepper system. It contains planned purchase order information generated by the Red Pepper system. It is used by the Purchasing module to setup these purchase orders in the PeopleSoft system. CN#6.01-08 JJO Added new fields due_time, planned_order, pl_po_lead_time, release_time CN#PL800-31.0 RAG Added field PL_PO_TYPE, CHNG_SOURCE 08/03/99 EGS (CN#PL800-8) Added OVERRIDE_SUGG_VNDR and BUYER_ID. 09/29/99 CEL (CN#PL800-32.0) Added EP_GROUP_CODE. 01/10/02 EGS(CN#PL900-1): Added PROBINST and PL_SEQ_NBR.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

4 APPROVED_FLG Character(1) VARCHAR2(1) NOT NULL Approved by Auditor
D=Denied
N=Not Approved
Y=Approved
Y/N Table Edit
Default Value: N

5 PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Plan Processed Flag
C=Complete
E=Errors
N=Initialize
P=In Process
Y/N Table Edit
Default Value: N

6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

7 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

8 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

9 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

10 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

11 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

12 PL_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL 01/09/02 EGS (CN#PL900-1): Added

13 RELEASE_DATE Date(10) DATE Release Date

14 RELEASE_TIME Time(15) TIMESTAMP Release Time

15 ORIG_DUE_DT Date(10) DATE Original Due Date

16 ORIG_DUE_TIME Time(15) TIMESTAMP Original Time Due

17 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

18 DUE_TIME Time(15) TIMESTAMP Due Time

19 PLAN_DUE_DT Date(10) DATE Planned Due Date

20 PLAN_DUE_TIME Time(15) TIMESTAMP Planned Due Time

21 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

22 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

23 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

24 PL_PO_LEAD_TIME Number(10,0) DECIMAL(10) NOT NULL 11/01/01 PCL (CN#PL900-1): Added

25 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

26 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity

27 QTY_PO_STD Number(16,4) DECIMAL(15,4) NOT NULL PO Quantity Standard

28 PLAN_QTY_PO_STD Number(16,4) DECIMAL(15,4) NOT NULL 11/01/01 PCL (CN#PL900-1): Added

29 QTY_CHNG_FLG Character(1) VARCHAR2(1) NOT NULL Quantity Change Flag for Supply Planning Post Records
Y/N Table Edit

30 TOLERANCE_FLG Character(1) VARCHAR2(1) NOT NULL jnw changed long description for planning phoenix - commit plan 10/18/02 JC (CN#PL880-1): Added TOLERANCE label

31 PL_STATUS_CD Character(2) VARCHAR2(2) NOT NULL 08/07/98 SCC CN#APRD-R-SCHEW-8L1TB: Change description for value 10 'Before Planning Time Fence' to 'Expedite'
10=Expedite
20=Accepted Horizon
30=After Cutoff Fence
40=No Time Fence Defined
99=Error/Exception

32 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes
Y/N Table Edit

33 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

34 PL_PO_TYPE Character(1) VARCHAR2(1) NOT NULL Purchase Order Type
E=Existing Orders
N=Planned Order

35 CHNG_SOURCE Character(3) VARCHAR2(3) NOT NULL Change Source
BPA=Contract Release to Single PO
CAP=Contract Batch Auto Approval
CRT=PAR Replenish/Close Backorders
CST=Close Short Purchase Orders
DRP=Order Management Referenced
EDX=PO Acknowledgments
EMC=Req. Requester Mass Change
EPO=eProcurement Change Request
EPR=User Change Request
IMC=Inventory Mass Change
ONL=On-line Purchase Order
PLN=Planning System
PMC=PO Buyer Mass Change
POC=PO Change Batch Process
PRD=Production/Shop Floor

36 SCHED_FLAG Character(1) VARCHAR2(1) NOT NULL Schedule Flag

37 OVERRIDE_SUGG_VNDR Character(1) VARCHAR2(1) NOT NULL Override Suggested Vendor
Y/N Table Edit

38 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

39 PL_PLAN_STATUS Character(2) VARCHAR2(2) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
05=Planned
15=Firmed
90=Canceled

40 CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Yes/No indicator
Y/N Table Edit
Default Value: Y

41 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code

42 PLANNING_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Planning Date and Time

43 CANCEL_CHNG_FLG Character(1) VARCHAR2(1) NOT NULL Planning Canceled

44 SCHED_CHNG_FLG Character(1) VARCHAR2(1) NOT NULL Planning Schedule Change

45 CHNG_DTTM DateTime(26) TIMESTAMP Change Request Date/Time

46 FIELD_NAME Character(18) VARCHAR2(18) NOT NULL Field Name

47 CHNG_TYPE Character(1) VARCHAR2(1) NOT NULL Change Type
C=Change
D=Deleted
H=Hold
I=Inserted
N=New
O=Original
R=Re-open
X=Cancelled

48 CHNG_CHAR_VALUE Character(254) VARCHAR2(254) NOT NULL New Field Value

49 CHNG_NBR_VALUE Signed Number(30,5) DECIMAL(28,5) NOT NULL New Numeric Value

50 CHNG_DATE_VALUE Date(10) DATE New Date Value

51 CHNG_TIME_VALUE Time(15) TIMESTAMP Change Time Value

52 DUE_DT_OLD Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

53 ACTION_MESS_CUT_DT Date(10) DATE 02/28/02 EGS (CN#PL900-1): Added

54 RESCH_IN_FACTOR Number(8,2) DECIMAL(7,2) NOT NULL Reschedule In Factor [days]

55 RESCH_OUT_FACTOR Number(8,2) DECIMAL(7,2) NOT NULL Reschedule Out Factor [days]

56 SPOT_BUY_FLG Character(1) VARCHAR2(1) NOT NULL 10/24/02 EGS (CN#PL880-1): Added

57 PL_AUC_SOURCING_BU Character(5) VARCHAR2(5) NOT NULL Sourcing Business Unit

58 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID

59 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round

60 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

61 PL_ORDER_TYPE Character(3) VARCHAR2(3) NOT NULL RAG# Added filed for Planning Phoneix.
BA=Buying Agreement
NFC=Net Forecast
PDN=Production Order
PLN=Planned Order
PPO=Planned Purchase Order
PPR=Planned Production
PSS=Strategic Sourcing Event
PTR=Planned Transfer
PUR=Purchase Order
SO=Sales Order
SOH=Starting On Hand Qty
SR=Material Stock Request
TFR=Transfer
XD=Extra Demand

62 FROZEN_CD Character(1) VARCHAR2(1) NOT NULL Frozen code
1=Change from unfrozen to frozen
2=Change from frozen to unfrozen
3=No Change

63 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
3	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
4	APPROVED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Approved by Auditor D=Denied N=Not Approved Y=Approved Y/N Table Edit Default Value: N
5	PROCESSED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Plan Processed Flag C=Complete E=Errors N=Initialize P=In Process Y/N Table Edit Default Value: N
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
8	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
9	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
10	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
11	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
12	PL_SEQ_NBR	Number(9,0)	DECIMAL(9) NOT NULL	01/09/02 EGS (CN#PL900-1): Added
13	RELEASE_DATE	Date(10)	DATE	Release Date
14	RELEASE_TIME	Time(15)	TIMESTAMP	Release Time
15	ORIG_DUE_DT	Date(10)	DATE	Original Due Date
16	ORIG_DUE_TIME	Time(15)	TIMESTAMP	Original Time Due
17	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
18	DUE_TIME	Time(15)	TIMESTAMP	Due Time
19	PLAN_DUE_DT	Date(10)	DATE	Planned Due Date
20	PLAN_DUE_TIME	Time(15)	TIMESTAMP	Planned Due Time
21	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
22	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
23	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
24	PL_PO_LEAD_TIME	Number(10,0)	DECIMAL(10) NOT NULL	11/01/01 PCL (CN#PL900-1): Added
25	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
26	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
27	QTY_PO_STD	Number(16,4)	DECIMAL(15,4) NOT NULL	PO Quantity Standard
28	PLAN_QTY_PO_STD	Number(16,4)	DECIMAL(15,4) NOT NULL	11/01/01 PCL (CN#PL900-1): Added
29	QTY_CHNG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Quantity Change Flag for Supply Planning Post Records Y/N Table Edit
30	TOLERANCE_FLG	Character(1)	VARCHAR2(1) NOT NULL	jnw changed long description for planning phoenix - commit plan 10/18/02 JC (CN#PL880-1): Added TOLERANCE label
31	PL_STATUS_CD	Character(2)	VARCHAR2(2) NOT NULL	08/07/98 SCC CN#APRD-R-SCHEW-8L1TB: Change description for value 10 'Before Planning Time Fence' to 'Expedite' 10=Expedite 20=Accepted Horizon 30=After Cutoff Fence 40=No Time Fence Defined 99=Error/Exception
32	PLAN_FROZEN_FLG	Character(1)	VARCHAR2(1) NOT NULL	11/01/01 PCL (CN#PL900-1): Updated N=No Y=Yes Y/N Table Edit
33	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
34	PL_PO_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Purchase Order Type E=Existing Orders N=Planned Order
35	CHNG_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Change Source BPA=Contract Release to Single PO CAP=Contract Batch Auto Approval CRT=PAR Replenish/Close Backorders CST=Close Short Purchase Orders DRP=Order Management Referenced EDX=PO Acknowledgments EMC=Req. Requester Mass Change EPO=eProcurement Change Request EPR=User Change Request IMC=Inventory Mass Change ONL=On-line Purchase Order PLN=Planning System PMC=PO Buyer Mass Change POC=PO Change Batch Process PRD=Production/Shop Floor
36	SCHED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Schedule Flag
37	OVERRIDE_SUGG_VNDR	Character(1)	VARCHAR2(1) NOT NULL	Override Suggested Vendor Y/N Table Edit
38	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
39	PL_PLAN_STATUS	Character(2)	VARCHAR2(2) NOT NULL	11/01/01 PCL (CN#PL900-1): Added 05=Planned 15=Firmed 90=Canceled
40	CHANGE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Yes/No indicator Y/N Table Edit Default Value: Y
41	PLANNER_CD	Character(12)	VARCHAR2(12) NOT NULL	Planner Code
42	PLANNING_TIMESTAMP	DateTime(26)	TIMESTAMP NOT NULL	Planning Date and Time
43	CANCEL_CHNG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Planning Canceled
44	SCHED_CHNG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Planning Schedule Change
45	CHNG_DTTM	DateTime(26)	TIMESTAMP	Change Request Date/Time
46	FIELD_NAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name
47	CHNG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Change Type C=Change D=Deleted H=Hold I=Inserted N=New O=Original R=Re-open X=Cancelled
48	CHNG_CHAR_VALUE	Character(254)	VARCHAR2(254) NOT NULL	New Field Value
49	CHNG_NBR_VALUE	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	New Numeric Value
50	CHNG_DATE_VALUE	Date(10)	DATE	New Date Value
51	CHNG_TIME_VALUE	Time(15)	TIMESTAMP	Change Time Value
52	DUE_DT_OLD	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
53	ACTION_MESS_CUT_DT	Date(10)	DATE	02/28/02 EGS (CN#PL900-1): Added
54	RESCH_IN_FACTOR	Number(8,2)	DECIMAL(7,2) NOT NULL	Reschedule In Factor [days]
55	RESCH_OUT_FACTOR	Number(8,2)	DECIMAL(7,2) NOT NULL	Reschedule Out Factor [days]
56	SPOT_BUY_FLG	Character(1)	VARCHAR2(1) NOT NULL	10/24/02 EGS (CN#PL880-1): Added
57	PL_AUC_SOURCING_BU	Character(5)	VARCHAR2(5) NOT NULL	Sourcing Business Unit
58	AUC_ID	Character(10)	VARCHAR2(10) NOT NULL	Event ID
59	AUC_ROUND	Number(5,0)	INTEGER NOT NULL	Event Round
60	AUC_VERSION	Number(5,0)	INTEGER NOT NULL	Event Version
61	PL_ORDER_TYPE	Character(3)	VARCHAR2(3) NOT NULL	RAG# Added filed for Planning Phoneix. BA=Buying Agreement NFC=Net Forecast PDN=Production Order PLN=Planned Order PPO=Planned Purchase Order PPR=Planned Production PSS=Strategic Sourcing Event PTR=Planned Transfer PUR=Purchase Order SO=Sales Order SOH=Starting On Hand Qty SR=Material Stock Request TFR=Transfer XD=Extra Demand
62	FROZEN_CD	Character(1)	VARCHAR2(1) NOT NULL	Frozen code 1=Change from unfrozen to frozen 2=Change from frozen to unfrozen 3=No Change
63	PEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	07/21/04 EGS: Created 10=Open 20=Completed 30=Canceled 40=Not Pegged