Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             TXVATRPT FILE

This file defines a VAT tax report for a country.

REFERENCED BY

TX120     TX130     TX206

UPDATED BY

TX06.1    TX06.3

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

TVR-VAT-RPT-ID       Alpha 10                                    TX06.1  TX06.3
VAT Report ID        The VAT Returns Report ID for which the
                     tax codes are being defined.

TVR-COUNTRY-CODE     Alpha 2                                     TX06.1  TX06.3
Country Code         The two-digit country code.  Required
                     for  VAT and intrastat reporting.  Must
                     be a  valid code in IN01.1 (Country
                     Maintenance).

TVR-DESCRIPTION      Alpha 30  (Lower Case)                      TX06.1
Description          The country description.

                         TXVATRPT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TVRSET1   COMPANY       Used to access reports by company, VAT   TX06.1  TX06.3
          VAT-RPT-ID    Report ID, and country code..            TX120   TX130
          COUNTRY-CODE

TVRSET2   COMPANY       Used to access VAT reports by company    TX120   TX206
          VAT-RPT-ID    and VAT report ID.
                        Duplicates