MLCLSAUDIT – Multi-Book Ledger Close Audit
- System
- Multi-Ledger (ML)
- Prefix
MCL- Primary key
LEDGER,COMPANY,FISCAL-YEAR,ACCT-PERIOD,CLOSE-SEQ- Fields
- 8
- Updated by
- 2 programs
- Referenced by
- 0 programs
MLCLSAUDIT is the Multi-Book Ledger Close Audit table in Lawson Multi-Ledger (prefix MCL). It is indexed by LEDGER, COMPANY, FISCAL-YEAR, ACCT-PERIOD, CLOSE-SEQ (MCLSET1). It is updated by ML110 and ML199. The table has 8 fields, 1 index and 0 documented relations.
About MLCLSAUDIT
No description in the Lawson data dictionary.
Fields (8)
Column = COBOL field name without the MCL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
MCL-LEDGER PKLEDGER | Alpha 15 | The ledger associated with the close audit record and defined in ML10. | ML199 |
MCL-COMPANY PKCOMPANY | Numeric 4 | This is the company the ledger is linked to in Ml10. | ML199 |
MCL-FISCAL-YEAR PKFISCAL_YEAR | Numeric 4 | This is the fiscal year assigned to this ledger and company combination. This field is updated by Ledger Period Closing (ML199). | ML199 |
MCL-ACCT-PERIOD PKACCT_PERIOD | Numeric 2 | This represents the ML period being mapped to. | ML199 |
MCL-CLOSE-SEQ PKCLOSE_SEQ | Numeric 2 | A close sequence number representing each close (ML199) for the period. | ML199 |
MCL-CLOSE-DATECLOSE_DATE | Numeric 8 (yyyymmdd) | The date the period is closed. | ML199 |
MCL-CLOSE-TIMECLOSE_TIME | Numeric 6 (hhmmss) | The time the period is closed. | ML199 |
MCL-PER-END-CODEPER_END_CODE | Alpha 1 | This field is used to indicate the closing status for the period. | ML199 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
MCLSET1 | LEDGER, COMPANY, FISCAL-YEAR, ACCT-PERIOD, CLOSE-SEQ | Primary | ML110, ML199 |