APVNMXVAL FILE
REFERENCED BY
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM20.1 AM20.3 AM21.1 AM21.3 AM500 AM51.1
AM551 AM97.1 AP10.1 AP510 API3.1 API4.1
IC840 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 UK47.1
UPDATED BY
AP03.1 AP03.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VMX-AP-OBJ-ID Numeric 12 AP03.1 AP03.2
Object
Identification
VMX-MATRIX-CAT Alpha 12 AP03.1 AP03.2
Element: Attribute Attribute 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.
VMX-MX-VALUE Alpha 32 AP03.1 AP03.2
Element: Attribute ValuThe attribute value.
APVNMXVAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VMXSET1 AP-OBJ-ID AM115 AM117
MATRIX-CAT AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP03.1 AP03.2
AP03.3 AP10.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VMXSET2 MATRIX-CAT KeyChange AM115 AM117
MX-VALUE AM15.1 AM15.2
AP-OBJ-ID AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP03.3 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
APVNMXVAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apvenmast APVENMAST Required
VMX-AP-OBJ-ID -> VEN-AP-OBJ-ID
Mxcatdef MXCATDEF Required
VMX-MATRIX-CAT -> MXC-MATRIX-CAT
Mxobjcat MXOBJCAT Required
"VENDR" -> MOC-OBJ-TYPE
VMX-MATRIX-CAT -> MOC-MATRIX-CAT
|