ML99.1 – Organization Query
- System
- Multi-Ledger (ML)
- Type
- Online screen — form 99
- Updates
- 13 tables
- References
- 33 tables
ML99.1 (Organization Query) is a Lawson Multi-Ledger online screen (form 99, subform 1). It updates ADDRDATA, CMPUTEAU, RADEFINAU, RATOTALAU, RATOTALS, RWFORMAT, RWFORMATAU, RWGRPDETAU and 5 more and references CMPUTE, CUCODES, FBDETAIL, FBHEADER, GLADDRESS, GLCGCPY, GLCHART, GLCHARTDTL and 25 more.
About ML99.1
Use Organization Query (ML99.1) to view organization hierarchy for thecompany and account selected on Ledger Account Analysis (ML95.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 Ledger Account Analysis (ML95.1). In this subform, you can view additional detail. Use Periods vs. YTD (ML99.2) to view the period range and year-to-dateamounts for specific accounts.
More information: Choose the Cur,Last button to view current and last year amounts for specificaccounts you selected on Organization Query (ML99.1). Choose the Act,But button to view actual and budget amounts for specificaccounts you selected in Organization Query (ML99.1). Choose the CSV Export button to create a comma-separated value (CSV) file.
Updated files (13)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| CMPUTEAU | RW Compute Statement Audit | 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 (33)
| Table | Description | System |
|---|---|---|
| CMPUTE | Compute Statements | GL |
| CUCODES | Currency Codes | IF |
| FBDETAIL | Budget Detail | GL |
| FBHEADER | Budget Header | 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 |
| GLCPYGRP | General Ledger Company Group | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MLCALMAP | Multi-Book Ledger Calendar Map | ML |
| MLCOLEDGER | Multi Book Ledger Co Ledger | ML |
| MLLEDGER | Multi Book 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