Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TXVATRPTCD


                            TXVATRPTCD FILE

                            VAT Report codes

This file contains the Tax Codes that are to be reported on a given line on a
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

UPDATED BY

TX06.1    TX06.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

TVC-VAT-RPT-ID         Alpha 10                                  TX06.2
Element: Vat Rpt Id    The VAT Report ID for which a VAT report
                       is generated.

TVC-COUNTRY-CODE       Alpha 2                                   TX06.2
Element: 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
Element: 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
Element: 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