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 Element: Chart Name	Alpha 12 This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.	GL160 GL60.1
GCI-SEQ-NUMBER Element: Seq Number	Numeric 6 A unique number assigned to each transaction to be interfaced into the Lawson system.	GL160 GL60.1
GCI-CHART-SECTION Element: Chart Section	Alpha 1 The chart section where accounts are placed. Valid values are Balance Sheet or Income Statement.	GL160 GL60.1
GCI-SUM-DET-ACCT Element: Sum Det Acct	Alpha 12 The number that identifies the account.	GL160 GL60.1
GCI-RECORD-TYPE Element: Record Type	Alpha 1 This field identifies the type of record defined. Valid values are: S=Summary D=Detail	GL160 GL60.1
GCI-DEPTH Element: Depth	Numeric 2 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.	GL160 GL60.1
GCI-ACCOUNT-DESC Element: Account Desc	Alpha 60 (Lower Case) The account description.	GL160 GL60.1
GCI-SIGN-CODE Element: Sign Code	Alpha 1 Indicates if a negative sign can be used next to a positive amount.	GL160 GL60.1
GCI-SPACE-CODE Element: Space Code	Numeric 1 Indicates the number of spaces you want to advance after the account appears on a report.	GL160 GL60.1
GCI-UNITS-CODE Element: Units Code	Alpha 1 Indicated whether units are allowed for the account.	GL160 GL60.1
GCI-ACTIVITY-REQ Element: Activity Req	Alpha 1 Indicates if an Activity Code is required.	GL160 GL60.1
GCI-ACTIVE-STATUS Element: Active Status	Alpha 1 The status of the account. If Inactive, no posting can be done to the account.	GL160 GL60.1
GCI-ACCT-CATEGORY Element: Acct Category	Alpha 5 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	GL160 GL60.1
GCI-DAILY-BALANCE Element: All Flag	Alpha 1	GL160 GL60.1
GCI-DYNAMIC-LIST Element: Matrix List	Alpha 12 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.	GL160 GL60.1
GCI-POSTING-LEVEL Element: Posting Level	Alpha 1 The posting level identifies where transactions are summarized for posting during conversion. You can select Summary or Detail.	GL160 GL60.1
GCI-SUB-ACCT-TMPLT Element: Sub Acct Tmplt	Alpha 12	GL160 GL60.1
GCI-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the company base currency code established in Company (GL10.1 ).	GL160 GL60.1
GCI-UNARY-OPER Element: Unary Oper	Alpha 1 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.	GL160 GL60.1
GCI-NAT-BALANCE Element: Nat Balance	Alpha 1 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.	GL60.1
GCI-CURR-CONTROL Element: Curr Control	Alpha 1 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.	GL60.1
GCI-REVALUE Element: Revalue	Alpha 1 This field indicates whether to revalue account balances to account for currency rate changes.	GL60.1
GCI-SL-ACCT-FLAG Element: Sl Acct Flag	Alpha 1 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	GL60.1
GCI-LEDGER-GROUP Element: Ledger Group	Alpha 15 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.	GL60.1
GCI-GL-BUD-FL Element: Gl Bud Fl	Alpha 1	GL60.1
GCI-GL-ACCT-TYPE Element: Gl Acct Type	Numeric 2 01 = Asset 02 = Liability 03 = Equity 04 = Revenue 05 = Expense 06 = Statistical	GL60.1
GCI-XBRL-TAG-ID Element: Xbrl Tag Id	Alpha 60	GL60.1

GLICHART FILE INDEX

All trademarks and registered trademarks are the property of their respective owners.