APVNMXVAL

REFERENCED BY
AP62.1


UPDATED BY
AP03.1 AP03.2 AP03.3 AP162 MX500 AM115
AM117 AM15.1 AM15.2 AM15.3 AM15.4 AM19.1
AM19.2 AM20.1 AM20.3 AM21.1 AM21.3 AM500
AM51.1 AM551 AM97.1 AP10.1 AP110 AP115
AP125 AP126 AP131 AP150 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP210
AP220 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 AP305 AP510 AP90.1 AP91.1
API1.1 API2.1 API3.1 API4.1 MX123 MX202
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO10.1
PO136 PO190 PO300 PO520 POCP.1 POI3.1
POII.1 POIJ.1 PR05.1 PR05.3 PR226 PR247
PR26.1 PR47.1 PR514 UK47.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VMX-AP-OBJ-ID
Element: Obj Id		Numeric 12
This 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
Element: Matrix Cat		Alpha 12
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.
AP03.1 AP03.2
AP162 MX500
VMX-MX-VALUE
Element: Mx Value		Alpha 32
The attribute value.
AP03.1 AP03.2
AP162 MX500


APVNMXVAL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VMXSET1 AP-OBJ-ID
MATRIX-CAT
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP03.1 AP03.2
AP03.3 AP10.1
AP110 AP115
AP125 AP126
AP131 AP150
AP162 AP20.1
AP20.2 AP20.3
VMXSET2 MATRIX-CAT
MX-VALUE
AP-OBJ-ID
KeyChange
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1


APVNMXVAL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Wed Jun 08 20:47:37 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.