Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            GLSUBACDTL FILE

                          GL Subaccount Detail

This file maintains the subaccount number and details of each subaccount
within a subaccount template.

REFERENCED BY

GL02.3    GL160     GL213     GL60.1

UPDATED BY

GL13.1    GL13.4    GL13.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

GSD-SUB-ACCT-TMPLT   Alpha 12                                    GL13.1
Sub Acct Tmplt       This field contains name of the
                     subaccont template to which the
                     subaccount belongs.

GSD-SUB-ACCOUNT      Numeric 4                                   GL13.1
Subaccount           This field contains the subaccount
                     number.

GSD-DESCRIPTION      Alpha 30  (Lower Case)                      GL13.1
Description          This field contains the subaccount
                     description.

GSD-SPACE-CODE       Numeric 1                                   GL13.1
Space Code           This field indicates the number of
                     spaces to advance after the account
                     appears on a report.
                     1 = Advance One Line
                     2 = Advance Two Lines
                     3 = Advance Three Lines
                     9 = Advance To Next Page

GSD-SIGN-CODE        Alpha 1                                     GL13.1
Sign Code            This field determines if the system
                     prints a negative sign next to a
                     positive amount. Reversing the sign
                     only affects report printing, not
                     account totaling.

                     Valid values are:
                     Y = Yes
                     N = No
                     N = No

                     If you leave this field blank, No
                     defaults and the system prints a
                     negative sign for a negative amount.

GSD-UNITS-CODE       Alpha 1                                     GL13.1
Units Code           This field determines if units are
                     allowed in the subaccount.

                     Valid values are:
                     Y= Yes (Allow both)
                     N = No (Allow only amounts)
                     O = Only (Allow only units)
                     Y = Yes

GSD-ACTIVITY-REQ     Alpha 1                                     GL13.1
Activity Req         This field indicates if an activity is
                     required. Valid values are:

                     Y = Yes
                     N = No
                     B = Blank

                     Blank means that the field takes on the
                     value assigned for this field to the
                     account that this subaccount is attached
                     to.

GSD-POSTING-LEVEL    Alpha 1                                     GL13.1
Posting Level        This field determines if transactions
                     are interfaced to the Lawson General
                     Ledger system in summary or detail form.

                     Valid values are:
                     S = Summary
                     D = Detail

GSD-CURRENCY-CODE    Alpha 5                                     GL13.1
Currency Code        This field contains the company base
                     currency code.

GSD-CURR-CONTROL     Alpha 1                                     GL13.1
Currency Control     This field lets you limit all
                     transactions to one currency.
                     0 = No
                     1 = Yes

GSD-TRANSL-CODE      Alpha 2                                     GL13.1
Transl Code          This field identifies the translation
                     rate applied against the subaccount
                     balance to calculate the translation
                     value.

GSD-REVALUE          Alpha 1                                     GL13.1
Revalue              This field indicates whether to revalue
                     non-base transactions of an account into
                     the company base currency..
                     0 = No
                     1 = Yes

GSD-ACTIVE-STATUS    Alpha 1                                     GL13.1
Status               This field determines the status of the
                     account. If Inactive, no posting can be
                     done to the account.
                     A = Active
                     I = Inactive

GSD-DYNAMIC-LIST     Alpha 12                                    GL13.1
Dynamic Generation   This field defines a list of accounting
List                 units to which the account is
                     automatically assigned..

GSD-RESTRICT-SYS     Alpha 1                                     GL13.1
Restrict Sys         This field indicates whether account
                     usage is restricted to specified system
                     codes.  Valid values are:
                     Y = Yes (Restrict to systems specified)
                     N = No  (no restriction)
                     Blank (inherits the restrictions defined
                     for the summary account it is associated
                     with)
                     " " = Sum Acct Default

GSD-ACCT-CATEGORY    Alpha 5                                     GL13.1
Account Category     This field contains the default account
                     category to be used, if you use the
                     Activity system.  Account categories are
                     groupings of costs, revenues, or a
                     combination of both used for reporting
                     and inquiries for activities in the
                     Activity Management system. All
                     transactions are  posted to an account
                     category within an activity. You can
                     assign a specific General Ledger account
                     or range of accounts (company,
                     accounting unit, account, and
                     subaccount) that make up the
                     transactions posted to an account
                     category using AC07.1 (Account
                     Assignment).

                     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.

GSD-DAILY-BALANCE    Alpha 1                                     GL13.1
Daily Balance        This field indicates whether
                     transactions can be viewed on a daily
                     basis.

                     Valid values are:
                     Y = Yes
                     N = No

GSD-RELATION         Alpha 15                                    GL13.1
User Analysis        This field defines a user analysis
Relation             value relation to associate with the
                     subaccount.

                     The relation must exist in User
                     Analysis Value Relation (SL02.1).

GSD-UNARY-OPER       Alpha 1                                     GL13.1
Unary Oper           This field contains the mathematical
                     operation to consolidate amounts for a
                     natural  balance.

                     Valid values are:

                     + = Add
                     - = Subtract
                     * = Multiply
                     / = Divide
                     % = Percentile
                     ~ = Do nothing

                     The default is Add.

                     Only used by the OLAP environment.
                     " " = Do Nothing

GSD-NAT-BALANCE      Alpha 1                                     GL13.1
Nat Balance          This field determines whether the
                     natural balance is a Debit (D) or Credit
                     (C).
                     This field is not required.

                     This is only used by the OLAP
                     environment.
                     D = Debit
                     C = Credit

GSD-SL-ACCT-FLAG     Alpha 1                                     GL13.1
Strategic Ledger     This flag determines whether user
                     analysis values can be assigned to a
                     specific account. You can select Yes,
                     No, or use the Summary Account
                     selection.

                     Y = Yes
                     N = No
                     " " = Sum Acct Default

GSD-LEDGER-GROUP     Alpha 15                                    GL13.1
Ledger Group

GSD-GL-BUD-FL        Alpha 1                                     GL13.1
Gl Bud Fl

                         GLSUBACDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GSDSET1   SUB-ACCOUNT   This index is used to retrieve
          SUB-ACCT-TMPLTsubaccount detail by subaccount.

GSDSET2   SUB-ACCT-TMPLTThis index is used to retrieve           GL02.3  GL13.1
          SUB-ACCOUNT   subaccount detail by subaccount          GL13.2  GL13.4
                        template.                                GL160   GL213
                                                                 GL60.1

                         GLSUBACDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxlisthdr      MXLISTHDR    Not Required

                            "ACCTU"               -> MLH-OBJ-TYPE
                            GSD-DYNAMIC-LIST      -> MLH-MATRIX-LIST

Trcodes        TRCODES      Not Required

                            GSD-TRANSL-CODE       -> TRC-TRANSL-CODE

                         GLSUBACDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glsubacvld     GLSUBACVLD

                            GSD-SUB-ACCT-TMPLT    -> GSV-SUB-ACCT-TMPLT
                            GSD-SUB-ACCOUNT       -> GSV-SUB-ACCOUNT
                                                     GSV-SYSTEM