Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             TXUSAGECD FILE

This file contains a list of valid Tax Usage Codes.  These codes are recorded
on Tax Distributions in the AP system to indicate the use for which products
were purchased and are used for VAT reporting.  The tax usage code table is
maintained by TX07.1 (Tax Usage Codes).

REFERENCED BY

AP10.5    AP10.6    AP10.1    AP10.2    TX06.2    TX206
AP20.1    AP20.2    AP20.5    AP20.7    AP23.1    MA40.1
MA40.2    MA41.1    MA41.2    MA41.4    MA41.5    MA41.6
MA43.1    MA43.2    MA43.3    MA43.4    MA52.1

UPDATED BY

TX07.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

TXU-COMPANY          Numeric 4                                   TX07.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

TXU-TAX-USAGE-CD     Alpha 10                                    TX07.1
Tax Usage Code       A tax usage code is used to keep
                     statistics on the amounts of goods and
                     services purchased for specific uses for
                     the purpose of VAT reporting.

TXU-DESCRIPTION      Alpha 30  (Lower Case)                      TX07.1
Description          The tax usage code description.

                         TXUSAGECD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TXUSET1   COMPANY       Used to access a tax usage code by       AP10.5  AP10.6
          TAX-USAGE-CD  company.                                 TX06.2  TX07.1
                                                                 TX206

TXUSET2   TAX-USAGE-CD  Used to access tax usage codes.          AP10.1  AP10.2
                        Duplicates                               AP20.1  AP20.2
                                                                 AP20.5  AP20.7
                                                                 AP23.1  MA40.1
                                                                 MA40.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.5  MA41.6
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA52.1