AP_APS8001_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	NUM_OPERAND3	Character(2)	VARCHAR2(2) NOT NULL	Number Operand <=Less Than <==Less Than OR Equal <>=Not Equal ==Equal >=Greater Than >==Greater Than OR Equal
5	NUM_QUERY_VALUE	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Number Query
6	NUM_OPERAND4	Character(2)	VARCHAR2(2) NOT NULL	Number Operand <=Less Than <==Less Than OR Equal <>=Not Equal ==Equal >=Greater Than >==Greater Than OR Equal
7	BUDGET_DT_FROM	Date(10)	DATE	Budget Date
8	BUDGET_DT_TO	Date(10)	DATE	Budget Date
9	ALC	Character(8)	VARCHAR2(8) NOT NULL	Agency Location Code
10	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
11	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
12	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
13	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
14	DISCOUNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the discount amount deducted from the par price of a given deal transaction such as a bond.
15	INTEREST_PAYMENT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment that goes towards paying the interest.
16	REMAINING_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Remaining Amount
17	DECIMALPOS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions