CB544 – Returned Payment Load

System
Cash Ledger (CB)
Type
Batch program
Updates
34 tables
References
58 tables

CB544 (Returned Payment Load) is a Lawson Cash Ledger batch program. It updates ACCOMMIT, ACCOMMITX, ACTRANS, ADDRDATA, CBBANKENT, CBBANKINST, CBCASHCODE, CBCONSOL and 26 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL and 50 more.

About CB544

Run Return Payments Load (CB544) to import returned payment transactions from a non-Lawson system into Cash Management. If the original deposit was for a rebate, the original deposit rebateinformaion will be copied and reversed from the rebate files. **Processing Effect During the conversion process, all records are edited for errors. When a record is moved from the Cash Ledger Returned Payment Load (CBRTPLOAD) file to the Cash Ledger Returned Payment (CBRETPMT) and Cash Ledger Distributions (CBDISTRIB) files, the interface file is deleted, unless errors are found. **Troubleshooting Use Returned Payment Maintenance (CB44.1) to view records and correct errors.

Updated files (34)

TableDescriptionSystem
ACCOMMITActivity CommitmentsAC
ACCOMMITXActivity Commitments DetailAC
ACTRANSActivity TransactionAC
ADDRDATAAddress CodeIF
CBBANKENTBankCB
CBBANKINSTBank Transaction CodeCB
CBCASHCODECash CodeCB
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
CBRETPMTReturn PaymentCB
CBRTPLOADReturn Payment Conversion/ImpCB
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
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 (58)

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
APVENGROUPVendor GroupAP
CBADJUSTReconciliation AdjustmentCB
CBAUTONBRNo description in the Lawson data dictionaryCB
CBBALANCEBank Account BalanceCB
CBCCGRPCash Code GroupCB
CBFTTRANSEFT Deposit Extract DataCB
CBGRPCCCash Code Group Cash CodesCB
CBRECPTHDRCash Receipt DepositCB
CBRTPLOADReturn Payment Conversion/ImpCB
CBSTATEMNTReconciliation StatementCB
CBSTMTDTLCash Staement DetailCB
CBTRFDTLFund Transfer 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
POCONTGRPThis table contains detail information on a CM contract group.PO
POCONTRACTContract DescriptionPO
POCONTREBNo description in the Lawson data dictionaryPO
SYSTEMCODESystem CodeIF
TXTAXRATETax RateTX
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (13)

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