Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            TXVATRPTCD FILE

                            VAT Report codes

REFERENCED BY

TX120

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 Rpt Id           The VAT Report ID for which a VAT report
                     is generated.

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 Seq Nbr          The sequence number of the line on the
                     report for which these tax codes are to
                     be used.

TVC-TAX-USAGE-CD     Alpha 10                                    TX06.2
Tax Usage Cd         The tax usage coe for the vendor.  This
                     filed is required if the AP Company
                     inidcates that VAT reporting required.

                         TXVATRPTCD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TVCSET1   COMPANY                                                TX06.1  TX06.2
          VAT-RPT-ID                                             TX120
          COUNTRY-CODE
          VAT-SEQ-NBR
          TAX-USAGE-CD