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 AC127 AC130 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACBO.1 ACVW.1 CA10.5 CA10.1 CA10.8 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 GLCV.1 GLOB.1 GLVW.1 AC191 AP213 AP284 AR286 AR287 FB121 FB165 FB195 FB220 FB230 FB231 FB295 FB30.1 FB31.1 FB65.1 GL135 GL167 GL170 GL190 GL195 GL196 GL199 GL215 GL230 GL243 GL270 GL281 GL284 GL285 GL286 GL287 GL288 GL289 GL290 GL291 GL295 GL296 GL297 GL325 GL327 GL330 GL43.1 GL45.1 GL500 GL90.1 JB240 HCGL.1 HGDT.1 HGLM.1 IC02.1 IC222 GL20.1 GL20.2 GL20.4 GL200 GL221 GL222 GL225 GL38.1 GL87.1 GL88.1 GLOP.1 IFAC.1 RQ10.1 SL40.4 SLSE.1 SL02.2 UPDATED BY GL100 GL00.2 GL00.3 GL00.6 GL00.9 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 GL160 chart of accounts when you defined your company structure in the General Ledger system. GDT-SUMRY-ACCT-ID Numeric 6 GL00.3 GL00.6 Summary Account ID The summary account ID. GL160 GDT-CHART-SECTION Alpha 1 GL00.3 GL160 Chart Section The chart section. 1 = Balance Sheet 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. 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 GL160 RW100 unit and subaccount make up the location (account) where amounts and other account information is stored. GDT-OLD-ACCT-NBR-D Derived Old Account Number The derived old account number. GDT-DESCRIPTION Alpha 30 (Lower Case) AP213 AR287 Description The detail account description. GL00.3 GL160 GL284 GL285 GL286 GL287 GL288 GL289 GL297 IC02.1 RW100 GDT-SHORT-DESC Derived Short Description The short description. GDT-SPACE-CODE Numeric 1 GL00.3 GL100 Space Code Indicates the number of spaces you want GL160 to advance after the account appears on 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 GL100 Sign Code Indicates a negative sign beside a GL160 positive amount. N = No Y = Yes GDT-UNITS-CODE Alpha 1 GL00.3 GL100 Units Code Determines if units are allowed. GL160 Y = Yes N = No O = Only GDT-ACTIVITY-REQ Alpha 1 GL00.3 GL100 Activity Required Indicates if an Activity is required. GL160 Y = Yes N = No B = Blank GDT-POSTING-LEVEL Alpha 1 GL00.3 GL100 Posting Level Determines if transactions are GL160 interfaced to the Lawson General Ledger system in detail or summary form. D = Detail S = Summary GDT-CURRENCY-CODE Alpha 5 GL00.3 GL100 Currency Code This field contains the company's base GL135 GL160 currency code. GL167 GL190 GL195 GL196 GL199 GL20.4 GL330 GL45.1 GL500 GDT-CURR-CONTROL Alpha 1 GL00.3 GL100 Currency Control Lets you limit all transactions to one GL160 currency. 0 = No 1 = Yes GDT-TRANSL-CODE Alpha 2 GL00.3 GL100 Translation Code Identifies the translation rate applied GL160 against the account balance to calculate the translation value. GDT-REVALUE Alpha 1 GL00.3 GL100 Revalue Lets you revalue non-base transactions GL160 of an account into the company base currency. 0 = No 1 = Yes GDT-ACTIVE-STATUS Alpha 1 GL00.3 GL100 Active Status The status of the account. If Inactive, GL160 no posting can be done to the account. A = Active I = Inactive GDT-SUM-SEQ-NBR Derived Summary Sequence The summary account sequence number. Number GDT-DYNAMIC-LIST Alpha 12 GL00.3 GL100 Dynamic List The attribute list associated with the GL160 summary account. GDT-RESTRICT-SYS Alpha 1 GL00.3 GL03.5 Restrict System Determines if system codes are GL100 validated every time the account is used by a system. Y = Yes N = No " " = Sum Acct Default GDT-ACCT-CATEGORY Alpha 5 GL00.3 GL100 Account Category Account categories are groupings of GL160 costs, revenues, or a combination of 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 GL100 Daily Balance Determines whether transactions can be GL160 viewed on a daily basis. Y = Yes N = No " " = Sum Acct Default GDT-SNGL-ACCT-TYPE Alpha 1 Account Type Indicates if an account must be either all credits or all debits. GDT-RELATION Alpha 15 GL00.3 GL100 User Analysis The user analysis value relation Relation assigned to the detail or summary account. The relation must exist in SL02.1 (User Analysis Value Relation). GDT-UNARY-OPER Alpha 1 GL00.3 GL100 Consolidation The mathematical operation to GL160 consolidate amounts for a natural 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 GL100 Natural Balance This field determines whether the GL160 natural balance is a Debit or Credit. This field is not required. This is only used by the OLAP environment. GDT-SL-ACCT-FLAG Alpha 1 GL00.3 GL100 Strategic Ledger This flag determines whether user GL160 analysis values can be assigned to a specific account. You can select Yes, No, or use the Summary Account selection. Y = Yes N = No " " = Sum Acct Default GLCHARTDTL FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN GDTSET1 CHART-NAME AC121 AC123 SUMRY-ACCT-ID AC127 AC130 ACCOUNT AC20.1 AC20.2 SUB-ACCOUNT AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACBO.1 ACVW.1 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.8 CA110 FB100 FB101 FB121 FB165 FB195 FB20.1 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB220 FB230 FB231 FB295 FB30.1 FB31.1 FB65.1 FB95.1 FB95.2 FB95.3 ... GDTSET3 CHART-NAME GL199 GL215 CHART-SECTION RW215 GL121 ACCOUNT GL20.2 GL20.4 SUB-ACCOUNT GL87.1 GL88.1 GLOP.1 GDTSET4 ACCOUNT SUB-ACCOUNT CHART-NAME SUMRY-ACCT-ID GDTSET5 RELATION KeyChange SL02.2 CHART-NAME 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 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 |