ACDETAIL – Cost Allocation Detail

System
General Ledger (GL)
Prefix
ALD
Primary key
ALLOC-CODE, COMPANY, ACCT-UNIT
Fields
5
Updated by
3 programs
Referenced by
67 programs

ACDETAIL is the Cost Allocation Detail table in Lawson General Ledger (prefix ALD). It is indexed by ALLOC-CODE, COMPANY, ACCT-UNIT (ALDSET1). It is related 1:1 to GLNAMES, ACHEADER and GLSYSTEM and 1:M to ACDETAILAU. 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 5 fields, 1 index and 6 documented relations.

About ACDETAIL

This file contains the allocation code detail information.

Fields (5)

Column = COBOL field name without the ALD- 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
#ALD-ALLOC-CODE PK
ALLOC_CODE		Alpha 12The allocation code name as defined in CA05.1 (Allocation Code).CA05.1, CA160
#ALD-COMPANY PK
COMPANY		Numeric 4The General Ledger company number for which the allocation code is defined.CA05.1, CA160
#ALD-ACCT-UNIT PK
ACCT_UNIT		Alpha 15The Post To accounting unit.CA05.1, CA160
#ALD-VALUE
VALUE		Numeric 13The value determines the percentage allocated to the company and accounting unit. The percentage is calculated by dividing the line value by the total value.CA05.1, CA160
#ALD-VALUE-PERCENT
VALUE_PERCENT		DerivedThe percentage of the allocated amount that is allocated to the company and accounting unit.—

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
ALDSET1
  1. ALLOC-CODE
  2. COMPANY
  3. ACCT-UNIT
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)
GLNAMESACHEADERGLSYSTEMACDETAILAUACDETAIL

One to one (5) — lookups and parents

RelationTableRulesConditionField map
AccountunitGLNAMESRequired
ALD-COMPANY→GLN-COMPANY
ALD-ACCT-UNIT→GLN-ACCT-UNIT
Acct UnitGLNAMESRequired
ALD-COMPANY→GLN-COMPANY
ALD-ACCT-UNIT→GLN-ACCT-UNIT
AcheaderACHEADERRequired
ALD-ALLOC-CODE→ALH-ALLOC-CODE
CompanyGLSYSTEMRequired
ALD-COMPANY→GLS-COMPANY
HeaderACHEADERRequired
ALD-ALLOC-CODE→ALH-ALLOC-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
AcdetailauACDETAILAU
ALD-ALLOC-CODE→ALU-ALLOC-CODE
ALD-COMPANY→ALU-COMPANY
ALD-ACCT-UNIT→ALU-ACCT-UNIT
—→ALU-ACTION
—→ALU-DATE
—→ALU-TIME
—→ALU-UNIQUE-I-D

Programs

Updated by (3)

Referenced by (67)