CBCATEGORY – Cash Receipt Category

System
Cash Ledger (CB)
Prefix
CBG
Primary key
COMPANY, PROC-LEVEL, PROD-TAX-CAT
Fields
12
Updated by
5 programs
Referenced by
1 program

CBCATEGORY is the Cash Receipt Category table in Lawson Cash Ledger (prefix CBG). It is indexed by COMPANY, PROC-LEVEL, PROD-TAX-CAT (CBGSET1). It is related 1:1 to CBPROCLEV. It is updated by CB03.2, CB10.3, CB10.5, CB150 and CB543 and referenced by CB43.1. The table has 12 fields, 1 index and 1 documented relation.

About CBCATEGORY

The Cash Receipt Category file contains all valid cash receipt categories. A cash receipt category represents a type of product or service and is used to itemize cash deposits.

Fields (12)

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

Field / columnTypeDescription & valuesUpdated by
CBG-COMPANY PK
COMPANY		Numeric 4The company number. Must be a valid record in the General Ledger Company file.CB03.2
CBG-PROC-LEVEL PK
PROC_LEVEL		Alpha 5The cash deposit process level associated with the cash receipt category. Used only by general ledger companies that use cash deposit process levels to make cash deposits. Must be a valid record in the Cash Deposit Process Level file.CB03.2
CBG-PROD-TAX-CAT PK
PROD_TAX_CAT		Alpha 15A user-defined code representing a cash receipt category. Used to itemize cash deposits.CB03.2
CBG-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description of the cash receipt category.CB03.2
CBG-REV-ACCT-UNIT
REV_ACCT_UNIT		Alpha 15The general ledger revenue accounting unit for the cash receipt category. Must be a valid record in the General Ledger Names file.CB03.2
CBG-REV-ACCOUNT
REV_ACCOUNT		Numeric 6The general ledger revenue account number for the cash receipt category. Must be a valid record in the General Ledger Account Master file.CB03.2
CBG-REV-SUB-ACCT
REV_SUB_ACCT		Numeric 4The general ledger revenue subaccount number for the cash receipt category. Must be a valid record in the General Ledger Account Master file.CB03.2
CBG-TAX-CODE
TAX_CODE		Alpha 10The tax code to be applied to deposits for the cash receipt category. Represents a tax liability for a category distribution amount and is used to calculate tax information for a category distribution. Must be a valid record in the Tax Code file.CB03.2
CBG-USED-FLAG
USED_FLAG		Alpha 1Indicates whether the category has been used. Valid values are:
  • Y Yes.
  • N No.
CB10.3, CB10.5, CB150, CB543
CBG-ACTIVITY
ACTIVITY		Alpha 15The default activity assigned to the cash receipt category. Must be a valid record in the Activity file. Activities are the tasks that make up an activity group. Activities identify work being done, such as work orders, phases, products, and so on. A variety of costs, revenues, or both make up an activity.CB03.2
CBG-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5The default account category assigned to the cash receipt category. Must be a valid record in the Activity Account Category file. Account categories are the Activity Management accounts by which activity transactions are grouped for budgeting and reporting.CB03.2
CBG-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1—
  • A Active
  • I Inactive
CB03.2

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CBGSET1COMPANY, PROC-LEVEL, PROD-TAX-CATPrimaryCB03.2, CB10.1, CB10.3, CB10.5, CB150, CB43.1, CB543

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CbproclevCBPROCLEVRequiredCBG-COMPANY → CBV-COMPANY, CBG-PROC-LEVEL → CBV-PROC-LEVEL

Programs

Updated by (5)

Referenced by (1)