PROTACCTS – This file contains expense accounts for premium portions of pay by job codes.
- System
- Payroll (PR)
- Prefix
OTA- Primary key
COMPANY,PROCESS-LEVEL,JOB-CODE,PAY-CODE,OT-JOB-CODE- Fields
- 7
- Updated by
- 1 program
- Referenced by
- 6 programs
PROTACCTS is the This file contains expense accounts for premium portions of pay by job codes. table in Lawson Payroll (prefix OTA). It is indexed by COMPANY, PROCESS-LEVEL, JOB-CODE, PAY-CODE, OT-JOB-CODE (OTASET1). It is related 1:1 to PRSYSTEM, JOBCODE and PRPAYCODE. It is updated by PR20.7 and referenced by PR195, PR197, PR220, PR582, PR82.1 and PR85.1. The table has 7 fields, 1 index and 4 documented relations.
About PROTACCTS
This file contains expense accounts for premium portions of pay by job codes. It is assigned to the pay code file.
Fields (7)
Column = COBOL field name without the OTA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
OTA-COMPANY PKCOMPANY | Numeric 4 | — | PR20.7 |
OTA-PROCESS-LEVEL PKPROCESS_LEVEL | Alpha 5 | — | PR20.7 |
OTA-JOB-CODE PKJOB_CODE | Alpha 9 | Contains a user-defined code that represents a type of job. | PR20.7 |
OTA-PAY-CODE PKPAY_CODE | Alpha 4 | Contains the pay code. A pay code is a user-defined code that identifies a kind of pay. | PR20.7 |
OTA-OT-JOB-CODE PKOT_JOB_CODE | Alpha 9 | Contains the job code for which overtime expensing is being defined. | PR20.7 |
OTA-OT-ACCOUNTOT_ACCOUNT | Numeric 6 | Contains the expense account to which overtime premium expenses for this job code/pay code should be posted. | PR20.7 |
OTA-OT-SUB-ACCTOT_SUB_ACCT | Numeric 4 | Contains the subaccount to which overtime premium expenses for this job code/pay code should be posted. | PR20.7 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
OTASET1 | COMPANY, PROCESS-LEVEL, JOB-CODE, PAY-CODE, OT-JOB-CODE | Primary | PR195, PR197, PR20.4, PR20.7, PR220, PR582, PR82.1, PR85.1 |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
Programs
Updated by (1)
- PR20.7 Overtime Premium Expense Table