TSQL For Loan Repayment Allocation
$10-30 USD
K zaplacení v momentě doručení
I am looking for a freelancer to write a TSQL script for allocating several loans repayments on loan repayment schedules on a 'First In First Out' (FIFO) basis.
Tables involved:
1. TblLoans (which contains the list of loans)
2. TblLoansRepaymentSchedules (which contains the loan repayment schedules)
3. TblReceiptsLoans (which contains the loan repayments)
4. TblReceiptsLoansSub (which will contain the result of the allocations of the loans repayments on the repayment schedule on a FIFO basis)
Approach:
1. The script will iterate from the first to the last loan in TblLoans.
2. For each loan, it will iterate from the first to the last repayment in TblReceiptsLoans.
3. For each repayment, it will look up the loans repayment schedules in TblLoansRepaymentSchedules, allocating the repayments on a FIFO basis and finally inserting the results into TblLoansReceiptsSub.
4. If a particular repayment is more than the repayment schedule, the balance of such repayments if spread to the next Installament.
5. If a particular repayment is less than the repayment schedule, such repayments will leave the Installament with a balance to be allocated with the next repayment.
Note:
1. TblLoans is similar customers
2. TblLoansRepaymentSchedules is similar invoices, each with unique InstallamentID as the invoice ID for each loan
3. TblReceiptsLoans is similar payments made on invoices
4. In allocating the loan repayments, Interests are considered first before Principals.
5. The script should be fast enough to allocate all the existing repayments on the repayment schedule as per the attached MS SQL tables within a reasonable time frame in hours or less.
Identifikační číslo projektu: #37330875
O projektu
11 Freelnceři na tento projekt zveřejňují nabídky v průměru $71
Hello my previous project was in Tsql i had a five star rating. I believe I'll be of great help to you on this project. I understand how important it is to have accurate results in a timely manner. With my extensive kn Další
I have a experience in asp.net, MVC, web API, c#, SQL, entity framework,linq, razor view (Cshtl), html, bootstrap,Angular JS, Jquery, TypeScript,Json,XML, reports (PDF,xls, crystal, rdlc,ssrs).
I understand you are looking for a freelancer to write a TSQL script for allocating several loans repayments on loan repayment schedules on a 'First In First Out' (FIFO) basis. If you give me this project, I can guaran Další
Hi There, I'm a SQL Server consultant with over a decade in experience. I can develop this for you and deliver it. thanks
I have 5 years of experience of TSQL specifically, it would be a quick script to make once I get the database's structure.
Working as SQL development lead I am a SQL professional with 13 years of experience. I’ve worked on several similar projects with handling crucial financial data. I have worked on building ETL process, delivering good Další