Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TXVATRPT


                             TXVATRPT FILE

                         VAT Report definitions

REFERENCED BY

TX130     TX120

UPDATED BY

TX06.1    TX06.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TVR-COMPANY            Numeric 4                                 TX06.1  TX06.3
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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

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

TVR-DESCRIPTION        Alpha 30  (Lower Case)                    TX06.1
Element: Description   This field displays the description.

                         TXVATRPT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TVRSET1   COMPANY                                                TX06.1  TX06.3
          VAT-RPT-ID                                             TX06.4  TX130
          COUNTRY-CODE

TVRSET2   COMPANY                                                TX120
          VAT-RPT-ID

                         TXVATRPT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Instctrycd     INSTCTRYCD   Required

                            TVR-COUNTRY-CODE    -> INT-COUNTRY-CODE

Txcompany      TXCOMPANY    Required

                            TVR-COMPANY         -> TXC-COMPANY

                         TXVATRPT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Vatrpt Lines   TXVATRPTLN

                            TVR-COMPANY         -> TVL-COMPANY
                            TVR-VAT-RPT-ID      -> TVL-VAT-RPT-ID
                            TVR-COUNTRY-CODE    -> TVL-COUNTRY-CODE
                                                   TVL-VAT-SEQ-NBR