VAT Report lines
UPDATED BY

TX06.1

TX06.2

TX120

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
TVL-COMPANY Element: Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	TX06.1 TX06.2
TVL-VAT-RPT-ID Element: Vat Rpt Id	Alpha 10 The VAT Report ID for which a VAT report is generated.	TX06.1 TX06.2
TVL-COUNTRY-CODE Element: Country Code	Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	TX06.1 TX06.2
TVL-VAT-SEQ-NBR Element: Vat Seq Nbr	Numeric 3 The sequence number of the line on the report for which these tax codes are to be used.	TX06.1 TX06.2
TVL-VAT-BOX-NBR Element: Vat Box Nbr	Alpha 3 The box number on the VAT report next to the line on which information from this line will be entered.	TX06.1 TX06.2
TVL-DESCRIPTION Element: Description	Alpha 30 (Lower Case) This field displays the description.	TX06.1
TVL-SOURCE Element: Source	Alpha 1 The source of the transaction. Input or output. Input transactions are Accounts Payable. Output transactions are Accounts Receivable.	TX06.1
TVL-TAX-USG-IND Element: Tax Usg Ind	Alpha 1 Indicates whether the information for this line is to be obtained based on the tax code or the tax usage code on the TXTAXTRANS record.	TX06.1
TVL-INV-CRD-IND Element: Inv Crd Ind	Alpha 1 Specified whether the transaction on which the tax was entered as an invoice or a credit memo. I = Invoice C = Credit Memo	TX06.1
TVL-GDS-SVCS-IND Element: Gds Svcs Ind	Alpha 1 Goods and services indicator.	TX06.1
TVL-VAT-TYPE Element: Vat Type	Alpha 1 Specifies the type of transaction the tax code is used for. D = Domestic E = Intra EEC X = Export I = Import	TX06.1
TVL-CALC-TAX-IND Element: Calc Tax Ind	Alpha 1 Cumulate tax indicator indicates whether this report line whould include the sum of the tax values for al tax transactions that meet the criteria Y N	TX06.1
TVL-CALC-BASE-IND Element: Calc Base Ind	Alpha 1 Cumulate base indicator indicates if this report line should include the sum of the base values for all tax transactions. Y N	TX06.1
TVL-PRINT-DTL-IND Element: Print Dtl Ind	Alpha 1 Print detail line indicates whether the report should include detail information for this line. If "Y", print detail when the report is generated. Y N	TX06.1
TVL-STATUS Element: Active Status	Alpha 1 The status of the account. If Inactive, no posting can be done to the account.	TX06.1

TXVATRPTLN FILE INDEX

TXVATRPTLN FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.