VNMXCONV – No description in the Lawson data dictionary

System
Accounts Payable (AP)
Prefix
VNC
Primary key
RUN-GROUP, VENDOR-GROUP, VENDOR, MATRIX-CAT
Fields
5
Updated by
2 programs
Referenced by
1 program

VNMXCONV is a Lawson Accounts Payable table (prefix VNC); no description in the lawson data dictionary. It is indexed by RUN-GROUP, VENDOR-GROUP, VENDOR, MATRIX-CAT (VNCSET1); alternate indexes: VNCSET2 and VNCSET3. It is related 1:M to MXOBJCAT. It is updated by AP162 and AP62.1 and referenced by AP262. The table has 5 fields, 3 indexes and 1 documented relation.

About VNMXCONV

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the VNC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
VNC-RUN-GROUP PK
RUN_GROUP		Alpha 15Run Group and Seq Number are the keys to the file. They should be used to group records together for interfacing.AP62.1
VNC-VENDOR-GROUP PK
VENDOR_GROUP		Alpha 4A vendor group represents a group of vendors that can be shared by one or more companies.AP62.1
VNC-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP62.1
VNC-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.AP62.1
VNC-MX-VALUE
MX_VALUE		Alpha 32The attribute value.AP62.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
VNCSET1RUN-GROUP, VENDOR-GROUP, VENDOR, MATRIX-CATPrimaryAP162, AP262, AP62.1
VNCSET2MATRIX-CAT, VENDOR-GROUP, VENDOR—
VNCSET3VENDOR-GROUP, VENDOR, MATRIX-CAT—

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
MxobjcatMXOBJCATVNC-MATRIX-CAT → MOC-MATRIX-CAT (MOCSET4), → MOC-OBJ-TYPE

Programs

Updated by (2)

Referenced by (1)