AUMXCONV – Acct Unit Attribute Conversion
- System
- General Ledger Setup (IF)
- Prefix
AUC- Primary key
RUN-GROUP,OLD-COMPANY,MATRIX-CAT,EFFECTIVE-DATE- Fields
- 5
- Updated by
- 2 programs
- Referenced by
- 1 program
AUMXCONV is the Acct Unit Attribute Conversion table in Lawson General Ledger Setup (prefix AUC). It is indexed by RUN-GROUP, OLD-COMPANY, MATRIX-CAT, EFFECTIVE-DATE (AUCSET1); alternate indexes: AUCSET2 and AUCSET3. It is related 1:1 to GLCOMPREL and 1:M to MXOBJCAT. It is updated by GL162 and GL62.1 and referenced by GL262. The table has 5 fields, 3 indexes and 2 documented relations.
About AUMXCONV
The Accounting Unit Attribute Conversion file contains the information needed to maintain accounting unit attribute information defined in GL62.1 (AU Attribute Interface Maint).
Fields (5)
Column = COBOL field name without the AUC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
AUC-RUN-GROUP PKRUN_GROUP | Alpha 15 | The name you assigned when you transferred the non-Lawson file to the target machine. | GL62.1 |
AUC-OLD-COMPANY PKOLD_COMPANY | Alpha 35 | A user defined field that contains the old company structure to be associated with the Lawson Company/Accounting Unit. This field determines what company and accounting unit a record will convert to | GL62.1 |
AUC-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | The attribute being interfaced. It must be a valid attribute for the object type in the Attribute Matrix application. | GL62.1 |
AUC-MX-VALUEMX_VALUE | Alpha 32 | The valid value for the Attribute. | GL62.1 |
AUC-EFFECTIVE-DATE PKEFFECTIVE_DATE | Numeric 8 (yyyymmdd) | This field contains the effective date for the attribute value. | GL62.1 |
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 |
|---|---|---|---|---|
AUCSET1 | RUN-GROUP, OLD-COMPANY, MATRIX-CAT, EFFECTIVE-DATE | Primary | GL162, GL262, GL62.1 | |
AUCSET2 | MATRIX-CAT, OLD-COMPANY, RUN-GROUP, EFFECTIVE-DATE | — | ||
AUCSET3 | OLD-COMPANY, RUN-GROUP, MATRIX-CAT, EFFECTIVE-DATE | — |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Glcomprel | GLCOMPREL | Not Required | AUC-OLD-COMPANY → GCR-OLD-COMPANY (GCRSET1) |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Mxobjcat | MXOBJCAT | AUC-MATRIX-CAT → MOC-MATRIX-CAT, MOC-OBJ-TYPE |
Programs
Updated by (2)
Referenced by (1)
- GL262 Accounting Unit Attribute Interface Listing