PO_POROLL1_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	RUN_DT	Date(10)	DATE	Run Date
5	ROLL_ENC_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Roll Encumbrance B=Roll Business Unit E=Roll Encumbrance
6	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
9	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
10	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
11	ASOFDATE	Date(10)	DATE	As of Date
12	FROM_DATE	Date(10)	DATE	From Date
13	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
14	SEQ_NUM_TO	Number(3,0)	SMALLINT NOT NULL	Sequence
15	BUDGET_DT	Date(10)	DATE	Budget Date
16	BUDGET_DT_FROM	Date(10)	DATE	Budget Date From
17	BUDGET_DT_TO	Date(10)	DATE	Budget Date To
18	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
19	BUSINESS_UNIT_REQ	Character(5)	VARCHAR2(5) NOT NULL	Requesting Business Unit
20	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
21	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
22	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
23	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number
24	QTY_ROLLED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Rolled
25	QTY_ROLLED_STD	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Rolled Standard
26	QTY_REQ	Number(16,4)	DECIMAL(15,4) NOT NULL	Requisition Quantity
27	AMT_REQ	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Requisition Merchandise Amount
28	PO_ENCUM_NET	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Outstanding PO Encumbrance
29	PO_ENCUM_NET_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Outstanding PO Encumbrance Bse
30	CONVERSION_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
31	FINALIZE_SW	Character(1)	VARCHAR2(1) NOT NULL	Finalize