PO_CNTRCT_AET

#	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	ALL_BU	Character(1)	VARCHAR2(1) NOT NULL	All Business Units N=Specific Business Unit Y=All Business Units
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	ALL_CNTRCT	Character(1)	VARCHAR2(1) NOT NULL	All Contracts N=Specific Contract Y=All Contracts
7	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
8	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
9	VERSION_NBR	Number(5,0)	INTEGER NOT NULL	Contract Version number
10	ALL_PO_DT	Character(1)	VARCHAR2(1) NOT NULL	All PO Dates N=PO Date Range S=PO Date By Y=All PO Dates
11	PO_DT	Date(10)	DATE	Date
12	PO_STG_ID	Character(10)	VARCHAR2(10) NOT NULL	Uniqye key to the PO Staging table
13	RECORD_COUNT	Number(7,0)	INTEGER NOT NULL	Count of Records
14	LAST_PO_STG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Last Stage ID used
15	R_SETID	Character(5)	VARCHAR2(5) NOT NULL	Retrieving SETID
16	R_CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Retrieving Contract ID
17	R_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Retrieving Business Unit
18	R_PO_DT	Date(10)	DATE	Retrieving PO Date
19	COMMENT_SEQ	Number(3,0)	SMALLINT NOT NULL	Comment Nbr
20	CNTRCT_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Buying Agreement Line Nbr
21	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
22	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
23	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
24	AE_CNV_IN_FLD_NM	Character(18)	VARCHAR2(18) NOT NULL	AE input convert field
25	AE_CNV_OUT_FLD_NM	Character(18)	VARCHAR2(18) NOT NULL	AE output converion field
26	THRU_DATE	Date(10)	DATE	Through Date
27	DAYSFROM	Signed Number(4,0)	DECIMAL(3) NOT NULL	Days From The Scheduled Run
28	SIGN	Character(1)	VARCHAR2(1) NOT NULL	Plus/Minus Sign
29	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
30	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
31	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
32	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
33	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
34	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
35	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number
36	BUSINESS_UNIT_LAST	Character(5)	VARCHAR2(5) NOT NULL	Last Business_Unit
37	REQ_ID_OLD	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
38	LINE_NBR_LAST	Number(5,0)	INTEGER NOT NULL	Last Line Number
39	SCHED_NBR_LAST	Number(5,0)	INTEGER NOT NULL	Scheduled last number
40	DISTRIB_NBR_LAST	Number(5,0)	INTEGER NOT NULL	Distrib Nbr
41	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
42	QTY_OPEN	Number(16,4)	DECIMAL(15,4) NOT NULL	Open Quantity
43	QTY_OPEN_STD	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Open Standard UOM