Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TXCALDTL


                             TXCALDTL FILE

                          VAT calendar detail

REFERENCED BY

AP272     TX101     TX125     TX130     TX222     TX226
TX301

UPDATED BY

TX08.1    TX120

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TXB-COMPANY            Numeric 4                                 TX08.1
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.

TXB-TAX-YEAR           Numeric 4                                 TX08.1
Element: Tax Year      The tax year for which the calendar was
                       defined.

TXB-TAX-PERIOD         Numeric 2                                 TX08.1
Element: Tax Period    The tax period of the specified year.

TXB-PER-END-DATE       Numeric 8  (yyyymmdd)                     TX08.1
Element: Per End Date  Identifies period end date in
                       distribution record; used during PR198
                       to relieve salary encumbrance
                       commitments for pay period (updated from
                       TIMERECORD.PER-END-DATE).

TXB-STATUS             Numeric 1                                 TX08.1  TX120
Element: Status        This field displays the status of the
                       transaction.
                       1 = Open
                       2 = Reported
                       3 = Closed

                         TXCALDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TXBSET1   COMPANY                                                AP272   TX08.1
          TAX-YEAR                                               TX101   TX120
          TAX-PERIOD                                             TX125   TX130
                                                                 TX222   TX226
                                                                 TX301