Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             GLICHART FILE

                     General Ledger Interface Chart

The General Ledger Chart Interface file contains the information needed to
create chart, summary, and detail records in the Lawson General Ledger system
when converting from a non-Lawson system defined in GL60.1 (Chart Interface
Maintenance).


REFERENCED BY

GL260

UPDATED BY

GL160     GL60.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

GCI-CHART-NAME       Alpha 12                                    GL60.1
Chart Name           This is the name you assigned to the
                     chart of accounts when you defined your
                     company structure in the General Ledger
                     system.


GCI-SEQ-NUMBER       Numeric 6                                   GL60.1
Record Sequence      A unique number assigned to each
Number               transaction to be transferred into the
                     Lawson system.


GCI-CHART-SECTION    Alpha 1                                     GL60.1
Chart Section        The chart section where accounts are
                     placed. Valid values are Balance Sheet
                     or Income Statement.


GCI-SUM-DET-ACCT     Alpha 12                                    GL60.1
Sum Det Acct         The number that identifies the account.


GCI-RECORD-TYPE      Alpha 1                                     GL60.1
Record Type          This field identifies the type of record
                     defined.

                     Valid values are:
                     S=Summary
                     D=Detail

GCI-DEPTH            Numeric 2                                   GL160   GL60.1
Depth                The account depth that determines the
                     order of account totaling. For example,
                     each account assigned a depth of 2
                     totals to the previous account assigned
                     a depth of 1. Valid values are 1 through
                     9.


GCI-ACCOUNT-DESC     Alpha 60  (Lower Case)                      GL60.1
Account Desc         The account description.

GCI-SIGN-CODE        Alpha 1                                     GL160   GL60.1
Sign Code            Indicates if a negative sign can be
                     used next to a positive amount.


GCI-SPACE-CODE       Numeric 1                                   GL160   GL60.1
Space Code           Indicates the number of spaces you want
                     to advance after the account appears on
                     a report.


GCI-UNITS-CODE       Alpha 1                                     GL160   GL60.1
Units Code           Indicated whether units are allowed for
                     the account.


GCI-ACTIVITY-REQ     Alpha 1                                     GL160   GL60.1
Activity Req         Indicates if an Activity Code is
                     required.


GCI-ACTIVE-STATUS    Alpha 1                                     GL160   GL60.1
Status               The status of the account. If Inactive,
                     no posting can be done to the account.


GCI-ACCT-CATEGORY    Alpha 5                                     GL60.1
Account Category     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.



GCI-DAILY-BALANCE    Alpha 1                                     GL160   GL60.1
Daily Balance        Determines whether transactions can be
                     viewed on a daily basis.


GCI-DYNAMIC-LIST     Alpha 12                                    GL60.1
Dynamic Generation   The accounting unit list used to
List                 automatically assign accounts for a
                     posting accounting unit during
                     transaction entry.


GCI-POSTING-LEVEL    Alpha 1                                     GL60.1
Posting Level        The posting level identifies where
                     transactions are summarized for posting
                     during conversion. You can select
                     Summary or Detail.


GCI-SUB-ACCT-TMPLT   Alpha 12                                    GL60.1
Sub Acct Tmplt

GCI-CURRENCY-CODE    Alpha 5                                     GL60.1
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).


GCI-UNARY-OPER       Alpha 1                                     GL160   GL60.1
Unary Oper           The mathematical operation to
                     consolidate amounts for a natural
                     balance. Valid values are  Add,
                     subtract, multiply, and divide. The
                     default is Add.

                     Only used by the OLAP environment.


GCI-NAT-BALANCE      Alpha 1                                     GL60.1
Nat Balance          This field determines whether the
                     natural balance is a Debit or Credit.
                     This field is not required.

                     This is only used by the OLAP
                     environment.



GCI-CURR-CONTROL     Alpha 1
Currency Control     This field determines whether
                     transactions that have a different
                     account currency are allowed. If Yes,
                     only transactions with the same account
                     currency code are allowed.


GCI-REVALUE          Alpha 1
Revalue              This field indicates whether to revalue
                     account balances to account for currency
                     rate changes.


GCI-SL-ACCT-FLAG     Alpha 1                                     GL60.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

GCI-LEDGER-GROUP     Alpha 15                                    GL60.1
Ledger Group

GCI-GL-BUD-FL        Alpha 1                                     GL60.1
Gl Bud Fl

                         GLICHART FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GCISET1   CHART-NAME                                             GL160   GL260
          SEQ-NUMBER                                             GL60.1

GCISET2   SUM-DET-ACCT                                           GL60.1
          CHART-NAME
          SEQ-NUMBER