APVNMXVAL – No description in the Lawson data dictionary

System
Accounts Payable (AP)
Prefix
VMX
Primary key
AP-OBJ-ID, MATRIX-CAT
Fields
3
Updated by
4 programs
Referenced by
290 programs

APVNMXVAL is a Lawson Accounts Payable table (prefix VMX); no description in the lawson data dictionary. It is indexed by AP-OBJ-ID, MATRIX-CAT (VMXSET1); alternate indexes: VMXSET2. It is related 1:1 to APVENMAST, MXCATDEF and MXOBJCAT. It is updated by AP03.1, AP03.2, AP162 and MX500 and referenced by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 282 more. The table has 3 fields, 2 indexes and 3 documented relations.

About APVNMXVAL

No description in the Lawson data dictionary.

Fields (3)

Column = COBOL field name without the VMX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#VMX-AP-OBJ-ID PK
AP_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AP03.1, AP03.2, AP162, MX500
#VMX-MATRIX-CAT PK
MATRIX_CAT		Alpha 12Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis.AP03.1, AP03.2, AP162, MX500
#VMX-MX-VALUE SET2
MX_VALUE		Alpha 32The attribute value.AP03.1, AP03.2, AP162, MX500

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
VMXSET1
  1. AP-OBJ-ID
  2. MATRIX-CAT
PrimaryAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
VMXSET2
  1. MATRIX-CAT
  2. MX-VALUE
  3. AP-OBJ-ID
KeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APVENMASTMXCATDEFMXOBJCATAPVNMXVAL

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ApvenmastAPVENMASTRequired
VMX-AP-OBJ-ID→VEN-AP-OBJ-ID
MxcatdefMXCATDEFRequired
VMX-MATRIX-CAT→MXC-MATRIX-CAT
MxobjcatMXOBJCATRequired
"VENDR"→MOC-OBJ-TYPE
VMX-MATRIX-CAT→MOC-MATRIX-CAT

Programs

Updated by (4)

Referenced by (290)