|
|
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 This is the name you assigned to the
chart of accounts when you defined your
company structure in the General Ledger
system.
GCI-SEQUENCE-NBR Numeric 4 GL60.1
Sequence Number The user-assigned sequence number to
keep the records unique and to determine
order.
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
Account The number that identifies the account.
GCI-RECORD-TYPE Alpha 1 GL60.1
Type This field identifies the type of
record defined.
Valid values are:
S=Summary
D=Detail
GCI-DEPTH Numeric 2 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-DESCRIPTION Alpha 30 (Lower Case) GL60.1
Account Description The description of the account.
GCI-SIGN-CODE Alpha 1 GL160 GL60.1
Sign Reversal Indicates if a negative sign can be
used next to a positive amount.
GCI-SPACE-CODE Numeric 1 GL160 GL60.1
Space After Indicates the number of spaces you want
to advance after the account appears on
a report.
GCI-UNITS-CODE Alpha 1 GL160 GL60.1
Allow Units Indicated whether units are allowed for
the account.
GCI-ACTIVITY-REQ Alpha 1 GL160 GL60.1
Activity Required 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-RELATION Alpha 15
User Analysis The user analysis value relation
Relation assigned to the detail or summary
account.
The relation must exist in SL02.1 (User
Analysis Value Relation).
GCI-DAILY-BALANCE Alpha 1 GL160 GL60.1
Daily Balance Determines whether transactions can be
viewed on a daily basis.
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-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-CURRENCY-CODE Alpha 5 GL60.1
Currency Code This field contains the company base
currency code established in GL10.1
(Company).
GCI-UNARY-OPER Alpha 1 GL160 GL60.1
Consolidation 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
Natural 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
GLICHART FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GCISET1 CHART-NAME GL160 GL260
SEQUENCE-NBR GL60.1
GCISET2 SUM-DET-ACCT Duplicates GL60.1
CHART-NAME
SEQUENCE-NBR
|