This Procedure Will:
1) Accept 6 items of data as arguments (Provided when the Procedure is called)
2) Define 3 internal Variables
3) Perform 3 Validation steps
4) Load validated data into the correct table
Feature 2 Sub queries
Our Procedure
will go here
CALL insert_invoice(34, 'ZXA-080', '2018-01-18',14092.59, 3, '2015-03-18');
CALL insert_invoice(34, 'ZXA-082', '2018-01-18',14092.59, NULL, NULL);
Vendor ID
Invoice ID
Invoice Date
Invoice Amount
Terms
Due Date