TXVATRPTCD FILE

This file maintains the tax usage codes that are to be reported on a given
line on  the VAT  Return report.  If any records exist in this file for a
report line,  then only the tax transactions related to those tax codes are
included on that line on the report.



REFERENCED BY

TX120     TX206

UPDATED BY

TX06.1    TX06.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

TVC-COMPANY          Numeric 4                                   TX06.2
Company              The company number represents an
                     established company and is entered on
                     all function codes.

TVC-VAT-RPT-ID       Alpha 10                                    TX06.2
VAT Report ID        The VAT Returns Report ID for which the
                     tax usage codes are being defined.

TVC-COUNTRY-CODE     Alpha 2                                     TX06.2
Country Code         The country code.  Required for VAT and
                     intrastat reporting.  Must be defined in
                      IN01.1 (Country Maintenance).


TVC-VAT-SEQ-NBR      Numeric 3                                   TX06.2
VAT Sequence Number  Sequence number of the line on the
                     report for which these tax usage codes
                     are to be used.

TVC-TAX-USAGE-CD     Alpha 10                                    TX06.2
Tax Usage Code       The tax usage code applying to this VAT
                     report line. More than one tax usage
                     code can apply to the same line.

                         TXVATRPTCD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TVCSET1   COMPANY       Used to access tax usage codes for a     TX06.1  TX06.2
          VAT-RPT-ID    VAT Return report line by company, VAT   TX120   TX206
          COUNTRY-CODE  Report ID, country code and VAT Sequence
          VAT-SEQ-NBR   number.
          TAX-USAGE-CD