Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLAUTMPDTL


                            GLAUTMPDTL FILE

This file maintains the names and descriptions of the detailed accounting
units  within an accounting unit template.

REFERENCED BY

GL123     GL124     GL214     GL216     GL23.1

UPDATED BY

GL14.1    GL14.8    GL14.6

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GAU-TEMPLATE-NAME      Alpha 12                                  GL14.1  GL14.8
Element: Name User     This field contains the name of the
                       accounting unit template.

GAU-ACCT-UNIT          Alpha 15                                  GL14.1  GL14.8
Element: Accounting UniThis file contains the name of an
                       accounting unit within the template..

GAU-DESCRIPTION        Alpha 30  (Lower Case)                    GL14.1  GL14.8
Element: Description   This field contains the accounting unit
                       description.

GAU-PARENT-AU          Alpha 15                                  GL14.1
Element: Parent Au     This field contains the name of the
                       accounting unit to which this accounting
                       unit reports.

GAU-LEVEL-DEPTH        Numeric 1                                 GL14.1  GL14.8
Element: Level Depth   This field contains the depth within the
                       template of the accounting unit.

GAU-LEVEL-DETAIL       Numeric 15                                GL14.1  GL14.8
Element: Level Detail  This field contains the address to be
                       assigned at the level depth defined for
                       the accounting unit.

GAU-PERSON-RESP        Alpha 15  (Lower Case)                    GL14.1  GL14.8
Element: First Name    This field contains the name of the
                       person responsible for the accounting
                       unit.

GAU-POSTING-FLAG       Alpha 1                                   GL14.1  GL14.8
Element: Posting Flag  This field indicates whether the posting
                       flag is Posting (P) or Summary (S).
                       Posting accounting units must have a
                       chart of accounts associated with them.
                       P = Posting
                       S = Summary

GAU-ACTIVE-STATUS      Alpha 1                                   GL14.1  GL14.8
Element: Status        This field indicates whether the
                       accounting unit is Active (A) or
                       Inactive (I).  If Inactive, no posting
                       can be done to the accounting unit.
                       A = Active
                       I = Inactive

GAU-CHART-NAME         Alpha 12                                  GL14.1  GL14.8
Element: Name User     This field contains the name of the
                       chart of accounts associated with the
                       accounting unit.

GAU-CHART-SECTION      Alpha 1                                   GL14.1  GL14.8
Element: Chart Section This field contains the chart of
                       accounts section associated with the
                       accounting unit.  Valid values are:
                       Blank = All
                       1     = Balance sheet
                       2     = Income statement

GAU-CURRENCY-CODE      Alpha 5                                   GL14.1  GL14.8
Element: Currency Code This field contains the currency code
                       assigned to the accounting unit.

GAU-VAR-LEVEL-DISP     Alpha 34                                  GL14.1
Element: Var Level DispThis field displays the varaible level.

                         GLAUTMPDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GAUSET1   TEMPLATE-NAME                                          GL123   GL124
          ACCT-UNIT                                              GL14.1  GL14.2
                                                                 GL14.4  GL14.5
                                                                 GL14.6  GL14.7
                                                                 GL14.8  GL214
                                                                 GL216   GL23.1

GAUSET2   ACCT-UNIT
          TEMPLATE-NAME

GAUSET3   TEMPLATE-NAME KeyChange                                GL123   GL14.9
          VAR-LEVEL-DISP                                         GL214
          ACCT-UNIT

GAUSET4   TEMPLATE-NAME KeyChange                                GL14.1
          PARENT-AU
          ACCT-UNIT

GAUSET5   TEMPLATE-NAME                                          GL14.1
          LEVEL-DEPTH
          ACCT-UNIT

                         GLAUTMPDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glautmphdr     GLAUTMPHDR   Required

                            GAU-TEMPLATE-NAME    -> GAH-TEMPLATE-NAME

                         GLAUTMPDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glautmpmst     GLAUTMPMST

                            GAU-TEMPLATE-NAME    -> GTM-TEMPLATE-NAME
                            GAU-ACCT-UNIT        -> GTM-ACCT-UNIT
                                                    GTM-ACCOUNT
                                                    GTM-SUB-ACCOUNT

Glautmpmxv     GLAUTMPMXV

                            GAU-TEMPLATE-NAME    -> GXV-TEMPLATE-NAME
                            GAU-ACCT-UNIT        -> GXV-ACCT-UNIT
                                                    GXV-MATRIX-CAT