GLMASTER – General Ledger Account Master
- System
- General Ledger Setup (IF)
- Prefix
GLM- Primary key
COMPANY,ACCOUNT,SUB-ACCOUNT,VAR-LEVELS,ACCT-UNIT- Fields
- 41
- Updated by
- 144 programs
- Referenced by
- 396 programs
GLMASTER is the General Ledger Account Master table in Lawson General Ledger Setup (prefix GLM). It is indexed by COMPANY, ACCOUNT, SUB-ACCOUNT, VAR-LEVELS, ACCT-UNIT (GLMSET1); alternate indexes: GLMSET2, GLMSET3, GLMSET5, GLMSET6, GLMSET7, GLMSET8 and GLMSET9. It is related 1:1 to GLNAMES, FBDETAIL, GLCHARTDTL, GLSYSTEM, GLCONSOL, CUCODES, GLMSTBOD, POCOMPANY and 3 more and 1:M to GLAMOUNTS, FBDETAIL, CUAMOUNT, CUAMOUNTX, GLAMOUNTSX, GLACCTVLD, GLCOMMIT, GLCOMMITX and 5 more. It is updated by AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 136 more and referenced by AC121, AC123, AC130, AC131, AC20.1, AC20.2, AC20.3, AC20.4 and 388 more. The table has 41 fields, 8 indexes and 36 documented relations.
About GLMASTER
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.
Fields (41)
Column = COBOL field name without the GLM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GLM-COMPANY PKCOMPANY | Numeric 4 | The company number. | AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
GLM-VAR-LEVELS PKVAR_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. | AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
GLM-ACCT-UNIT PKACCT_UNIT | Alpha 15 | The accounting unit is a shorthand notation representing the variable level number. | AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
GLM-OLD-COMPANY-DOLD_COMPANY_D | Derived | Contains the old company derived. | — |
GLM-ACCOUNT PKACCOUNT | Numeric 6 | This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. | AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
GLM-SUB-ACCOUNT PKSUB_ACCOUNT | Numeric 4 | This field along with the accounting unit and account make up the location (account) where amounts and other account information are stored. | AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
GLM-OLD-ACCT-NBR-DOLD_ACCT_NBR_D | Derived | Contains the derived old account number. | — |
GLM-ACTIVE-STATUSACTIVE_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
| GL121, GL122, GL124, GL167, GL20.2, ML167 |
GLM-STATUS-DERIVEDSTATUS_DERIVED | Derived | Contains the derived status. | — |
GLM-ACCT-NDACCT_ND | Numeric 1 | Account amount decimal positions. | AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
GLM-UNITS-CODEUNITS_CODE | Alpha 1 | Required if a detail-type account. This field indicates if units are allowed, not allowed, or only allowed. " " = Default
| GL121, GL122, GL124, GL146, GL167, GL190, GL197, GL20.2 +17 more |
GLM-UNITS-DERIVEDUNITS_DERIVED | Derived | Contains the derived units. | — |
GLM-AVG-DAILY-BALAVG_DAILY_BAL | Alpha 1 | Yes value indicates the account is used for calculating average daily balance. " " = No
| GL121, GL122, GL20.2 |
GLM-ACTIVITY-REQACTIVITY_REQ | Alpha 1 | Indicates if an Activity code is required. " " = Default
| GL121, GL122, GL124, GL20.2 |
GLM-GLINTCO-STATGLINTCO_STAT | 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. | CU03.1, FB35.1, GL110, GL121, GL20.4, GL25.1, GL30.1 |
GLM-POSTING-LEVELPOSTING_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
| GL121, GL122, GL124, GL20.2 |
GLM-OPTION-FLD-1OPTION_FLD_1 | Alpha 2 (Lower Case) | Free-form field used to store any information relevant to an account. This field is used for reporting purposes. | GL121, GL122, GL124, GL167, GL20.2, ML167, RW100 |
GLM-OPTION-FLD-2OPTION_FLD_2 | Alpha 7 (Lower Case) | Free-form field used to store information relevant to an account. This field is used for reporting purposes. | GL121, GL122, GL124, GL167, GL20.2, ML167, RW100 |
GLM-OPTION-FLD-3OPTION_FLD_3 | Alpha 12 (Lower Case) | Free-form field used to store any information relevant to an account. This field is used for reporting purposes. | GL121, GL122, GL124, GL167, GL20.2, ML167, RW100 |
GLM-TRANSL-CODETRANSL_CODE | Alpha 2 | Contains the translation code. | FB145, FB190, FB195, FB40.1, FB40.2, FB40.3, FB45.1, GL121 +14 more |
GLM-CURRENCY-CODECURRENCY_CODE | Alpha 5 | The company base currency code. | AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
GLM-CURR-CONTROLCURR_CONTROL | Alpha 1 | Flag used to allow posting to the account in currencies other than the account currency. " " = Default
| GL121, GL122, GL124, GL20.2 |
GLM-REVALUEREVALUE | Alpha 1 | Determines whether or not this account will participate in the revaluation process. " " = Default
| GL121, GL122, GL124, GL20.2 |
GLM-DATE-ENTEREDDATE_ENTERED | Numeric 8 (yyyymmdd) | Date used to document account changes. | AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
GLM-CHART-NAMECHART_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. | AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
GLM-BASE-CURRENCYBASE_CURRENCY | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
GLM-RESTRICT-SYSRESTRICT_SYS | Alpha 1 | Indicates if system codes are validated each time the account is used by a system. " " = Default
| GL03.6, GL121, GL122, GL124, GL20.2 |
GLM-ACCT-CATEGORYACCT_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 | GL121, GL122, GL124, GL20.2 |
GLM-DER-X-SYSDER_X_SYS | Derived | Indicates if system restrictions exist for an account. | — |
GLM-SUMM-ACCT-IDSUMM_ACCT_ID | Derived | The summary account ID. | — |
GLM-ACCT-DESCACCT_DESC | Derived | This is the account description. | — |
GLM-BLANKBLANK | Derived | This derived field is always blank. It is used in the Drill Around feature for column headings. | — |
GLM-CUCODE-DESCCUCODE_DESC | Derived | This is the currency code description. | — |
GLM-SL-ACCT-FLAGSL_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. " " = Default
| GL122, GL20.2 |
GLM-RELATIONRELATION | 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). | GL122, GL20.2 |
GLM-LEDGER-GROUPLEDGER_GROUP | Alpha 15 | — | GL122, GL20.2 |
GLM-GL-BUD-FLGL_BUD_FL | Alpha 1 | This is the Yes/No flag for budget editing. " " = Default
| GL122, GL20.2 |
GLM-CREATED-BYCREATED_BY | Alpha 10 | — | AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
GLM-LAST-UPDT-DATELAST_UPDT_DATE | Numeric 8 (yyyymmdd) | — | AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
GLM-LAST-UPDT-TIMELAST_UPDT_TIME | Numeric 8 | — | AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
GLM-LAST-UPDATE-BYLAST_UPDATE_BY | Alpha 10 | — | AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
Indexes (8)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GLMSET1 | COMPANY, ACCOUNT, SUB-ACCOUNT, VAR-LEVELS, ACCT-UNIT | Primary | AC121, AC123, AC130, AC191, AC20.1, AC20.2, AC20.3, AC20.4 +22 more (list truncated in source) | |
GLMSET2 | COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT | AC131, AC191, AD190, AD191, AD220, AM19.1, AM19.2, AP115 +22 more (list truncated in source) | ||
GLMSET3 | COMPANY, ACCOUNT, SUB-ACCOUNT, ACCT-UNIT | FB20.3, GL120, GL50.4, RW100, GL121, GL20.4, GL222, ML50.4 | ||
GLMSET5 | COMPANY, VAR-LEVELS, ACCOUNT, SUB-ACCOUNT, ACCT-UNIT | CA110, FB11.1, FB111, FB120, FB160, FB211, FB296, FB60.1 +22 more (list truncated in source) | ||
GLMSET6 | VAR-LEVELS, ACCOUNT, SUB-ACCOUNT, COMPANY, ACCT-UNIT | GLRV.1 | ||
GLMSET7 | ACCOUNT, SUB-ACCOUNT, VAR-LEVELS, COMPANY, ACCT-UNIT | FB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 +22 more (list truncated in source) | ||
GLMSET8 | CHART-NAME, ACCOUNT, SUB-ACCOUNT, COMPANY, ACCT-UNIT | KeyChange | AC191, AC40.4, AC41.4, AC42.1, AP125, AP126, AP131, AP170 +22 more (list truncated in source) | |
GLMSET9 | LEDGER-GROUP, COMPANY, ACCOUNT, SUB-ACCOUNT, VAR-LEVELS, ACCT-UNIT | KeyChange, Subset | Where LEDGER-GROUP != Spaces | ML11.1 |
Relations
One to one (14) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Accountunit | GLNAMES | Required | GLM-COMPANY → -COMPANY, GLM-ACCT-UNIT → -ACCT-UNIT | |
| Acct Unit | GLNAMES | Required | GLM-COMPANY → GLN-COMPANY, GLM-ACCT-UNIT → GLN-ACCT-UNIT | |
| Budget 1 | FBDETAIL | Not Required | GLM-COMPANY → FBD-COMPANY, GLS-FISCAL-YEAR → FBD-FISCAL-YEAR, 1 → FBD-BUDGET-NBR, GLM-ACCT-UNIT → FBD-ACCT-UNIT, GLM-ACCOUNT → FBD-ACCOUNT, GLM-SUB-ACCOUNT → FBD-SUB-ACCOUNT | |
| Chart Detail | GLCHARTDTL | Required | GLM-CHART-NAME → GDT-CHART-NAME, GLM-ACCOUNT → GDT-ACCOUNT, GLM-SUB-ACCOUNT → GDT-SUB-ACCOUNT | |
| Company | GLSYSTEM | Required | GLM-COMPANY → GLS-COMPANY | |
| Consol | GLCONSOL | Not Required | GLS-FISCAL-YEAR → GCN-FISCAL-YEAR, Zeroes → GCN-LEVEL-DEPTH, Zeroes → GCN-BUDGET-NBR, "A" → GCN-TRANS-TYPE, GLM-COMPANY → GCN-COMPANY, Spaces → GCN-VAR-LEVELS, GLM-ACCOUNT → GCN-ACCOUNT, GLM-SUB-ACCOUNT → GCN-SUB-ACCOUNT, Spaces → GCN-CURRENCY-CODE | |
| Cucodes | CUCODES | Required | GLM-CURRENCY-CODE → CUC-CURRENCY-CODE | |
| Glmstbod | GLMSTBOD | Not Required, Delete Cascades | GLM-COMPANY → YBW-COMPANY, GLM-ACCOUNT → YBW-ACCOUNT, GLM-SUB-ACCOUNT → YBW-SUB-ACCOUNT, GLM-VAR-LEVELS → YBW-VAR-LEVELS, GLM-ACCT-UNIT → YBW-ACCT-UNIT | |
| Pocompany | POCOMPANY | Not Required | GLM-COMPANY → PCY-COMPANY | |
| Procuregrp | PROCUREGRP | Not Required | PCY-PROCURE-GROUP → PCG-PROCURE-GROUP | |
| Summary Acct | GLCHARTSUM | Required | GLM-CHART-NAME → GCS-CHART-NAME, GDT-SUMRY-ACCT-ID → GCS-SUMRY-ACCT-ID | |
| Trcodes | TRCODES | Required | When GLM-TRANSL-CODE = Spaces | GLM-TRANSL-CODE → TRC-TRANSL-CODE |
| Var Levels | GLNAMES | Required | GLM-COMPANY → GLN-COMPANY, GLM-VAR-LEVELS → GLN-VAR-LEVELS, GLM-ACCT-UNIT → GLN-ACCT-UNIT | |
| Variablelevel | GLNAMES | Required | GLM-COMPANY → GLN-COMPANY, GLM-VAR-LEVELS → GLN-VAR-LEVELS, GLM-ACCT-UNIT → GLN-ACCT-UNIT |
One to many (22) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Amounts | GLAMOUNTS | Delete Restricted | GLM-COMPANY → GAM-COMPANY, GLM-ACCT-UNIT → GAM-ACCT-UNIT, GLM-ACCOUNT → GAM-ACCOUNT, GLM-SUB-ACCOUNT → GAM-SUB-ACCOUNT, → GAM-FISCAL-YEAR | |
| Budget All | FBDETAIL | Delete Restricted | GLM-COMPANY → FBD-COMPANY, GLM-ACCT-UNIT → FBD-ACCT-UNIT, GLM-ACCOUNT → FBD-ACCOUNT, GLM-SUB-ACCOUNT → FBD-SUB-ACCOUNT, → FBD-BUDGET-NBR, → FBD-FISCAL-YEAR | |
| Budgets | FBDETAIL | Delete Restricted | GLM-COMPANY → FBD-COMPANY, GLM-ACCT-UNIT → FBD-ACCT-UNIT, GLM-ACCOUNT → FBD-ACCOUNT, GLM-SUB-ACCOUNT → FBD-SUB-ACCOUNT, → FBD-BUDGET-NBR, → FBD-FISCAL-YEAR | |
| Cuamount1 | CUAMOUNT | Delete Cascades | GLM-COMPANY → CAM-COMPANY, GLM-ACCT-UNIT → CAM-ACCT-UNIT, GLM-ACCOUNT → CAM-ACCOUNT, GLM-SUB-ACCOUNT → CAM-SUB-ACCOUNT, 1 → CAM-AMT-TYPE, GLM-CURRENCY-CODE → CAM-CURRENCY-CODE, → CAM-FISCAL-YEAR, → CAM-VAR-LEVELS | |
| Cuamount2 | CUAMOUNT | Delete Cascades | GLM-COMPANY → CAM-COMPANY, GLM-ACCT-UNIT → CAM-ACCT-UNIT, GLM-ACCOUNT → CAM-ACCOUNT, GLM-SUB-ACCOUNT → CAM-SUB-ACCOUNT, 2 → CAM-AMT-TYPE, → CAM-CURRENCY-CODE, → CAM-FISCAL-YEAR, → CAM-VAR-LEVELS | |
| Cuamount3 | CUAMOUNT | Delete Cascades | GLM-COMPANY → CAM-COMPANY, GLM-ACCT-UNIT → CAM-ACCT-UNIT, GLM-ACCOUNT → CAM-ACCOUNT, GLM-SUB-ACCOUNT → CAM-SUB-ACCOUNT, 3 → CAM-AMT-TYPE, GLS-CURR-CODE-1 → CAM-CURRENCY-CODE, → CAM-FISCAL-YEAR, → CAM-VAR-LEVELS | |
| Cuamount4 | CUAMOUNT | Delete Cascades | GLM-COMPANY → CAM-COMPANY, GLM-ACCT-UNIT → CAM-ACCT-UNIT, GLM-ACCOUNT → CAM-ACCOUNT, GLM-SUB-ACCOUNT → CAM-SUB-ACCOUNT, 4 → CAM-AMT-TYPE, GLS-CURR-CODE-2 → CAM-CURRENCY-CODE, → CAM-FISCAL-YEAR, → CAM-VAR-LEVELS | |
| Cuamountx 3 | CUAMOUNTX | GLM-COMPANY → CAX-COMPANY, 3 → CAX-AMT-TYPE, GLM-ACCT-UNIT → CAX-ACCT-UNIT, GLM-ACCOUNT → CAX-ACCOUNT, GLM-SUB-ACCOUNT → CAX-SUB-ACCOUNT, → CAX-DATE | ||
| Cuamountx 4 | CUAMOUNTX | GLM-COMPANY → CAX-COMPANY, 4 → CAX-AMT-TYPE, GLM-ACCT-UNIT → CAX-ACCT-UNIT, GLM-ACCOUNT → CAX-ACCOUNT, GLM-SUB-ACCOUNT → CAX-SUB-ACCOUNT, → CAX-DATE | ||
| Dailytrans | GLAMOUNTSX | GLM-COMPANY → GAX-COMPANY, GLM-ACCT-UNIT → GAX-ACCT-UNIT, GLM-ACCOUNT → GAX-ACCOUNT, GLM-SUB-ACCOUNT → GAX-SUB-ACCOUNT, → GAX-DATE | ||
| Glacctvld Gcs | GLACCTVLD | "S" → VLD-RECORD-TYPE, GLS-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 Gdt | GLACCTVLD | GLS-CHART-NAME → VLD-CHART-NAME, GLM-ACCOUNT → VLD-ACCOUNT, GLM-SUB-ACCOUNT → VLD-SUB-ACCOUNT, → VLD-SYSTEM | ||
| Glacctvld Glm | GLACCTVLD | GLM-COMPANY → VLD-COMPANY, GLM-ACCT-UNIT → VLD-ACCT-UNIT, GLM-ACCOUNT → VLD-ACCOUNT, GLM-SUB-ACCOUNT → VLD-SUB-ACCOUNT, → VLD-SYSTEM | ||
| Glacctvld Sys | GLACCTVLD | "M" → VLD-RECORD-TYPE, GLM-CHART-NAME → VLD-CHART-NAME, GDT-SUMRY-ACCT-ID → VLD-SUMRY-ACCT-ID, GLM-ACCOUNT → VLD-ACCOUNT, GLM-SUB-ACCOUNT → VLD-SUB-ACCOUNT, GLM-COMPANY → VLD-COMPANY, GLM-ACCT-UNIT → VLD-ACCT-UNIT, → VLD-SYSTEM | ||
| Glcommit | GLCOMMIT | GLM-COMPANY → GOT-COMPANY, GLM-ACCT-UNIT → GOT-ACCT-UNIT, GLM-ACCOUNT → GOT-ACCOUNT, GLM-SUB-ACCOUNT → GOT-SUB-ACCOUNT, → GOT-FISCAL-YEAR, → GOT-SYSTEM | ||
| Glcommitx | GLCOMMITX | GLM-COMPANY → GOX-COMPANY, GLM-ACCT-UNIT → GOX-ACCT-UNIT, GLM-ACCOUNT → GOX-ACCOUNT, GLM-SUB-ACCOUNT → GOX-SUB-ACCOUNT, → GOX-FISCAL-YEAR, → GOX-PERIOD, → GOX-SYSTEM, → GOX-CURRENCY-CODE, → GOX-GLT-OBJ-ID | ||
| Glhistcom | GLHISTCOM | GLM-COMPANY → GHT-COMPANY, GLM-ACCT-UNIT → GHT-ACCT-UNIT, GLM-ACCOUNT → GHT-ACCOUNT, GLM-SUB-ACCOUNT → GHT-SUB-ACCOUNT, → GHT-YEAR, → GHT-SYSTEM, → GHT-UNIQUE-I-D | ||
| Glmasterua | GLMASTERAU | GLM-COMPANY → GLK-COMPANY, GLM-ACCT-UNIT → GLK-ACCT-UNIT, GLM-ACCOUNT → GLK-ACCOUNT, GLM-SUB-ACCOUNT → GLK-SUB-ACCOUNT, → GLK-ACTION, → GLK-DATE, → GLK-TIME, → GLK-UNIQUE-I-D | ||
| Othr Acct Unit | GLMASTER | GLM-COMPANY → GLM-COMPANY, GLM-ACCOUNT → GLM-ACCOUNT, GLM-SUB-ACCOUNT → GLM-SUB-ACCOUNT, → GLM-VAR-LEVELS, → GLM-ACCT-UNIT | ||
| Trans All Prds | GLTRANS | GLM-COMPANY → GLT-TO-COMPANY, GLM-ACCOUNT → GLT-ACCOUNT, GLM-SUB-ACCOUNT → GLT-SUB-ACCOUNT, GLM-ACCT-UNIT → GLT-ACCT-UNIT, GLS-FISCAL-YEAR → GLT-FISCAL-YEAR, → GLT-ACCT-PERIOD, → GLT-SYSTEM, → GLT-CONTROL-GROUP, → GLT-JE-TYPE, → GLT-JE-SEQUENCE, → GLT-LINE-NBR, → GLT-COMPANY | ||
| Transactions | GLTRANS | GLM-COMPANY → GLT-TO-COMPANY, GLS-FISCAL-YEAR → GLT-FISCAL-YEAR, GLS-ACCT-PERIOD → GLT-ACCT-PERIOD, GLM-ACCT-UNIT → GLT-ACCT-UNIT, GLM-ACCOUNT → GLT-ACCOUNT, GLM-SUB-ACCOUNT → GLT-SUB-ACCOUNT, → GLT-POSTING-DATE, → GLT-SYSTEM, → GLT-CONTROL-GROUP, → GLT-JE-TYPE, → GLT-LINE-NBR, → GLT-COMPANY, → GLT-JE-SEQUENCE | ||
| Units | GLUNITS | Delete Restricted | GLM-COMPANY → GLU-COMPANY, GLM-ACCOUNT → GLU-ACCOUNT, GLM-SUB-ACCOUNT → GLU-SUB-ACCOUNT, GLM-VAR-LEVELS → GLU-VAR-LEVELS, GLM-ACCT-UNIT → GLU-ACCT-UNIT, → GLU-FISCAL-YEAR |
Programs
Updated by (144)
- AC191 Accounting Unit Balance Post
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- API1.1 Add Invoice
- API2.1 Add Invoice
- BR44.1 Mass Transaction Transfer
- CB222 Cash Position Reconciliation
- CU03.1 Currency Gain Loss Accounts
- DR100 Distribution Requirements Report
- FB11.1 Budget Edit Group
- FB111 Budget Edit Group Build
- FB160 Budget Edit Group Interface
- FB211 Budget Edit Group Listing
- FB296 Budget Audit
- FB35.1 Interbudget Relationships
- FB45.1 Budget Journal Control
- FB60.1 Budget Edit Group Interface Maintenance
- FB95.1 Budget Analysis
- FB95.2 Account, Period
- FB95.3 Account, Year to Date
- FB95.4 Accounting Unit, Period
- FB95.5 Accounting Unit, Year to Date
- FB95.6 Totals
- GL03.6 Posting Account System Restriction
- GL110 Company Copy Delete
- GL120 Level Reorganization
- GL121 Mass Account Addition
- GL122 Mass Account Change Delete
- GL124 Mass Accounting Unit Addition
- GL135 Intercompany Chart Map Posting
- GL146 Batch Journal Control
- GL167 Balance Interface
- GL190 Journal Posting
- GL195 Translation Calculation
- GL196 Report Currency Translation
- GL197 Period, Year End GL Commitments Processing
- GL199 Period Closing
- GL20.2 Posting Accounts
- GL20.4 Mass Add Accounts
- GL25.1 Intercompany Relationships
- GL298 GL Commitment Analysis Report
- GL299 GL and AC History commitment
- GL30.1 Interzone Relationships
- GL330 Undistributed Retained Earnings Rebuild
- GL40.1 Journal Entry
- GL40.2 Define Journal
- GL40.3 Speed Entry
- GL40.7 Totals
- GL40.8 Journal Entry
- GL44.1 Report Currency Entry
- GL45.1 Journal Control
- GL500 Fiscal Year Change
- GL90.6 Compare Transaction Analysis
- GL94.1 Commitment Analysis
- GL94.2 Account
- GL94.3 Account Totals
- GL94.4 Accounting Unit
- GL94.5 Accounting Unit Totals
- GL94.6 Commitment Account Detail
- GL94.7 Commitment Accounting Unit Detail
- GL95.1 Account Analysis
- GL95.2 Fiscal Year Summary
- GL95.3 Totals
- GL95.4 Chart Query
- GL95.5 Periods versus Year to Date
- GL95.6 Year to Date Current Year versus Last Year
- GL95.7 Periods Current Year versus Last Year
- GL95.8 Year to Date Actual versus Budget
- GL95.9 Periods Actual versus Budget
- GL96.1 Accounting Units
- GL96.2 Year to Date Current Year versus Last Year
- GL96.3 Periods Current Year versus Last Year
- GL96.4 Year to Date Actual versus Budget
- GL96.5 Periods Actual versus Budget
- GL97.1 Accounts
- GL97.2 Year to Date Current Year versus Last Year
- GL97.3 Periods Current Year versus Last Year
- GL97.4 Year to Date Actual versus Budget
- GL97.5 Periods Actual versus Budget
- GL97.6 Year to Date Account Currencies
- GL97.7 Periods Account Currencies
- GL97.8 Fiscal Year Summary
- GL97.9 Totals
- GL98.1 Companies
- GL98.2 Year to Date Current Year versus Last Year
- GL98.3 Periods Current Year versus Last Year
- GL98.4 Year to Date Actual versus Budget
- GL98.5 Periods Actual versus Budget
- GL99.1 Organization Query
- GL99.2 Periods versus Year to Date
- GL99.3 Year to Date Current Year versus Last Year
- GL99.4 Periods Current Year versus Last Year
- GL99.5 Year to Date Actual versus Budget
- GL99.6 Periods Actual versus Budget
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC222 Unreleased Documents
- IC83.1 Par Location Counts
- IFAC.1 General Ledger Account Edit
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.2 Memo Line AOC Detail
- MA43.2 Purchase Order Lookup
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA61.1 Match Invoice Approval
- MAI1.1 Invoke for MAMATCH Object
- ML146 Batch Ledger Journal Control
- ML167 Ledger Balance Interface
- ML190 Ledger Journal Posting
- ML195 Ledger Translation Calculation
- ML196 Ledger Report Currency Translation
- ML199 Ledger Period Closing
- ML330 Ledger Undistributed RE Rebuil
- ML40.1 Ledger Journal Entry
- ML40.2 Define Ledger Journal
- ML40.3 Ledger Speed Entry
- ML40.7 Ledger Totals
- ML40.8 Ledger Journal Entry
- ML44.1 Ledger Report Currency Entry
- ML45.1 Ledger Journal Control
- RQ10.1 Requisition
- RQ10.3 Select and Copy
- RQ11.1 Kit Accessories
- RQ13.2 Direct Line Approval
- RQ35.1 Requisition Returns
- RQ500 Requisition Interface
- RQIB.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQIJ.1 Requisition Copy
Referenced by (396)
- AC121 Budget Calculation
- AC123 Budget Copy
- AC130 Allocation Calculation
- AC131 Allocation Update
- AC20.1 Life Only Budget
- AC20.2 Annual Budget
- AC20.3 Period Budget
- AC20.4 Activity Budgets by Activity
- AC20.5 Activity Budgets by Account Category
- AC32.1 Allocation Pool
- AC37.1 Allocation Group
- AC40.4 Journal Entry (AC and GL)
- AC41.4 Resource Time Entry (AC and GL)
- AC42.1 Subcontractor Time and Material Entry
- AC490 Activity Reconciliation
- ACVW.1 Build GL Accounting Unit View
- AD190 Transaction Posting
- AD191 Cost of Funds
- AD220 Account Listing
- AM180 Depreciation Calculation and Listing
- AM19.1 PO Line Asset Detail
- AM19.2 Create Detail
- AP115 Vendor Merge
- AP131 Chargeback
- AP170 Payment Closing
- AP193 Recurring Invoice Update
- AP220 Invoice Edit Report
- AP30.2 Distribution Adjustments
- AP30.4 Invoice Cancel
- AP305 Accounts Payable Company Purge
- AP510 Vendor Conversion
- AP520 Invoice Interface
- ATVW.1 Build Account Category View
- BR41.4 Contract Adjustment (AC and GL)
- CA10.1 Allocation
- CA10.4 Line Copy
- CA10.5 Allocation Calculation
- CA10.7 Allocation Detail
- CA110 Allocation Calculation
- CB10.1 Cash Receipt Deposit
- CB15.1 Bank Fund Transfer - Multiple Deposits
- CB15.2 Bank Fund Transfer - Multiple Withdrawals
- CB150 Mass Release
- CB191 Bank Statement Close
- CB20.1 Bank Transaction Entry
- CB30.1 Reconciliation Variance Adjustment
- CB45.1 EFT/CC Extract Entry
- CB46.1 Returned Payment Entry
- CB500 Bank Transaction Interface
- CB543 Receipts Load
- CB544 Returned Payment Load
- CB55.1 Payment Entry
- CB554 Payment Load
- CU00.1 Currency Table
- CU01.1 Currency Code
- CU01.2 Currency Codes
- CU02.1 Currency Relationship
- CU02.2 Relationship Summary
- CU10.1 Exchange Rates
- CU10.2 Daily Rate Entry
- CU20.1 Currency Table Translation Rates
- CU20.2 Currency Table Period Rate Entry
- CU20.3 Company Translation Rates
- CX100 Pick List Print
- CX20.1 Case Build
- CX20.2 Case Detail
- CX20.4 Substitute Items
- CX20.5 Insert line
- CX220 Case, Preference Listing
- CX30.1 Case Completion Feedback
- CX300 Preference List Purge
- CX506 HL7 Schedules Import Interface
- CXCP.1 Copy preference to case
- EE135 Mass Employee Release
- EE35.1 Advance Release
- EE35.2 Expense Release
- EE520 Expense Interface
- EX545 Advance Payback Creation
- FB100 Budget Calculation - Computes
- FB120 Intracompany Mass Budgeting
- FB145 Budget Batch Journal Control
- FB190 Budget Double Entry Posting
- FB195 Translation Calculation
- FB20.1 Period Budget, Rate
- FB20.3 By Account
- FB20.4 By Accounting Unit
- FB20.6 Period Budget, Amounts
- FB20.7 Period Budget, Units
- FB21.1 Budget by Period
- FB40.1 Budget Journal Entry
- FB40.2 Define Budget Journal
- FB40.3 Budget Speed Entry
- GL00.1 Chart of Accounts
- GL00.2 Define Chart
- GL00.3 Detail Accounts
- GL00.6 Move Detail Account
- GL00.7 System Accounts
- GL00.8 Rename Summary Account
- GL00.9 Chart Copy
- GL02.1 Detail Subaccount Definition
- GL02.2 Multiple Detail Subaccount Definition
- GL02.3 Template Subaccount Definition
- GL02.6 Move Detail Account
- GL10.1 Company
- GL10.2 Backposting Control
- GL100 Mass Chart Account Change Delete
- GL111 Backposting Control Mass Upd
- GL125 Mass Accounting Unit Change
- GL130 Chart Map Creation
- GL14.8 Copy Accounting Unit Template
- GL141 Consolidation Unload
- GL148 Zone Rebalancing
- GL160 Chart of Accounts Interface
- GL161 Accounting Unit Interface
- GL165 Transaction Interface
- GL170 Recurring Journal Interface
- GL191 Currency Revaluation
- GL194 Update IncomeStatement Beg Bal
- GL221 Posting Accounts Listing
- GL222 Posting Accounts Listing by Account
- GL281 French Trial Balance
- GL288 GL Grand Livre Report - Period
- GL291 Trial Balance
- GL35.1 Chart Map Maintenance
- GL38.1 Recurring Journal Interface
- GL50.4 Filters
- GL65.1 Transaction Interface Maintenance
- GL70.1 Recurring Journal
- GL70.2 Define Recurring Journal
- GL70.3 Amounts Only
- GL70.5 Filter
- GL70.6 Recurring Copy
- GL75.1 Recurring Journal Control
- GL76.1 Manual Commitment Entry
- GL93.1 Historical Commitment Analysis
- GLAV.1 Build GL Accounting Unit View
- GLCV.1 General Ledger Chart View Build
- GLRV.1 General Ledger Report
- GLVW.1 Build GL Accounting Unit View
- HGLM.1 Account Selection Invoke
- IC02.1 Location
- IC12.1 Item Location
- IC130 General Ledger Interface
- IC140 Vendor Reorder Advice
- IC145 Stock Status Report
- IC243 Killed Item Report
- IC330 Item Mass Change
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC66.1 Replenishment PO Worksheet
- IFBD.2 IF BOD Inquiry
- IFEB.1 GL and AC Budget Edit
- MA126 Auto Matching
- MA180 Open Receipt Archive
- MA26.1 PO Invoice Match
- MA278 Cost Variance Analysis
- MA53.1 Receipt Interface
- MA530 ERS Invoice Creation
- MA531 Receipt Interface
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.5 Receipt Match Reference Adjustment
- MA63.1 Invoice Line Match
- MA65.1 Invoice Line Adjustment
- MA66.2 Invoice Message - Details
- MA67.2 Invoice Match from frontend
- MA67.3 Detail Match from frontend
- MA68.2 Invoice Level Match - Prepaid
- MA68.3 Detail Level Match - Prepaid
- MA68.5 Receipt Match Reference Adjustment
- MA69.1 AOC Level Detail Match
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MA80.1 Receipt Archive
- ML11.1 Ledger Group
- ML165 Ledger Transaction Interface
- ML170 Ledger Recurring Journal Interface
- ML191 Ledger Currency Revaluation
- ML291 Ledger Trial Balance
- ML50.4 Filters
- ML65.1 Ledger Transaction Interface Maintenance
- ML70.1 Ledger Recurring Journal
- ML70.2 Define Recurring Journal
- ML70.3 Amounts Only
- ML70.5 Filter
- ML70.6 Ledger Recurring Copy
- ML75.1 Ledger Recurring Journal Control
- ML90.1 Ledger Transaction Analysis
- ML90.2 Ledger Transaction Totals
- ML90.4 Reconcile Ledger Transactions
- ML90.5 Nulls
- ML94.1 Ytd Ml and Gl Actuals
- ML94.2 Period ML and GL Actuals
- ML94.3 YTD ML and GL Actuals
- ML94.4 Period ML and GL Actuals
- ML95.1 Ledger Account Analysis
- ML95.2 Fiscal Year Summary
- ML95.3 Totals
- ML95.4 Ledger Chart Query
- ML95.5 Periods vs. YTD
- ML95.6 YTD Current Year vs. Last Year
- ML95.7 Periods Current Year vs. Last Year
- ML95.8 YTD Actual vs. Budget
- ML95.9 Periods Actual vs. Budget
- ML96.1 Accounting Units
- ML96.2 YTD Current Year vs. Last Year
- ML96.3 Periods Current Year vs. Last Year
- ML96.4 YTD Actual vs. Budget
- ML96.5 Periods Actual vs. Budget
- ML97.1 Accounts
- ML97.2 YTD Current Year vs. Last Year
- ML97.3 Periods Current Year vs. Last Year
- ML97.4 YTD Actual vs. Budget
- ML97.5 Periods Actual vs. Budget
- ML97.6 YTD Account Currencies
- ML97.7 Periods Account Currencies
- ML97.8 Fiscal Year Summary
- ML97.9 Totals
- ML98.1 Companies
- ML98.2 YTD Current Year vs. Last Year
- ML98.3 Periods Current Year vs. Last Year
- ML98.4 YTD Actual vs. Budget
- ML98.5 Periods Actual vs. Budget
- ML99.1 Organization Query
- ML99.2 Periods vs. YTD
- ML99.3 YTD Current Year vs. Last Year
- ML99.4 Periods Current Year vs. Last Year
- ML99.5 YTD Actual vs. Budget
- ML99.6 Periods Actual vs. Budget
- MX135 Acct Unit Attribute Value Update For Effective Date
- PD10.1 P-Card Card Request
- PD10.2 P-Card Cardholder
- PD130 P-Card Invoice and Release
- PD20.1 P-Card Charge Approval
- PD20.2 P-Card Charge Approval Level
- PD20.3 P-Card Charge Approval SEA
- PD22.1 P-Card Charge Accounts
- PD570 P-Card Charge Import
- PO04.1 Buyer
- PO04.2 Buyer Purchasing Class
- PO10.1 PO Vendor
- PO10.2 Vendor Purchase From Location
- PO100 Purchase Order Interface from Lawson Applications
- PO101 Create Standing PO Release
- PO115 Procurement Template Mass Changes
- PO120 Mass PO Issue
- PO122 Transmitted PO Acknowledgement
- PO131 Receiving Log
- PO132 Print Vendor Return Material Authorization
- PO135 Received, Not Invoiced Report
- PO136 Matched, Not Received Report
- PO15.1 Procurement Templates
- PO15.2 Procurement Template Participants
- PO15.4 Procurement Template Line Detail
- PO150 Bid Load to Contract or Catalog
- PO17.1 Purchase Order Approval Review
- PO190 Close Purchase Order Header
- PO20.1 Purchase Order Entry
- PO20.4 Line Defaults
- PO20.6 Substitute Vendor Items
- PO20.9 Multiple Lines
- PO204 Buyer Master Listing
- PO21.1 Select and Copy
- PO21.2 Add-On Cost Spread
- PO21.3 Account Distribution
- PO21.4 Miscellaneous Add-On Cost
- PO21.5 Item Add-On Cost
- PO22.1 Authorization, Release
- PO22.3 Mass Cancel or Delete Purchase Orders
- PO22.4 Mass Cancel or Delete Purchase Order Lines
- PO220 PO Status Report
- PO222 Remaining PO Balance Report
- PO224 PO Revision Report
- PO225 Vendor Agreement Listing
- PO229 Vendor Agreement Format Print
- PO23.1 Purchase Order Worksheet
- PO230 Unreleased Receivings Listing
- PO234 PO Interface Listing Report
- PO24.1 Purchase Order Direct Approval
- PO25.1 Vendor Agreements
- PO25.5 Vendor Agreement Item Add-On Cost
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO251 PO Buyer Message Listing
- PO26.1 Message Review
- PO26.2 Vendor Agreement Line Distributions
- PO26.3 Vendor Agreement Commitments Spread
- PO26.4 Vendor Agreement Line Price Breaks
- PO26.5 Vendor Agreement Line Price Breaks
- PO26.6 Vendor Agreement Line Maximums
- PO26.7 Mass Release of Vendor Agreements
- PO26.9 Vendor Agreement Release
- PO27.2 Select Blanket Lines
- PO27.3 Create PO From Procurement Template
- PO27.4 Select and Copy Template
- PO275 Delivery Date Analysis
- PO276 Deliver Quantity Analysis
- PO277 Deliver Quality Analysis
- PO28.2 Vendor Agreement Line Detail List
- PO280 Purchases By Class
- PO29.1 Copy Purchase Order
- PO30.1 PO Receiving
- PO30.2 Substitute Item
- PO30.3 Additional Tracking Numbers
- PO30.4 PO Receiving Line Detail List
- PO300 PO and Receipt Purge
- PO31.1 Vendor Return
- PO31.2 Vendor Return Item Selection
- PO32.1 GL distribution for returns
- PO32.2 Item Detail
- PO32.4 Cancel Detail
- PO33.1 Receiving Adjustment
- PO34.1 Inspection Accept or Reject
- PO35.1 Receiving Approval and Release
- PO36.1 Identify Lawson Items by Vendor Agreement Line
- PO36.2 Vendor Agreement Import Manual Input
- PO38.1 Invoice AOC
- PO39.1 Additional Receiving Entry
- PO39.2 Additional Adjustment/Rejection Entry
- PO44.1 PO Line Source
- PO50.1 Buyer Message Entry
- PO52.1 Buyer Message - Receiving
- PO520 Purchase Order Interface from Non Lawson
- PO536 Vendor Price Agreement Load
- PO54.5 PO Line Detail List
- POCP.1 POC Comments Copy
- POI3.1 Invoke for POPI70PD
- POID.1 PO Delivery Ticket Select
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- POIK.1 Edit AC and GL Budgets
- POIM.1 GL Budget Ck for PO and RQ
- PR195 Accrual Program
- PR197 Payroll Close
- PR582 Mass Adjustment Load
- PR82.1 Adjustment
- PR85.1 Bank Account Reconciliation
- RQ01.1 Requesting Locations
- RQ12.1 Approval Review
- RQ44.1 Requisition Inquiry
- RQ810 Request Location Load
- RQID.1 RQRQHUPD Invoke Object
- RQII.1 Invoke for Reqheader Inquiry
- RW100 Report Generation
- RW230 Ratio Listing
- RW270 Total Name Listing
- RW30.1 Ratio Definition
- RW70.1 Total Names
- SL40.4 Filter
- SLSE.1 User Analysis Edit
- SLVW.1 Build SL Accounting Unit View
- SNOA.1 RETRIEVE ACTUALS
- SNRA.1 RETRIEVE ACTUALS
- SNSA.1 RETRIEVE ACTUALS
- WH130 Pick List Print
- WH132 Batch Feedback
- WH190 Shipment Release
- WH20.2 Nonstock and Special Allocation
- WH20.7 Substitute Location
- WH222 Shipments In Process
- WH30.1 Picking Feedback by Document
- WH30.2 Picking Feedback by Shipment
- WH30.3 Picking by Batch
- WH30.4 Bin Sequence Picking Feedback
- WH31.1 Packing Feedback by Document
- WH31.2 Packing Feedback by Shipment
- WH31.3 Packing by Batch
- WH31.4 Bin Sequence Packing Feedback
- WH32.1 Shipping Feedback by Document
- WH32.2 Shipping Feedback by Shipment
- WH32.3 Shipping by Batch
- WH32.4 Bin Sequence Shipping Feedback
- WH32.5 Shipping Line Feedback
- WH33.1 Bins
- WH33.2 Lots
- WH33.3 Serials
- WH33.4 UOMs
- WH33.5 Additional Shipment Information
- WH33.6 Catch Weight
- WH33.8 Preassembled Kits
- WH33.9 Line Options
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH520 Batch Feedback Interface
- WH830 Shipment Load Program