CBMXVALUE – Cash Code Attribute Value

System
Cash Ledger (CB)
Prefix
CMV
Primary key
OBJ-ID, MATRIX-CAT
Fields
3
Updated by
4 programs
Referenced by
23 programs

CBMXVALUE is the Cash Code Attribute Value table in Lawson Cash Ledger (prefix CMV). It is indexed by OBJ-ID, MATRIX-CAT (CMVSET1); alternate indexes: CMVSET2. It is related 1:1 to CBCPYCASH, MXOBJCAT and MXCATDEF and 1:M to CBMXVALUE. It is updated by CB01.4, CB01.5, CB162 and MX500 and referenced by AP150, AP155, AP160, AP161, AP265, CB00.3, CB145, CB170 and 15 more. The table has 3 fields, 2 indexes and 4 documented relations.

About CBMXVALUE

No description in the Lawson data dictionary.

Fields (3)

Column = COBOL field name without the CMV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CMV-OBJ-ID PK
OBJ_ID		Numeric 12This 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 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.CB01.4, CB01.5, CB162, MX500
CMV-MX-VALUE
MX_VALUE		Alpha 32The attribute value.CB01.4, CB01.5, CB162, MX500

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CMVSET1OBJ-ID, MATRIX-CATPrimaryAP150, AP155, AP160, AP161, AP265, ZA161, CB00.3, CB01.4 +20 more
CMVSET2MATRIX-CAT, MX-VALUE, OBJ-IDKeyChangeAP150, AP155, AP160, AP161, AP265, ZA161, CB01.7, CB145 +14 more

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CbcpycashCBCPYCASHNot RequiredCMV-OBJ-ID → CBY-OBJ-ID
Matrix CatMXOBJCATRequired"CSHCD" → MOC-OBJ-TYPE, CMV-MATRIX-CAT → MOC-MATRIX-CAT
MxcatdefMXCATDEFRequiredCMV-MATRIX-CAT → MXC-MATRIX-CAT

One to many (1) — child tables

RelationTableRulesConditionField map
Same ValueCBMXVALUECMV-MATRIX-CAT → CMV-MATRIX-CAT, CMV-MX-VALUE → CMV-MX-VALUE, → CMV-OBJ-ID

Programs

Updated by (4)

Referenced by (23)