PRPROVINCE – This file contains province codes and descriptions.
- System
- Payroll (PR)
- Prefix
PPV- Primary key
PROVINCE- Fields
- 2
- Updated by
- 0 programs
- Referenced by
- 0 programs
PRPROVINCE is the This file contains province codes and descriptions. table in Lawson Payroll (prefix PPV). It is indexed by PROVINCE (PPVSET1). The table has 2 fields, 1 index and 0 documented relations.
About PRPROVINCE
This file contains province codes and descriptions.
Fields (2)
Column = COBOL field name without the PPV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PPV-PROVINCE PKPROVINCE | Alpha 2 | Contains the two letter province code. | — |
PPV-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | — |
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 |
|---|---|---|---|---|
PPVSET1 | PROVINCE | Primary | BN150, BN305, BN47.1, BN547, BN70.1, HPPV.1, HR04.9, HR06.4 +22 more (list truncated in source) |
Programs
No Lawson programs are documented as updating or referencing this table.