ACGLCODE – Activity GL Codes

System
Activity Management (AC)
Prefix
AGC
Primary key
AC-GL-CODE
Fields
7
Updated by
1 program
Referenced by
40 programs

ACGLCODE is the Activity GL Codes table in Lawson Activity Management (prefix AGC). It is indexed by AC-GL-CODE (AGCSET1); alternate indexes: AGCSET2. It is related 1:1 to GLNAMES and GLSYSTEM and 1:M to GLMASTER. It is updated by AC04.1 and referenced by AC00.1, AC10.3, AC160, AC190, AC197, AC198, AC204, AC56.1 and 32 more. The table has 7 fields, 2 indexes and 3 documented relations.

About ACGLCODE

This file contains information on Activity general ledger (GL) codes from AC04.1 (GL Code). It includes GL code and description, responsible company, accounting unit, account, subaccount, and active flag.

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
AGC-AC-GL-CODE PK
AC_GL_CODE		Alpha 4Required key. This is the GL code, identifying a general ledger account, for posting to the General Ledger system.AC04.1
AGC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is the description of the GL code.AC04.1
AGC-COMPANY
COMPANY		Numeric 4Required. This is the responsible company for the activity and GL code.AC04.1
AGC-ACCT-UNIT
ACCT_UNIT		Alpha 15Required. This is the accounting unit identified by the GL code. The accounting unit must have been defined already in the General Ledger system.AC04.1
AGC-ACCOUNT
ACCOUNT		Numeric 6Required. This is the account identified by the GL code. The account must have been defined already in the General Ledger system.AC04.1
AGC-SUB-ACCT
SUB_ACCT		Numeric 4This is the subaccount identified by the GL code. The subaccount must have been defined already in the General Ledger system.AC04.1
AGC-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1This flag indicates whether the GL code is active.
  • A Active
  • I Inactive
AC04.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
AGCSET1AC-GL-CODEPrimaryAC00.1, AC04.1, AC10.3, AC160, AC190, AC197, AC198, AC204 +22 more (list truncated in source)
AGCSET2COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCT, AC-GL-CODEKeyChange—

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
GlnamesGLNAMESRequiredAGC-COMPANY → GLN-COMPANY (GLNSET1), AGC-ACCT-UNIT → GLN-ACCT-UNIT
GlsystemGLSYSTEMRequiredAGC-COMPANY → GLS-COMPANY

One to many (1) — child tables

RelationTableRulesConditionField map
GlmasterGLMASTERAGC-COMPANY → GLM-COMPANY, AGC-ACCOUNT → GLM-ACCOUNT, AGC-SUB-ACCT → GLM-SUB-ACCOUNT, → GLM-VAR-LEVELS, → GLM-ACCT-UNIT

Programs

Updated by (1)

Referenced by (40)