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
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GDT-CHART-NAME Element: Chart Name | Alpha 12 This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system. |
|
||||||||||||||||||||||||
| GDT-SUMRY-ACCT-ID Element: Summary Account ID | Numeric 6 The summary account ID. |
|
||||||||||||||||||||||||
| GDT-CHART-SECTION Element: Chart Section | Alpha 1 The chart section. 1 = Balance Sheet 2 = Income Statement |
|
||||||||||||||||||||||||
| GDT-ACCOUNT Element: Account | Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. |
|||||||||||||||||||||||||
| GDT-SUB-ACCOUNT Element: Subaccount | Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. |
|
||||||||||||||||||||||||
| GDT-OLD-ACCT-NBR-D Old Account Nbr Description | Derived The derived old account number. |
|
||||||||||||||||||||||||
| GDT-ACCOUNT-DESC Element: Account Description | Alpha 60 (Lower Case) The account description. |
|
||||||||||||||||||||||||
| GDT-SHORT-ACCT-DSC Short Account Description | Derived |
|
||||||||||||||||||||||||
| GDT-SPACE-CODE Element: Space Code | Numeric 1 Indicates the number of spaces you want 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 Element: Sign Code | Alpha 1 Indicates a negative sign beside a positive amount. N = No Y = Yes |
|
||||||||||||||||||||||||
| GDT-UNITS-CODE Element: Units Code | Alpha 1 Determines if units are allowed. Y = Yes - Not Required N = No O = Only R = Yes - Required |
|
||||||||||||||||||||||||
| GDT-ACTIVITY-REQ Element: Activity Required | Alpha 1 Indicates if an Activity is required. Y = Yes N = No B = Blank |
|
||||||||||||||||||||||||
| GDT-POSTING-LEVEL Element: Posting Level | Alpha 1 Determines if transactions are interfaced to the Lawson General Ledger system in detail or summary form. D = Detail S = Summary |
|
||||||||||||||||||||||||
| GDT-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company's base currency code. |
|
||||||||||||||||||||||||
| GDT-CURR-CONTROL Element: Currency Control | Alpha 1 Lets you limit all transactions to one currency. 0 = No 1 = Yes |
|
||||||||||||||||||||||||
| GDT-TRANSL-CODE Element: Translation Code | Alpha 2 Identifies the translation rate applied against the account balance to calculate the translation value. |
|
||||||||||||||||||||||||
| GDT-REVALUE Element: Revalue | Alpha 1 Lets you revalue non-base transactions of an account into the company base currency. 0 = No 1 = Yes |
|
||||||||||||||||||||||||
| GDT-ACTIVE-STATUS Element: Active Status | Alpha 1 The status of the account. If Inactive, no posting can be done to the account. A = Active I = Inactive |
|
||||||||||||||||||||||||
| GDT-DYNAMIC-LIST Element: Dynamic List | Alpha 12 The attribute list associated with the summary account. |
|
||||||||||||||||||||||||
| GDT-RESTRICT-SYS Element: Restrict System | Alpha 1 Determines if system codes are validated every time the account is used by a system. Y = Yes N = No " " = Sum Acct Default |
|
||||||||||||||||||||||||
| GDT-ACCT-CATEGORY Element: Account Category | Alpha 5 Account categories are groupings of 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. Valid account category types are: cost revenue accrual pass thru |
|
||||||||||||||||||||||||
| GDT-DAILY-BALANCE Element: Daily Balance | Alpha 1 Determines whether transactions can be viewed on a daily basis. Y = Yes N = No |
|
||||||||||||||||||||||||
| GDT-RELATION Element: Relation | Alpha 15 The user analysis value relation assigned to the detail or summary account. The relation must exist in SL02.1 (User Analysis Value Relation). |
|
||||||||||||||||||||||||
| GDT-UNARY-OPER Element: Unary Operator | Alpha 1 The mathematical operation to 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 Element: Natural Balance | Alpha 1 This field determines whether the natural balance is a Debit or Credit. This field is not required. This is only used by the OLAP environment. D = Debit C = Credit |
|
||||||||||||||||||||||||
| GDT-SL-ACCT-FLAG Element: SL Account Flag | Alpha 1 This flag determines whether user 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 |
|
||||||||||||||||||||||||
| GDT-OBJ-ID Element: Object ID | Numeric 12 This is the object identifier. It is used to relate commitments or posted 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 Element: Ledger Group | Alpha 15 |
|
||||||||||||||||||||||||
| GDT-GL-BUD-FL Element: GL Budget Edit Flag | Alpha 1 This is the Yes/No flag for budget editing. N = No Y = Yes " " = Sum Acct Default |
|
||||||||||||||||||||||||
| GDT-GL-ACCT-TYPE Element: Gl Acct Type | Numeric 2 01 = Asset 02 = Liability 03 = Equity 04 = Revenue 05 = Expense 06 = Statistical |
|
||||||||||||||||||||||||
| GDT-XBRL-TAG-ID Element: Xbrl Tag Id | Alpha 60 |
|
||||||||||||||||||||||||
| GDT-CREATED-BY Element: Operator | Alpha 10 |
|
||||||||||||||||||||||||
| GDT-LAST-UPDT-DATE Element: Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
| GDT-LAST-UPDT-TIME Element: Time | Numeric 8 |
|
||||||||||||||||||||||||
| GDT-LAST-UPDATE-BY Element: Operator | Alpha 10 |
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chart Of Accts | GLCHART |
Required
| ||||||||||||
| Currency Code | CUCODES |
Not Required
| ||||||||||||
| Glchdtlbod | GLCHDTLBOD |
Not Required, Delete Cascades
| ||||||||||||
| Mxlisthdr | MXLISTHDR |
Not Required
| ||||||||||||
| Sumry Account | GLCHARTSUM |
Required
| ||||||||||||
| Transl Code | TRCODES |
Not Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chartdtlaudit | GLCHTDTLAU |
| ||||||||||||||||||||||||
| Glacctvld Dtl | GLACCTVLD |
| ||||||||||||||||||||||||
| Glacctvld Glm | GLACCTVLD |
| ||||||||||||||||||||||||
| Glacctvld Sum | GLACCTVLD |
| ||||||||||||||||||||||||
| Glacctvld Sys | GLACCTVLD |
| ||||||||||||||||||||||||
| Mxlistmbr | MXLISTMBR |
| ||||||||||||||||||||||||
| Other Charts | GLCHARTDTL |
| ||||||||||||||||||||||||
| Posting Accts | GLMASTER |
|
All trademarks and registered trademarks are the property of their
respective owners.