Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLICHART


                             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
Element: Name User     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
Element: Chart Section The chart section where accounts are
                       placed. Valid values are Balance Sheet
                       or Income Statement.


GCI-SUM-DET-ACCT       Alpha 12                                  GL160   GL60.1
Element: Account Group The number that identifies the account.


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

                       Valid values are:
                       S=Summary
                       D=Detail

GCI-DEPTH              Numeric 2                                 GL160   GL60.1
Element: 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
Element: Account Desc  The account description.

GCI-SIGN-CODE          Alpha 1                                   GL160   GL60.1
Element: All Flag      Indicates if a negative sign can be
                       used next to a positive amount.


GCI-SPACE-CODE         Numeric 1                                 GL160   GL60.1
Element: 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
Element: Units Code    Indicated whether units are allowed for
                       the account.


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


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

GCI-ACCT-CATEGORY      Alpha 5                                   GL60.1
Element: Account CategoAccount 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
Element: All Flag

GCI-DYNAMIC-LIST       Alpha 12                                  GL60.1
Element: Attribute List

GCI-POSTING-LEVEL      Alpha 1                                   GL60.1
Element: 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
Element: Sub Acct Tmplt

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

GCI-UNARY-OPER         Alpha 1                                   GL160   GL60.1
Element: 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
Element: 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
Element: Currency ContrThis 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
Element: Revalue       This field indicates whether to revalue
                       account balances to account for currency
                       rate changes.


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

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

GCI-GL-BUD-FL          Alpha 1                                   GL60.1
Element: 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  KeyChange                                GL160   GL60.1
          CHART-NAME
          SEQ-NUMBER