CBMXVALUE

Cash Code Attribute Value

REFERENCED BY
CB62.1 CBBC.1


UPDATED BY
CB01.4 CB01.5 CB01.7 CB162 MX500 AP150
AP155 AP160 AP161 AP265 CB00.3 CB145
CB170 CB175 CB180 CB186 CB187 CB210
CB215 CB220 CB221 CB222 CB260 CB286
MX123

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CMV-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.
CB01.4 CB01.5
CB162 MX500
CMV-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.
CB01.4 CB01.5
CB162 MX500
CMV-MX-VALUE
Element: Mx Value
Alpha 32
The attribute value.
CB01.4 CB01.5
CB162 MX500


CBMXVALUE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CMVSET1 OBJ-ID
MATRIX-CAT
AP150 AP155
AP160 AP161
AP265 CB00.3
CB01.4 CB01.5
CB01.7 CB145
CB162 CB170
CB175 CB180
CB186 CB187
CB210 CB215
CB220 CB221
CB222 CB260
CB286 CB62.1
CBBC.1 MX123
MX500
CMVSET2 MATRIX-CAT
MX-VALUE
OBJ-ID
KeyChange
AP150 AP155
AP160 AP161
AP265 CB01.7
CB145 CB170
CB175 CB180
CB186 CB187
CB210 CB215
CB220 CB221
CB222 CB260
CB286 MX123
MX500


CBMXVALUE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cbcpycash CBCPYCASH Not Required
CMV-OBJ-ID->CBY-OBJ-ID
Matrix Cat MXOBJCAT Required
"CSHCD"->MOC-OBJ-TYPE
CMV-MATRIX-CAT->MOC-MATRIX-CAT
Mxcatdef MXCATDEF Required
CMV-MATRIX-CAT->MXC-MATRIX-CAT


CBMXVALUE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Same Value CBMXVALUE
CMV-MATRIX-CAT->CMV-MATRIX-CAT
CMV-MX-VALUE->CMV-MX-VALUE
  CMV-OBJ-ID


File created: Wed Jun 08 20:48:22 2016

Home
Contact Us



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