Cash Ledger – Lawson CB tables and programs
Cash Ledger (CB) in Lawson S3 v10 MSP6 has 65 tables, 91 online screens and 38 batch programs.
Tables (65)
| Table | Prefix | Description | Primary key | Fields |
|---|---|---|---|---|
| CBADJUST | CBJ | Reconciliation Adjustment | BANK-INST-CODE, TRANS-IDENT | 18 |
| CBAUTONBR | CBW | No description in the Lawson data dictionary | COMPANY | 2 |
| CBBALANCE | CBB | Bank Account Balance | CASH-CODE, PER-END-DATE | 10 |
| CBBANKAUD | CAB | Bank Entity Audit | BANK-ENTITY, UNIQUE-I-D | 14 |
| CBBANKBOD | YBG | No description in the Lawson data dictionary | BANK-ENTITY | 7 |
| CBBANKENT | CBE | Bank | BANK-ENTITY | 26 |
| CBBANKINST | CBI | Bank Transaction Code | BANK-INST-CODE | 34 |
| CBCASHCODE | CBC | Cash Code | CASH-CODE | 30 |
| CBCASHFORM | CCF | Cash Payment Format | CASH-CODE, BANK-INST-CODE, PROC-GRP | 13 |
| CBCATEGORY | CBG | Cash Receipt Category | COMPANY, PROC-LEVEL, PROD-TAX-CAT | 12 |
| CBCCGRP | CCG | Cash Code Group | CASH-CODE-GRP | 2 |
| CBCCTRNJB | CJB | Cash Code Journal Book | COMPANY, CASH-CODE, BANK-INST-CODE | 4 |
| CBCHECK | CHK | Accounts Payable Cash Payment | CASH-CODE, BANK-INST-CODE, TRANS-IDENT | 39 |
| CBCHRGCODE | CRG | No description in the Lawson data dictionary | CHARGE-CODE | 3 |
| CBCONSOL | CBO | This file is updated by a batch program that consolidated CBTRANS amounts by Cash Code/Bank Inst Code/Company. | CASH-CODE, BANK-INST-CODE, COMPANY, MAINT-DATE | 24 |
| CBCPCSAUD | CCC | Company Cash Code Audit | COMPANY, CASH-CODE, UNIQUE-I-D | 16 |
| CBCPYCASH | CBY | Company-Cash Code Relationship | COMPANY, CASH-CODE | 53 |
| CBCREDRISK | CCR | Credit Risk | BANK-ENTITY, CREDIT-LINE | 9 |
| CBCSCDAUD | CCB | Cash Code Audit | CASH-CODE, UNIQUE-I-D | 14 |
| CBCTRANS | CVC | Bank Transaction Conversion/In | RUN-GROUP, CASH-CODE, BANK-INST-CODE, TRANS-NBR, SEQ-NBR | 44 |
| CBDICT | CBQ | No description in the Lawson data dictionary | DB-FILE-PFX, FLD-NBR | 5 |
| CBDISTRIB | CBD | Transaction Distribution | CASH-CODE, BANK-INST-CODE, TRANS-IDENT, DIST-TYPE, SEQ-NBR | 38 |
| CBDRFTFORM | CBF | Bill of Exchange Paymnt Format | COMPANY, BANK-INST-CODE | 8 |
| CBESCHEAT | CSC | Cash Ledger Escheatment Accounts | COMPANY, CASH-CODE, PROC-LEVEL | 9 |
| CBFORMATS | CFM | No description in the Lawson data dictionary | FORMAT-NBR | 2 |
| CBFTTRANS | CFT | EFT Deposit Extract Data | CASH-CODE, BANK-INST-CODE, TRANS-IDENT | 33 |
| CBGRPCC | CCD | Cash Code Group Cash Codes | CASH-CODE-GRP, CASH-CODE | 2 |
| CBIABNKDIM | CIB | No description in the Lawson data dictionary | BNK-DIMENSION | 8 |
| CBIACSHDIM | CDC | No description in the Lawson data dictionary | CSH-DIMENSION | 3 |
| CBIACSHMBR | CZZ | No description in the Lawson data dictionary | CSH-DIMENSION, CASH-CODE-GRP | 3 |
| CBIADIM | CDM | No description in the Lawson data dictionary | DATA-MART-NAME | 8 |
| CBIAMXCSH | CYZ | No description in the Lawson data dictionary | CSH-DIMENSION, MATRIX-CAT | 3 |
| CBIAORGDIM | CDO | No description in the Lawson data dictionary | ORG-DIMENSION | 7 |
| CBIARPTDIM | CIR | No description in the Lawson data dictionary | RPT-DIMENSION | 12 |
| CBIASCNDIM | CDS | No description in the Lawson data dictionary | SCN-DIMENSION | 3 |
| CBIASCNMBR | CDZ | No description in the Lawson data dictionary | SCN-DIMENSION, MBR-NAME | 4 |
| CBIASTADIM | CIS | No description in the Lawson data dictionary | STA-DIMENSION | 23 |
| CBMXCONV | CBN | Cash Code Attribute Conversion | RUN-GROUP, COMPANY, CASH-CODE, MATRIX-CAT | 5 |
| CBMXVALUE | CMV | Cash Code Attribute Value | OBJ-ID, MATRIX-CAT | 3 |
| CBPAYMENT | CBM | Cash Payment | CASH-CODE, BANK-INST-CODE, TRANS-IDENT | 67 |
| CBPMTBOD | YBH | No description in the Lawson data dictionary | CASH-CODE, BANK-INST-CODE, TRANS-IDENT | 9 |
| CBPMTCAT | CCY | No description in the Lawson data dictionary | PMT-CAT-CODE | 3 |
| CBPMTFORM | CPF | No description in the Lawson data dictionary | PAYMENT-FORM | 3 |
| CBPMTLOAD | CLO | Cash Payment Conversion/Import | RUN-GROUP, CASH-CODE, BANK-INST-CODE, REFERENCE-NO, SEQ-NBR | 64 |
| CBPOSIDATE | CPS | Cash Positive Date | CASH-CODE, BANK-INST-CODE | 4 |
| CBPROCLEV | CBV | Cash Receipt Process Level | COMPANY, PROC-LEVEL | 14 |
| CBRCHDBOD | YBJ | No description in the Lawson data dictionary | CASH-CODE, BANK-INST-CODE, TRANS-NBR | 9 |
| CBRECLOAD | CRC | Cash Receipt Conversion/Import | RUN-GROUP, CASH-CODE, BANK-INST-CODE, TRANS-NBR, SEQ-NBR | 41 |
| CBRECON | CBR | Manual Reconciliation Entry | CASH-CODE, BANK-INST-CODE, TRANS-NBR, TRANS-IDENT | 8 |
| CBRECPTDTL | CBA | Cash Receipt Detail | CASH-CODE, BANK-INST-CODE, TRANS-NBR, SEQ-NBR | 23 |
| CBRECPTHDR | CBP | Cash Receipt Deposit | CASH-CODE, BANK-INST-CODE, TRANS-NBR | 30 |
| CBRETPMT | CRP | Return Payment | CASH-CODE, BANK-INST-CODE, TRANS-IDENT | 39 |
| CBRTPLOAD | RPL | Return Payment Conversion/Imp | CASH-CODE, BANK-INST-CODE, TRANS-NBR, SEQ-NBR | 37 |
| CBSEGBLOCK | CBK | Cash Segment Block | CASH-CODE, BANK-INST-CODE, TRANS-IDENT, DIST-TYPE, SEQ-NBR | 6 |
| CBSTATEMNT | CSM | Reconciliation Statement | CASH-CODE, RECON-STMT-NBR | 22 |
| CBSTMTDTL | CSD | Cash Staement Detail | CASH-CODE, RECON-STMT-NBR, LINE-NBR | 18 |
| CBSTMTREC | CSR | No description in the Lawson data dictionary | STMT-NBR, STMT-SUFFIX, LINE-NBR | 22 |
| CBTRANS | CBT | Bank Transaction | BANK-INST-CODE, TRANS-IDENT | 73 |
| CBTRANSAUD | CAU | No description in the Lawson data dictionary | BANK-INST-CODE, TRANS-IDENT, UNIQUE-I-D | 19 |
| CBTRANSBOD | YCL | No description in the Lawson data dictionary | CASH-CODE, BANK-INST-CODE, TRANS-NBR, SUFFIX, TRANS-IDENT | 11 |
| CBTRFDTL | CBL | Fund Transfer Detail | CASH-CODE, TRANSFER-NBR, DTL-CASH-CODE | 19 |
| CBTRFHDR | CBH | Fund Transfer | CASH-CODE, TRANSFER-NBR | 25 |
| CBTRFTABLE | CBX | Fund Transfer Table | CASH-CODE | 4 |
| CBUSER | CBU | Cash Ledger User | USER-CLASS, USER-ID | 4 |
| CBUSRCLASS | CBS | Cash Ledger User Class | USER-CLASS | 2 |
Online screens (91)
| Screen | Description | Updates | References |
|---|---|---|---|
| CB00.1 | Bank | 4 | 27 |
| CB00.2 | Cash Code | 7 | 6 |
| CB00.3 | Company Cash Code Relationships | 9 | 14 |
| CB00.4 | Bank Transaction Definition | 1 | 0 |
| CB00.5 | Cash Payment Formats | 4 | 6 |
| CB00.7 | Cash Payments | 1 | 0 |
| CB01.1 | Credit Risk | 4 | 4 |
| CB01.2 | BOE Payment Formats | 2 | 5 |
| CB01.3 | Cash Code Security | 0 | 2 |
| CB01.4 | Attributes | 3 | 12 |
| CB01.5 | Values by Attribute | 2 | 6 |
| CB01.6 | Manual Cash Code List | 3 | 2 |
| CB01.7 | Cash Code List Members | 2 | 8 |
| CB02.1 | Bank Transfer Table | 3 | 2 |
| CB03.1 | Cash Receipt Process Levels | 2 | 4 |
| CB03.2 | Cash Receipt Category | 6 | 10 |
| CB04.1 | Cash Ledger Security | 2 | 0 |
| CB04.2 | Cash Ledger Users | 1 | 1 |
| CB05.1 | Cash Code Journal Book | 3 | 8 |
| CB06.1 | Bank Statement | 8 | 15 |
| CB06.2 | Bank Statement Detail Entry | 34 | 46 |
| CB07.1 | Stale Dating Accounts | 4 | 5 |
| CB08.1 | Payment Form Code | 1 | 0 |
| CB08.2 | Charge Code | 1 | 0 |
| CB08.3 | Payment Category | 1 | 0 |
| CB09.1 | CB Auto Numbering by Company | 1 | 1 |
| CB10.1 | Cash Receipt Deposit | 35 | 73 |
| CB10.3 | Cash Receipt Entry | 9 | 12 |
| CB10.5 | Cash Receipt Detail Rebate Option | 12 | 15 |
| CB11.1 | Cash Code Group | 1 | 2 |
| CB11.2 | Define Cash Code Group | 2 | 1 |
| CB15.1 | Bank Fund Transfer - Multiple Deposits | 26 | 47 |
| CB15.2 | Bank Fund Transfer - Multiple Withdrawals | 16 | 51 |
| CB20.1 | Bank Transaction Entry | 31 | 55 |
| CB20.6 | Bank Transaction DIstribution | 14 | 19 |
| CB25.1 | Manual Reconciliation Entry | 10 | 14 |
| CB30.1 | Reconciliation Variance Adjustment | 31 | 44 |
| CB43.1 | Receipts Load Maintenance | 13 | 27 |
| CB44.1 | Returned Payment Maintenance | 9 | 21 |
| CB45.1 | EFT/CC Extract Entry | 26 | 48 |
| CB46.1 | Returned Payment Entry | 32 | 54 |
| CB50.1 | Bank Transaction Interface Maintenance | 10 | 25 |
| CB54.1 | Payment Load Maintenance | 9 | 22 |
| CB55.1 | Payment Entry | 28 | 59 |
| CB56.1 | Cash Payment Inquiry | 0 | 1 |
| CB56.2 | CB Reportable Income Adjustments | 4 | 5 |
| CB56.4 | Selection Criteria | 2 | 2 |
| CB57.1 | Payment Cancel | 18 | 17 |
| CB62.1 | Cash Code Attribute Interface Maintenance | 2 | 11 |
| CB80.1 | Bank Transaction Adjustment | 27 | 23 |
| CB81.1 | Reconciliation Statement Maintenance | 3 | 2 |
| CB82.1 | Statement Reconciliation | 26 | 22 |
| CB82.2 | Selection Criteria | 1 | 0 |
| CB85.1 | Tape Payment Rejection | 2 | 1 |
| CB89.1 | Bank Entity Audit Analysis | 0 | 2 |
| CB89.2 | Selection Criteria | 0 | 1 |
| CB89.3 | Cash Code Audit Analysis | 0 | 2 |
| CB89.4 | Company Cash Code Audit Analysis | 0 | 2 |
| CB90.1 | Current Bank Account Balance | 1 | 2 |
| CB90.2 | Currency Analysis | 2 | 9 |
| CB90.3 | Bank Account Period Balance | 1 | 3 |
| CB90.4 | Bank Transactions | 2 | 3 |
| CB90.5 | Selection Criteria | 1 | 4 |
| CB90.6 | Transaction Balance Inquiry at Cash Code Level | 1 | 3 |
| CB90.7 | Transaction Balance Inquiry at Company Level | 2 | 7 |
| CB90.8 | Transaction Balance Inquiry at Tran Code Level | 2 | 3 |
| CB95.1 | Cash Code Audit | 1 | 3 |
| CB95.2 | Operator Audit | 0 | 1 |
| CB99.1 | Bank Account Balance Update | 1 | 3 |
| CB99.2 | Bank Period Balance Update | 1 | 1 |
| CB99.3 | Transaction Bank Balance Update | 3 | 6 |
| CB99.4 | Transaction Account Balance Update | 3 | 6 |
| CB99.5 | Transaction Open Balance Update | 4 | 6 |
| CBBB.1 | Build Bank Instrument Dimension | 7 | 5 |
| CBBC.1 | Olap Dimension Retrieval Format | 7 | 13 |
| CBBD.1 | Olap Dimension Retrieval Format | 7 | 5 |
| CBBI.1 | General Ledger Accounting Unit Edit | 1 | 0 |
| CBBO.1 | Olap Dimension Retrieval Format | 7 | 6 |
| CBBR.1 | Build Bank Instrument Dimension | 7 | 5 |
| CBBT.1 | Build Transaction Status Dimension | 7 | 4 |
| CBD2.1 | Reporting Currency Dimension Definition | 1 | 2 |
| CBD2.2 | Transaction Status Dimension Definition | 1 | 0 |
| CBD2.3 | Bank Instrument Dimension Definition | 1 | 0 |
| CBDM.1 | Cash Ledger Data Mart Setup | 1 | 7 |
| CBDM.2 | Intraday Dimension Definition | 2 | 0 |
| CBDM.3 | CB Organization Dimension Definition | 1 | 0 |
| CBDM.4 | Cash Code Dimension Definition | 2 | 2 |
| CBDM.5 | Dimension Attributes | 1 | 4 |
| CBOD.1 | CB BOD Maintenance | 4 | 1 |
| CBOD.2 | CB BOD Inquiry | 0 | 6 |
| CBOP.1 | Cash Ledger OLAP Data Build | 3 | 22 |
Batch programs (38)
| Program | Description | Updates | References |
|---|---|---|---|
| CB145 | EFT Extract Update | 14 | 26 |
| CB150 | Mass Release | 39 | 71 |
| CB162 | Cash Code Attribute Interface | 5 | 9 |
| CB170 | Positive Pay File Creation | 8 | 15 |
| CB175 | Bank Transaction Posting | 9 | 23 |
| CB180 | Cash Ledger Void Update | 33 | 39 |
| CB181 | CBCONSOL Current Day Build | 2 | 1 |
| CB185 | Bank Tape Mass Reconciliation | 15 | 15 |
| CB186 | Stale Dating Processing | 13 | 28 |
| CB187 | Stale Dating Reopen Update | 13 | 26 |
| CB190 | Bank Period Close | 11 | 16 |
| CB191 | Bank Statement Close | 47 | 73 |
| CB195 | Company Period Close | 5 | 19 |
| CB210 | Cash Receipt Deposit Listing | 7 | 18 |
| CB211 | Cash Code Group Listing | 1 | 4 |
| CB215 | Bank Transfer Listing | 6 | 17 |
| CB220 | Bank History Report | 7 | 16 |
| CB221 | Bank Transaction Listing | 7 | 19 |
| CB222 | Cash Position Reconciliation | 21 | 77 |
| CB245 | EFT Extract Listing | 3 | 6 |
| CB246 | Return Payment Listing | 3 | 6 |
| CB255 | Payment Listing | 5 | 11 |
| CB260 | Cash Account Activity | 7 | 16 |
| CB262 | Cash Code Attribute Interface Listing | 1 | 4 |
| CB281 | Reconciliation Statement List | 2 | 4 |
| CB286 | Stale Dating and Escheatment Report | 6 | 22 |
| CB295 | Bank Transaction Audit Report | 3 | 4 |
| CB300 | History Purge | 21 | 5 |
| CB305 | Audit Report and Purge | 6 | 5 |
| CB500 | Bank Transaction Interface | 32 | 56 |
| CB543 | Receipts Load | 38 | 57 |
| CB544 | Returned Payment Load | 34 | 58 |
| CB554 | Payment Load | 27 | 57 |
| CB580 | Payment Formats Load | 2 | 1 |
| CB588 | CB Dictionary Load | 2 | 0 |
| CB590 | CB Data Mart Registration | 3 | 0 |
| CB700 | CB08 Load | 4 | 2 |
| CB750 | CB shell program for BOD files | 1 | 3 |
Other tables used by Cash Ledger programs (217)
ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL, ACCALX, ACCATGRP, ACCATGRPX, ACCATSUM, ACCATSUMX, ACCNTRACT, ACCOMMIT, ACCOMMITX, ACCONSOL, ACDETAILAU, ACHEADERAU, ACIFACTV, ACTRANS, ADDRDATA, AGEUSERONE, AGINGCODE, AMACCTAU, AMACCTGPAU, AMASTTYPAU, AMAUGRPAU, AMDICT2, AMDIVISNAU, AMSYSOPTAU, APACCRCODE, APAPPHIST, APCOMPANY, APCONTACT, APDRAFTS, APDRFTDIST, APINCCODE, APINVOICE, APMONITOR, APPAYGROUP, APPAYMENT, APPLICTYPE, APPMTBOD, APPROCGRP, APPROCLEV, APRPTBLINC, APVENADDR, APVENBAL, APVENCLASS, APVENGROUP, APVENLCBOD, APVENLOC, APVENMAST, ARACPIVOT, ARADJUST, ARAPPLDBOD, ARAPPLIED, ARCODE, ARCOMP, ARCONTACTS, ARCUSTBOD, ARCUSTFLDS, ARCUSTGRP, ARCUSTOMER, ARCUSTPER, ARCUSTTOTS, ARDISTRIB, ARITEMAUD, ARLOCKBOX, AROIHDR, AROITEMS, AROPIVOT, ARPAYMENT, ARPROCLEVL, ARPYMNTHDR, ARREMIT, ARSADJUST, ARSAPPLIED, ARSUMMARY, ARUDISTRIB, ARUPMNTHDR, ARXIND, AUMXVALUAU, AUMXVLDTAU, BILLTO, BILLTOBOD, C2IPAYMENT, CAALOCGPAU, CADETAILAU, CAHEADERAU, CONBOD, CUACCT, CUACCTAU, CUAMOUNT, CUCODES, CUCODESAU, CUCONV, CUCONVAU, CURELAT, CURELATAU, CUSTDESC, CUSTEP, CUSTORDER, CUTABLE, CUTABLEAU, CUTRANSL, CUTRNSLAU, EBCSVREC, EPTRANS, FBADJCODAU, FBCNTRLAU, FBDETAIL, FBDETAILAU, FBFNDHDRAU, FBFUNDAMT, FBFUNDDTL, FBHEADER, FBHEADERAU, FBHSTHDRAU, FBINTBUAU, FBSPREADAU, FBTRANS, FBTRANSAU, FBYETR, FTTRANS, GLACCTVLD, GLACMXVLAU, GLADDRESS, GLAMOUNTS, GLAUTMXVAU, GLCGCPY, GLCHART, GLCHARTDTL, GLCHARTSUM, GLCHTDTLAU, GLCODES, GLCOMMIT, GLCOMMITX, GLCPYGRP, GLHISCOMBL, GLHISCOMX, GLINTCO, GLMASTER, GLMASTERAU, GLNAMES, GLNAMESAU, GLSRCCODE, GLSYSTEM, GLSYSTEMAU, GLTRANS, GMFNDACT, GTMXVALUAU, IACALCMBR, IADIMTYPES, IADRILL, IAFILEDEF, IAFILEDLT, IAFORMULA, IATIME, INFERCONCD, INSTCTRYCD, JBKACCT, JBKOPCODE, JBKSEQNBR, JBKSYSCODE, JBOOKHDR, LANGPREF, MACAPDTL, MLCOLEDGER, MXCATDEF, MXCATDEFAU, MXELEMENT, MXELEMNTAU, MXLISTDTL, MXLISTHDR, MXLISTMBR, MXLSTDTLAU, MXLSTHDRAU, MXOBJCAT, MXOBJCATAU, MXTMPDTLAU, MXTMPHDRAU, MXTMPLDTL, MXTMPLHDR, MXTPEFDTAU, MXTPHEDTAU, MXVALIDATE, MXVALIDAU, MXVEWDTLAU, MXVEWHDRAU, NATACCT, NATBALANCE, OECOMPANY, OECUST, OLAPDBM, OLAPDIM, POCONTGRP, POCONTRACT, POCONTREB, POREBDIST, POREBDUE, POREBRECD, RJMXVALUAU, ROLAPDIM, ROLAPIDS, STATICCUST, SUBCKPOINT, SYSTEMCODE, TXCODEMAST, TXCOMPANY, TXTAXCODE, TXTAXRATE, TXTAXTABLE, TXTAXTRAN, VBABOD, WFSETUP