|
|
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
|
