Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLSUBACDTL


                            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
Element: Sub Acct TmpltThis field contains name of the
                       subaccont template to which the
                       subaccount belongs.

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

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

GSD-SPACE-CODE         Numeric 1                                 GL13.1
Element: 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
Element: All Flag      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
Element: 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
Element: 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
Element: 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
Element: Currency Code This field contains the company base
                       currency code.

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

GSD-TRANSL-CODE        Alpha 2                                   GL13.1
Element: Add On Cost CoThis field identifies the translation
                       rate applied against the subaccount
                       balance to calculate the translation
                       value.

GSD-REVALUE            Alpha 1                                   GL13.1
Element: 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
Element: 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
Element: Attribute ListThis field defines a list of accounting
                       units to which the account is
                       automatically assigned..

GSD-RESTRICT-SYS       Alpha 1                                   GL13.1
Element: 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
Element: Account CategoThis 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
Element: All Flag      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
Element: 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
Element: 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
Element: Strategic LedgThis 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
Element: Ledger Group

GSD-GL-BUD-FL          Alpha 1                                   GL13.1
Element: 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