VAT_DF_TXE_TMP

(SQL Table)
Index Back

VAT Transaction Default Temp

# 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 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
7 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
8 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
9 VAT_RECLAIM_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Reclaim Percent
10 VAT_AUTO_CALC_FLG Character(1) VARCHAR2(1) NOT NULL Automatically Calculate VAT
N=No
Y=Yes