EX_PYPUB_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AE_PRODUCT	Character(2)	VARCHAR2(2) NOT NULL	Product
3	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
4	AE_STEP	Character(8)	VARCHAR2(8) NOT NULL	Name
5	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
8	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Documentation ID
9	EX_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies Expenses Document Type A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization
10	EX_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number
11	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
14	GROSSUP	Character(1)	VARCHAR2(1) NOT NULL	Gross Up Indicator
15	SEPCHK	Number(1,0)	SMALLINT NOT NULL	Separate Check Indicator
16	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
17	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine