Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBTIMEREC


                             PBTIMEREC FILE

UPDATED BY

AC541     AC542     BN150     BN66.1    PR128     PR130
PR131     PR132     PR134     PR136     PR137     PR140
PR189     PR195     PR197     PR29.1    PR32.1    PR32.2
PR33.1    PR33.2    PR33.3    PR35.1    PR35.2    PR35.3
PR35.4    PR35.5    PR35.6    PR35.8    PR36.1    PR37.1
PR45.1    PR529     PR530     PR560     PR80.1    PR82.1
PR85.1    PR89.1    UK102     UK330     UK560     TA147
UK120

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TPB-COMPANY            Numeric 4                                 AC541   AC542
Element: Company       The company number represents an          BN150   BN66.1
                       established company and is entered on     PR128   PR130
                       all function codes.                       PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR37.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 TA147   UK102
                                                                 UK120   UK330
                                                                 UK560

TPB-EMPLOYEE           Numeric 9                                 AC541   AC542
Element: Employee      Contains the employee number. Each        BN150   BN66.1
                       person employed by the company is         PR128   PR130
                       assigned a unique number. The system      PR131   PR132
                       uses the employee number to correlate     PR134   PR136
                       all of the information related to that    PR137   PR140
                       person.                                   PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR37.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 TA147   UK102
                                                                 UK120   UK330
                                                                 UK560

TPB-CHECK-ID           Numeric 12                                BN66.1  PR140
Internal Check ID      Contains the payment identification       PR189   PR195
Number                 number (unique payment identifier used    PR197   PR80.1
                       in tracking payment information).         PR85.1  PR89.1

TPB-PAY-SUM-GRP        Alpha 3                                   BN66.1  PR140
Payment Summary                                                  PR189   PR195
Group                                                            PR197   PR80.1
                                                                 PR85.1  PR89.1

TPB-TIME-SEQ           Numeric 12                                AC541   AC542
Element: Sequence Number                                         BN150   BN66.1
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR37.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 TA147   UK102
                                                                 UK120   UK330
                                                                 UK560

TPB-DED-GRP-AMT        Signed 15.2                               PR80.1  PR85.1
Element: Ded Grp Amt

TPB-DED-GRP-AMT-WC     Signed 15.2                               PR80.1  PR85.1
Element: Ded Grp Amt Wc

TPB-DED-GRP-AMT-SU     Signed 15.2
Element: Ded Grp Amt Su

TPB-PCT-RATE-1         Signed 8.5                                AC541   AC542
Element: Pct Rate 1                                              BN150   BN66.1
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR37.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 TA147   UK102
                                                                 UK120   UK330
                                                                 UK560

TPB-PCT-RATE-2         Signed 8.5                                AC541   AC542
Element: Pct Rate 2                                              BN150   BN66.1
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR37.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 TA147   UK102
                                                                 UK120   UK330
                                                                 UK560

TPB-AMT-RATE-1         Signed 6.2                                AC541   AC542
Element: Amt Rate 1                                              BN150   BN66.1
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR37.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 TA147   UK102
                                                                 UK120   UK330
                                                                 UK560

TPB-AMT-RATE-2         Signed 6.2                                AC541   AC542
Element: Amt Rate 2                                              BN150   BN66.1
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR37.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 TA147   UK102
                                                                 UK120   UK330
                                                                 UK560

TPB-GROSS-AMT-1        Signed 15.2                               AC541   AC542
Element: Gross Amt 1                                             BN150   BN66.1
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR37.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 TA147   UK102
                                                                 UK120   UK330
                                                                 UK560

TPB-GROSS-AMT-2        Signed 15.2                               AC541   AC542
Element: Gross Amt 2                                             BN150   BN66.1
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR37.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 TA147   UK102
                                                                 UK120   UK330
                                                                 UK560

TPB-CLIENT-JOBID       Alpha 20                                  AC541   AC542
Element: Client Jobid                                            BN150   BN66.1
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR37.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 TA147   UK102
                                                                 UK120   UK330
                                                                 UK560

TPB-TIME-USER-FLD      Alpha 20                                  AC541   AC542
Element: Time User Fld                                           BN150   BN66.1
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR37.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 TA147   UK102
                                                                 UK120   UK330
                                                                 UK560

TPB-UNITS-AMOUNT       Signed 15.2                               AC541   AC542
Element: Adj Amt       This is the units amount included in      BN150   BN66.1
                       the file.                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR37.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 TA147   UK102
                                                                 UK120   UK330
                                                                 UK560

TPB-UNIT-MEASURE       Alpha 12                                  AC541   AC542
Element: Unit Measure                                            BN150   BN66.1
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR37.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 TA147   UK102
                                                                 UK120   UK330
                                                                 UK560

TPB-RATE               Signed 13.4                               AC541   AC542
Element: Rate          Contains the percentage rate.             BN150   BN66.1
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR37.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 TA147   UK102
                                                                 UK120   UK330
                                                                 UK560

TPB-GROSS-CALC-AMT     Signed 15.2
Element: Gross Calc Amt

TPB-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

TPB-CURR-ND            Numeric 1
Account Currency
Code

TPB-CHECK-TYPE         Alpha 1
Element: Payment Type  Contains the payment type.

                         PBTIMEREC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TPBSET1   COMPANY                                                AC541   AC542
          EMPLOYEE                                               BN150   BN66.1
          TIME-SEQ                                               PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR37.1
                                                                 ...

TPBSET2   COMPANY
          EMPLOYEE
          CHECK-ID
          PAY-SUM-GRP
          TIME-SEQ

                         PBTIMEREC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Timerecord     TIMERECORD   Required

                            TPB-COMPANY         -> TRD-COMPANY  (TRDSET1)
                            TPB-EMPLOYEE        -> TRD-EMPLOYEE
                            TPB-TIME-SEQ        -> TRD-TIME-SEQ