CBMXCONV – Cash Code Attribute Conversion
- System
- Cash Ledger (CB)
- Prefix
CBN- Primary key
RUN-GROUP,COMPANY,CASH-CODE,MATRIX-CAT- Fields
- 5
- Updated by
- 2 programs
- Referenced by
- 1 program
CBMXCONV is the Cash Code Attribute Conversion table in Lawson Cash Ledger (prefix CBN). It is indexed by RUN-GROUP, COMPANY, CASH-CODE, MATRIX-CAT (CBNSET1); alternate indexes: CBNSET2 and CBNSET3. It is related 1:M to MXOBJCAT. It is updated by CB162 and CB62.1 and referenced by CB262. The table has 5 fields, 3 indexes and 1 documented relation.
About CBMXCONV
No description in the Lawson data dictionary.
Fields (5)
Column = COBOL field name without the CBN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CBN-RUN-GROUP PKRUN_GROUP | Alpha 15 | Run Group and Seq Number are the keys to the file. They should be used to group records together for interfacing. | CB62.1 |
CBN-COMPANY PKCOMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | CB62.1 |
CBN-CASH-CODE PKCASH_CODE | Alpha 4 | A cash code represents a bank account. More than one company can use the same cash code. The cash code must be linked to a bank in the Lawson Cash Ledger system. | CB62.1 |
CBN-MATRIX-CAT PKMATRIX_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. | CB62.1 |
CBN-MX-VALUEMX_VALUE | Alpha 32 | The attribute value. | CB62.1 |
Indexes (3)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CBNSET1 | RUN-GROUP, COMPANY, CASH-CODE, MATRIX-CAT | Primary | CB162, CB262, CB62.1 | |
CBNSET2 | MATRIX-CAT, COMPANY, CASH-CODE, RUN-GROUP | — | ||
CBNSET3 | COMPANY, CASH-CODE, RUN-GROUP, MATRIX-CAT | — |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Mxobjcat | MXOBJCAT | CBN-MATRIX-CAT → MOC-MATRIX-CAT (MOCSET4), MOC-OBJ-TYPE |
Programs
Updated by (2)
Referenced by (1)
- CB262 Cash Code Attribute Interface Listing