|
|
TXVATRPTLN FILE
VAT Report lines
This file contains the transactions that are to be included on a VAT Return
reporting line. The Total Tax and Total Invoice Amount to be calculated for
each line is determined either by the tax codes and tax transactions that meet
the criteria specified on this record or by the tax codes on the Tax Report
Detail records that are related to this record.
REFERENCED BY
TX120
UPDATED BY
TX06.1 TX06.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TVL-COMPANY Numeric 4 TX06.1 TX06.2
Element: Company The company number represents an
established company and is entered on
all function codes.
TVL-VAT-RPT-ID Alpha 10 TX06.1 TX06.2
Element: Vat Rpt Id The VAT Report ID for which a VAT report
is generated.
TVL-COUNTRY-CODE Alpha 2 TX06.1 TX06.2
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
TVL-VAT-SEQ-NBR Numeric 3 TX06.1 TX06.2
Element: Vat Seq Nbr The sequence number of the line on the
report for which these tax codes are to
be used.
TVL-VAT-BOX-NBR Alpha 3 TX06.1 TX06.2
Element: Vat Box Nbr The box number on the VAT report next to
the line on which information from this
line will be entered.
TVL-DESCRIPTION Alpha 30 (Lower Case) TX06.1
Element: Description This field displays the description.
TVL-SOURCE Alpha 1 TX06.1
Element: Source The source of the transaction. Input or
output. Input transactions are Accounts
Payable. Output transactions are
Accounts Receivable.
TVL-TAX-USG-IND Alpha 1 TX06.1
Element: Tax Usg Ind 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.
TVL-INV-CRD-IND Alpha 1 TX06.1
Element: Inv Crd Ind Specified whether the transaction on
which the tax was entered as an invoice
or a credit memo.
I = Invoice
C = Credit Memo
TVL-GDS-SVCS-IND Alpha 1 TX06.1
Element: Gds Svcs Ind Goods and services indicator.
TVL-VAT-TYPE Alpha 1 TX06.1
Element: Vat Type Specifies the type of transaction the
tax code is used for.
D = Domestic
E = Intra EEC
X = Export
I = Import
TVL-CALC-TAX-IND Alpha 1 TX06.1
Element: Calc Tax Ind 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
TVL-CALC-BASE-IND Alpha 1 TX06.1
Element: Calc Base Ind Cumulate base indicator indicates if
this report line should include the sum
of the base values for all tax
transactions.
Y
N
TVL-PRINT-DTL-IND Alpha 1 TX06.1
Element: Print Dtl Ind 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
TXVATRPTLN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TVLSET1 COMPANY TX06.1 TX06.2
VAT-RPT-ID TX120
COUNTRY-CODE
VAT-SEQ-NBR
TXVATRPTLN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
