Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TAXIDEXMP


                             TAXIDEXMP FILE

                      Pay/Deduction Exemption Code

The Pay/Deduction Exemption Code file contains two types of records. PR05.2
(Taxable Wages Table) creates type D records that represent withholding
deductions whose taxable wage is to be reduced by the amount of a designated
deduction. PR20.5 (Withholding Exemptions) creates type P records that
represent withholding deductions that are not to be used in calculating taxes
for a designated pay code.

REFERENCED BY

BN66.1    PR140     PR189     PR195     PR220     PR262
PR80.1    PR89.1    UK13.1    UK50.3

UPDATED BY

PR05.1    PR05.2    PR20.5    PR20.2    HR00.1    HR01.1


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TID-COMPANY            Numeric 4                                 PR05.2  PR20.5
Element: Company Hr

TID-PAY-DED-FLAG       Alpha 1                                   PR05.2  PR20.5
Element: Pay Ded Flag  Contains the value that indicates if
                       the record is a type D (created by
                       PR05.2 - Taxable Wages Table) or a type
                       P (created by  PR20.5 - Withholding
                       Exemptions).
                       D = Deduction Code
                       P = Pay Summary Group

TID-PAY-CODE           Alpha 4                                   PR05.2  PR20.5
Element: Pay Code      For type D (created by PR05.2 - Taxable
                       Wages Table) records, this field
                       contains a deduction. For type P
                       (created by PR20.5 - Withholding
                       Exemptions) records, this field contains
                       a pay code.

TID-DED-CODE           Alpha 4                                   PR05.2  PR20.5
Element: Ded Code      Contains a deduction for both types of
                       records.

TID-TAXABLE-FLAG       Alpha 1                                   PR20.5
Element: Taxable Flag  Contains a value that identifies how
                       the deduction is treated. The system
                       uses this field only with type P
                       records. If the value in this field is E
                       (Exempt), the deduction entered is
                       exempt from the pay code amount.

                       If the value in this field is T
                       (Taxable Wages only), the taxable wages
                       associated with the deduction entered
                       are updated by the amount of the pay
                       code. The tax amount for the deduction
                       is not withheld.
                       T = Update Taxable Only
                       E = Exempt from Taxation

                         TAXIDEXMP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TIDSET1   COMPANY                                                BN66.1  HR00.1
          PAY-DED-FLAG                                           HR01.1  PR05.1
          PAY-CODE                                               PR05.2  PR140
          DED-CODE                                               PR189   PR195
                                                                 PR20.2  PR20.5
                                                                 PR220   PR262
                                                                 PR80.1  PR89.1
                                                                 UK13.1  UK50.3

                         TAXIDEXMP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            TID-COMPANY     -> PRS-COMPANY
                            Spaces          -> PRS-PROCESS-LEVEL

Ded Code       DEDCODE      Required
                            When TID-PAY-DED-FLAG = "D"

                            TID-COMPANY     -> DDC-COMPANY
                            TID-PAY-CODE    -> DDC-DED-CODE

Deduction      DEDCODE      Required

                            TID-COMPANY     -> DDC-COMPANY
                            TID-DED-CODE    -> DDC-DED-CODE

Pay Sum Grp    PAYSUMGRP    Required
                            When TID-PAY-DED-FLAG = "P"

                            TID-COMPANY     -> PSG-COMPANY
                            TID-PAY-CODE    -> PSG-PAY-SUM-GRP