VAT_RRG_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	VAT_SETID	Character(5)	VARCHAR2(5) NOT NULL	VAT SetID
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Code
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type
8	CHARTFIELD_PR1_VAL	Character(20)	VARCHAR2(20) NOT NULL	Chartfield Priority 1 Value
9	CHARTFIELD_PR2_VAL	Character(20)	VARCHAR2(20) NOT NULL	Chartfield Priority 2 Value
10	VAT_RCVRY_RT_ITM	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Item VAT Recovery Rate
11	CHARTFIELD_VALUE	Character(30)	VARCHAR2(30) NOT NULL	ChartField Value
12	VAT_RECOVERY_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Recovery Percent
13	VAT_REBATE_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Rebate Percent
14	VAT_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a VAT calculation error has been found. This field is maintained by the system. N=No Error O=VAT Amount Calculation Error
15	LENGTH	Number(5,0)	INTEGER NOT NULL	Length
16	TAX_PCT	Number(7,4)	DECIMAL(6,4) NOT NULL	Tax Percent
17	VAT_REBATE_RT	Number(6,2)	DECIMAL(5,2) NOT NULL	VAT Rebate Rate
18	VAT_RCVRY_ACT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	VAT Taxable Activity Percent
19	VAT_REBATE_ACT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	VAT Exempt Activity Percent
20	VAT_RCVRY_SRC	Character(1)	VARCHAR2(1) NOT NULL	VAT Recovery Source M=Mixed Apportionment U=Use Type
21	LENGTH_MIN	Number(5,0)	INTEGER NOT NULL	Minimum Length
22	CHARTCNTRLFIELD	Character(21)	VARCHAR2(21) NOT NULL	Chart Control
23	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field for Hiding Groups
24	ROW_RETURNED	Character(1)	VARCHAR2(1) NOT NULL	An internal work field utilized in position tree processing.