Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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
Template Name        This field contains the name of the
                     accounting unit template.

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

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

GAU-PARENT-AU        Alpha 15                                    GL14.1
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
Level Depth          This field contains the depth within the
                     template of the accounting unit.

GAU-LEVEL-DETAIL     Numeric 15                                  GL14.1  GL14.8
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
Person Responsible   This field contains the name of the
                     person responsible for the accounting
                     unit.

GAU-POSTING-FLAG     Alpha 1                                     GL14.1  GL14.8
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
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
Chart Name           This field contains the name of the
                     chart of accounts associated with the
                     accounting unit.

GAU-CHART-SECTION    Alpha 1                                     GL14.1  GL14.8
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
Currency Code        This field contains the currency code
                     assigned to the accounting unit.

GAU-VAR-LEVEL-DISP   Alpha 34                                    GL14.1
Var Level Disp       This 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                                          GL123   GL14.9
          VAR-LEVEL-DISP                                         GL214
          ACCT-UNIT

GAUSET4   TEMPLATE-NAME                                          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