GL165 – Transaction Interface
- System
- General Ledger (GL)
- Type
- Batch program
- Updates
- 7 tables
- References
- 48 tables
GL165 (Transaction Interface) is a Lawson General Ledger batch program. It updates ACCOMMIT, ACTRANS, ADDRDATA, CKPOINT, GLTRANSREL, JBOOKHDR and SYSTEMCODE and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL and 40 more.
About GL165
Run Transaction Interface (GL165) to import the transaction interface file for use in the Lawson system. **Processing Effect During the conversion process, all records are edited for errors. When a record is moved from the General Ledger Transaction Interface (GLTRANSREL) (UNIX/Windows) or (DBGLGTR) (System i) file to the General Ledger Transaction (GLTRANS) (UNIX/Windows) or (DBGLGLT) (System i) file, the interface file is deleted, unless errors are found. **Troubleshooting Use Transaction Interface Maintenance (GL65.1) to correct errors and rerun this program.
More information: Run Transaction Interface Listing (GL265) to list data in the General Ledger Transaction Interface file before running GL165. Use Journal Control (GL45.1) to view and maintain converted information after you run this program.
Updated files (7)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACTRANS | Activity Transaction | AC |
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
| GLTRANSREL | GL Transaction Conversion | GL |
| JBOOKHDR | Journal Book Header | IF |
| SYSTEMCODE | System Code | IF |
Referenced files (48)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACBUDHDR | Activity Budget Header | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCNTRACT | Activity Contract | BR |
| ACCOMMIT | Activity Commitments | AC |
| ACCONSOL | Activity Consolidation | AC |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACTRANS | Activity Transaction | AC |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| FBDETAIL | Budget Detail | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBFUNDDTL | Budget Fund Detail | GL |
| FBHEADER | Budget Header | GL |
| GLACCTREL | GL Account Relationships | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCODES | General Ledger Codes | IF |
| GLCOMMIT | GL Commitments | GL |
| GLCOMPREL | GL Organization Relationships | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSRCCODE | General Ledger Source Code | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| GMFNDACT | Grant Eligible Activities | GM |
| INSTCTRYCD | Intrastat Country Codes | TX |
| JBKOPCODE | Journal Book Operator Code | IF |
| JBKSYSCODE | Journal Book System | IF |
| MLCALMAP | Multi-Book Ledger Calendar Map | ML |
| MLCOLEDGER | Multi Book Ledger Co Ledger | ML |
| MLLEDGER | Multi Book Ledger | ML |
| MXOBJCAT | Attribute Object | IF |
| MXVALIDATE | Attribute Validation | IF |
Program calls
Invoked programs (22)
ACAC, ACTA, API4, GLCC, IFAC, IFAU, IFCU, IFFC, IFGT, IFJR, IFLU, IFOB, IFRS, IFSC, IFSG, IFTR, IFUP, SLFD, SLSB, SLSE, SLSS, SLSU