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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
OTASET1 |
| 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 |
| |||||||||||||
| Jobcode | JOBCODE | Required |
| |||||||||||||
| Paycode | PRPAYCODE | Required |
| |||||||||||||
| Process Level | PRSYSTEM | Required |
|
Programs
Updated by (1)
- PR20.7 Overtime Premium Expense Table