GL160 – Chart of Accounts Interface
- System
- General Ledger Setup (IF)
- Type
- Batch program
- Updates
- 16 tables
- References
- 57 tables
GL160 (Chart of Accounts Interface) is a Lawson General Ledger Setup batch program. It updates CKPOINT, CUACCTAU, CUCODESAU, CUCONVAU, CURELATAU, CUTABLEAU, CUTRNSLAU, GLACCTVLD and 8 more and references ACACCTCAT, ACDETAILAU, ACHEADERAU, AMACCTAU, AMACCTGPAU, AMASTTYPAU, AMAUGRPAU, AMDICT2 and 49 more.
About GL160
Run Chart of Accounts Interface (GL160) to import the chart of accounts interface file for use in the Lawson system. **Processing Effect For UNIX/Windows platforms: During the interface process, all records are edited for errors. When a record is moved from the General Ledger Interface Chart (GLICHART) file to the General Ledger Chart (GLCHART), General Ledger Chart Summary (GLCHARTSUM) and General Ledger Chart Detail (GLCHARTDTL) files, the interface file is deleted, unless errors are found. For System i platform: During the interface process, all records are edited for errors. When a record is moved from the General Ledger Interface Chart (DBIFGCI) file to the General Ledger Chart (DBIFGCH), General Ledger Chart Summary (DBIFGCS) and General Ledger Chart Detail (DBIFGDT) files, the interface file is deleted, unless errors are found. **Troubleshooting Use GL60.1 to correct errors and rerun this program.
More information: Run Chart Interface Listing (GL260) to list chart records in the General Ledger Interface file to verify chart details before running this program. Use Chart of Accounts (GL00.1) to display and maintain converted information after you run this program.
Updated files (16)
| Table | Description | System |
|---|---|---|
| CKPOINT | No description in the Lawson data dictionary | — |
| CUACCTAU | CU Account Audit | IF |
| 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 |
| GLACCTVLD | GL Account Validation | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCHTDTLAU | Chart Detail Audit | IF |
| GLICHART | General Ledger Interface Chart | IF |
| GLMASTERAU | Account Master Audit | IF |
| GLNAMESAU | General Ledger Names Audit | IF |
| GLSYSTEMAU | GL Company Audit | IF |
Referenced files (57)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| 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 |
| FBADJCODAU | Budget Adjustment Code Audit | GL |
| FBCNTRLAU | Budget Journal Control Audit | GL |
| FBDETAILAU | Budget Detail Audit | 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 |
| FBTRANSAU | Budget Transactions Audit | GL |
| GLACMXVLAU | GL Acct Attribute Value Audit | IF |
| GLAUTMXVAU | GL AU Attribute Template Audit | GL |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSUBACDTL | GL Subaccount Detail | GL |
| GLSUBACHDR | GL Subaccount Header | GL |
| GLSUBACVLD | GL Subaccount Restrictions | IF |
| GLSYSTEM | General Ledger Company | IF |
| GTMXVALUAU | JE Attribute Value Audit | IF |
| MACAPDTL | Invoice Distrib Conversion | MA |
| MLGROUP | ML Group | ML |
| MXCATDEFAU | Attribute Definition Audit | IF |
| MXELEMNTAU | Attribute Element Audit | IF |
| MXLISTHDR | Attribute List Header | 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 (11)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU