PRONWAGES – No description in the Lawson data dictionary
- System
- Payroll (PR)
- Prefix
POW- Primary key
COMPANY,DED-CODE,PROCESS-LEVEL,BUS-NBR-GRP,EFFECT-DATE- Fields
- 7
- Updated by
- 2 programs
- Referenced by
- 9 programs
PRONWAGES is a Lawson Payroll table (prefix POW); no description in the lawson data dictionary. It is indexed by COMPANY, DED-CODE, PROCESS-LEVEL, BUS-NBR-GRP, EFFECT-DATE (POWSET1). It is updated by PR05.4 and PR125 and referenced by BN66.1, PR140, PR189, PR195, PR205, PR80.1, PR80.4, PR89.1 and 1 more. The table has 7 fields, 1 index and 0 documented relations.
About PRONWAGES
No description in the Lawson data dictionary.
Fields (7)
Column = COBOL field name without the POW- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
POW-COMPANY PKCOMPANY | Numeric 4 | — | PR05.4, PR125 |
POW-DED-CODE PKDED_CODE | Alpha 4 | — | PR05.4, PR125 |
POW-PROCESS-LEVEL PKPROCESS_LEVEL | Alpha 5 | — | PR05.4, PR125 |
POW-BUS-NBR-GRP PKBUS_NBR_GRP | Alpha 4 | — | PR05.4, PR125 |
POW-EFFECT-DATE PKEFFECT_DATE | Numeric 8 (yyyymmdd) | — | PR05.4, PR125 |
POW-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | The end date for this effort period. | PR05.4, PR125 |
POW-PAYROLL-WAGESPAYROLL_WAGES | Signed 13.2 | — | PR05.4, PR125 |
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 |
|---|---|---|---|---|
POWSET1 | COMPANY, DED-CODE, PROCESS-LEVEL, BUS-NBR-GRP, EFFECT-DATE* | Primary | BN66.1, PR05.1, PR05.4, PR125, PR140, PR189, PR195, PR205 +4 more |