ACHEADER – Cost Allocation Header

System
General Ledger (GL)
Prefix
ALH
Primary key
ALLOC-CODE
Fields
4
Updated by
3 programs
Referenced by
67 programs

ACHEADER is the Cost Allocation Header table in Lawson General Ledger (prefix ALH). It is indexed by ALLOC-CODE (ALHSET1). It is related 1:1 to GLSYSTEM and 1:M to ACDETAIL and ACHEADERAU. It is updated by CA05.1, CA05.2 and CA160 and referenced by AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 59 more. The table has 4 fields, 1 index and 3 documented relations.

About ACHEADER

This file contains the allocation code header information.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
ALH-ALLOC-CODE PK
ALLOC_CODE		Alpha 12The allocation code name as defined in CA05.1 (Allocation Code).CA05.1, CA05.2, CA160
ALH-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description of the allocation code.CA05.2, CA160
ALH-TOTAL-VALUES
TOTAL_VALUES		Numeric 13The total of all the values entered on the detail lines.CA05.1, CA160
ALH-COMPANY
COMPANY		Numeric 4The company number assigned to an allocation code. The field is derived from the detail line company. If more than one company is represented in the detail, the value will not be populated.CA05.1, CA160

Indexes (1)

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

IndexKeysFlagsConditionUsed in
ALHSET1ALLOC-CODEPrimaryAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CompanyGLSYSTEMNot RequiredALH-COMPANY → GLS-COMPANY

One to many (2) — child tables

RelationTableRulesConditionField map
AcdetailACDETAILDelete CascadesALH-ALLOC-CODE → ALD-ALLOC-CODE, → ALD-COMPANY, → ALD-ACCT-UNIT
AcheaderauACHEADERAUALH-ALLOC-CODE → AHA-ALLOC-CODE, → AHA-ACTION, → AHA-DATE, → AHA-TIME, → AHA-UNIQUE-I-D

Programs

Updated by (3)

Referenced by (67)