CACODEREL – Allocation Code Interface

System: General Ledger (GL)
Prefix: CDR
Primary key: RUN-GROUP, SEQ-NUMBER
Fields: 5
Updated by: 2 programs
Referenced by: 1 program

CACODEREL is the Allocation Code Interface table in Lawson General Ledger (prefix CDR). It is indexed by RUN-GROUP, SEQ-NUMBER (CDRSET1); alternate indexes: CDRSET2 and CDRSET3. It is related 1:1 to GLCOMPREL. It is updated by CA160 and CA60.1 and referenced by CA260. The table has 5 fields, 3 indexes and 1 documented relation.

About CACODEREL

This file contains the non-Lawson allocation code interface records.

Fields (5)

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

Field / column	Type	Description & values	Updated by
`CDR-RUN-GROUP` PK RUN_GROUP	Alpha 15	Run Group and Seq Number are the keys to the file. They should be used to group records together for interfacing.	CA60.1
`CDR-SEQ-NUMBER` PK SEQ_NUMBER	Numeric 6	A unique number assigned to each record to be interfaced into the Lawson system.	CA60.1
`CDR-ALLOC-CODE` ALLOC_CODE	Alpha 12	The allocation code name as defined by CA05 (Allocation Codes).	CA60.1
`CDR-OLD-COMPANY` OLD_COMPANY	Alpha 35	The old company structure associated with the Lawson Company/Accounting Unit.	CA60.1
`CDR-VALUE` VALUE	Numeric 13	The value determines the percentage allocated to the company and accounting unit. The percentage is calculated by dividing the line value by the total value.	CA60.1

Indexes (3)

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

Index	Keys	Flags	Used in
`CDRSET1`	`RUN-GROUP`, `SEQ-NUMBER`	Primary	CA160, CA60.1
`CDRSET2`	`ALLOC-CODE`, `OLD-COMPANY`, `RUN-GROUP`, `SEQ-NUMBER`	KeyChange	CA160
`CDRSET3`	`RUN-GROUP`, `ALLOC-CODE`, `OLD-COMPANY`, `SEQ-NUMBER`	KeyChange	CA160, CA260

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Old Company	GLCOMPREL	Required		`CDR-OLD-COMPANY` → `GCR-OLD-COMPANY`

CACODEREL – Allocation Code Interface

About CACODEREL

Fields (5)

Indexes (3)

Relations

One to one (1) — lookups and parents

Programs

Updated by (2)

Referenced by (1)