Lawson Insight Technical Documentation |
|
GLCHARTDTL
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 AC37.1 AC490 ACVW.1
AM180 CA10.5 CA10.1 CA10.7 CA110 FB100
FB101 FB11.1 FB111 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 AC40.4 AC41.4 AC42.1 AP125 AP126
AP175 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP213 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP284 API1.1 API2.1 AR286 AR287
BR41.4 CB10.1 CB191 CB20.1 CB30.1 CB500
EE135 EE35.1 EE35.2 EE520 FB145 FB165
FB190 FB195 FB220 FB295 FB31.1 FB40.1
FB40.2 FB40.3 FB45.1 GL134 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 GL34.1 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
MA41.2 MA41.7 MA43.2 MA61.1 MAI1.1 PO150
PO25.1 PO25.6 PO25.7 PO536 POIM.1 MM280
MM80.1 MM80.2 SL40.4 SLSE.1 WO30.1 GLRV.1
SL02.2 MX202 MX223
UPDATED BY
GL100 GL00.2 GL00.3 GL00.6 GL00.7 GL00.9
GL02.1 GL02.2 GL02.3 GL02.6 GL03.3 GL03.5
GL160 GL722
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GDT-CHART-NAME Alpha 12 GL00.3 GL00.9
Element: 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
Element: Summary AccounThe summary account ID. GL02.1 GL02.2
GL02.3 GL02.6
GL160
GDT-CHART-SECTION Alpha 1 GL00.3 GL02.1
Element: Chart Section The chart section. GL02.2 GL02.3
1 = Balance Sheet GL160
2 = Income Statement
GDT-ACCOUNT Numeric 6 CA110 FB11.1
Element: 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
Element: Subaccount GL02.1 GL02.2
GL02.3 GL160
RW100
GDT-OLD-ACCT-NBR-D Derived
Element: Old Acct Nbr DThe derived old account number.
GDT-ACCOUNT-DESC Alpha 60 (Lower Case) AP213 AR287
Element: 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
Element: Short Acct Dsc
GDT-SPACE-CODE Numeric 1 GL00.3 GL02.1
Element: 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
Element: 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 GL00.7
Element: Units Code Determines if units are allowed. GL02.1 GL02.2
Y = Yes GL02.3 GL03.3
N = No GL100 GL160
O = Only
GDT-ACTIVITY-REQ Alpha 1 GL00.3 GL02.1
Element: Activity RequiIndicates 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
Element: 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
Element: 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
Element: Currency ContrLets 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
Element: Translation CoIdentifies 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
Element: 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
Element: 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
Element: 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
Element: Restrict SysteDetermines 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
Element: Account CategoAccount 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
Element: All Flag 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
Element: 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
Element: 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
Element: Strategic LedgThis 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
Element: Ledger Group GL02.2 GL02.3
GL100 GL160
GDT-GL-BUD-FL Alpha 1 GL00.3 GL02.1
Element: Gl Bud Fl This is the Yes/No flag for budget GL02.2 GL02.3
editing. GL100 GL160
N = No
Y = Yes
" " = 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 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB101 FB11.1
FB111 FB20.1
FB20.6 FB20.7
FB21.1 FB211
FB296 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
...
GDTSET2 CHART-NAME AC191 AC40.4
ACCOUNT AC41.4 AC42.1
SUB-ACCOUNT ACVW.1 AP125
AP126 AP175
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP213 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP284 API1.1
API2.1 AR286
AR287 BR41.4
CB10.1 CB191
CB20.1 CB30.1
...
GDTSET3 CHART-NAME KeyChange GL199 GL215
CHART-SECTION RW215 GL121
ACCOUNT GL124 GL14.2
SUB-ACCOUNT GL14.4 GL160
GL20.2 GL20.4
GL722 GLDM.3
GLOP.1 GLRV.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 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
...
GDTSET5 RELATION KeyChange SL02.2
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 AC37.1
AC490 ACVW.1
AM180 CA10.5
CA110 FB100
FB101 FB11.1
FB111 FB20.1
FB20.6 FB20.7
FB21.1 FB211
FB296 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
...
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
|