Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLAUTMPMST


                            GLAUTMPMST FILE

This file maintains the posting account information for the posting accounting
units within the template.

REFERENCED BY

GL123     GL124     GL00.3    GL216

UPDATED BY

GL14.2    GL14.4    GL14.8    GL14.1    GL14.6

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

GTM-ACCT-UNIT          Alpha 15                                  GL14.2  GL14.4
Element: Accounting UniThis is the name of the posting           GL14.8
                       accounting unit.

GTM-ACCOUNT            Numeric 6                                 GL14.2  GL14.4
Element: Account       This is the number of the account         GL14.8
                       attached to the accounting unit.

GTM-SUB-ACCOUNT        Numeric 4                                 GL14.2  GL14.4
Element: Subaccount    This field contains the number of the     GL14.8
                       subaccount attached to the account and
                       accounting unit.

GTM-UNITS-CODE         Alpha 1                                   GL14.2  GL14.8
Element: Units Code    This field indicates whether units are
                       allowed. Valid values are
                       Y = Yes (allow both units and accounts)
                       N = No (Do not allow units)
                       O = Only (Allow only units)
                           Default (Value defaulted from the
                           chart of accounts)

GTM-ACTIVITY-REQ       Alpha 1                                   GL14.2  GL14.8
Element: Activity Req  Indicates whether an activity is
                       required. Valid values are:

                       Y = Yes (activity is required)
                       N = No  (Activity is optional)
                       B = Blank (Activity is not allowed)
                           Default (Value defaulted from the
                           chart of accounts)

GTM-POSTING-LEVEL      Alpha 1                                   GL14.2  GL14.8
Element: Posting Level This field indicates whether interfaced
                       transactions posted in Summary or Detail
                       form.  Valid values are:
                       D = Detail (all posted accounts)
                       S = Summary (summary of posted accounts)
                           Default  (Defaulted from chart of
                           accounts.

GTM-CURRENCY-CODE      Alpha 5                                   GL14.2  GL14.4
Element: Currency Code This field contains the account           GL14.8
                       currency.  It defaults to the company
                       base currency code, but you can select a
                       non-base currency..

GTM-CURR-CONTROL       Alpha 1                                   GL14.2  GL14.8
Element: Currency ContrThis field lets you limit all
                       transactions to the account currency.
                       The default is N (No)..

GTM-TRANSL-CODE        Alpha 2                                   GL14.2  GL14.8
Element: Add On Cost CoThis field identifies the translation
                       rate applied against the account balance
                       to calculate the translation value.

GTM-REVALUE            Alpha 1                                   GL14.2  GL14.8
Element: Revalue       This field indicates whether to revalue
                       non-base account balances to accommodate
                       currency rate changes.

GTM-ACTIVE-STATUS      Alpha 1                                   GL14.2  GL14.8
Element: Status        This field displays The status of the
                       account. If Inactive, no posting can be
                       done to the account.

GTM-ACCT-CATEGORY      Alpha 5                                   GL14.2  GL14.8
Element: Account CategoThis field contains the default activity
                       account category to be associated with
                       the posting account.

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

GTM-OPTION-FLD-1       Alpha 2  (Lower Case)                     GL14.2  GL14.8
Element: Option Field OThis a free-form user field used to
                       store any information relevant to an
                       account. This field is used only for
                       reporting purposes.

GTM-OPTION-FLD-2       Alpha 7  (Lower Case)                     GL14.2  GL14.8
Element: Option Field TThis is a free-form user field used to
                       store  information relevant to an
                       account. This field is used only for
                       reporting  purposes.

GTM-OPTION-FLD-3       Alpha 12  (Lower Case)                    GL14.2  GL14.8
Element: Level DescriptThis is a free-form field user field
                       used to store  any information relevant
                       to an account.  This field is used only
                       for reporting  purposes.

GTM-CHART-NAME         Alpha 12                                  GL14.2  GL14.4
Element: Name User     This fiekd contains the name of the       GL14.8
                       chart of accounts associated with the
                       account.

GTM-RESTRICT-SYS       Alpha 1                                   GL14.2  GL14.8
Element: Restrict Sys  This field indicates whether account
                       usage is  restricted to specified system
                       codes.

                         GLAUTMPMST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GTMSET1   TEMPLATE-NAME This index accesses posting account and  GL123   GL124
          ACCT-UNIT     subaccount information by template name  GL14.1  GL14.2
          ACCOUNT       and accounting unit.                     GL14.4  GL14.6
          SUB-ACCOUNT                                            GL14.8

GTMSET2   TEMPLATE-NAME This index access posting account and    GL00.3  GL216
          ACCOUNT       subaccount information by template name.
          SUB-ACCOUNT
          ACCT-UNIT

                         GLAUTMPMST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Trcodes        TRCODES      Not Required

                            GTM-TRANSL-CODE      -> TRC-TRANSL-CODE

                         GLAUTMPMST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glautmpvld     GLAUTMPVLD

                            GTM-TEMPLATE-NAME    -> GAV-TEMPLATE-NAME
                            GTM-ACCT-UNIT        -> GAV-ACCT-UNIT
                            GTM-ACCOUNT          -> GAV-ACCOUNT
                            GTM-SUB-ACCOUNT      -> GAV-SUB-ACCOUNT
                                                    GAV-SYSTEM