UPG_APM02_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
4	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
5	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
6	TAX_DSCNT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Discount
7	TAX_FRGHT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Freight
8	TAX_MISC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Misc Charges
9	TAX_VAT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include VAT N=No Y=Yes
10	SALETX_CALC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Calculated Sales Tax Amount
11	SALETX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
12	USETAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
13	FRGT_SUT_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight SUT Basis Amount
14	DSCN_SUT_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount SUT Basis Amount
15	MISC_SUT_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc Charge SUT Basis Amount
16	SUT_CALC_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	SUT Calculation Basis Amount
17	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
18	TAX_CD_SUT	Character(8)	VARCHAR2(8) NOT NULL	Tax Code - Sales and Use Tax
19	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
20	TAX_CD_SUT_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Sales/Use Tax Code Percent
21	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field for Hiding Groups