ACGLCODE FILE
Activity GL Codes
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.
REFERENCED BY
AC00.1 AC10.3 AC160 AC190 AC198 AC204
AC542 AC58.1 AC60.1 AC60.2 BR01.2 BR02.1
BR10.1 BR10.3 BR12.1 BR41.1 BRIP.1 PR197
UPDATED BY
AC04.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AGC-AC-GL-CODE Alpha 4 AC04.1
Activity GL Code Required key. This is the GL code,
identifying a general ledger account,
for posting to the General Ledger
system.
AGC-DESCRIPTION Alpha 30 (Lower Case) AC04.1
GL Code Description This is the description of the GL code.
AGC-COMPANY Numeric 4 AC04.1
Company Required. This is the responsible
company for the activity and GL code.
AGC-ACCT-UNIT Alpha 15 AC04.1
Accounting Unit Required. This is the accounting unit
identified by the GL code. The
accounting unit must have been defined
already in the General Ledger system.
AGC-ACCOUNT Numeric 6 AC04.1
Account Required. This is the account
identified by the GL code. The account
must have been defined already in the
General Ledger system.
AGC-SUB-ACCT Numeric 4 AC04.1
Subaccount This is the subaccount identified by
the GL code. The subaccount must have
been defined already in the General
Ledger system.
AGC-ACTIVE-FLAG Alpha 1 AC04.1
Active Flag This flag indicates whether the GL code
is active.
A = Active
I = Inactive
ACGLCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AGCSET1 AC-GL-CODE AC00.1 AC04.1
AC10.3 AC160
AC190 AC198
AC204 AC542
AC58.1 AC60.1
AC60.2 BR01.2
BR02.1 BR10.1
BR10.3 BR12.1
BR41.1 BRIP.1
PR197
AGCSET2 COMPANY KeyChange
ACCT-UNIT
ACCOUNT
SUB-ACCT
AC-GL-CODE
ACGLCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glnames GLNAMES Required
AGC-COMPANY -> GLN-COMPANY (GLNSET1)
AGC-ACCT-UNIT -> GLN-ACCT-UNIT
Glsystem GLSYSTEM Required
AGC-COMPANY -> GLS-COMPANY
ACGLCODE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glmaster GLMASTER
AGC-COMPANY -> GLM-COMPANY
AGC-ACCOUNT -> GLM-ACCOUNT
AGC-SUB-ACCT -> GLM-SUB-ACCOUNT
GLM-VAR-LEVELS
GLM-ACCT-UNIT
|
