PL_POST_PO_TAO (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_TAO

(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 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

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

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

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

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

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

7 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

8 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

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

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

11 RELEASE_DATE Date(10) DATE Release Date

12 RELEASE_TIME Time(15) TIMESTAMP Release Time

13 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.

14 DUE_TIME Time(15) TIMESTAMP Due Time

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

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

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

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

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

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

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

22 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
Y/N Table Edit

23 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

24 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

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

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

27 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

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

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

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

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

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

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

34 PLANNING_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Planning Date/Time

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

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

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

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

39 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

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

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

42 CHNG_DATE_VALUE Date(10) DATE New Date Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
2	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
5	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
6	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
7	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
8	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
9	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
10	PL_SEQ_NBR	Number(9,0)	DECIMAL(9) NOT NULL	01/09/02 EGS (CN#PL900-1): Added
11	RELEASE_DATE	Date(10)	DATE	Release Date
12	RELEASE_TIME	Time(15)	TIMESTAMP	Release Time
13	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.
14	DUE_TIME	Time(15)	TIMESTAMP	Due Time
15	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
16	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
17	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
18	PL_PO_LEAD_TIME	Number(10,0)	DECIMAL(10) NOT NULL	11/01/01 PCL (CN#PL900-1): Added
19	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
20	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
21	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
22	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 Y/N Table Edit
23	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
24	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
25	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
26	PL_PO_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Purchase Order Type E=Existing Orders N=Planned Order
27	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
28	SCHED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Schedule Flag
29	OVERRIDE_SUGG_VNDR	Character(1)	VARCHAR2(1) NOT NULL	Override Suggested Vendor Y/N Table Edit
30	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
31	PL_PLAN_STATUS	Character(2)	VARCHAR2(2) NOT NULL	11/01/01 PCL (CN#PL900-1): Added 05=Planned 15=Firmed 90=Canceled
32	CHANGE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Yes/No indicator Y/N Table Edit Default Value: Y
33	PLANNER_CD	Character(12)	VARCHAR2(12) NOT NULL	Planner Code
34	PLANNING_TIMESTAMP	DateTime(26)	TIMESTAMP NOT NULL	Planning Date/Time
35	CANCEL_CHNG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Planning Canceled
36	SCHED_CHNG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Planning Schedule Change
37	CHNG_DTTM	DateTime(26)	TIMESTAMP	Change Request Date/Time
38	FIELD_NAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name
39	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
40	CHNG_CHAR_VALUE	Character(254)	VARCHAR2(254) NOT NULL	New Field Value
41	CHNG_NBR_VALUE	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	New Numeric Value
42	CHNG_DATE_VALUE	Date(10)	DATE	New Date Value