Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACGLCODE


                             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     AC60.1    AC60.2    BR01.2    BR10.1    BR10.3
BR12.1    BR120     BR130     BR131     BR140     BR15.2
BR215     BR530     BRIP.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   AC197
                                                                 AC198   AC204
                                                                 AC60.1  AC60.2
                                                                 BR01.2  BR10.1
                                                                 BR10.3  BR12.1
                                                                 BR120   BR130
                                                                 BR131   BR140
                                                                 BR15.2  BR215
                                                                 BR530   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