Database Designing Help For Billing System

I am developing a Electronic Bill Payment System for a bank which has more than 100 customers subscribing for Electronic Bill Payment. I have a table in which I am creating profile

Solution 1:

Well if its a query you need to generate bills that are due 27th of every month and also find the customer's utility company, then you can try this -

SELECT A.Customer_Name, B.UtilityCompany_ID FROM
Customer A inner join Bill_Master B on A.Customer_ID = B.Customer_ID
WHERE Bill_Due_Date BETWEEN GETDATE() AND DATEADD(MONTH,-1,GETDATE())