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    BN66.1    BN71.1
BN72.1    BS13.1    BS14.1    BS15.1    BS32.1    ETI1.1
HR211     PR140     PR195     PR26.1    PR26.2    PR39.1
PR39.2    PR47.1    PR47.2    PR514     PR539     PR89.1
UK47.1    UK47.2    HR04.9

UPDATED BY

BN150     BN305     ET530     ETI2.1    HR11.1    HR11.2
HR511     LP130     PA02.1    PA100     PA102     PA115
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
PR189     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     PR80.1    PR82.1    UK102     UK560
TA147     HR00.1    HR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PXL-COMPANY            Numeric 4                                 BN150   BN305
Element: Company Hr                                              ET530   ETI2.1
                                                                 HR11.1  HR11.2
                                                                 HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 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
                                                                 PR189   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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PXL-EMPLOYEE           Numeric 9                                 BN150   BN305
Element: Employee      Contains the employee number. Each        ET530   ETI2.1
                       person employed by the company is         HR11.1  HR11.2
                       assigned a unique number. The system      HR511   LP130
                       uses the employee number to correlate     PA02.1  PA100
                       all of the information related to that    PA102   PA115
                       person.                                   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
                                                                 PR189   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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PXL-RECORD-TYPE        Alpha 1                                   BN150   BN305
Element: Record Type   This field identifies the type of         ET530   ETI2.1
                       record defined.                           HR11.1  HR11.2
                                                                 HR511   LP130
                       Valid values are:                         PA02.1  PA100
                       S = Summary                               PA102   PA115
                       D = Detail                                PA13.1  PA13.2
                       " " = System                              PA502   PA513
                       U = User                                  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
                                                                 PR189   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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PXL-LOCAT-CODE         Alpha 10                                  BN150   BN305
Element: Locat Code                                              ET530   ETI2.1
                                                                 HR11.1  HR11.2
                                                                 HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 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
                                                                 PR189   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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PXL-DED-CODE           Alpha 4                                   BN150   BN305
Element: Ded Code                                                ET530   ETI2.1
                                                                 HR11.1  HR11.2
                                                                 HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 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
                                                                 PR189   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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PXL-ACTIVE-FLAG        Alpha 1                                   BN150   BN305
Element: Active Flag   The Active flag of the credit card        ET530   ETI2.1
                       type.                                     HR11.1  HR11.2
                       A = Active                                HR511   LP130
                       I = Inactive                              PA02.1  PA100
                                                                 PA102   PA115
                                                                 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
                                                                 PR189   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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PXL-DATE-STAMP         Numeric 8  (yyyymmdd)                     BN150   BN305
Element: Date Stamp    This field contains the server date       ET530   ETI2.1
                       (month, date, and year) of the last       HR11.1  HR11.2
                       change to this record.                    HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 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
                                                                 PR189   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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PXL-TIME-STAMP         Numeric 6  (hhmmss)                       BN150   BN305
Element: Time Stamp    Contains the server time (hour, minute,   ET530   ETI2.1
                       and second) when the record was last      HR11.1  HR11.2
                       changed.                                  HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 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
                                                                 PR189   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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PXL-USER-ID            Alpha 10  (Lower Case)                    BN150   BN305
Element: User                                                    ET530   ETI2.1
                                                                 HR11.1  HR11.2
                                                                 HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 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
                                                                 PR189   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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

                         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   BN305
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BN65.1
                                                                 BN66.1  BN71.1
                                                                 BN72.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  ET530
                                                                 ETI1.1  ETI2.1
                                                                 HR00.1  HR01.1
                                                                 ...

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

PXLSET3   COMPANY       Subset                                   BN150   BN305
          EMPLOYEE      Where ACTIVE-FLAG = "A"                  ET530   ETI2.1
          LOCAT-CODE                                             HR11.1  HR11.2
          DED-CODE                                               HR511   LP130
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 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
                                                                 ...

                         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