TXVATRPTLN FILE

This file defines a VAT Return reporting line. The total tax and total
invoice amount to be calculated for each line is determined by the criteria
specified for this record on TX06.1 (Tax Report Maintenance for VAT) and by
the tax codes specified for this record on TX06.2  (Codes  for  Report Lines).

REFERENCED BY

TX120     TX206

UPDATED BY

TX06.1    TX06.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

TVL-COMPANY          Numeric 4                                   TX06.1  TX06.2
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
VAT Report ID        The VAT Returns Report ID for which the
                     tax information is defined.

TVL-COUNTRY-CODE     Alpha 2                                     TX06.1  TX06.2
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
VAT Sequence Number  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
VAT Box Number       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
Description          This field contains the description.

TVL-SOURCE           Alpha 1                                     TX06.1
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
Tax Usage Indicator  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
Invoice/Credit Memo  Specified whether the transaction on
Indicator            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
Goods/Services       Indicates whether the Tax Code is used
Indicator            for Goods, Services or both Goods and
                     Services.

TVL-VAT-TYPE         Alpha 1                                     TX06.1
VAT Type             Specifies the type of transaction the
                     Tax Code is used for.
                     D = Domestic
                     E = Within EC
                     I = Import

TVL-CALC-TAX-IND     Alpha 1                                     TX06.1
Cumulative Tax       Cumulate tax indicator indicates
Indicator            whether this report line should include
                     the sum of the tax values for all tax
                     transactions that meet the criteria.

TVL-CALC-BASE-IND    Alpha 1                                     TX06.1
Cumulative Taxable   Cumulate base indicator indicates if
Base Ind             this report line should include the sum
                     of the base values for all tax
                     transactions.

TVL-PRINT-DTL-IND    Alpha 1                                     TX06.1
Print Detail         Print detail line indicates whether the
Indicator            report should include detail information
                     for this line.  If "Y", print detail
                     when the report is generated.

                         TXVATRPTLN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TVLSET1   COMPANY       Used to access tax report lines by       TX06.1  TX06.2
          VAT-RPT-ID    company, VAT report ID, country code,    TX120   TX206
          COUNTRY-CODE  and VAT sequence number
          VAT-SEQ-NBR