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
ATVW.1 AM180 CA10.5 CA10.1 CA10.7 CA110
FB100 FB101 FB11.1 FB111 FB160 FB20.1
FB20.6 FB20.7 FB20.3 FB20.4 FB21.1 FB211
FB296 FB60.1 FB95.1 FB95.2 FB95.3 FB95.4
FB95.5 FB95.6 GL191 GL256 GL298 GL326
GL328 GL90.6 GL90.1 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 SNOA.1
SNRA.1 SNSA.1 AC145 AC40.4 AC41.4 AC42.1
AC45.1 AP170 AP175 AP193 AP213 AP284
AP30.2 AP520 AR286 AR287 BR41.4 CB10.1
CB15.1 CB15.2 CB150 CB191 CB20.1 CB30.1
CB45.1 CB46.1 CB500 CB543 CB544 CB55.1
CB554 EE135 EE35.1 EE35.2 EE520 FB145
FB165 FB190 FB195 FB215 FB220 FB235
FB295 FB31.1 FB40.1 FB40.2 FB40.3 FB45.1
GL134 GL135 GL146 GL147 GL148 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 GL70.1 GL70.2 GL70.3 GL70.5 GL70.6
GL75.1 JB240 HGDT.1 HGLM.1 IC02.1 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 MX123 LP198
PA495 PD230 PO150 PO25.1 PO25.6 PO25.7
PO536 POIM.1 MM280 MM80.1 MM80.2 SL40.4
SLSE.1 SN60.1 SN60.2 GLRV.1 SL02.2 MX202
MX223
UPDATED BY
AC191 AP125 AP126 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 API1.1 API2.1 BR44.1
GL100 GL00.2 GL00.3 GL00.6 GL00.7 GL00.9
GL02.1 GL02.2 GL02.3 GL02.6 GL03.3 GL03.5
GL160 IFAC.1 MA41.1 MA41.2 MA41.4 MA41.7
MA43.2 MA61.1 MAI1.1 RQ10.1 RQ10.3 RQ11.1
RQ13.2 RQ35.1 RQ500 RQIB.1 RQIF.1 RQIJ.1
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 GL500
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 GL90.6
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 This field contains the subaccount from GL02.1 GL02.2
your general ledger chart of accounts GL02.3 GL160
that was charged with the amount carried RW100
on this record.
GDT-OLD-ACCT-NBR-D Derived
Old Account Nbr The derived old account number.
Description
GDT-ACCOUNT-DESC Alpha 60 (Lower Case) AP213 AR287
Element: Account DescriThe 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 Account
Description
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 - Not Required GL02.3 GL03.3
N = No GL100 GL160
O = Only
R = Yes - Required
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-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.
Valid account category types are:
cost
revenue
accrual
pass thru
GDT-DAILY-BALANCE Alpha 1 GL00.3 GL02.1
Element: 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
Element: Relation The user analysis value relation GL02.2 GL02.3
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 OperatorThe 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: Natural BalancThis 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: SL Account FlaThis 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
Element: Object ID This is the object identifier. It is GL02.1 GL02.2
used to relate commitments or posted GL02.3 GL160
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 GL02.1
Element: Ledger Group GL02.2 GL02.3
GL100 GL160
GDT-GL-BUD-FL Alpha 1 GL00.3 GL02.1
Element: GL Budget EditThis 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
ATVW.1 AM180
CA10.5 CA110
FB100 FB101
FB11.1 FB111
FB160 FB20.1
FB20.6 FB20.7
FB21.1 FB211
FB296 FB60.1
FB95.1 FB95.2
...
GDTSET2 CHART-NAME AC145 AC191
ACCOUNT AC40.4 AC41.4
SUB-ACCOUNT AC42.1 AC45.1
ACVW.1 ATVW.1
AP125 AP126
AP170 AP175
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP213 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP284 AP30.2
AP520 API1.1
...
GDTSET3 CHART-NAME KeyChange GL199 GL215
CHART-SECTION RW215 GL121
ACCOUNT GL124 GL14.2
SUB-ACCOUNT GL14.4 GL160
GL20.2 GL20.4
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
ATVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
...
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
ATVW.1 AM180
CA10.5 CA110
FB100 FB101
FB11.1 FB111
FB160 FB20.1
FB20.6 FB20.7
FB21.1 FB211
FB296 FB60.1
FB95.1 FB95.2
...
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
|