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     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