VAT_RPT_ID_DTL3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VAT_RPT_ID	Character(8)	VARCHAR2(8) NOT NULL	Report ID
2	VAT_RPT_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
4	FIELDCOUNT	Number(4,0)	SMALLINT NOT NULL	Field Count
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
6	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. Prompt Table: VAT_HEADER_VW
7	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. Prompt Table: VAT_TXN_CD
8	VAT_DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger. Prompt Table: VAT_DST_VAT_VW