ACTRLIMIT – Accrual Transaction Limit

System
Event Management (TA)
Prefix
ATL
Primary key
COMPANY, PLAN-NAME, LIMIT-TYPE, THRU-LIM-CYC
Fields
5
Updated by
4 programs
Referenced by
2 programs

ACTRLIMIT is the Accrual Transaction Limit table in Lawson Event Management (prefix ATL). It is indexed by COMPANY, PLAN-NAME, LIMIT-TYPE, THRU-LIM-CYC (ATLSET1). It is related 1:1 to PRSYSTEM and PLANMASTER. It is updated by TA20.1, TA20.3, TA20.5 and TA40.1 and referenced by TA220 and ZH230. The table has 5 fields, 1 index and 2 documented relations.

About ACTRLIMIT

The Accrual Transaction Limit file is used with the Time Accrual Plan file to establish accrual and eligible hours limits.

Fields (5)

Column = COBOL field name without the ATL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ATL-COMPANY PK
COMPANY
Numeric 4Contains the number that represents an established company.TA20.3, TA20.5, TA40.1
ATL-PLAN-NAME PK
PLAN_NAME
Alpha 10Contains the plan name. This is verified in the Time Accrual Plan file.TA20.3, TA20.5, TA40.1
ATL-LIMIT-TYPE PK
LIMIT_TYPE
Alpha 1Contains accrual and eligible limit types.
  • A Accrual
  • E Eligibile
TA20.3, TA20.5, TA40.1
ATL-THRU-LIM-CYC PK
THRU_LIM_CYC
Numeric 7Contains the last limit cycle for which the accrual limit is effective.TA20.3, TA20.5
ATL-MAX-BALANCE
MAX_BALANCE
Signed 9.4Contains the maximum number of hours employees can have in their accrual balance during the limit cycle.TA20.3, TA20.5, TA40.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
ATLSET1COMPANY, PLAN-NAME, LIMIT-TYPE, THRU-LIM-CYCPrimaryZH230, TA20.1, TA20.3, TA20.5, TA220, TA40.1

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredATL-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL
Plan NamePLANMASTERRequiredATL-COMPANYPLM-COMPANY, ATL-PLAN-NAMEPLM-PLAN-NAME

Programs

Updated by (4)

Referenced by (2)