|
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
AC541 AC542 AC58.1 AC60.1 AC60.2 BR01.2
BR10.1 BR10.3 BR12.1 BR120 BR124 BR130
BR131 BR151 BR153 BR154 BR155 BR21.1
BR251 BR47.1 BR47.2 BR50.2 BR51.1 BR51.2
BR52.1 BR521 BR530 BRIP.1 BRPI.1 PR197
UPDATED BY
AC04.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AGC-AC-GL-CODE Alpha 4 AC04.1
Element: Activity GL CoRequired 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
Element: GL Code DescriThis is the description of the GL code.
AGC-COMPANY Numeric 4 AC04.1
Element: Company Required. This is the responsible
company for the activity and GL code.
AGC-ACCT-UNIT Alpha 15 AC04.1
Element: Accounting UniRequired. 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
Element: 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
Element: 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
Element: 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 AC541
AC542 AC58.1
AC60.1 AC60.2
BR01.2 BR10.1
BR10.3 BR12.1
BR120 BR124
BR130 BR131
BR151 BR153
BR154 BR155
BR21.1 BR251
BR47.1 BR47.2
BR50.2 BR51.1
...
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
|