CBUSER – Cash Ledger User

System
Cash Ledger (CB)
Prefix
CBU
Primary key
USER-CLASS, USER-ID
Fields
4
Updated by
2 programs
Referenced by
410 programs

CBUSER is the Cash Ledger User table in Lawson Cash Ledger (prefix CBU). It is indexed by USER-CLASS, USER-ID (CBUSET1). It is related 1:1 to CBUSRCLASS. It is updated by CB04.1 and CB04.2 and referenced by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 402 more. The table has 4 fields, 1 index and 1 documented relation.

About CBUSER

The Cash Ledger User file contains all valid users for a Cash Ledger user class.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
CBU-USER-CLASS PK
USER_CLASS		Alpha 12The user class. Must be a valid record in the Cash Ledger User Class file.CB04.2
CBU-USER-ID PK
USER_ID		Alpha 10 (Lower Case)The user's system login identification.CB04.2
CBU-INQUIRE-ACCESS
INQUIRE_ACCESS		Alpha 1Indicates whether the user can display information about the cash code throughout the Lawson Cash Ledger system. Valid values are:
  • Y Yes.
  • N No.
CB04.2
CBU-UPDATE-ACCESS
UPDATE_ACCESS		Alpha 1Indicates whether the user can add, change, delete, or update information for the cash code throughout the Lawson Cash Ledger system. Valid values are:
  • Y Yes.
  • N No.
CB04.2

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CBUSET1USER-CLASS, USER-IDPrimaryAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CbusrclassCBUSRCLASSRequiredCBU-USER-CLASS → CBS-USER-CLASS

Programs

Updated by (2)

Referenced by (410)