AMAPLEAPMT_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	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
5	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once Default Value: N
6	PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success Default Value: P
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	FROM_ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	From Asset ID
9	TO_ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	To Asset ID
10	PYMNT_DT_FROM	Date(10)	DATE	From Payment Date
11	PYMNT_DT_TO	Date(10)	DATE	To Payment Date
12	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
13	INVOICE_DT	Date(10)	DATE	Invoice Date
14	RT_RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Market Rate Index
15	LOOP_COUNT	Number(4,0)	SMALLINT NOT NULL	Number of Program Loops
16	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
18	VOUCHER_STYLE	Character(4)	VARCHAR2(4) NOT NULL	Voucher Style ADJ=Adjustments AMR=Amortization Voucher CLBK=Claim Voucher CORR=Reversal Voucher JRNL=Journal Voucher PPAY=Prepaid Voucher REG=Regular Voucher RGTR=Register Voucher SGLP=Single Payment Voucher THRD=Third Party Voucher TMPL=Template Voucher
19	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
20	END_DT	Date(10)	DATE	End Date
21	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
22	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
23	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
24	DESCRLONG4	Long Character	CLOB	Long Description