VAT_DF_VCE_TMP (SQL Table)	Index Back
VAT Code Defaulting Temp Table

VAT_DF_VCE_TMP

(SQL Table)

VAT Code Defaulting Temp Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

3 STATE Character(6) VARCHAR2(6) NOT NULL State

4 EXPENSE_TYPE_SETID Character(5) VARCHAR2(5) NOT NULL Expense Type SetID

5 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type

6 VAT_APPLICABLE Character(1) VARCHAR2(1) NOT NULL VAT Applicable
E=Exempt
O=Outside of Scope of VAT
T=Taxable

7 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
3	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
4	EXPENSE_TYPE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Expense Type SetID
5	EXPENSE_TYPE	Character(7)	VARCHAR2(7) NOT NULL	Expense Type
6	VAT_APPLICABLE	Character(1)	VARCHAR2(1) NOT NULL	VAT Applicable E=Exempt O=Outside of Scope of VAT T=Taxable
7	TAX_CD_VAT	Character(8)	VARCHAR2(8) NOT NULL	Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.