Lawson Insight Technical Documentation | 
  
    
  | 
  
                             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
 |