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

Field / columnTypeDescription & valuesUpdated by
#CDR-RUN-GROUP PK
RUN_GROUP		Alpha 15Run 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 6A unique number assigned to each record to be interfaced into the Lawson system.CA60.1
#CDR-ALLOC-CODE SET2 SET3
ALLOC_CODE		Alpha 12The allocation code name as defined by CA05 (Allocation Codes).CA60.1
#CDR-OLD-COMPANY SET2 SET3
OLD_COMPANY		Alpha 35The old company structure associated with the Lawson Company/Accounting Unit.CA60.1
#CDR-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.CA60.1

Indexes (3)

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
CDRSET1
  1. RUN-GROUP
  2. SEQ-NUMBER
PrimaryCA160, CA60.1
CDRSET2
  1. ALLOC-CODE
  2. OLD-COMPANY
  3. RUN-GROUP
  4. SEQ-NUMBER
KeyChangeCA160
CDRSET3
  1. RUN-GROUP
  2. ALLOC-CODE
  3. OLD-COMPANY
  4. SEQ-NUMBER
KeyChangeCA160, CA260

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
Old CompanyGLCOMPRELRequired
CDR-OLD-COMPANY→GCR-OLD-COMPANY

Programs

Updated by (2)

Referenced by (1)