General Ledger Account Master
This file contains the chart of accounts. All Lawson subsystems verify the existence of accounts against this file. The Chart of Accounts, Level Reorganization, Mass Account Addition, and Mass Account Change Delete are the primary programs that create and maintain information in the file.
REFERENCED BY
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GLM-COMPANY Element: Company | Numeric 4 The company number. |
|||||||||||||||||||
GLM-VAR-LEVELS Element: Variable Levels | Alpha 30 Required. The variable level number is tied directly to the accounting unit. It is used to indicate an accounting unit's position within the company hierarchy, establishing its consolidation relationship with other units. Must be defined in the GLNAMES file as a posting level. |
|||||||||||||||||||
GLM-ACCT-UNIT Element: Accounting Unit | Alpha 15 The accounting unit is a shorthand notation representing the variable level number. |
|||||||||||||||||||
GLM-OLD-COMPANY-D Element: Old Company | Derived Contains the old company derived. |
|
||||||||||||||||||
GLM-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. |
|||||||||||||||||||
GLM-SUB-ACCOUNT Element: Subaccount | Numeric 4 This field along with the accounting unit and account make up the location (account) where amounts and other account information are stored. |
|||||||||||||||||||
GLM-OLD-ACCT-NBR-D Element: Old Account Number | Derived Contains the derived old account number. |
|
||||||||||||||||||
GLM-ACTIVE-STATUS Element: Active Status | Alpha 1 Required field if a detail-type account, otherwise this field should be blank. Indicates if a detail account is either active or inactive. Inactive accounts cannot be used for posting. " " = Default I = Inactive |
|
||||||||||||||||||
GLM-STATUS-DERIVED Element: Status | Derived Contains the derived status. |
|
||||||||||||||||||
GLM-ACCT-ND Account Number of Decimals | Numeric 1 Account amount decimal positions. |
|||||||||||||||||||
GLM-UNITS-CODE Element: Units Code | Alpha 1 Required if a detail-type account. This field indicates if units are allowed, not allowed, or only allowed. " " = Default Y = Yes - Not Required N = No O = Only Units R = Yes - Required |
|
||||||||||||||||||
GLM-UNITS-DERIVED Element: Units | Derived Contains the derived units. |
|
||||||||||||||||||
GLM-AVG-DAILY-BAL Average Daily Balance | Alpha 1 Yes value indicates the account is used for calculating average daily balance. " " = No N = No Y = Yes I = Inactive |
|
||||||||||||||||||
GLM-ACTIVITY-REQ Element: Activity Required | Alpha 1 Indicates if an Activity code is required. Y = Yes N = No " " = Default |
|
||||||||||||||||||
GLM-GLINTCO-STAT Element: Intercompany Status | Numeric 3 Not required. This field is used to count the number of intercompany or interzone relationships using this account number. Accounts cannot be deleted if this field is greater than zero. |
|
||||||||||||||||||
GLM-POSTING-LEVEL Element: Posting Level | Alpha 1 Required if a detail-type account. This field is used to determine whether interface transactions should be combined when creating GLTRANS records. " " = Default D = Detail S = Summary |
|
||||||||||||||||||
GLM-OPTION-FLD-1 Element: | Alpha 2 (Lower Case) Free-form field used to store any information relevant to an account. This field is used for reporting purposes. |
|
||||||||||||||||||
GLM-OPTION-FLD-2 Element: | Alpha 7 (Lower Case) Free-form field used to store information relevant to an account. This field is used for reporting purposes. |
|
||||||||||||||||||
GLM-OPTION-FLD-3 Element: | Alpha 12 (Lower Case) Free-form field used to store any information relevant to an account. This field is used for reporting purposes. |
|
||||||||||||||||||
GLM-TRANSL-CODE Element: | Alpha 2 Contains the translation code. |
|
||||||||||||||||||
GLM-CURRENCY-CODE Element: Currency Code | Alpha 5 The company base currency code. |
|||||||||||||||||||
GLM-CURR-CONTROL Element: Currency Control | Alpha 1 Flag used to allow posting to the account in currencies other than the account currency. " " = Default 0 = No 1 = Yes |
|
||||||||||||||||||
GLM-REVALUE Element: Revalue | Alpha 1 Determines whether or not this account will participate in the revaluation process. " " = Default 0 = No 1 = Yes |
|
||||||||||||||||||
GLM-DATE-ENTERED Element: Date Entered | Numeric 8 (yyyymmdd) Date used to document account changes. |
|||||||||||||||||||
GLM-CHART-NAME Element: Chart Name | Alpha 12 This is the name assigned to the chart of accounts when you defined your company structure in the Lawson General Ledger system. |
|||||||||||||||||||
GLM-BASE-CURRENCY Element: Base Currency | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|||||||||||||||||||
GLM-RESTRICT-SYS Element: Restrict System | Alpha 1 Indicates if system codes are validated each time the account is used by a system. Y = Yes N = No " " = Default |
|
||||||||||||||||||
GLM-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 |
|
||||||||||||||||||
GLM-DER-X-SYS Element: Der X Sys | Derived Indicates if system restrictions exist for an account. |
|
||||||||||||||||||
GLM-SUMM-ACCT-ID Element: Summary Account ID | Derived The summary account ID. |
|
||||||||||||||||||
GLM-ACCT-DESC Element: Account Description | Derived This is the account description. |
|
||||||||||||||||||
GLM-BLANK Element: Blank | Derived This derived field is always blank. It is used in the Drill Around feature for column headings. |
|
||||||||||||||||||
GLM-CUCODE-DESC Element: Cucode Desc | Derived This is the currency code description. |
|
||||||||||||||||||
GLM-SL-ACCT-FLAG Element: Sl Acct 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 " " = Default |
|
||||||||||||||||||
GLM-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). |
|
||||||||||||||||||
GLM-LEDGER-GROUP Element: Ledger Group | Alpha 15 |
|
||||||||||||||||||
GLM-GL-BUD-FL Element: Gl Bud Fl | Alpha 1 This is the Yes/No flag for budget editing. N = No Edit Y = Yes " " = Default |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Accountunit | GLNAMES |
Required
| |||||||||||||||||||||||||||
Acct Unit | GLNAMES |
Required
| |||||||||||||||||||||||||||
Budget 1 | FBDETAIL |
Not Required
| |||||||||||||||||||||||||||
Chart Detail | GLCHARTDTL |
Required
| |||||||||||||||||||||||||||
Company | GLSYSTEM |
Required
| |||||||||||||||||||||||||||
Consol | GLCONSOL |
Not Required
| |||||||||||||||||||||||||||
Cucodes | CUCODES |
Required
| |||||||||||||||||||||||||||
Pocompany | POCOMPANY |
Not Required
| |||||||||||||||||||||||||||
Procuregrp | PROCUREGRP |
Not Required
| |||||||||||||||||||||||||||
Summary Acct | GLCHARTSUM |
Required
| |||||||||||||||||||||||||||
Trcodes | TRCODES |
Required
| |||||||||||||||||||||||||||
Var Levels | GLNAMES |
Required
| |||||||||||||||||||||||||||
Variablelevel | GLNAMES |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Amounts | GLAMOUNTS |
Delete Restricted
| |||||||||||||||||||||||||||||||||||||||
Budget All | FBDETAIL |
Delete Restricted
| |||||||||||||||||||||||||||||||||||||||
Budgets | FBDETAIL |
Delete Restricted
| |||||||||||||||||||||||||||||||||||||||
Cuamount1 | CUAMOUNT |
Delete Cascades
| |||||||||||||||||||||||||||||||||||||||
Cuamount2 | CUAMOUNT |
Delete Cascades
| |||||||||||||||||||||||||||||||||||||||
Cuamount3 | CUAMOUNT |
Delete Cascades
| |||||||||||||||||||||||||||||||||||||||
Cuamount4 | CUAMOUNT |
Delete Cascades
| |||||||||||||||||||||||||||||||||||||||
Cuamountx 3 | CUAMOUNTX |
| |||||||||||||||||||||||||||||||||||||||
Cuamountx 4 | CUAMOUNTX |
| |||||||||||||||||||||||||||||||||||||||
Dailytrans | GLAMOUNTSX |
| |||||||||||||||||||||||||||||||||||||||
Glacctvld Gcs | GLACCTVLD |
| |||||||||||||||||||||||||||||||||||||||
Glacctvld Gdt | GLACCTVLD |
| |||||||||||||||||||||||||||||||||||||||
Glacctvld Glm | GLACCTVLD |
| |||||||||||||||||||||||||||||||||||||||
Glacctvld Sys | GLACCTVLD |
| |||||||||||||||||||||||||||||||||||||||
Glcommit | GLCOMMIT |
| |||||||||||||||||||||||||||||||||||||||
Glcommitx | GLCOMMITX |
| |||||||||||||||||||||||||||||||||||||||
Glhistcom | GLHISTCOM |
| |||||||||||||||||||||||||||||||||||||||
Othr Acct Unit | GLMASTER |
| |||||||||||||||||||||||||||||||||||||||
Trans All Prds | GLTRANS |
| |||||||||||||||||||||||||||||||||||||||
Transactions | GLTRANS |
| |||||||||||||||||||||||||||||||||||||||
Units | GLUNITS |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.