Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLCONDRILL


                            GLCONDRILL FILE

                            GL Drill Around

The GL Consolidation Drill file provides drill around functionality from a
consolidation company balance amount back to the originating company source
transaction that created the amounts.

UPDATED BY

GL195     GL500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GLD-GLT-OBJ-ID         Numeric 12                                GL195
GL Transaction         This is a unique internal GL transaction
Object ID              identification number that is used for
                       Drill Around purposes.

GLD-ORIG-COMPANY       Numeric 4                                 GL195
Element: Original CompaThis field contains the name of the
                       source company that originated the
                       transaction posted to the consolidation
                       company.

GLD-COMPANY            Numeric 4                                 GL195
Element: Company       This field contains the name of the
                       consolidation company.

GLD-ACCOUNT            Numeric 6                                 GL195
Element: Account       This field contains the account number
                       containing the amounts being queried.

GLD-SUB-ACCOUNT        Numeric 4                                 GL195
Element: Subaccount    This field contains the sub-account
                       containing the amounts being queried.

GLD-FISCAL-YEAR        Numeric 4                                 GL195   GL500
Element: Fiscal Year   Tis field contains the fiscal year of
                       the transaction being queried.

                         GLCONDRILL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GLDSET1   GLT-OBJ-ID    Provides access to the GLTRANS and       GL195   GL500
                        GLAMOUNTS records of the originating
                        company.

                         GLCONDRILL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glamacct       GLAMOUNTS

                            GLD-ORIG-COMPANY    -> GAM-COMPANY
                            GLD-FISCAL-YEAR     -> GAM-FISCAL-YEAR
                                                   GAM-ACCOUNT
                                                   GAM-SUB-ACCOUNT
                                                   GAM-ACCT-UNIT

Glamounts      GLAMOUNTS

                            GLD-FISCAL-YEAR     -> GAM-FISCAL-YEAR
                            GLD-ORIG-COMPANY    -> GAM-COMPANY
                            GLD-ACCOUNT         -> GAM-ACCOUNT
                            GLD-SUB-ACCOUNT     -> GAM-SUB-ACCOUNT
                                                   GAM-VAR-LEVELS
                                                   GAM-ACCT-UNIT