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 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 AC191 AC40.4
AC41.4 AC42.1 AP125 AP126 AP213 AP25.1
AP25.2 AP26.1 AP27.1 AP284 AP30.2 AR286
AR287 BR41.4 BR44.1 CB10.1 CB15.1 CB15.2
CB191 CB20.1 CB30.1 CB500 EE135 EE35.1
EE35.2 EE520 FB145 FB165 FB190 FB195
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 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 PA495 PO150 PO25.1
PO25.6 PO25.7 PO536 POIM.1 MM280 SL40.4
SLSE.1 WO30.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
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 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 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-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.
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
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 FB95.3
...
GDTSET2 CHART-NAME AC191 AC40.4
ACCOUNT AC41.4 AC42.1
SUB-ACCOUNT ACVW.1 AP125
AP126 AP213
AP25.1 AP25.2
AP26.1 AP27.1
AP284 AP30.2
AR286 AR287
BR41.4 BR44.1
CB10.1 CB15.1
CB15.2 CB191
CB20.1 CB30.1
CB500 EE135
EE35.1 EE35.2
EE520 CA10.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
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
FB160 FB20.1
FB20.6 FB20.7
FB21.1 FB211
FB296 FB60.1
FB95.1 FB95.2
FB95.3 FB95.4
...
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 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
...
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
|