GL120 – Level Reorganization
- System
- General Ledger (GL)
- Type
- Batch program
- Updates
- 50 tables
- References
- 53 tables
GL120 (Level Reorganization) is a Lawson General Ledger batch program. It updates ADAMOUNTSX, ADAVGBAL, ADCFBAL, ADDRDATA, AUMXVALUE, CKPOINT, CUACCTAU, CUAMOUNT and 42 more and references ACDETAILAU, ACHEADERAU, AMACCTAU, AMACCTGPAU, AMASTTYPAU, AMAUGRPAU, AMDICT2, AMDIVISNAU and 45 more.
About GL120
Run Level Reorganization (GL120) to update the new level values. You run this program to move accounting unit and account history to a new level address assigned in Accounting Units-Accounts (GL20.1). The changes are not processed until you run this report with the Update Unprocessed Change report option. IMPORTANT You must run Undistributed RE Rebuild (GL330) and Consolidation File Creation (GL320) after running GL120 to update the URE (undistributed retained earnings) and GLCONSOL (UNIX/Windows) or DBGLGCN (System i) balances.
Updated files (50)
| Table | Description | System |
|---|---|---|
| ADAMOUNTSX | Daily GL Amounts for ADB | AD |
| ADAVGBAL | Average Daily Balance by Date | AD |
| ADCFBAL | Cost of Funds by Date | AD |
| ADDRDATA | Address Code | IF |
| AUMXVALUE | Acct Unit Attribute Value | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
| CUACCTAU | CU Account Audit | IF |
| CUAMOUNT | Currency Amount | GL |
| CUAMOUNTX | Currency Amount-Daily | GL |
| CUCODESAU | Currency Codes Audit | IF |
| CUCONVAU | Currency Exchange Rate Audit | IF |
| CURELATAU | Currency Relation Audit | IF |
| CUTABLEAU | Currency Table Audit | IF |
| CUTRNSLAU | Currency Translation Audit | IF |
| FBADJCODAU | Budget Adjustment Code Audit | GL |
| FBCNTRLAU | Budget Journal Control Audit | GL |
| FBDETAIL | Budget Detail | GL |
| FBDETAILAU | Budget Detail Audit | GL |
| FBDTLHIST | Budget Detail History | GL |
| FBFNDHDRAU | Budget Edit Group Audit | GL |
| FBHEADERAU | Budget Header Audit | GL |
| FBHSTHDRAU | Budget Version Audit | GL |
| FBINTBUAU | Budget Interbudget Rel Audit | GL |
| FBSPREADAU | Budget Spread Code Audit | GL |
| FBTRANS | Budget Transactions | GL |
| FBTRANSAU | Budget Transactions Audit | GL |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLAMOUNTSX | General Ledger Amounts Daily | GL |
| GLAUDIT | General Ledger Audit | GL |
| GLCHTDTLAU | Chart Detail Audit | IF |
| GLCOMMIT | GL Commitments | GL |
| GLCOMMITX | GL commitment Detail | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| GLMASTER | General Ledger Account Master | IF |
| GLMASTERAU | Account Master Audit | IF |
| GLNAMES | General Ledger Names | IF |
| GLNAMESAU | General Ledger Names Audit | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLSYSTEMAU | GL Company Audit | IF |
| GLTRANS | General Ledger Transactions | GL |
| GLUNITS | General Ledger Units | GL |
| GLUNITSX | General Ledger Units-Daily | GL |
| MLAMOUNTS | Multi-Book Ledger Amounts | ML |
| MLCUAMOUNT | ML Ledger Currency Amount | ML |
| MLTRANS | ML Transactions | ML |
| MLUNITS | ML Units | ML |
| MXLISTHDR | Attribute List Header | IF |
| MXOBJCAT | Attribute Object | IF |
| SLTRANS | PL Transaction | SL |
| ULPOST | This file is used to store the last posting date and time. | IF |
Referenced files (53)
| Table | Description | System |
|---|---|---|
| ACDETAILAU | CA Alloc Code Detail Audit | GL |
| ACHEADERAU | CA Alloc Code Definition Audit | GL |
| AMACCTAU | Asset Account Audit | AM |
| AMACCTGPAU | Asset Account Group Audit | AM |
| AMASTTYPAU | Asset Type Audit | AM |
| AMAUGRPAU | AM Accounting Unit Group Audit | AM |
| AMDICT2 | No description in the Lawson data dictionary | AM |
| AMDIVISNAU | AM Division Audit | AM |
| AMSYSOPTAU | No description in the Lawson data dictionary | AM |
| AUMXVALUAU | AU Attribute Value Audit | IF |
| AUMXVLDTAU | AU Attribute Value Edate Audit | IF |
| CAALOCGPAU | Allocation Group Audit | GL |
| CADETAILAU | Allocation Detail Audit | GL |
| CAHEADERAU | Allocation Header Audit | GL |
| CUACCT | Currency Gain and Loss Account | IF |
| CUCODES | Currency Codes | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| CUTABLE | Currency Table | IF |
| CUTRANSL | Currency Translation | IF |
| FBADJCODE | No description in the Lawson data dictionary | GL |
| FBCONTROL | Budget Journal Control | GL |
| FBFUNDHDR | Budget Fund Header | GL |
| FBHEADER | Budget Header | GL |
| FBHISTHDR | Budget History Header | GL |
| FBINTBU | Interbudget Relationship | GL |
| FBSPREAD | Budgeting Spread Code | GL |
| GLACMXVLAU | GL Acct Attribute Value Audit | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLAUTMXVAU | GL AU Attribute Template Audit | GL |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCPYGRP | General Ledger Company Group | IF |
| GTMXVALUAU | JE Attribute Value Audit | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MACAPDTL | Invoice Distrib Conversion | MA |
| MLCOLEDGER | Multi Book Ledger Co Ledger | ML |
| MXCATDEFAU | Attribute Definition Audit | IF |
| MXELEMNTAU | Attribute Element Audit | IF |
| MXLSTDTLAU | Attribute List Detail Audit | IF |
| MXLSTHDRAU | Attribute List Header Audit | IF |
| MXOBJCATAU | Attribute Object Audit | IF |
| MXTMPDTLAU | Attribute Template Dtl Audit | IF |
| MXTMPHDRAU | Attribute Template Hdr Audit | IF |
| MXTPEFDTAU | Attr Template EDate Dtl Audit | IF |
| MXTPHEDTAU | Attr Template EDate Hdr Audit | IF |
| MXVALIDAU | Attribute Validation Audit | IF |
| MXVEWDTLAU | Attribute View Detail Audit | IF |
| MXVEWHDRAU | Attribute View Header Audit | IF |
| RJMXVALUAU | Recurring JE Attr Value Audit | IF |
| SYSTEMCODE | System Code | IF |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (2)
IFOB, IFSG