CB150 – Mass Release

System
Cash Ledger (CB)
Type
Batch program
Updates
39 tables
References
71 tables

CB150 (Mass Release) is a Lawson Cash Ledger batch program. It updates ACCOMMIT, ACCOMMITX, ACTRANS, ADDRDATA, APMONITOR, CBBANKENT, CBBANKINST, CBCASHCODE and 31 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL and 63 more.

About CB150

Run Mass Release (CB150) to update records in Cash Management application to a released status. This program can also change the prenotification status. **Processing Effect When you run CB150, the records in the CBRECTPDTL, CBPAYMENT, CBFTTRANS,CBTRANS, CBTRFHDR, CBDISTRIB files are updated, depending on the update optionyou select. Use the System or Enter Dates to release all transactions by the date - or -within the date range specified in the Days field in the following manner: - For Payments, Bank Transactions, and Bank Fund Transfers, the program willrelease records with a Post Date that is equal to or within the date range specified. - For Receipts, the program will release records with a Deposit Date that isequal to or within the date range specified. - For Return Payments, the program will release records with a Return Datethat is equal to or within the date range specified. - For EFT, the program will release records with a Trans Date that is equalto or within the date range specified.

Updated files (39)

TableDescriptionSystem
ACCOMMITActivity CommitmentsAC
ACCOMMITXActivity Commitments DetailAC
ACTRANSActivity TransactionAC
ADDRDATAAddress CodeIF
APMONITORAccounts Payable MonitorAP
CBBANKENTBankCB
CBBANKINSTBank Transaction CodeCB
CBCASHCODECash CodeCB
CBCATEGORYCash Receipt CategoryCB
CBCONSOLThis file is updated by a batch program that consolidated CBTRANS amounts by Cash Code/Bank Inst Code/Company.CB
CBCPYCASHCompany-Cash Code RelationshipCB
CBDISTRIBTransaction DistributionCB
CBFTTRANSEFT Deposit Extract DataCB
CBPAYMENTCash PaymentCB
CBRECPTHDRCash Receipt DepositCB
CBRETPMTReturn PaymentCB
CBSEGBLOCKCash Segment BlockCB
CBTRANSBank TransactionCB
CBTRANSAUDNo description in the Lawson data dictionaryCB
CBTRFHDRFund TransferCB
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
JBKSEQNBRJournal Book Sequence NumberGL
POREBDISTNo description in the Lawson data dictionaryPO
POREBDUEContract Rebate HeaderPO
POREBRECDContract Rebate DetailPO
SUBCKPOINTSubledger Check PointIF
TXCODEMASTTax Code MasterTX
TXCOMPANYTax CompanyTX
TXTAXCODETax Code MaintenanceTX
TXTAXTABLETax TableTX
TXTAXTRANTax TransactionTX

Referenced files (71)

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
APCONTACTNo description in the Lawson data dictionaryAP
APDRAFTSAP Bill of ExchangeAP
APINVOICEAccounts Payable InvoiceAP
APPAYMENTInvoice PaymentAP
APPMTBODNo description in the Lawson data dictionaryAP
APVENADDRAP Vendor AddressAP
APVENBALVendor BalanceAP
APVENCLASSVendor ClassAP
APVENGROUPVendor GroupAP
APVENLCBODNo description in the Lawson data dictionaryAP
APVENLOCVendor LocationAP
APVENMASTVendor Master RecordAP
CBADJUSTReconciliation AdjustmentCB
CBAUTONBRNo description in the Lawson data dictionaryCB
CBBALANCEBank Account BalanceCB
CBCASHFORMCash Payment FormatCB
CBCCGRPCash Code GroupCB
CBCHECKAccounts Payable Cash PaymentCB
CBGRPCCCash Code Group Cash CodesCB
CBRECPTDTLCash Receipt DetailCB
CBSTATEMNTReconciliation StatementCB
CBSTMTDTLCash Staement DetailCB
CBTRANSBODNo description in the Lawson data dictionaryCB
CBTRFDTLFund Transfer DetailCB
CBTRFTABLEFund Transfer TableCB
CBUSERCash Ledger UserCB
CBUSRCLASSCash Ledger User ClassCB
CUCODESCurrency CodesIF
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
GLSYSTEMGeneral Ledger CompanyIF
GLTRANSGeneral Ledger TransactionsGL
GMFNDACTGrant Eligible ActivitiesGM
INSTCTRYCDIntrastat Country CodesTX
POCONTGRPThis table contains detail information on a CM contract group.PO
POCONTRACTContract DescriptionPO
POCONTREBNo description in the Lawson data dictionaryPO
SYSTEMCODESystem CodeIF
TXTAXRATETax RateTX
VBABODNo description in the Lawson data dictionaryAP
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (12)

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