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)

TableDescriptionSystem
ACCOMMITActivity CommitmentsAC
ACCOMMITXActivity Commitments DetailAC
ACTRANSActivity TransactionAC
ADDRDATAAddress CodeIF
APMONITORAccounts Payable MonitorAP
CBBANKENTBankCB
CBBANKINSTBank Transaction CodeCB
CBCASHCODECash CodeCB
CBCHECKAccounts Payable Cash PaymentCB
CBCONSOLThis file is updated by a batch program that consolidated CBTRANS amounts by Cash Code/Bank Inst Code/Company.CB
CBCPYCASHCompany-Cash Code RelationshipCB
CBCTRANSBank Transaction Conversion/InCB
CBDISTRIBTransaction DistributionCB
CBSEGBLOCKCash Segment BlockCB
CBTRANSBank TransactionCB
CBTRANSAUDNo description in the Lawson data dictionaryCB
CKPOINTNo description in the Lawson data dictionary
FBDETAILBudget DetailGL
FBFUNDAMTBudget Fund BalanceGL
FBTRANSBudget TransactionsGL
FBYETRNo description in the Lawson data dictionaryGL
GLCOMMITGL CommitmentsGL
GLCOMMITXGL commitment DetailGL
GLHISCOMBLNo description in the Lawson data dictionaryGL
GLHISCOMXNo description in the Lawson data dictionaryGL
JBOOKHDRJournal Book HeaderIF
SUBCKPOINTSubledger Check PointIF
TXCODEMASTTax Code MasterTX
TXCOMPANYTax CompanyTX
TXTAXCODETax Code MaintenanceTX
TXTAXTABLETax TableTX
TXTAXTRANTax TransactionTX

Referenced files (56)

TableDescriptionSystem
ACACCTCATActivity Account CategoriesAC
ACACCTCATXAccount Category DetailAC
ACACTGRPActivity GroupAC
ACACTIVITYActivityAC
ACBILLActivity BillingBR
ACBILLXActivity Billing DetailBR
ACBUDHDRActivity Budget HeaderAC
ACCALActivity CalendarAC
ACCALXActivity Calendar DetailAC
ACCATGRPAccount Category GroupAC
ACCATGRPXAccount Category Group DetailAC
ACCATSUMAccount Category SummaryAC
ACCATSUMXAccount Category Summ DetailAC
ACCNTRACTActivity ContractBR
ACCONSOLActivity ConsolidationAC
ACIFACTVThis file contains activity import information from AC500 (Activity Import).AC
ACTRANSActivity TransactionAC
APACCRCODEInvoice Accrual CodeAP
APCOMPANYAccounts Payable CompanyAP
APPAYGROUPPay GroupAP
APVENGROUPVendor GroupAP
APVENMASTVendor Master RecordAP
CBADJUSTReconciliation AdjustmentCB
CBAUTONBRNo description in the Lawson data dictionaryCB
CBBALANCEBank Account BalanceCB
CBCTRANSBank Transaction Conversion/InCB
CBSTATEMNTReconciliation StatementCB
CBSTMTDTLCash Staement DetailCB
CBTRFHDRFund TransferCB
CBUSERCash Ledger UserCB
CBUSRCLASSCash Ledger User ClassCB
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
FBFUNDDTLBudget Fund DetailGL
FBHEADERBudget HeaderGL
GLADDRESSGeneral Ledger Company AddressIF
GLAMOUNTSGeneral Ledger AmountsGL
GLCHARTGeneral Ledger ChartIF
GLCHARTDTLGeneral Ledger Chart DetailIF
GLCHARTSUMGeneral Ledger Chart SummaryIF
GLCODESGeneral Ledger CodesIF
GLINTCOGeneral Ledger IntercompanyIF
GLMASTERGeneral Ledger Account MasterIF
GLNAMESGeneral Ledger NamesIF
GLSRCCODEGeneral Ledger Source CodeIF
GLSYSTEMGeneral Ledger CompanyIF
GLTRANSGeneral Ledger TransactionsGL
GMFNDACTGrant Eligible ActivitiesGM
INSTCTRYCDIntrastat Country CodesTX
JBKACCTJournal Book AccountIF
JBKOPCODEJournal Book Operator CodeIF
JBKSYSCODEJournal Book SystemIF
MXLISTMBRAttribute ListIF
SYSTEMCODESystem CodeIF
TXTAXRATETax RateTX
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (12)

ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFRS, IFSG, IFUP, SLSE, SLSU