PLANCLASS – Plan Class
- System
- Event Management (TA)
- Prefix
PLC- Primary key
COMPANY,PLAN-CLASS- Fields
- 5
- Updated by
- 1 program
- Referenced by
- 5 programs
PLANCLASS is the Plan Class table in Lawson Event Management (prefix PLC). It is indexed by COMPANY, PLAN-CLASS (PLCSET1). It is related 1:1 to PRSYSTEM and 1:M to PLANMASTER. It is updated by TA05.1 and referenced by HPLC.1, TA20.1, TA205, TA220 and TA40.1. The table has 5 fields, 1 index and 2 documented relations.
About PLANCLASS
The Plan Class file is used to group plans for printing on payments. If a plan class prints on a payment, the payment shows all plans in the plan class and the plan class description.
Fields (5)
Column = COBOL field name without the PLC- 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 |
|---|---|---|---|
#PLC-COMPANY PKCOMPANY | Numeric 4 | Contains the number that represents an established company. | TA05.1 |
#PLC-PLAN-CLASS PKPLAN_CLASS | Alpha 3 | Contains the plan class name. | TA05.1 |
#PLC-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | Contains the plan class description. | TA05.1 |
#PLC-PRINT-FLAGPRINT_FLAG | Alpha 1 | Contains the value that indicates whether balances in the plan class print on payments.
| TA05.1 |
#PLC-CHECK-DESCCHECK_DESC | Alpha 8 (Lower Case) | Contains the description that prints on payments. | TA05.1 |
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 |
|---|---|---|---|---|
PLCSET1 |
| Primary | HPLC.1, TA05.1, TA20.1, TA205, TA220, TA40.1 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Company | PRSYSTEM | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Plans | PLANMASTER | Delete Restricted |
|
Programs
Updated by (1)
- TA05.1 Plan Class