Customers may make payment to cover one or multiple invoices. Add additional tables in the database to show customer payments. You want to record the following information: cash receipt number, date of receipt, total amount received and amount applied to a specific invoice.
Record the following information in the new table(s): On Oct 31 received $2,300 payment from D Ainge (receipt#1031001). $898 of the payment applies for invoices 103 and the rest applies for 101.Design the query to show the customer name, invoice amount,invoice date, payment date, payment amount of invoice 101.
Recently Asked Questions
- A couple of years ago, William Shatner proposed a $30 Billion Kickstarter project to build a water pipeline to address California’s drought issues.
- Red Dwarf Toasters needs to produce 1000 of their new “Talking Toaster". There are three ways this toaster can be produced: manually,
- describe the iniation of labor, dilation stage, expulsion stage, and placental stage ....