Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PROTACCTS FILE

This file contains expense accounts for premium portions of pay by job codes.
It is assigned to the pay code file.

REFERENCED BY

AC542     PR195     PR197     PR220     PR82.1    PR85.1

UPDATED BY

PR20.7

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

OTA-COMPANY          Numeric 4                                   PR20.7
Company              The company number represents an
                     established company and is entered on
                     all function codes.


OTA-PROCESS-LEVEL    Alpha 5                                     PR20.7
Process Level        This field contains the process level,
                     which is the reporting hierarchy below
                     company.


OTA-JOB-CODE         Alpha 9                                     PR20.7
Job Code             Contains a user-defined code that
                     represents a type of job.

OTA-PAY-CODE         Alpha 4                                     PR20.7
Payment Code         Contains the pay code. A pay code is a
                     user-defined code that identifies a kind
                     of pay.


OTA-OT-JOB-CODE      Alpha 9                                     PR20.7
Ot Job Code          Contains the job code for which
                     overtime expensing is being defined.

OTA-OT-ACCOUNT       Numeric 6                                   PR20.7
Ot Account           Contains the expense account to which
                     overtime premium expenses for this job
                     code/pay code should be posted.

OTA-OT-SUB-ACCT      Numeric 4                                   PR20.7
Ot Sub Acct          Contains the subaccount to which
                     overtime premium expenses for this job
                     code/pay code should be posted.

                         PROTACCTS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OTASET1   COMPANY                                                AC542   PR195
          PROCESS-LEVEL                                          PR197   PR20.4
          JOB-CODE                                               PR20.7  PR220
          PAY-CODE                                               PR82.1  PR85.1
          OT-JOB-CODE

                         PROTACCTS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            OTA-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Jobcode        JOBCODE      Required

                            OTA-COMPANY          -> JBC-COMPANY
                            OTA-JOB-CODE         -> JBC-JOB-CODE

Paycode        PRPAYCODE    Required

                            OTA-COMPANY          -> PCD-COMPANY
                            OTA-PROCESS-LEVEL    -> PCD-PROCESS-LEVEL
                            OTA-JOB-CODE         -> PCD-JOB-CODE
                            OTA-PAY-CODE         -> PCD-PAY-CODE

Process Level  PRSYSTEM     Required

                            OTA-COMPANY          -> PRS-COMPANY
                            OTA-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL