Lawson Insight Technical Documentation |
|
APVNMXVAL
APVNMXVAL FILE
REFERENCED BY
AC160 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 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 AP62.1
AP90.1 AP91.1 API1.1 API2.1 API3.1 API4.1
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
MX123 MA180 MA279 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD235 PO10.1 PO100 PO101
PO120 PO122 PO131 PO20.1 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO220 PO223
PO23.1 PO233 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO253 PO254 PO27.2 PO278 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.1 PO54.2 PO54.3
PO54.4 POI3.1 POID.1 POII.1 POIJ.1 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
UK47.1 RQ10.1 RQ10.2 WH20.2 WH20.7
UPDATED BY
AP03.1 AP03.2 AP162 MX500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VMX-AP-OBJ-ID Numeric 12 AP03.1 AP03.2
Element: Obj Id This is the object identifier. It is AP162 MX500
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.
VMX-MATRIX-CAT Alpha 12 AP03.1 AP03.2
Element: Matrix Cat Attribute name assigned to an object AP162 MX500
(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: Mx Value The attribute value. AP162 MX500
APVNMXVAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VMXSET1 AP-OBJ-ID AC160 AM115
MATRIX-CAT 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
AP162 AP20.1
AP20.2 AP20.3
...
VMXSET2 MATRIX-CAT KeyChange AC160 AM115
MX-VALUE AM117 AM15.1
AP-OBJ-ID 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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.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
|