CB191 – Bank Statement Close
- System
- Cash Ledger (CB)
- Type
- Batch program
- Updates
- 47 tables
- References
- 73 tables
CB191 (Bank Statement Close) is a Lawson Cash Ledger batch program. It updates ACCOMMIT, ACCOMMITX, ACTRANS, ADDRDATA, APMONITOR, APPAYMENT, ARACPIVOT, ARAPPLIED and 39 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL and 65 more.
About CB191
After you enter and release all transactions associated with a bank statement, run Bank Statement Close (CB191) to close the bank statement. This is required for cash codes that have Yes selected in the ReconciliationStatement Required field on Cash Code (CB00.2). **Processing Effect The program evaluates cash ledger transactions associated with a specific bank statement number. If the total transaction amount is correct for the beginning and ending balances defined for the bank statement on Bank Statement (CB06.1), the program updates the transaction records with a Statement Closed status and updates the statement record with a Closed status.
Updated files (47)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ACTRANS | Activity Transaction | AC |
| ADDRDATA | Address Code | IF |
| APMONITOR | Accounts Payable Monitor | AP |
| APPAYMENT | Invoice Payment | AP |
| ARACPIVOT | Acct Receivables Payment Trans | AR |
| ARAPPLIED | Acct Receivables Application | AR |
| ARCUSTOMER | AR Company Customer | AR |
| ARCUSTPER | AR Customer Period Totals | AR |
| ARDISTRIB | AR Distributions | AR |
| ARPAYMENT | Acct Receivables Payment | AR |
| ARPYMNTHDR | Acct Receivables Payment Batch | AR |
| ARSUMMARY | Transaction Activity | AR |
| ARUDISTRIB | No description in the Lawson data dictionary | AR |
| ARUPMNTHDR | No description in the Lawson data dictionary | AR |
| CBBANKENT | Bank | CB |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | CB |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBCONSOL | This file is updated by a batch program that consolidated CBTRANS amounts by Cash Code/Bank Inst Code/Company. | CB |
| CBCPYCASH | Company-Cash Code Relationship | CB |
| CBDISTRIB | Transaction Distribution | CB |
| CBSTATEMNT | Reconciliation Statement | CB |
| CBTRANS | Bank Transaction | CB |
| CBTRANSAUD | No description in the Lawson data dictionary | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| CUSTDESC | AR Group Customer | AR |
| FBDETAIL | Budget Detail | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBTRANS | Budget Transactions | GL |
| FBYETR | No description in the Lawson data dictionary | GL |
| GLCOMMIT | GL Commitments | GL |
| GLCOMMITX | GL commitment Detail | GL |
| GLHISCOMBL | No description in the Lawson data dictionary | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| MXLISTHDR | Attribute List Header | IF |
| NATBALANCE | AR National Account Balance | AR |
| POREBDIST | No description in the Lawson data dictionary | PO |
| POREBDUE | Contract Rebate Header | PO |
| POREBRECD | Contract Rebate Detail | PO |
| SUBCKPOINT | Subledger Check Point | IF |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
| TXTAXTRAN | Tax Transaction | TX |
Referenced files (73)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACBUDHDR | Activity Budget Header | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCNTRACT | Activity Contract | BR |
| ACCONSOL | Activity Consolidation | AC |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACTRANS | Activity Transaction | AC |
| AGEUSERONE | No description in the Lawson data dictionary | AR |
| APACCRCODE | Invoice Accrual Code | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APVENGROUP | Vendor Group | AP |
| ARAPPLDBOD | No description in the Lawson data dictionary | AR |
| ARCODE | AR GL Code | AR |
| ARCOMP | Accounts Receivable Company | AR |
| ARCONTACTS | AR Customer Contacts | AR |
| ARCUSTBOD | No description in the Lawson data dictionary | AR |
| ARCUSTFLDS | AR Customer User Fields | AR |
| ARCUSTGRP | Accounts Receivable Cust Group | AR |
| AROIHDR | Acct Receivables Trans Header | AR |
| AROITEMS | Acct Receivables Transaction | AR |
| ARREMIT | Payment Remittance | AR |
| ARSADJUST | Cash Application Adjust Select | AR |
| ARSAPPLIED | Cash Application Select | AR |
| BILLTO | Bill To | AR |
| BILLTOBOD | No description in the Lawson data dictionary | AR |
| C2IPAYMENT | No description in the Lawson data dictionary | C2 |
| CBADJUST | Reconciliation Adjustment | CB |
| CBAUTONBR | No description in the Lawson data dictionary | CB |
| CBBALANCE | Bank Account Balance | CB |
| CBCCGRP | Cash Code Group | CB |
| CBGRPCC | Cash Code Group Cash Codes | CB |
| CBSTMTDTL | Cash Staement Detail | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| CONBOD | No description in the Lawson data dictionary | AR |
| CUCODES | Currency Codes | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| CUSTORDER | Customer Order File | OE |
| FBFUNDDTL | Budget Fund Detail | GL |
| FBHEADER | Budget Header | GL |
| FTTRANS | EFT Transaction | AR |
| GLADDRESS | General Ledger Company Address | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCODES | General Ledger Codes | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| GMFNDACT | Grant Eligible Activities | GM |
| INSTCTRYCD | Intrastat Country Codes | TX |
| NATACCT | Accounts Receivable Natl Acct | AR |
| OECOMPANY | Order Entry Company | BL |
| OECUST | Customer Order Processing | AR |
| POCONTGRP | This table contains detail information on a CM contract group. | PO |
| POCONTRACT | Contract Description | PO |
| POCONTREB | No description in the Lawson data dictionary | PO |
| SYSTEMCODE | System Code | IF |
| TXTAXRATE | Tax Rate | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (13)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, SLSE, SLSU