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.

Field / columnTypeDescription & valuesUpdated by
PLC-COMPANY PK
COMPANY
Numeric 4Contains the number that represents an established company.TA05.1
PLC-PLAN-CLASS PK
PLAN_CLASS
Alpha 3Contains the plan class name.TA05.1
PLC-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)Contains the plan class description.TA05.1
PLC-PRINT-FLAG
PRINT_FLAG
Alpha 1Contains the value that indicates whether balances in the plan class print on payments.
  • N No, do not print.
  • Y Yes, print on check stub.
TA05.1
PLC-CHECK-DESC
CHECK_DESC
Alpha 8 (Lower Case)Contains the description that prints on payments.TA05.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PLCSET1COMPANY, PLAN-CLASSPrimaryHPLC.1, TA05.1, TA20.1, TA205, TA220, TA40.1

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredPLC-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL

One to many (1) — child tables

RelationTableRulesConditionField map
PlansPLANMASTERDelete RestrictedPLC-COMPANYPLM-COMPANY, PLC-PLAN-CLASSPLM-PLAN-CLASS, PLM-PLAN-NAME

Programs

Updated by (1)

Referenced by (5)