Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRTAXLOC


                             PRTAXLOC FILE

REFERENCED BY

BN100     BN101     BN102     BN103     BN104     BN105
BN145     BN245     BN31.1    BN31.2    BN32.1    BN32.2
BN32.3    BN45.1    BN531     BN65.1    BN71.1    BN72.1
BS13.1    BS14.1    BS15.1    BS32.1    HR211     PR26.1
PR26.2    PR39.1    PR39.2    PR47.1    PR47.2    UK47.1
UK47.2    HR04.9

UPDATED BY

BN150     HR11.1    HR11.2    HR511     PA02.1    PA100
PA102     PA13.1    PA13.2    PA502     PA513     PA52.1
PA52.3    PA52.4    PA52.5    PR110     PR113     PR120
PR128     PR13.1    PR13.5    PR13.6    PR13.7    PR13.8
PR130     PR131     PR132     PR134     PR136     PR14.1
PR15.2    PR205     PR29.1    PR313     PR32.2    PR33.2
PR33.3    PR35.1    PR35.2    PR35.3    PR35.4    PR35.5
PR35.6    PR35.8    PR35.9    PR36.1    PR45.1    PR529
PR530     PR560     PR82.1    UK102     TA147     TP135
HR00.1    HR01.1    PA115     PBIP.1    PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PXL-COMPANY            Numeric 4                                 BN150   HR11.1
Element: Company Hr    Identifies the AP company if the          HR11.2  HR511
                       resource type = V.  Identifies the HR     PA02.1  PA100
                       company if the resource type = E.  It is  PA102   PA13.1
                       blank for type A, P or Q resources.       PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.7  PR13.8
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR14.1
                                                                 PR15.2  PR205
                                                                 PR29.1  PR32.2
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR35.9
                                                                 PR36.1  PR45.1
                                                                 PR529   PR530
                                                                 PR560   PR82.1
                                                                 TA147   TP135
                                                                 UK102

PXL-EMPLOYEE           Numeric 9                                 BN150   HR11.1
Element: Employee      Contains the employee number. Each        HR11.2  HR511
                       person employed by the company is         PA02.1  PA100
                       assigned a unique number. The system      PA102   PA13.1
                       uses the employee number to correlate     PA13.2  PA502
                       all of the information related to that    PA513   PA52.1
                       person.                                   PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.7  PR13.8
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR14.1
                                                                 PR15.2  PR205
                                                                 PR29.1  PR32.2
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR35.9
                                                                 PR36.1  PR45.1
                                                                 PR529   PR530
                                                                 PR560   PR82.1
                                                                 TA147   TP135
                                                                 UK102

PXL-RECORD-TYPE        Alpha 1                                   BN150   HR11.1
Element: Record Type   This field identifies the type of         HR11.2  HR511
                       record defined.                           PA02.1  PA100
                                                                 PA102   PA13.1
                       Valid values are:                         PA13.2  PA502
                       S = Summary                               PA513   PA52.1
                       D = Detail                                PA52.3  PA52.4
                       " " = System                              PA52.5  PR110
                       U = User                                  PR113   PR120
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.7  PR13.8
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR14.1
                                                                 PR15.2  PR205
                                                                 PR29.1  PR32.2
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR35.9
                                                                 PR36.1  PR45.1
                                                                 PR529   PR530
                                                                 PR560   PR82.1
                                                                 TA147   TP135
                                                                 UK102

PXL-LOCAT-CODE         Alpha 10                                  BN150   HR11.1
Element: Location                                                HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.7  PR13.8
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR14.1
                                                                 PR15.2  PR205
                                                                 PR29.1  PR32.2
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR35.9
                                                                 PR36.1  PR45.1
                                                                 PR529   PR530
                                                                 PR560   PR82.1
                                                                 TA147   TP135
                                                                 UK102

PXL-DED-CODE           Alpha 4                                   BN150   HR11.1
Element: Deduction Code                                          HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.7  PR13.8
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR14.1
                                                                 PR15.2  PR205
                                                                 PR29.1  PR32.2
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR35.9
                                                                 PR36.1  PR45.1
                                                                 PR529   PR530
                                                                 PR560   PR82.1
                                                                 TA147   TP135
                                                                 UK102

PXL-ACTIVE-FLAG        Alpha 1                                   BN150   HR11.1
Element: Status        The Active flag of the credit card        HR11.2  HR511
                       type.                                     PA02.1  PA100
                       A = Active                                PA102   PA13.1
                       I = Inactive                              PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.7  PR13.8
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR14.1
                                                                 PR15.2  PR205
                                                                 PR29.1  PR32.2
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR35.9
                                                                 PR36.1  PR45.1
                                                                 PR529   PR530
                                                                 PR560   PR82.1
                                                                 TA147   TP135
                                                                 UK102

PXL-DATE-STAMP         Numeric 8  (yyyymmdd)                     BN150   HR11.1
Element: Date Stamp    This field contains the server date       HR11.2  HR511
                       (month, date, and year) of the last       PA02.1  PA100
                       change to this record.                    PA102   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.7  PR13.8
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR14.1
                                                                 PR15.2  PR205
                                                                 PR29.1  PR32.2
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR35.9
                                                                 PR36.1  PR45.1
                                                                 PR529   PR530
                                                                 PR560   PR82.1
                                                                 TA147   TP135
                                                                 UK102

PXL-TIME-STAMP         Numeric 6  (hhmmss)                       BN150   HR11.1
Element: Time Stamp    Contains the server time (hour, minute,   HR11.2  HR511
                       and second) when the record was last      PA02.1  PA100
                       changed.                                  PA102   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.7  PR13.8
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR14.1
                                                                 PR15.2  PR205
                                                                 PR29.1  PR32.2
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR35.9
                                                                 PR36.1  PR45.1
                                                                 PR529   PR530
                                                                 PR560   PR82.1
                                                                 TA147   TP135
                                                                 UK102

PXL-USER-ID            Alpha 10  (Lower Case)                    BN150   HR11.1
Element: User          Contains the user ID of the person who    HR11.2  HR511
                       last changed this record.                 PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.7  PR13.8
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR14.1
                                                                 PR15.2  PR205
                                                                 PR29.1  PR32.2
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR35.9
                                                                 PR36.1  PR45.1
                                                                 PR529   PR530
                                                                 PR560   PR82.1
                                                                 TA147   TP135
                                                                 UK102

                         PRTAXLOC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PXLSET1   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          LOCAT-CODE                                             BN104   BN105
          DED-CODE                                               BN145   BN150
                                                                 BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN45.1  BN531
                                                                 BN65.1  BN71.1
                                                                 BN72.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  HR00.1
                                                                 HR01.1  HR11.1
                                                                 HR11.2  HR211
                                                                 HR511   PA02.1
                                                                 ...

PXLSET2   COMPANY                                                HR04.9  PR113
          LOCAT-CODE                                             PR313
          EMPLOYEE
          DED-CODE

PXLSET3   COMPANY       Subset                                   BN150   HR11.1
          EMPLOYEE      Where ACTIVE-FLAG = "A"                  HR11.2  HR511
          LOCAT-CODE                                             PA02.1  PA100
          DED-CODE                                               PA102   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR29.1  PR32.2
                                                                 ...

                         PRTAXLOC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PXL-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

Deduction Code DEDCODE      Required

                            PXL-COMPANY       -> DDC-COMPANY
                            PXL-DED-CODE      -> DDC-DED-CODE

Emp Deduction  EMDEDMASTR   Required

                            PXL-COMPANY       -> EDM-COMPANY
                            PXL-EMPLOYEE      -> EDM-EMPLOYEE
                            PXL-DED-CODE      -> EDM-DED-CODE
                            Zeroes            -> EDM-SEQ-NBR

Employee       EMPLOYEE     Required

                            PXL-COMPANY       -> EMP-COMPANY
                            PXL-EMPLOYEE      -> EMP-EMPLOYEE

Location       PCODES       Required

                            "LO"              -> PCO-TYPE
                            PXL-LOCAT-CODE    -> PCO-CODE