AUMXVALDT – This file is used to store the effective date values for attribute unit attributes.
- System
- General Ledger Setup (IF)
- Prefix
AVD- Primary key
OBJ-ID,MATRIX-CAT,EFFECTIVE-DATE- Fields
- 5
- Updated by
- 4 programs
- Referenced by
- 38 programs
AUMXVALDT is the This file is used to store the effective date values for attribute unit attributes. table in Lawson General Ledger Setup (prefix AVD). It is indexed by OBJ-ID, MATRIX-CAT, EFFECTIVE-DATE (AVDSET1); alternate indexes: AVDSET2 and AVDSET4. It is related 1:M to AUMXVLDTAU. It is updated by GL162, GL20.7, GL20.8 and GL20.9 and referenced by GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 and 30 more. The table has 5 fields, 3 indexes and 1 documented relation.
About AUMXVALDT
This file is used to store the effective date values for attribute unit attributes.
Fields (5)
Column = COBOL field name without the AVD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
AVD-OBJ-ID PKOBJ_ID | Numeric 12 | This is the unique object identifier. | GL162, GL20.7, GL20.8, GL20.9 |
AVD-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | This is the accounting unit attribute to which a value is assigned. | GL162, GL20.7, GL20.8, GL20.9 |
AVD-MX-VALUEMX_VALUE | Alpha 32 | This is the value of the attribute. | GL162, GL20.7, GL20.8, GL20.9 |
AVD-EFFECTIVE-DATE PKEFFECTIVE_DATE | Numeric 8 (yyyymmdd) | This is the date the value takes effect. | GL162, GL20.7, GL20.8, GL20.9 |
AVD-COMPANYCOMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | GL162, GL20.7, GL20.8, GL20.9 |
Indexes (3)
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 |
|---|---|---|---|---|
AVDSET1 | OBJ-ID, MATRIX-CAT, EFFECTIVE-DATE | Primary | GL146, GL197, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8, GL44.1 +22 more (list truncated in source) | |
AVDSET2 | MATRIX-CAT, EFFECTIVE-DATE, OBJ-ID | MX202 | ||
AVDSET4 | COMPANY, OBJ-ID, MATRIX-CAT, EFFECTIVE-DATE* | RW100, MX135 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Aumxvldtau | AUMXVLDTAU | AVD-OBJ-ID → UDU-OBJ-ID, AVD-MATRIX-CAT → UDU-MATRIX-CAT, AVD-EFFECTIVE-DATE → UDU-EFFECTIVE-DATE, UDU-ACTION, UDU-DATE, UDU-TIME, UDU-UNIQUE-I-D |
Programs
Updated by (4)
- GL162 Accounting Unit Attribute Interface
- GL20.7 Attributes
- GL20.8 Attribute Value Effective Date
- GL20.9 Values By Attribute Effective Date
Referenced by (38)
- GL14.1 Accounting Unit Template Definition
- GL14.5 Values By Attribute
- GL14.7 Attributes
- GL14.8 Copy Accounting Unit Template
- GL146 Batch Journal Control
- GL16.1 Summary Account Attributes
- GL16.2 Detail Account Attributes
- GL16.3 Summary Account Values by attribute
- GL16.4 Detail Account Values by Attributes
- GL197 Period, Year End GL Commitments Processing
- GL40.1 Journal Entry
- GL40.2 Define Journal
- GL40.3 Speed Entry
- GL40.7 Totals
- GL40.8 Journal Entry
- GL44.1 Report Currency Entry
- GL45.1 Journal Control
- GL70.1 Recurring Journal
- GL70.2 Define Recurring Journal
- GL70.3 Amounts Only
- GL70.6 Recurring Copy
- MX00.1 Attribute
- MX00.2 Element
- MX00.3 Associate Attribute to Objects
- MX05.1 Attribute Template
- MX05.2 Define Template
- MX06.1 Attribute Value Effective Date Template
- MX06.2 Define Attibute Value Effective Date Template
- MX10.1 List
- MX10.2 Define List
- MX135 Acct Unit Attribute Value Update For Effective Date
- MX20.1 View
- MX20.2 Define View
- MX20.4 Rename Summary Level
- MX20.5 View Copy
- MX202 Attribute Value Listing
- RW100 Report Generation
- SL40.1 Error Transaction Edit