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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 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
VNCSET1
  1. RUN-GROUP
  2. VENDOR-GROUP
  3. VENDOR
  4. MATRIX-CAT
PrimaryAP162, AP262, AP62.1
VNCSET2
  1. MATRIX-CAT
  2. VENDOR-GROUP
  3. VENDOR
—
VNCSET3
  1. VENDOR-GROUP
  2. VENDOR
  3. MATRIX-CAT
—

Relations

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

One to many (1) — child tables

RelationTableRulesConditionField map
MxobjcatMXOBJCAT
VNC-MATRIX-CAT→MOC-MATRIX-CAT (MOCSET4)
—→MOC-OBJ-TYPE

Programs

Updated by (2)

Referenced by (1)