Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TXVATRPTLN


                            TXVATRPTLN FILE

                            VAT Report lines

REFERENCED BY

TX120

UPDATED BY

TX06.1    TX06.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TVL-COMPANY            Numeric 4                                 TX06.1  TX06.2
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.

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

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

TVL-VAT-SEQ-NBR        Numeric 3                                 TX06.1  TX06.2
Element: Vat Seq Nbr   The sequence number of the line on the
                       report for which these tax codes are to
                       be used.

TVL-VAT-BOX-NBR        Alpha 3                                   TX06.1  TX06.2
Element: Vat Box Nbr   The box number on the VAT report next to
                       the line on which information from this
                       line will be entered.

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

TVL-SOURCE             Alpha 1                                   TX06.1
Element: Source        The source of the transaction. Input or
                       output.  Input transactions are Accounts
                       Payable. Output transactions are
                       Accounts Receivable.

TVL-TAX-USG-IND        Alpha 1                                   TX06.1
Element: Tax Usg Ind   Indicates whether the information for
                       this line is to be obtained based on the
                       tax code or the tax usage code on the
                       TXTAXTRANS record.

TVL-INV-CRD-IND        Alpha 1                                   TX06.1
Element: Inv Crd Ind   Specified whether the transaction on
                       which the tax was entered as an invoice
                       or a credit memo.
                       I = Invoice
                       C = Credit Memo

TVL-GDS-SVCS-IND       Alpha 1                                   TX06.1
Element: Gds Svcs Ind  Goods and services indicator.

TVL-VAT-TYPE           Alpha 1                                   TX06.1
Element: Vat Type      Specifies the type of transaction the
                       tax code is used for.
                       D = Domestic
                       E = Intra EEC
                       X = Export
                       I = Import

TVL-CALC-TAX-IND       Alpha 1                                   TX06.1
Element: Calc Tax Ind  Cumulate tax indicator indicates whether
                       this report line whould include the sum
                       of the tax values for al tax
                       transactions that meet the criteria
                       Y
                       N

TVL-CALC-BASE-IND      Alpha 1                                   TX06.1
Element: Calc Base Ind Cumulate base indicator indicates if
                       this report line should include the sum
                       of the base values for all tax
                       transactions.
                       Y
                       N

TVL-PRINT-DTL-IND      Alpha 1                                   TX06.1
Element: Print Dtl Ind Print detail line indicates whether the
                       report should include detail information
                       for this line.  If "Y", print detail
                       when the report is generated.
                       Y
                       N

                         TXVATRPTLN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TVLSET1   COMPANY                                                TX06.1  TX06.2
          VAT-RPT-ID                                             TX120
          COUNTRY-CODE
          VAT-SEQ-NBR

                         TXVATRPTLN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Vatrpt Codes   TXVATRPTCD

                            TVL-COMPANY         -> TVC-COMPANY
                            TVL-VAT-RPT-ID      -> TVC-VAT-RPT-ID
                            TVL-COUNTRY-CODE    -> TVC-COUNTRY-CODE
                            TVL-VAT-SEQ-NBR     -> TVC-VAT-SEQ-NBR
                                                   TVC-TAX-USAGE-CD

Vatsales Codes TXVATESLCD

                            TVL-COMPANY         -> TVS-COMPANY
                            TVL-VAT-RPT-ID      -> TVS-VAT-RPT-ID
                            TVL-COUNTRY-CODE    -> TVS-COUNTRY-CODE
                                                   TVS-TAX-CODE