Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PROTACCTS


                             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
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

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

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

OTA-PAY-CODE           Alpha 4                                   PR20.7
Element: 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
Element: Ot Job Code   Contains the job code for which
                       overtime expensing is being defined.

OTA-OT-ACCOUNT         Numeric 6                                 PR20.7
Element: 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
Element: 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