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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ALDSET1ALLOC-CODE, COMPANY, ACCT-UNITPrimaryAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
AccountunitGLNAMESRequiredALD-COMPANY → GLN-COMPANY, ALD-ACCT-UNIT → GLN-ACCT-UNIT
Acct UnitGLNAMESRequiredALD-COMPANY → GLN-COMPANY, ALD-ACCT-UNIT → GLN-ACCT-UNIT
AcheaderACHEADERRequiredALD-ALLOC-CODE → ALH-ALLOC-CODE
CompanyGLSYSTEMRequiredALD-COMPANY → GLS-COMPANY
HeaderACHEADERRequiredALD-ALLOC-CODE → ALH-ALLOC-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
AcdetailauACDETAILAUALD-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)