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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ALHSET1
  1. ALLOC-CODE
PrimaryAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLSYSTEMACDETAILACHEADERAUACHEADER

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CompanyGLSYSTEMNot Required
ALH-COMPANY→GLS-COMPANY

One to many (2) — child tables

RelationTableRulesConditionField map
AcdetailACDETAILDelete Cascades
ALH-ALLOC-CODE→ALD-ALLOC-CODE
—→ALD-COMPANY
—→ALD-ACCT-UNIT
AcheaderauACHEADERAU
ALH-ALLOC-CODE→AHA-ALLOC-CODE
—→AHA-ACTION
—→AHA-DATE
—→AHA-TIME
—→AHA-UNIQUE-I-D

Programs

Updated by (3)

Referenced by (67)