 |
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 AC32.1 AC490 ACVW.1 AM180
CA10.5 CA10.1 CA10.7 CA110 FB100 FB101
FB11.1 FB20.1 FB20.6 FB20.7 FB20.3 FB20.4
FB21.1 FB211 FB296 FB95.1 FB95.2 FB95.3
FB95.4 FB95.5 FB95.6 GL191 GL256 GL298
GL326 GL328 GL94.1 GL94.2 GL94.3 GL94.4
GL94.5 GL94.6 GL94.7 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 IFBA.1 SLVW.1 AC191 AP125
AP126 AP213 AP25.1 AP25.2 AP26.1 AP27.1
AP284 AR286 AR287 CB10.1 CB191 CB20.1
CB30.1 CB500 EE135 EE35.1 EE35.2 EE520
DA290 FB165 FB190 FB195 FB220 FB295
FB31.1 FB40.1 FB40.2 FB40.3 FB45.1 GL135
GL146 GL147 GL165 GL167 GL170 GL190
GL195 GL196 GL197 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 GL65.1 GL75.1 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
POIM.1 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 GL722
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 FB11.1
Account This field along with the accounting FB95.1 FB95.2
unit and subaccount make up the location FB95.3 FB95.4
(account) where amounts and other FB95.5 FB95.6
account information is stored. GL00.3 GL02.1
GL02.2 GL02.3
GL160 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
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 FB45.1 GL00.3
Currency Code This field contains the company's base GL02.1 GL02.2
currency code. GL02.3 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 GL02.1 GL02.2
Identification used to relate commitments or posted GL02.3 GL160
transactions back to the originating GL722
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 GL02.1
Ledger Group GL02.2 GL02.3
GL100 GL160
GDT-GL-BUD-FL Alpha 1 GL00.3 GL02.1
Gl Bud Fl N = No GL02.2 GL02.3
Y = Yes GL100 GL160
" " = Sum Acct Default
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
AC32.1 AC490
ACVW.1 AM180
CA10.5 CA110
FB100 FB101
FB11.1 FB20.1
FB20.6 FB20.7
FB21.1 FB211
FB296 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL100
...
GDTSET2 CHART-NAME AC191 ACVW.1
ACCOUNT AP125 AP126
SUB-ACCOUNT AP213 AP25.1
AP25.2 AP26.1
AP27.1 AP284
AR286 AR287
CB10.1 CB191
CB20.1 CB30.1
CB500 EE135
EE35.1 EE35.2
EE520 CA10.1
CA10.7 CA110
DA290 FB100
FB101 FB11.1
FB165 FB190
...
GDTSET3 CHART-NAME GL199 GL215
CHART-SECTION RW215 GL121
ACCOUNT GL124 GL14.2
SUB-ACCOUNT GL14.4 GL20.2
GL20.4 GL722
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
AC32.1 AC490
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
...
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
AC32.1 AC490
ACVW.1 AM180
CA10.5 CA110
FB100 FB101
FB11.1 FB20.1
FB20.6 FB20.7
FB21.1 FB211
FB296 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL256
...
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
|