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.

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
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 1CB00.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
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.2CB00.2
CBC-AR-DRAFTS
AR_DRAFTS
Signed 18.2CB00.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.2CB00.2, CB191
CBC-SGLSTMT-USR-FL
SGLSTMT_USR_FL
Alpha 1CB00.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 1CB00.2
CBC-CREATED-BY
CREATED_BY
Alpha 10CB00.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 8AC160, 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 10AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
CBC-SEPA-FLAG
SEPA_FLAG
Alpha 1CB00.2
CBC-SWIFT-ID
SWIFT_ID
Alpha 12CB00.2

Indexes (3)

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

IndexKeysFlagsConditionUsed in
CBCSET1CASH-CODEPrimaryAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
CBCSET2BANK-ENTITY, CASH-CODEKeyChangeCB00.2
CBCSET3BANK-ENTITY, BANK-ACCT-NBR, CASH-CODEKeyChangeCB00.2, CB185, CB81.1, CB82.1

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CbbankentCBBANKENTRequiredCBC-BANK-ENTITYCBE-BANK-ENTITY
CbcashcodeCBCASHCODERequiredCBC-CASH-CODECBC-CASH-CODE
Cbsend BankentCBBANKENTRequiredCBC-SEND-BANK-ENTCBE-BANK-ENTITY
CucodesCUCODESRequiredCBC-CURRENCY-CODECUC-CURRENCY-CODE

One to many (14) — child tables

RelationTableRulesConditionField map
CbadjustCBADJUSTCBC-CASH-CODECBJ-CASH-CODE, CBJ-REC-STATUS, CBJ-BANK-INST-CODE, CBJ-TRANS-NBR, CBJ-SUFFIX, CBJ-TRANS-IDENT
Cbadjust UnrelCBADJUSTCBC-CASH-CODECBJ-CASH-CODE, ZeroesCBJ-REC-STATUS, CBJ-BANK-INST-CODE, CBJ-TRANS-NBR, CBJ-SUFFIX, CBJ-TRANS-IDENT
CbbalanceCBBALANCEDelete RestrictedCBC-CASH-CODECBB-CASH-CODE, CBB-PER-END-DATE
CbcashformCBCASHFORMCBC-CASH-CODECCF-CASH-CODE, CCF-BANK-INST-CODE, CCF-PROC-GRP
CbcheckCBCHECKCBC-CASH-CODECHK-CASH-CODE, CHK-BANK-INST-CODE, CHK-TRANS-IDENT
CbcpycashCBCPYCASHCBC-CASH-CODECBY-CASH-CODE, CBY-COMPANY
CbcscdaudCBCSCDAUDCBC-CASH-CODECCB-CASH-CODE, CCB-UNIQUE-I-D
CbgrpccCBGRPCCCBC-CASH-CODECCD-CASH-CODE, CCD-CASH-CODE-GRP
CbtransCBTRANSCBC-CASH-CODECBT-CASH-CODE, CBT-BANK-INST-CODE, CBT-TRANS-NBR, CBT-SUFFIX, CBT-TRANS-IDENT
Cbtrans DateCBTRANSCBC-CASH-CODECBT-CASH-CODE, CBT-ISSUE-DATE, CBT-BANK-INST-CODE, CBT-SOURCE-CODE, CBT-TRANS-NBR, CBT-SUFFIX, CBT-TRANS-IDENT
CbtrfhdrCBTRFHDRCBC-CASH-CODECBH-CASH-CODE, CBH-TRANSFER-NBR
Recpthdr UnrelCBRECPTHDRCBC-CASH-CODECBP-CASH-CODE, CBP-BANK-INST-CODE, CBP-TRANS-NBR
Trfhdr UnrelCBTRFHDRCBC-CASH-CODECBH-CASH-CODE, CBH-TRANSFER-NBR
Unrel TrfhdrCBTRFHDRCBC-CASH-CODECBH-CASH-CODE, CBH-TRANSFER-NBR

Programs

Updated by (410)

Referenced by (28)