|
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 AC197 AC198
AC204 AC56.1 AC560 AC60.1 AC60.2 AC70.1
BR01.2 BR10.1 BR10.3 BR12.1 BR120 BR124
BR130 BR131 BR140 BR15.2 BR151 BR153
BR154 BR155 BR21.1 BR215 BR251 BR47.1
BR47.2 BR50.2 BR51.1 BR51.2 BR52.1 BR530
BR570 BR70.1 BR70.2 BRIP.1 PW110
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 AC197
AC198 AC204
AC56.1 AC560
AC60.1 AC60.2
AC70.1 BR01.2
BR10.1 BR10.3
BR12.1 BR120
BR124 BR130
BR131 BR140
BR15.2 BR151
BR153 BR154
BR155 BR21.1
BR215 BR251
...
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
|