CBCASHCODE – Cash Code

System
Cash Ledger (CB)
Prefix
CBC
Primary key
CASH-CODE
Fields
30
Updated by
410 programs
Referenced by
28 programs

CBCASHCODE is the Cash Code table in Lawson Cash Ledger (prefix CBC). It is indexed by CASH-CODE (CBCSET1); alternate indexes: CBCSET2 and CBCSET3. It is related 1:1 to CBBANKENT, CBCASHCODE and CUCODES and 1:M to CBADJUST, CBBALANCE, CBCASHFORM, CBCHECK, CBCPYCASH, CBCSCDAUD, CBGRPCC, CBTRANS and 2 more. It is updated by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 402 more and referenced by AP100, AP101, AP109, AP111, AP14.1, AP14.2, AP14.5, AP16.1 and 20 more. The table has 30 fields, 3 indexes and 18 documented relations.

About CBCASHCODE

The Cash Code file contains all valid cash codes. A cash code represents a bank account at a financial institution location.

Fields (30)

Column = COBOL field name without the CBC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#CBC-CASH-CODE PK
CASH_CODE
Alpha 4A user-defined code representing a bank account at a bank location.CB00.2, CB99.1
#CBC-BANK-ACCT-NBR SET3
BANK_ACCT_NBR
Alpha 35The bank-assigned account number identification to be used for the cash code.CB00.2
#CBC-BANK-IDENT
BANK_IDENT
Alpha 1—CB00.2
#CBC-CURRENCY-CODE
CURRENCY_CODE
Alpha 5The currency of the bank account. Must be a valid record in the Currency Code file.CB00.2
#CBC-BANK-ENTITY SET2 SET3
BANK_ENTITY
Alpha 15The bank location where the bank account is located. Must be a valid record in the Bank file.CB00.2
#CBC-SEND-BANK-ENT
SEND_BANK_ENT
Alpha 15If the bank for the cash code does not process electronic payments, this field contains the bank that processes the electronic payment media, if applicable. Must be a valid record in the Bank file. If left blank, the Bank Identification defaults.CB00.2
#CBC-ACTIVE-STATUS
ACTIVE_STATUS
Alpha 1The status of the of the bank account. If the bank account is Inactive, new bank transactions cannot be entered for the bank account, but bank transactions already entered in the system can be processed and reconciled. Valid values are:
  • A Active.
  • I Inactive.
CB00.2
#CBC-REC-BALANCE
REC_BALANCE
Signed 18.2The current reconciled balance of the bank account.AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +24 more
#CBC-OPEN-BALANCE
OPEN_BALANCE
Signed 18.2The current outstanding, or unreconciled, balance of the bank account.AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +24 more
#CBC-AP-DRAFTS
AP_DRAFTS
Signed 18.2—CB00.2
#CBC-AR-DRAFTS
AR_DRAFTS
Signed 18.2—CB00.2
#CBC-USED-FLAG
USED_FLAG
Alpha 1Indicates whether the cash code has been used. Valid values are:
  • Y Yes.
  • N No.
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
#CBC-CURR-ND
CURR_ND
Numeric 1The number of decimal places defined for the bank account currency.CB00.2
#CBC-ROI-RATE
ROI_RATE
Signed 5.3The return on investment rate granted by the bank. For example, the interest rate.CB00.2
#CBC-SERIAL-NUM
SERIAL_NUM
Numeric 8The serial number of the last payment tape created for the bank.CB00.2
#CBC-USER-CLASS
USER_CLASS
Alpha 12The user class assigned to the cash code. Used to restrict access and use of the cash code to a specific group of users. If left blank, no access restrictions apply.CB00.2
#CBC-RECON-STMT-REQ
RECON_STMT_REQ
Alpha 1—
  • Y Yes
  • N No
CB00.2
#CBC-RECON-JRNL-BK
RECON_JRNL_BK
Alpha 12The reconciliation journal book associated with the cash code. Used only if the Reconciliation Statement Required
  • field Yes.
—
#CBC-NET-BALANCE
NET_BALANCE
DerivedThe Reconciled Balance plus the Open Balance for the bank account.—
#CBC-RECON-STMT-NBR
RECON_STMT_NBR
Numeric 12The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.CB00.2, CB06.1
#CBC-LAST-END-BAL
LAST_END_BAL
Signed 18.2—CB00.2, CB191
#CBC-SGLSTMT-USR-FL
SGLSTMT_USR_FL
Alpha 1—CB00.2
#CBC-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field contains the description used in the GoFinancials product.CB00.2
#CBC-CBO-BAL-FLAG
CBO_BAL_FLAG
Alpha 1—CB00.2
#CBC-CREATED-BY
CREATED_BY
Alpha 10—CB00.2, CB99.1
#CBC-LAST-UPDT-DATE
LAST_UPDT_DATE
Numeric 8 (yyyymmdd)—AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
#CBC-LAST-UPDT-TIME
LAST_UPDT_TIME
Numeric 8—AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
#CBC-LAST-UPDATE-BY
LAST_UPDATE_BY
Alpha 10—AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
#CBC-SEPA-FLAG
SEPA_FLAG
Alpha 1—CB00.2
#CBC-SWIFT-ID
SWIFT_ID
Alpha 12—CB00.2

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CBCSET1
  1. CASH-CODE
PrimaryAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
CBCSET2
  1. BANK-ENTITY
  2. CASH-CODE
KeyChangeCB00.2
CBCSET3
  1. BANK-ENTITY
  2. BANK-ACCT-NBR
  3. CASH-CODE
KeyChangeCB00.2, CB185, CB81.1, CB82.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CBBANKENTCBCASHCODECUCODESCBADJUSTCBBALANCECBCASHFORMCBCHECKCBCPYCASHCBCSCDAUDCBGRPCCCBTRANSCBTRFHDRCBRECPTHDRCBCASHCODE

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CbbankentCBBANKENTRequired
CBC-BANK-ENTITY→CBE-BANK-ENTITY
CbcashcodeCBCASHCODERequired
CBC-CASH-CODE→CBC-CASH-CODE
Cbsend BankentCBBANKENTRequired
CBC-SEND-BANK-ENT→CBE-BANK-ENTITY
CucodesCUCODESRequired
CBC-CURRENCY-CODE→CUC-CURRENCY-CODE

One to many (14) — child tables

RelationTableRulesConditionField map
CbadjustCBADJUST
CBC-CASH-CODE→CBJ-CASH-CODE
—→CBJ-REC-STATUS
—→CBJ-BANK-INST-CODE
—→CBJ-TRANS-NBR
—→CBJ-SUFFIX
—→CBJ-TRANS-IDENT
Cbadjust UnrelCBADJUST
CBC-CASH-CODE→CBJ-CASH-CODE
Zeroes→CBJ-REC-STATUS
—→CBJ-BANK-INST-CODE
—→CBJ-TRANS-NBR
—→CBJ-SUFFIX
—→CBJ-TRANS-IDENT
CbbalanceCBBALANCEDelete Restricted
CBC-CASH-CODE→CBB-CASH-CODE
—→CBB-PER-END-DATE
CbcashformCBCASHFORM
CBC-CASH-CODE→CCF-CASH-CODE
—→CCF-BANK-INST-CODE
—→CCF-PROC-GRP
CbcheckCBCHECK
CBC-CASH-CODE→CHK-CASH-CODE
—→CHK-BANK-INST-CODE
—→CHK-TRANS-IDENT
CbcpycashCBCPYCASH
CBC-CASH-CODE→CBY-CASH-CODE
—→CBY-COMPANY
CbcscdaudCBCSCDAUD
CBC-CASH-CODE→CCB-CASH-CODE
—→CCB-UNIQUE-I-D
CbgrpccCBGRPCC
CBC-CASH-CODE→CCD-CASH-CODE
—→CCD-CASH-CODE-GRP
CbtransCBTRANS
CBC-CASH-CODE→CBT-CASH-CODE
—→CBT-BANK-INST-CODE
—→CBT-TRANS-NBR
—→CBT-SUFFIX
—→CBT-TRANS-IDENT
Cbtrans DateCBTRANS
CBC-CASH-CODE→CBT-CASH-CODE
—→CBT-ISSUE-DATE
—→CBT-BANK-INST-CODE
—→CBT-SOURCE-CODE
—→CBT-TRANS-NBR
—→CBT-SUFFIX
—→CBT-TRANS-IDENT
CbtrfhdrCBTRFHDR
CBC-CASH-CODE→CBH-CASH-CODE
—→CBH-TRANSFER-NBR
Recpthdr UnrelCBRECPTHDR
CBC-CASH-CODE→CBP-CASH-CODE
—→CBP-BANK-INST-CODE
—→CBP-TRANS-NBR
Trfhdr UnrelCBTRFHDR
CBC-CASH-CODE→CBH-CASH-CODE
—→CBH-TRANSFER-NBR
Unrel TrfhdrCBTRFHDR
CBC-CASH-CODE→CBH-CASH-CODE
—→CBH-TRANSFER-NBR

Programs

Updated by (410)

Referenced by (28)