GL20.9 – Values By Attribute Effective Date
- System
- General Ledger Setup (IF)
- Type
- Online screen — form 20
- Updates
- 20 tables
- References
- 18 tables
GL20.9 (Values By Attribute Effective Date) is a Lawson General Ledger Setup online screen (form 20, subform 9). It updates AUMXVALDT, AUMXVALUAU, AUMXVLDTAU, GLACMXVLAU, GLAUTMXVAU, GTMXVALUAU, MXCATDEFAU, MXELEMNTAU and 12 more and references AUMXVALUE, GLACCMXVAL, GLAUTMPMXV, GLNAMES, GTMXVALUE, MXCATDEF, MXELEMENT, MXLISTDTL and 10 more.
About GL20.9
Use Values By Attribute Effective Date (GL20.9) to assign an attribute value to any company and accounting unit for a specified effective date. Type an effective date in the Effective Date field and type a value for any company and accounting unit. You must access this form from Attributes (GL20.1) via Attribute Value Effective Date (GL20.7). To select another attribute for which you want to assign effective date values, you must return to GL20.1. IMPORTANT Effective date values cannot be used in attribute lists. For an effective date value to be used in a list, you must runAccounting Unit Attr Value Update For Effective Date (MX135) for the effective date. All values assigned for that effective date display as the attribute values on Attributes (GL20.7).
Updated files (20)
| Table | Description | System |
|---|---|---|
| AUMXVALDT | This file is used to store the effective date values for attribute unit attributes. | IF |
| AUMXVALUAU | AU Attribute Value Audit | IF |
| AUMXVLDTAU | AU Attribute Value Edate Audit | IF |
| GLACMXVLAU | GL Acct Attribute Value Audit | IF |
| GLAUTMXVAU | GL AU Attribute Template Audit | GL |
| GTMXVALUAU | JE Attribute Value Audit | IF |
| MXCATDEFAU | Attribute Definition Audit | IF |
| MXELEMNTAU | Attribute Element Audit | IF |
| MXLSTDTLAU | Attribute List Detail Audit | IF |
| MXLSTHDRAU | Attribute List Header Audit | IF |
| MXOBJCAT | Attribute Object | 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 |
Referenced files (18)
| Table | Description | System |
|---|---|---|
| AUMXVALUE | Acct Unit Attribute Value | IF |
| GLACCMXVAL | GL Account Attribute Value | IF |
| GLAUTMPMXV | GL AU Attribute Template | GL |
| GLNAMES | General Ledger Names | IF |
| GTMXVALUE | Attribute Template Value | IF |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXLISTHDR | Attribute List Header | IF |
| MXTMPLDTL | Attribute Template Detail | IF |
| MXTMPLEFDT | Attr Template Effective Date | IF |
| MXTMPLHDR | Attribute Template Header | IF |
| MXTMPLHEDT | Attr Template Header Detail | IF |
| MXVALIDATE | Attribute Validation | IF |
| MXVIEWDTL | Attribute View Detail | IF |
| MXVIEWHDR | Attribute View Header | IF |
| RJMXVALUE | Recurring Journal Matrix Value | IF |
| SYSTEMCODE | System Code | IF |
Program calls
Invoked programs (11)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU