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: 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
Element: Seq Number    A unique number assigned to each
                       transaction to be interfaced 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: Sum Det Acct  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: Sign Code     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: Active Status The status of the account. If Inactive,
                       no posting can be done to the account.


GCI-ACCT-CATEGORY      Alpha 5                                   GL60.1
Element: Acct 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.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

GCI-DAILY-BALANCE      Alpha 1                                   GL160   GL60.1
Element: All Flag

GCI-DYNAMIC-LIST       Alpha 12                                  GL60.1
Element: Matrix List   Attribute categories are selection
                       parameters used to build a list of
                       objects (accounting units). Attribute
                       categories and values are the basis of
                       the selection and sorting. A attribute
                       list can then be used for reporting on
                       and processing objects.


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: Curr 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
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: Sl Acct Flag  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
Element: Ledger Group  This is the Multi-Book Ledger Group.
                       The ledger is established in Ledger
                       Setup
                       (ML10).
                       This field indicates that the ledgers
                       within the group are valid for the
                       account.

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