GL99.1 – Organization Query
- System
- General Ledger (GL)
- Type
- Online screen — form 99
- Updates
- 15 tables
- References
- 41 tables
GL99.1 (Organization Query) is a Lawson General Ledger online screen (form 99, subform 1). It updates ADDRDATA, CMPUTEAU, FBTRANS, GLTRANS, RADEFINAU, RATOTALAU, RATOTALS, RWFORMAT and 7 more and references CMPUTE, CUCODES, FBBATRANS, FBCONTROL, FBDETAIL, FBFUNDHDR, FBHEADER, FBTRANS and 33 more.
About GL99.1
Use Organization Query (GL99.1) to view organization hierarchy for thecompany and account selected in Account Analysis (GL95.1).
More information: After you complete the form and press OK, the Periods vs. Year to Datesubform appears. Use this subform to view period and year-to-date chart amounts for the year and period you selected in Account Analysis (GL95.1). In this subform, you can view additional detail.
Updated files (15)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| CMPUTEAU | RW Compute Statement Audit | GL |
| FBTRANS | Budget Transactions | GL |
| GLTRANS | General Ledger Transactions | GL |
| RADEFINAU | Ratio Definitions Audit | GL |
| RATOTALAU | Ratio Totals Audit | GL |
| RATOTALS | Ratio Totals | GL |
| RWFORMAT | Report Writer Format | GL |
| RWFORMATAU | Report Writer Format Audit | GL |
| RWGRPDETAU | Report Writer Group Detail Adt | GL |
| RWHEADAU | Report Writer Header Audit | GL |
| RWREQSTAU | Report Writer Request Audit | GL |
| RWROWDTAU | Report Writer Row Detail Audit | GL |
| RWUSERAU | Report Writer User Audit | GL |
| ULTOTALS | No description in the Lawson data dictionary | GL |
Referenced files (41)
| Table | Description | System |
|---|---|---|
| CMPUTE | Compute Statements | GL |
| CUCODES | Currency Codes | IF |
| FBBATRANS | No description in the Lawson data dictionary | GL |
| FBCONTROL | Budget Journal Control | GL |
| FBDETAIL | Budget Detail | GL |
| FBFUNDHDR | Budget Fund Header | GL |
| FBHEADER | Budget Header | GL |
| FBTRANS | Budget Transactions | GL |
| FBYETR | No description in the Lawson data dictionary | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCOMMITX | GL commitment Detail | GL |
| GLCONTROL | General Ledger Control | GL |
| GLCPYGRP | General Ledger Company Group | IF |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MLCALMAP | Multi-Book Ledger Calendar Map | ML |
| MLCOLEDGER | Multi Book Ledger Co Ledger | ML |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| MXOBJCAT | Attribute Object | IF |
| MXVIEWDTL | Attribute View Detail | IF |
| MXVIEWHDR | Attribute View Header | IF |
| RADEFINE | Ratio Definitions | GL |
| RWDICT | Report Writer Dictionary | GL |
| RWGRPDET | Report Writer Group Detail | GL |
| RWHEADER | Report Writer Header | GL |
| RWREQUEST | Report Writer Request | GL |
| RWROWDET | RW Row File Detail | GL |
| RWUSER | Report Writer User | GL |
| SYSTEMCODE | System Code | IF |
| ULPOST | This file is used to store the last posting date and time. | IF |
Program calls
Invoked programs (8)
GLAC, GLBL, GLRV, GLVW, IFOB, IFSG, IFUP, MLRV