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

PR220     UK50.3

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TID-COMPANY            Numeric 4                                 PR05.2  PR20.5
Element: Company Hr    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.

TID-PAY-DED-FLAG       Alpha 1                                   PR05.2  PR20.5
Pay Code or Deduct     Contains the value that indicates if
Code Flag              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: Payment 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: Deduction CodeContains a deduction for both types of
                       records.

TID-TAXABLE-FLAG       Alpha 1                                   PR20.5
Taxable or             Contains a value that identifies how
Non-Taxable Flag       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                                                HR00.1  HR01.1
          PAY-DED-FLAG                                           PBIP.1  PR05.1
          PAY-CODE                                               PR05.2  PR197
          DED-CODE                                               PR20.2  PR20.5
                                                                 PR220   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