Lawson Insight Technical Documentation | 
  
    
  | 
  
                              UKNITP FILE
REFERENCED BY
ET530     PR139     PR160     PR180     PR197     PR85.1
UK141     UK145     UK201     UK202     UK50.3
UPDATED BY
BN66.1    PR140     PR189     PR195     PR300     PR80.1
PR82.1    PR82.3    PR89.1    UK560
FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY
UKI-COMPANY            Numeric 4                                 BN66.1  PR140
Element: Company Hr                                              PR189   PR195
                                                                 PR80.1  PR82.1
                                                                 PR89.1  UK560
UKI-EMPLOYEE           Numeric 9                                 BN66.1  PR140
Element: Employee      Contains the employee number. Each        PR189   PR195
                       person employed by the company is         PR80.1  PR82.1
                       assigned a unique number. The system      PR89.1  UK560
                       uses the employee number to correlate
                       all of the information related to that
                       person.
UKI-CHECK-ID           Numeric 12                                BN66.1  PR140
Element: Check Id      Contains the payment identification       PR189   PR195
                       number (unique payment identifier used    PR80.1  PR82.1
                       in tracking payment information).         PR89.1  UK560
UKI-REPORT-ENTITY      Alpha 5                                   BN66.1  PR140
Element: Report Entity                                           PR189   PR195
                                                                 PR80.1  PR82.1
                                                                 PR89.1
UKI-PROCESS-LEVEL      Alpha 5                                   BN66.1  PR140
Element: Process Lev Hr                                          PR189   PR195
                                                                 PR80.1  PR89.1
UKI-WAGE-TO-LEL        Signed 7.2                                BN66.1  PR140
Element: Wage To Lel                                             PR189   PR195
                                                                 PR80.1  PR82.3
                                                                 PR89.1  UK560
UKI-WAGE-TO-ET         Signed 7.2                                BN66.1  PR140
Element: Wage To Et                                              PR189   PR195
                                                                 PR80.1  PR82.3
                                                                 PR89.1  UK560
UKI-WAGE-TO-UEL        Signed 7.2                                BN66.1  PR140
Element: Wage To Uel                                             PR189   PR195
                                                                 PR80.1  PR82.3
                                                                 PR89.1  UK560
UKI-EENI-REBATE        Signed 7.2                                BN66.1  PR140
Element: Eeni Rebate                                             PR189   PR195
                                                                 PR80.1  PR82.3
                                                                 PR89.1  UK560
UKI-ERNI-REBATE        Signed 7.2                                BN66.1  PR140
Element: Erni Rebate                                             PR189   PR195
                                                                 PR80.1  PR82.3
                                                                 PR89.1  UK560
                         UKNITP FILE INDEX
NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN
UKISET1   COMPANY                                                BN66.1  ET530
          EMPLOYEE                                               PR139   PR140
          CHECK-ID                                               PR160   PR180
          REPORT-ENTITY                                          PR189   PR195
                                                                 PR197   PR300
                                                                 PR80.1  PR80.2
                                                                 PR82.1  PR82.3
                                                                 PR85.1  PR89.1
                                                                 UK141   UK145
                                                                 UK201   UK202
                                                                 UK50.3  UK560
                         UKNITP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH
Employee       EMPLOYEE     Required
                            UKI-COMPANY     -> EMP-COMPANY
                            UKI-EMPLOYEE    -> EMP-EMPLOYEE
 |