CB500 – Bank Transaction Interface
- System
- Cash Ledger (CB)
- Type
- Batch program
- Updates
- 32 tables
- References
- 56 tables
CB500 (Bank Transaction Interface) is a Lawson Cash Ledger batch program. It updates ACCOMMIT, ACCOMMITX, ACTRANS, ADDRDATA, APMONITOR, CBBANKENT, CBBANKINST, CBCASHCODE and 24 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL and 48 more.
About CB500
Run Bank Transaction Interface (CB500) to import bank transactions from a non-Lawson system to Cash Management. After you load the appropriate banktransaction information into the Bank Transaction Conversion file, you can run thisprogram to edit the information for completeness and accuracy. **Processing Effect If the information passes all edits, new bank transaction records will be created in Cash Management and the corresponding records will be purgedfrom the conversion file.
More information: If this is your initial conversion, be sure to perform the following steps after you successfully convert your non-Lawson bank transactions toCash Management. 1. Use Bank Account Balance Update (CB99.1) to adjust the open and reconciledbalances of each bank account to include transactions not converted in the current balances. 2. Run Bank Period Close (CB190) for each bank account to update convertedbank transactions to a bank period and calculate new bank account balances. Use the date of your last bank period. 3. Use Bank Period Balance Update (CB99.2) to adjust the period endingbalance of each bank account to include transactions not converted and excludetransactions converted for past periods. Use the period ending date you typed in CB190. NOTE You must set up the following codes and information as valid records ifthis information is to be converted as part of the bank transaction records: cash codes on Cash Code (CB00.2); process levels, vendors, and alternatelocations in Lawson Accounts Payable; and currency codes in Lawson Currency.
Updated files (32)
| 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 |
| 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 |
| CBCTRANS | Bank Transaction Conversion/In | CB |
| CBDISTRIB | Transaction Distribution | CB |
| CBSEGBLOCK | Cash Segment Block | CB |
| CBTRANS | Bank Transaction | CB |
| CBTRANSAUD | No description in the Lawson data dictionary | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| 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 |
| JBOOKHDR | Journal Book Header | IF |
| 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 (56)
| 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 |
| APACCRCODE | Invoice Accrual Code | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APPAYGROUP | Pay Group | AP |
| APVENGROUP | Vendor Group | AP |
| APVENMAST | Vendor Master Record | AP |
| CBADJUST | Reconciliation Adjustment | CB |
| CBAUTONBR | No description in the Lawson data dictionary | CB |
| CBBALANCE | Bank Account Balance | CB |
| CBCTRANS | Bank Transaction Conversion/In | CB |
| CBSTATEMNT | Reconciliation Statement | CB |
| CBSTMTDTL | Cash Staement Detail | CB |
| CBTRFHDR | Fund Transfer | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| FBFUNDDTL | Budget Fund Detail | GL |
| FBHEADER | Budget Header | GL |
| 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 |
| GLINTCO | General Ledger Intercompany | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSRCCODE | General Ledger Source Code | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| GMFNDACT | Grant Eligible Activities | GM |
| INSTCTRYCD | Intrastat Country Codes | TX |
| JBKACCT | Journal Book Account | IF |
| JBKOPCODE | Journal Book Operator Code | IF |
| JBKSYSCODE | Journal Book System | IF |
| MXLISTMBR | Attribute List | IF |
| SYSTEMCODE | System Code | IF |
| TXTAXRATE | Tax Rate | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (12)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFRS, IFSG, IFUP, SLSE, SLSU