TXVATRPTLN

VAT Report lines

REFERENCED BY
TX120


UPDATED BY
TX06.1 TX06.2

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TVLSET1 COMPANY
VAT-RPT-ID
COUNTRY-CODE
VAT-SEQ-NBR
TX06.1 TX06.2
TX06.4 TX120


TXVATRPTLN FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Vatrpt Codes TXVATRPTCD
TVL-COMPANY->TVC-COMPANY
TVL-VAT-RPT-ID->TVC-VAT-RPT-ID
TVL-COUNTRY-CODE->TVC-COUNTRY-CODE
TVL-VAT-SEQ-NBR->TVC-VAT-SEQ-NBR
  TVC-TAX-USAGE-CD
Vatsales Codes TXVATESLCD
TVL-COMPANY->TVS-COMPANY
TVL-VAT-RPT-ID->TVS-VAT-RPT-ID
TVL-COUNTRY-CODE->TVS-COUNTRY-CODE
  TVS-TAX-CODE


File created: Thu Jun 09 11:29:36 2016

Home
Contact Us



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