GL300 – General Ledger History Delete
- System
- General Ledger (GL)
- Type
- Batch program
- Updates
- 37 tables
- References
- 21 tables
GL300 (General Ledger History Delete) is a Lawson General Ledger batch program. It updates ACDETAILAU, ACHEADERAU, ADDRDATA, CAALOCGPAU, CADETAILAU, CAHEADERAU, CKPOINT, CUAMOUNT and 29 more and references ACDETAIL, ACHEADER, CAALLOCGRP, CADETAIL, CAHEADER, CUCONTROL, FBADJCODE, FBFUNDHDR and 13 more.
About GL300
Run General Ledger History Delete (GL300) to delete historical journal entry transactions, comments, consolidation records, and budgets for a fiscal year. General Ledger history must be at least two years old before this program deletes it. You can delete all budgets for a year, or a range of budgets. This program creates a report showing the total number of header, transaction, and budget lines deleted. If the Archive Records is Yes, deleted records are removed from the General Ledger database and archived in a comma separated value (CSV) file as follows: For UNIX/Windows platforms: - JE Transactions and Comments are saved in file GLTRANS - Consolidations and Balances are saved in files GLAMOUNTS, GLUNITS,CUAMOUNT, GLCONSOL, GLAMOUNTSX, and CUAMOUNTX - Budgets are saved in files FBDETAIL and FBDTLHIST WARNING This program permanently deletes data. Before you run this program, back up your data according to your organization's procedures. Before you submit the report, carefully review the parameters. For System i platform: - JE Transactions and Comments are saved in file DBGLGLT - Consolidations and Balances are saved in files DBGLGAM, DBGLGLU, DBGLCAM,DBGLGCN, DBGLGAX, and DBGLCAX - Budgets are saved in files DBGLFBD and DBGLFDH WARNING This program permanently deletes data. Before you run this program, back up your data according to your organization's procedures. Before you submit the report, carefully review the parameters.
Updated files (37)
| Table | Description | System |
|---|---|---|
| ACDETAILAU | CA Alloc Code Detail Audit | GL |
| ACHEADERAU | CA Alloc Code Definition Audit | GL |
| ADDRDATA | Address Code | IF |
| CAALOCGPAU | Allocation Group Audit | GL |
| CADETAILAU | Allocation Detail Audit | GL |
| CAHEADERAU | Allocation Header Audit | GL |
| CKPOINT | No description in the Lawson data dictionary | — |
| CUAMOUNT | Currency Amount | GL |
| CUAMOUNTX | Currency Amount-Daily | GL |
| CUCONTROL | Currency Control | GL |
| FBADJCODAU | Budget Adjustment Code Audit | GL |
| FBBATRANS | No description in the Lawson data dictionary | GL |
| FBCNTRLAU | Budget Journal Control Audit | GL |
| FBCONTROL | Budget Journal Control | GL |
| FBDETAIL | Budget Detail | GL |
| FBDETAILAU | Budget Detail Audit | GL |
| FBDTLHIST | Budget Detail History | GL |
| FBFNDHDRAU | Budget Edit Group Audit | GL |
| FBHEADER | Budget Header | GL |
| FBHEADERAU | Budget Header Audit | GL |
| FBHISTHDR | Budget History Header | 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 |
| GLCNTRLAU | Journal Control Audit | GL |
| GLCONSOL | General Ledger Consolidation | GL |
| GLCONTROL | General Ledger Control | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| GLSEGBLOCK | General Ledger Segment Block | GL |
| GLUNITS | General Ledger Units | GL |
| GTMXVALUE | Attribute Template Value | IF |
| MXOBJCAT | Attribute Object | IF |
| RJCNTRLAU | Recurring Journal Ctrl Audit | GL |
Referenced files (21)
| Table | Description | System |
|---|---|---|
| ACDETAIL | Cost Allocation Detail | GL |
| ACHEADER | Cost Allocation Header | GL |
| CAALLOCGRP | Allocation Group | GL |
| CADETAIL | Allocation Detail | GL |
| CAHEADER | Allocation Header | GL |
| CUCONTROL | Currency Control | GL |
| FBADJCODE | No description in the Lawson data dictionary | GL |
| FBFUNDHDR | Budget Fund Header | GL |
| FBINTBU | Interbudget Relationship | GL |
| FBSPREAD | Budgeting Spread Code | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCPYGRP | General Ledger Company Group | IF |
| GLSEGBLOCK | General Ledger Segment Block | GL |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| INSTCTRYCD | Intrastat Country Codes | TX |
| RJCONTROL | Recurring Journal Control | GL |
| SYSTEMCODE | System Code | IF |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (2)
IFOB, IFSG