OMBI_VAT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
4	VAT_APPLICABLE	Character(1)	VARCHAR2(1) NOT NULL	VAT Applicable E=Exempt O=Outside of Scope of VAT T=Taxable
5	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.
6	VAT_TXN_TYPE	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.
7	PROD_GRP_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product Group SetID
8	PROD_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product SetID
9	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
10	VAT_CALC_GROSS_NET	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount. G=Calculate at Gross N=Calculate at Net
11	VAT_RECALC_FLG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
12	VAT_DCLRTN_POINT	Character(1)	VARCHAR2(1) NOT NULL	A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment. A=At Accounting Date D=At Delivery Time I=At Invoice Time P=At Payment Time
13	VAT_TXN_TYPE_EXPRT	Character(4)	VARCHAR2(4) NOT NULL	VAT Transaction Type for Exports
14	VAT_TXN_TYPE_EU_SL	Character(4)	VARCHAR2(4) NOT NULL	VAT Transaction Type for European Union Sales
15	VAT_TXN_TYPE_EXON	Character(4)	VARCHAR2(4) NOT NULL	Exonerated VAT Trans Type
16	VAT_TXN_TYPE_SUSP	Character(4)	VARCHAR2(4) NOT NULL	Suspended VAT Transaction Type
17	VAT_TXN_TYPE_OOS	Character(4)	VARCHAR2(4) NOT NULL	Out of Scope VAT Trans Type
18	VAT_TXN_TYPE_EXMPT	Character(4)	VARCHAR2(4) NOT NULL	Exempt VAT Transaction Type
19	VAT_CODE_SUSP	Character(8)	VARCHAR2(8) NOT NULL	Suspended VAT Code
20	VAT_CODE_EXPRT	Character(8)	VARCHAR2(8) NOT NULL	Export VAT Code
21	VAT_CODE_EXON	Character(8)	VARCHAR2(8) NOT NULL	Exonerated VAT Code
22	VAT_CODE_EU_SL	Character(8)	VARCHAR2(8) NOT NULL	EU Sales VAT Code
23	VAT_ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	" Rounding rule to be applied to VAT calculations. Options are 'Natural' D=Round Down N=Natural Round U=Round Up
24	SUSPEND_FLG	Character(1)	VARCHAR2(1) NOT NULL	Location Suspend Flag
25	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country