Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            TXVATESLCD FILE

This file contains a list of tax codes that are to be included on the EC
Sales List Report that is related to a specific VAT Report.

REFERENCED BY

TX130

UPDATED BY

TX06.1    TX06.3

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

TVS-VAT-RPT-ID       Alpha 10                                    TX06.3
Vat Rpt Id           The VAT Report ID for which the EC
                     Sales List report is generated.

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


TVS-TAX-CODE         Alpha 10                                    TX06.3
Tax Code             A tax code to be included in the EC
                     Sales report.

                         TXVATESLCD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TVSSET1   COMPANY       Used to access the ESL tax codes by      TX06.1  TX06.3
          VAT-RPT-ID    company, VAT Report ID, and country      TX130
          COUNTRY-CODE  code.
          TAX-CODE

TVSSET2   COMPANY       Used to access ESL tax codes by company
          VAT-RPT-ID    and VAT Report ID.
          TAX-CODE      Duplicates