 |
Lawson Insight Technical Documentation |
|
GLCHARTDTL FILE
General Ledger Chart Detail
This file contains chart detail records including posting and currency
options defined in the Detail Accounts and Account Information subforms form
GL00.1 (Chart of Accounts).
REFERENCED BY
AC121 AC123 AC130 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC30.2 AC30.3 AC32.1 AC490
ACVW.1 AM180 CA10.5 CA10.1 CA10.7 CA110
FB100 FB101 FB20.1 FB20.6 FB20.7 FB20.3
FB20.4 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4
FB95.5 FB95.6 GL191 GL256 GL326 GL328
GL95.1 GL95.2 GL95.3 GL95.4 GL95.5 GL95.6
GL95.7 GL95.8 GL95.9 GL96.1 GL96.2 GL96.3
GL96.4 GL96.5 GL97.1 GL97.2 GL97.3 GL97.4
GL97.5 GL97.6 GL97.7 GL97.8 GL97.9 GL98.1
GL98.2 GL98.3 GL98.4 GL98.5 GL99.1 GL99.2
GL99.3 GL99.4 GL99.5 GL99.6 RW100 RW215
RW230 RW270 RW30.1 RW70.1 RW80.1 GL121
GL16.2 GL16.4 GLAV.1 GLCV.1 GLVW.1 IF720
IFBA.1 SLVW.1 AC191 AP213 AP284 AR286
AR287 FB165 FB195 FB220 FB295 FB31.1
GL135 GL146 GL167 GL190 GL195 GL196
GL199 GL215 GL230 GL238 GL243 GL281
GL284 GL285 GL286 GL287 GL288 GL289
GL290 GL291 GL295 GL296 GL297 GL325
GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7
GL40.8 GL43.1 GL44.1 GL45.1 GL500 GL90.1
JB240 HCGL.1 HGDT.1 HGLM.1 IC02.1 IC222
GL124 GL14.2 GL14.4 GL20.1 GL20.2 GL20.4
GL200 GL216 GL22.2 GL22.1 GL221 GL222
GL225 GL38.1 GLAC.1 GLDM.3 GLOP.1 IFAC.1
MX123 SLSE.1 MX202 MX223
UPDATED BY
GL100 GL00.2 GL00.3 GL00.6 GL00.9 GL02.1
GL02.2 GL02.3 GL02.6 GL03.5 GL160
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GDT-CHART-NAME Alpha 12 GL00.3 GL00.9
Chart Name This is the name you assigned to the GL02.1 GL02.2
chart of accounts when you defined your GL02.3 GL160
company structure in the General Ledger
system.
GDT-SUMRY-ACCT-ID Numeric 6 GL00.3 GL00.6
Summary Account ID The summary account ID. GL02.1 GL02.2
GL02.3 GL02.6
GL160
GDT-CHART-SECTION Alpha 1 GL00.3 GL02.1
Chart Section The chart section. GL02.2 GL02.3
1 = Balance Sheet GL160
2 = Income Statement
GDT-ACCOUNT Numeric 6 CA110 FB95.1
Account This field along with the accounting FB95.2 FB95.3
unit and subaccount make up the location FB95.4 FB95.5
(account) where amounts and other FB95.6 GL00.3
account information is stored. GL02.1 GL02.2
GL02.3 GL160
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
GL97.5 GL97.6
GL97.7 GL97.8
GL97.9 GL98.1
GL98.2 GL98.3
GL98.4 GL98.5
GL99.1 GL99.2
GL99.3 GL99.4
GL99.5 GL99.6
RW100
GDT-SUB-ACCOUNT Numeric 4 CA110 GL00.3
Subaccount This field along with the accounting GL02.1 GL02.2
unit and subaccount make up the location GL02.3 GL160
(account) where amounts and other RW100
account information is stored.
GDT-OLD-ACCT-NBR-D Derived
Old Acct Nbr D The derived old account number.
GDT-ACCOUNT-DESC Alpha 60 (Lower Case) AP213 AR287
Account Desc The account description. GL00.3 GL02.1
GL02.2 GL02.3
GL160 GL284
GL285 GL286
GL287 GL288
GL289 GL297
RW100
GDT-SHORT-ACCT-DSC Derived
Short Acct Dsc
GDT-SPACE-CODE Numeric 1 GL00.3 GL02.1
Space Code Indicates the number of spaces you want GL02.2 GL02.3
to advance after the account appears on GL100 GL160
a report.
1 = Advance One Line
2 = Advance Two Lines
3 = Advance Three Lines
9 = Advance To Next Page
GDT-SIGN-CODE Alpha 1 GL00.3 GL02.1
Sign Code Indicates a negative sign beside a GL02.2 GL02.3
positive amount. GL100 GL160
N = No
Y = Yes
GDT-UNITS-CODE Alpha 1 GL00.3 GL02.1
Units Code Determines if units are allowed. GL02.2 GL02.3
Y = Yes GL100 GL160
N = No
O = Only
GDT-ACTIVITY-REQ Alpha 1 GL00.3 GL02.1
Activity Required Indicates if an Activity is required. GL02.2 GL02.3
Y = Yes GL100 GL160
N = No
B = Blank
GDT-POSTING-LEVEL Alpha 1 GL00.3 GL02.1
Posting Level Determines if transactions are GL02.2 GL02.3
interfaced to the Lawson General Ledger GL100 GL160
system in detail or summary form.
D = Detail
S = Summary
GDT-CURRENCY-CODE Alpha 5 GL00.3 GL02.1
Currency Code This field contains the company's base GL02.2 GL02.3
currency code. GL100 GL135
GL160 GL167
GL190 GL195
GL196 GL199
GL20.4 GL330
GL45.1 GL500
GDT-CURR-CONTROL Alpha 1 GL00.3 GL02.1
Currency Control Lets you limit all transactions to one GL02.2 GL02.3
currency. GL100 GL160
0 = No
1 = Yes
GDT-TRANSL-CODE Alpha 2 GL00.3 GL02.1
Translation Code Identifies the translation rate applied GL02.2 GL02.3
against the account balance to calculate GL100 GL160
the translation value.
GDT-REVALUE Alpha 1 GL00.3 GL02.1
Revalue Lets you revalue non-base transactions GL02.2 GL02.3
of an account into the company base GL100 GL160
currency.
0 = No
1 = Yes
GDT-ACTIVE-STATUS Alpha 1 GL00.3 GL02.1
Active Status The status of the account. If Inactive, GL02.2 GL02.3
no posting can be done to the account. GL100 GL160
A = Active
I = Inactive
GDT-SUM-SEQ-NBR Derived
Summary Sequence The summary account sequence number.
Number
GDT-DYNAMIC-LIST Alpha 12 GL00.3 GL02.1
Dynamic List The attribute list associated with the GL02.2 GL02.3
summary account. GL100 GL160
GDT-RESTRICT-SYS Alpha 1 GL00.3 GL02.1
Restrict System Determines if system codes are GL02.2 GL02.3
validated every time the account is used GL03.5 GL100
by a system. GL160
Y = Yes
N = No
" " = Sum Acct Default
GDT-ACCT-CATEGORY Alpha 5 GL00.3 GL02.1
Account Category Account categories are groupings of GL02.2 GL02.3
costs, revenues, or a combination of GL100 GL160
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.
GDT-DAILY-BALANCE Alpha 1 GL00.3 GL02.1
Daily Balance Determines whether transactions can be GL02.2 GL02.3
viewed on a daily basis. GL100 GL160
Y = Yes
N = No
GDT-RELATION Alpha 15 GL00.3 GL02.1
User Analysis The user analysis value relation GL02.2 GL02.3
Relation assigned to the detail or summary GL100
account.
The relation must exist in SL02.1 (User
Analysis Value Relation).
GDT-UNARY-OPER Alpha 1 GL00.3 GL02.1
Unary Oper The mathematical operation to GL02.2 GL02.3
consolidate amounts for a natural GL100 GL160
balance. Valid values are Add,
subtract, multiply, and divide. The
default is Add.
Only used by the OLAP environment.
+ = Addition
- = Subtraction
* = Multiplication
/ = Division
% = Percentile
" " = Do Nothing
GDT-NAT-BALANCE Alpha 1 GL00.3 GL02.1
Nat Balance This field determines whether the GL02.2 GL02.3
natural balance is a Debit or Credit. GL100 GL160
This field is not required.
This is only used by the OLAP
environment.
D = Debit
C = Credit
GDT-SL-ACCT-FLAG Alpha 1 GL00.3 GL02.1
Strategic Ledger This flag determines whether user GL02.2 GL02.3
analysis values can be assigned to a GL100 GL160
specific account. You can select Yes,
No, or use the Summary Account
selection.
Y = Yes
N = No
" " = Sum Acct Default
GDT-OBJ-ID Numeric 12 GL00.3 GL00.9
Object This is the object identifier. It is GL160
Identification used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
GDT-LEDGER-GROUP Alpha 15 GL00.3 GL160
Ledger Group
GLCHARTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GDTSET1 CHART-NAME AC121 AC123
SUMRY-ACCT-ID AC130 AC20.1
ACCOUNT AC20.2 AC20.3
SUB-ACCOUNT AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
CA10.5 CA110
FB100 FB101
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL100 GL191
...
GDTSET2 CHART-NAME AC191 ACVW.1
ACCOUNT AP213 AP284
SUB-ACCOUNT AR286 AR287
CA10.1 CA10.7
CA110 FB100
FB101 FB165
FB195 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB220
FB295 FB31.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL135 GL146
...
GDTSET3 CHART-NAME GL199 GL215
CHART-SECTION RW215 GL121
ACCOUNT GL124 GL14.2
SUB-ACCOUNT GL14.4 GL20.2
GL20.4 GLDM.3
GLOP.1
GDTSET4 ACCOUNT AC121 AC123
SUB-ACCOUNT AC130 AC20.1
CHART-NAME AC20.2 AC20.3
SUMRY-ACCT-ID AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
CA10.5 CA110
FB100 FB20.1
FB20.6 FB20.7
FB21.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL95.1
GL95.2 GL95.3
...
GDTSET5 RELATION KeyChange
CHART-NAME
SUMRY-ACCT-ID
ACCOUNT
SUB-ACCOUNT
GDTSET6 OBJ-ID Subset AC121 AC123
Where OBJ-ID != Zeroes AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
CA10.5 CA110
FB100 FB101
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL256 GL95.1
...
GDTSET7 LEDGER-GROUP KeyChange, Subset
CHART-NAME Where LEDGER-GROUP != Spaces
SUMRY-ACCT-ID
ACCOUNT
SUB-ACCOUNT
GLCHARTDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Chart Of Accts GLCHART Required
GDT-CHART-NAME -> GCH-CHART-NAME (GCHSET1)
Currency Code CUCODES Not Required
GDT-CURRENCY-CODE -> CUC-CURRENCY-CODE
Mxlisthdr MXLISTHDR Not Required
"ACCTU" -> MLH-OBJ-TYPE
GDT-DYNAMIC-LIST -> MLH-MATRIX-LIST
Sumry Account GLCHARTSUM Required
GDT-CHART-NAME -> GCS-CHART-NAME
GDT-SUMRY-ACCT-ID -> GCS-SUMRY-ACCT-ID
Transl Code TRCODES Not Required
GDT-TRANSL-CODE -> TRC-TRANSL-CODE
GLCHARTDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glacctvld Dtl GLACCTVLD
GDT-CHART-NAME -> VLD-CHART-NAME
GDT-ACCOUNT -> VLD-ACCOUNT
GDT-SUB-ACCOUNT -> VLD-SUB-ACCOUNT
VLD-SYSTEM
Glacctvld Glm GLACCTVLD
"M" -> VLD-RECORD-TYPE
Spaces -> VLD-CHART-NAME
Zeroes -> VLD-SUMRY-ACCT-ID
GDT-ACCOUNT -> VLD-ACCOUNT
GDT-SUB-ACCOUNT -> VLD-SUB-ACCOUNT
VLD-COMPANY
VLD-ACCT-UNIT
VLD-SYSTEM
Glacctvld Sum GLACCTVLD
"S" -> VLD-RECORD-TYPE
GDT-CHART-NAME -> VLD-CHART-NAME
GDT-SUMRY-ACCT-ID -> VLD-SUMRY-ACCT-ID
Zeroes -> VLD-ACCOUNT
Zeroes -> VLD-SUB-ACCOUNT
Zeroes -> VLD-COMPANY
Spaces -> VLD-ACCT-UNIT
VLD-SYSTEM
Glacctvld Sys GLACCTVLD
"D" -> VLD-RECORD-TYPE
GDT-CHART-NAME -> VLD-CHART-NAME
GDT-SUMRY-ACCT-ID -> VLD-SUMRY-ACCT-ID
GDT-ACCOUNT -> VLD-ACCOUNT
GDT-SUB-ACCOUNT -> VLD-SUB-ACCOUNT
Zeroes -> VLD-COMPANY
Spaces -> VLD-ACCT-UNIT
VLD-SYSTEM
Mxlistmbr MXLISTMBR
"ACCTU" -> MLM-OBJ-TYPE
GDT-DYNAMIC-LIST -> MLM-MATRIX-LIST
MLM-SEQ-NUMBER
Other Charts GLCHARTDTL
GDT-ACCOUNT -> GDT-ACCOUNT
GDT-SUB-ACCOUNT -> GDT-SUB-ACCOUNT
GDT-CHART-NAME
GDT-SUMRY-ACCT-ID
Posting Accts GLMASTER
GDT-CHART-NAME -> GLM-CHART-NAME
GDT-ACCOUNT -> GLM-ACCOUNT
GDT-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
GLM-COMPANY
GLM-ACCT-UNIT
|