import from svntrunk

author: mo khan <mo@mokhan.ca> 2007-08-26 20:10:42 -0600
committer: mo khan <mo@mokhan.ca> 2007-08-26 20:10:42 -0600
commit: 330be9feefb6394479553be0e078b4c4df3cbff1 (patch)
tree: 55618c8af0d36583cde0ea5b4b193b98815a35aa /sql
13 files changed, 1231 insertions, 0 deletions
diff --git a/sql/constraints.sql.template b/sql/constraints.sql.template
new file mode 100644
index 0000000..f2f1dd9
--- /dev/null
+++ b/sql/constraints.sql.template
@@ -0,0 +1,48 @@
+USE [@initial.catalog@]
+
+ALTER TABLE [dbo].[InvoiceLineItems]  WITH CHECK ADD  CONSTRAINT [FK_InvoiceLineItems_GLAccounts] FOREIGN KEY([AccountNo])
+REFERENCES [dbo].[GLAccounts] ([AccountNo])
+ON UPDATE CASCADE
+GO
+
+ALTER TABLE [dbo].[InvoiceLineItems] CHECK CONSTRAINT [FK_InvoiceLineItems_GLAccounts]
+GO
+
+ALTER TABLE [dbo].[InvoiceLineItems]  WITH CHECK ADD  CONSTRAINT [FK_InvoiceLineItems_Invoices] FOREIGN KEY([InvoiceID])
+REFERENCES [dbo].[Invoices] ([InvoiceID])
+ON UPDATE CASCADE
+ON DELETE CASCADE
+GO
+ALTER TABLE [dbo].[InvoiceLineItems] CHECK CONSTRAINT [FK_InvoiceLineItems_Invoices]
+GO
+
+ALTER TABLE [dbo].[Invoices]  WITH CHECK ADD  CONSTRAINT [FK_Invoices_Terms] FOREIGN KEY([TermsID])
+REFERENCES [dbo].[Terms] ([TermsID])
+GO
+ALTER TABLE [dbo].[Invoices] CHECK CONSTRAINT [FK_Invoices_Terms]
+GO
+
+ALTER TABLE [dbo].[Invoices]  WITH CHECK ADD  CONSTRAINT [FK_Invoices_Vendors] FOREIGN KEY([VendorID])
+REFERENCES [dbo].[Vendors] ([VendorID])
+GO
+ALTER TABLE [dbo].[Invoices] CHECK CONSTRAINT [FK_Invoices_Vendors]
+GO
+
+ALTER TABLE [dbo].[Vendors]  WITH CHECK ADD  CONSTRAINT [FK_Vendors_GLAccounts] FOREIGN KEY([DefaultAccountNo])
+REFERENCES [dbo].[GLAccounts] ([AccountNo])
+ON UPDATE CASCADE
+GO
+ALTER TABLE [dbo].[Vendors] CHECK CONSTRAINT [FK_Vendors_GLAccounts]
+GO
+
+ALTER TABLE [dbo].[Vendors]  WITH CHECK ADD  CONSTRAINT [FK_Vendors_States] FOREIGN KEY([State])
+REFERENCES [dbo].[States] ([StateCode])
+GO
+ALTER TABLE [dbo].[Vendors] CHECK CONSTRAINT [FK_Vendors_States]
+GO
+
+ALTER TABLE [dbo].[Vendors]  WITH CHECK ADD  CONSTRAINT [FK_Vendors_Terms] FOREIGN KEY([DefaultTermsID])
+REFERENCES [dbo].[Terms] ([TermsID])
+GO
+ALTER TABLE [dbo].[Vendors] CHECK CONSTRAINT [FK_Vendors_Terms]
+GO
+\ No newline at end of file
diff --git a/sql/data/GLAccounts.sql.template b/sql/data/GLAccounts.sql.template
new file mode 100644
index 0000000..770f47a
--- /dev/null
+++ b/sql/data/GLAccounts.sql.template
@@ -0,0 +1,77 @@
+USE [@initial.catalog@];
+
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (100,'Cash');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (110,'Accounts Receivable');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (120,'Book Inventory');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (150,'Furniture');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (160,'Computer Equipment');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (162,'Capitalized Lease');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (167,'Software');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (170,'Other Equipment');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (181,'Book Development');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (200,'Accounts Payable');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (205,'Royalties Payable');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (221,'401K Employee Contributions');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (230,'Sales Taxes Payable');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (234,'Medicare Taxes Payable');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (235,'Income Taxes Payable');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (237,'State Payroll Taxes Payable');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (238,'Employee FICA Taxes Payable');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (239,'Employer FICA Taxes Payable');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (241,'Employer FUTA Taxes Payable');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (242,'Employee SDI Taxes Payable');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (243,'Employer UCI Taxes Payable');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (251,'IBM Credit Corporation Payable');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (280,'Capital Stock');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (290,'Retained Earnings');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (300,'Retail Sales');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (301,'College Sales');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (302,'Trade Sales');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (306,'Consignment Sales');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (310,'Compositing Revenue');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (394,'Book Club Royalties');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (400,'Book Printing Costs');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (403,'Book Production Costs');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (500,'Salaries and Wages');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (505,'FICA');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (506,'FUTA');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (507,'UCI');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (508,'Medicare');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (510,'Group Insurance');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (520,'Building Lease');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (521,'Utilities');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (522,'Telephone');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (523,'Building Maintenance');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (527,'Computer Equipment Maintenance');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (528,'IBM Lease');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (532,'Equipment Rental');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (536,'Card Deck Advertising');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (540,'Direct Mail Advertising');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (541,'Space Advertising');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (546,'Exhibits and Shows');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (548,'Web Site Production and Fees');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (550,'Packaging Materials');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (551,'Business Forms');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (552,'Postage');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (553,'Freight');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (555,'Collection Agency Fees');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (556,'Credit Card Handling');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (565,'Bank Fees');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (568,'Auto License Fee');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (569,'Auto Expense');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (570,'Office Supplies');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (572,'Books, Dues, and Subscriptions');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (574,'Business Licenses and Taxes');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (576,'PC Software');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (580,'Meals');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (582,'Travel and Accomodations');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (589,'Outside Services');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (590,'Business Insurance');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (591,'Accounting');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (610,'Charitable Contributions');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (611,'Profit Sharing Contributions');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (620,'Interest Paid to Banks');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (621,'Other Interest');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (630,'Federal Corporation Income Taxes');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (631,'State Corporation Income Taxes');
+insert into [dbo].[GLAccounts]([AccountNo],[Description]) values (632,'Sales Tax');
diff --git a/sql/data/InvoiceLineItems.sql.template b/sql/data/InvoiceLineItems.sql.template
new file mode 100644
index 0000000..fe9b701
--- /dev/null
+++ b/sql/data/InvoiceLineItems.sql.template
@@ -0,0 +1,122 @@
+USE [@initial.catalog@];
+
+-- SET IDENTITY_INSERT @initial.catalog@.dbo.InvoiceLineItems ON
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (1,1,572,116.5400,'MVS Online Library');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (2,1,572,1083.5800,'MSDN');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (3,1,120,20551.1800,'CICS Part 2');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (4,1,120,26881.4000,'MVS JCL');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (5,1,527,936.9300,'Quarterly Maintenance');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (6,1,553,2312.2000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (7,1,541,600.0000,'Trade advertising');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (8,1,553,1927.5400,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (9,1,553,2184.1100,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (10,1,553,2318.0300,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (11,1,553,3813.3300,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (12,1,553,3689.9900,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (13,1,553,2765.3600,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (14,1,553,2115.8100,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (15,1,540,313.5500,'Card revision');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (16,1,553,2051.5900,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (17,1,523,356.4800,'Network wiring');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (18,1,540,904.1400,'DB2 Card decks');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (19,1,536,1197.0000,'Spring catalog');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (19,2,540,765.1300,'ADO.NET 2.0 cover');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (20,1,536,639.7700,'Card deck');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (21,1,536,601.9500,'Card deck revision');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (22,1,536,953.1000,'Crash Course revision');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (23,1,541,565.1500,'Crash Course Ad');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (24,1,540,1000.4600,'Crash Course Cover');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (25,1,553,10.0000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (26,1,553,162.7500,'International shipment');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (27,1,553,10.0000,'Address correction');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (28,1,553,27.0000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (29,1,553,13.7500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (30,1,570,17.5000,'Supplies');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (31,1,553,144.7000,'Int''l shipment');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (32,1,523,95.0000,'Telephone service');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (33,1,553,33.0000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (34,1,120,10976.0600,'VSAM for the Cobol Programmer');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (35,1,553,63.4000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (36,1,120,23517.5800,'DB2 Part 1');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (37,1,120,37966.1900,'CICS Desk Reference');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (38,1,553,61.5000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (39,1,553,158.0000,'Int''l shipment');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (40,1,553,26.7500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (41,1,553,23.5000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (42,1,572,9.9500,'Monthly access fee');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (43,1,572,9.9500,'Monthly access fee');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (44,1,553,52.2500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (45,1,553,109.5000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (46,1,553,42.7500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (47,1,553,36.0000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (48,1,553,111.0000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (49,1,553,53.2500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (50,1,553,53.7500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (51,1,553,108.5000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (52,1,553,38.7500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (53,1,553,15.5000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (54,1,553,127.7500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (55,1,553,241.0000,'Int''l shipment');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (56,1,553,129.0000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (57,1,553,40.7500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (58,1,553,60.0000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (59,1,553,104.0000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (60,1,553,67.0000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (61,1,553,147.2500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (62,1,553,172.5000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (63,1,553,108.2500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (64,1,553,138.7500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (65,1,553,127.7500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (66,1,553,739.2000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (67,1,553,10.0000,'Address correction');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (68,1,553,30.7500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (69,1,510,116.0000,'Health Insurance');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (70,1,553,67.9200,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (71,1,553,59.9700,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (72,1,553,26.2500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (73,1,553,22.5700,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (74,1,553,31.9500,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (75,1,553,42.6700,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (76,1,553,44.4400,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (77,1,553,40.2000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (78,1,553,400.0000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (79,1,553,42.5000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (80,1,591,220.0000,'Form 571-L');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (81,1,541,1575.0000,'Catalog ad');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (82,1,553,6.0000,'Freight out');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (83,1,553,25.6700,'Freight out');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (84,1,552,6.0000,'Freight out');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (85,1,553,6.0000,'Freight');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (86,1,540,207.7800,'Prospect list');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (87,1,536,2184.5000,'PC card deck');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (88,1,536,2433.0000,'Card deck');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (89,1,120,6940.2500,'OS Utilities');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (90,1,523,450.0000,'Back office additions');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (91,1,536,90.3600,'Card deck advertising');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (92,1,536,175.0000,'Card deck advertising');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (93,1,548,7125.3400,'Web site design');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (94,1,569,503.2000,'Bronco lease');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (95,1,235,1600.0000,'Income Tax');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (96,1,520,1750.0000,'Warehouse lease');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (97,1,520,4901.2600,'Office lease');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (98,1,522,46.2100,'Telephone (Line 1)');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (99,1,522,39.7700,'Telephone (Line 2)');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (100,1,580,50.0000,'DiCicco''s');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (100,2,540,75.6000,'Kinko''s');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (100,3,570,58.4000,'Office Max');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (100,4,546,478.0000,'Publishers Marketing');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (101,1,221,1367.5000,'401K Contributions');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (102,1,574,856.9200,'Property Taxes');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (103,1,522,19.6700,'Telephone (Line 3)');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (104,1,552,290.0000,'International pkg.');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (105,1,522,32.7000,'Telephone (line 4)');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (106,1,522,16.3300,'Telephone (line 5)');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (107,1,522,16.3300,'Telephone (line 6)');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (108,1,589,16.6200,'Propane-forklift');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (109,1,580,41.8000,'Coffee');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (110,1,540,85.3100,'Book copy');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (111,1,510,224.0000,'Health Insurance');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (112,1,510,224.0000,'Health Insurance');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (113,1,540,21842.0000,'Book repro');
+insert into [dbo].[InvoiceLineItems]([InvoiceID],[InvoiceSequence],[AccountNo],[Amount],[Description]) values (114,1,541,579.4200,'Catalog ad');
+-- SET IDENTITY_INSERT @initial.catalog@.dbo.InvoiceLineItems OFF
diff --git a/sql/data/Invoices.sql.template b/sql/data/Invoices.sql.template
new file mode 100644
index 0000000..c541861
--- /dev/null
+++ b/sql/data/Invoices.sql.template
@@ -0,0 +1,121 @@
+USE [@initial.catalog@];
+
+SET IDENTITY_INSERT @initial.catalog@.dbo.Invoices ON
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (1,34,'QP58872','2007-01-05 00:00:00',116.5400,116.5400,0.0000,4,'2007-03-04 00:00:00','2007-02-22 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (2,34,'Q545443','2007-01-14 00:00:00',1083.5800,1083.5800,0.0000,4,'2007-03-23 00:00:00','2007-03-14 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (3,110,'P-0608','2007-02-11 00:00:00',20551.1800,0.0000,1200.0000,5,'2007-04-30 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (4,110,'P-0259','2007-02-16 00:00:00',26881.4000,26881.4000,0.0000,3,'2007-03-16 00:00:00','2007-03-12 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (5,81,'MABO1489','2007-02-16 00:00:00',936.9300,936.9300,0.0000,3,'2007-03-16 00:00:00','2007-03-13 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (6,122,'989319-497','2007-02-17 00:00:00',2312.2000,2312.2000,0.0000,3,'2007-03-17 00:00:00','2007-02-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (7,82,'C73-24','2007-02-17 00:00:00',600.0000,600.0000,0.0000,2,'2007-03-10 00:00:00','2007-03-05 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (8,122,'989319-487','2007-02-18 00:00:00',1927.5400,1927.5400,0.0000,3,'2007-03-18 00:00:00','2007-02-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (9,122,'989319-477','2007-02-19 00:00:00',2184.1100,2184.1100,0.0000,3,'2007-03-19 00:00:00','2007-02-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (10,122,'989319-467','2007-02-24 00:00:00',2318.0300,0.0000,0.0000,3,'2007-03-24 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (11,122,'989319-457','2007-02-24 00:00:00',3813.3300,0.0000,0.0000,3,'2007-03-24 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (12,122,'989319-447','2007-02-24 00:00:00',3689.9900,0.0000,0.0000,3,'2007-03-24 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (13,122,'989319-437','2007-02-24 00:00:00',2765.3600,0.0000,0.0000,3,'2007-03-14 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (14,122,'989319-427','2007-02-25 00:00:00',2115.8100,0.0000,0.0000,3,'2007-03-25 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (15,121,'97/553B','2007-02-26 00:00:00',313.5500,313.5500,0.0000,4,'2007-05-25 00:00:00','2007-03-05 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (16,122,'989319-417','2007-02-16 00:00:00',2051.5900,2051.5900,0.0000,3,'2007-03-16 00:00:00','2007-02-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (17,90,'97-1024A','2007-02-26 00:00:00',356.4800,356.4800,0.0000,3,'2007-04-09 00:00:00','2007-04-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (18,121,'97/553','2007-02-27 00:00:00',904.1400,904.1400,0.0000,4,'2007-05-26 00:00:00','2007-03-05 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (19,121,'97/522','2007-02-28 00:00:00',1962.1300,1762.1300,200.0000,4,'2007-05-27 00:00:00','2007-04-04 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (20,121,'97/503','2007-02-28 00:00:00',639.7700,639.7700,0.0000,4,'2007-05-27 00:00:00','2007-04-04 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (21,121,'97/488','2007-02-28 00:00:00',601.9500,601.9500,0.0000,4,'2007-05-27 00:00:00','2007-04-04 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (22,121,'97/486','2007-02-28 00:00:00',953.1000,953.1000,0.0000,4,'2007-05-27 00:00:00','2007-04-04 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (23,121,'97/465','2007-03-01 00:00:00',565.1500,565.1500,0.0000,4,'2007-05-31 00:00:00','2007-05-07 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (24,121,'97/222','2007-03-01 00:00:00',1000.4600,1000.4600,0.0000,4,'2007-05-31 00:00:00','2007-05-07 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (25,123,'4-342-8069','2007-03-01 00:00:00',10.0000,10.0000,0.0000,3,'2007-03-31 00:00:00','2007-03-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (26,123,'4-327-7357','2007-03-01 00:00:00',162.7500,162.7500,0.0000,3,'2007-03-31 00:00:00','2007-03-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (27,123,'4-321-2596','2007-03-01 00:00:00',10.0000,10.0000,0.0000,3,'2007-03-31 00:00:00','2007-03-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (28,123,'7548906-20','2007-03-01 00:00:00',27.0000,27.0000,0.0000,3,'2007-03-31 00:00:00','2007-03-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (29,123,'4-314-3057','2007-03-05 00:00:00',13.7500,13.7500,0.0000,3,'2007-04-04 00:00:00','2007-03-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (30,94,'203339-13','2007-03-02 00:00:00',17.5000,0.0000,0.0000,3,'2007-04-13 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (31,123,'2-000-2993','2007-03-07 00:00:00',144.7000,144.7000,0.0000,3,'2007-04-06 00:00:00','2007-03-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (32,89,'125520-1','2007-03-05 00:00:00',95.0000,95.0000,0.0000,3,'2007-04-08 00:00:00','2007-03-22 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (33,123,'1-202-2978','2007-03-07 00:00:00',33.0000,33.0000,0.0000,3,'2007-04-06 00:00:00','2007-03-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (34,110,'0-2436','2007-03-07 00:00:00',10976.0600,0.0000,0.0000,4,'2007-05-17 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (35,123,'1-200-5164','2007-03-07 00:00:00',63.4000,63.4000,0.0000,3,'2007-04-06 00:00:00','2007-03-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (36,110,'0-2060','2007-03-08 00:00:00',23517.5800,21221.6300,2295.9500,3,'2007-04-09 00:00:00','2007-04-10 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (37,110,'0-2058','2007-03-08 00:00:00',37966.1900,37966.1900,0.0000,3,'2007-04-09 00:00:00','2007-03-31 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (38,123,'963253272','2007-03-06 00:00:00',61.5000,61.5000,0.0000,3,'2007-04-05 00:00:00','2007-03-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (39,123,'963253271','2007-03-06 00:00:00',158.0000,158.0000,0.0000,3,'2007-04-05 00:00:00','2007-03-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (40,123,'963253269','2007-03-06 00:00:00',26.7500,26.7500,0.0000,3,'2007-04-05 00:00:00','2007-03-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (41,123,'963253267','2007-03-06 00:00:00',23.5000,23.5000,0.0000,3,'2007-04-05 00:00:00','2007-03-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (42,97,'21-4748363','2007-03-09 00:00:00',9.9500,0.0000,0.0000,4,'2007-04-25 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (43,97,'21-4923721','2007-03-09 00:00:00',9.9500,9.9500,0.0000,1,'2007-03-21 00:00:00','2007-03-13 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (44,123,'963253264','2007-03-13 00:00:00',52.2500,52.2500,0.0000,3,'2007-04-12 00:00:00','2007-03-16 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (45,123,'963253263','2007-03-13 00:00:00',109.5000,109.5000,0.0000,3,'2007-04-12 00:00:00','2007-03-16 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (46,123,'963253261','2007-03-13 00:00:00',42.7500,42.7500,0.0000,3,'2007-04-12 00:00:00','2007-03-16 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (47,123,'963253260','2007-03-14 00:00:00',36.0000,36.0000,0.0000,3,'2007-04-13 00:00:00','2007-03-16 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (48,123,'963253258','2007-03-14 00:00:00',111.0000,111.0000,0.0000,3,'2007-04-13 00:00:00','2007-03-16 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (49,123,'963253256','2007-03-15 00:00:00',53.2500,53.2500,0.0000,3,'2007-04-14 00:00:00','2007-03-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (50,123,'963253255','2007-03-15 00:00:00',53.7500,53.7500,0.0000,3,'2007-04-14 00:00:00','2007-03-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (51,123,'963253254','2007-03-15 00:00:00',108.5000,108.5000,0.0000,3,'2007-04-14 00:00:00','2007-03-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (52,123,'963253252','2007-03-15 00:00:00',38.7500,38.7500,0.0000,3,'2007-04-14 00:00:00','2007-03-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (53,123,'963253251','2007-03-16 00:00:00',15.5000,15.5000,0.0000,3,'2007-04-15 00:00:00','2007-03-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (54,123,'963253249','2007-03-16 00:00:00',127.7500,127.7500,0.0000,3,'2007-04-15 00:00:00','2007-03-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (55,123,'963253248','2007-03-19 00:00:00',241.0000,241.0000,0.0000,3,'2007-04-18 00:00:00','2007-03-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (56,123,'963253246','2007-03-19 00:00:00',129.0000,129.0000,0.0000,3,'2007-04-18 00:00:00','2007-03-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (57,123,'963253245','2007-03-19 00:00:00',40.7500,40.7500,0.0000,3,'2007-04-18 00:00:00','2007-03-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (58,123,'963253244','2007-03-19 00:00:00',60.0000,60.0000,0.0000,3,'2007-04-18 00:00:00','2007-03-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (59,123,'963253242','2007-03-19 00:00:00',104.0000,104.0000,0.0000,3,'2007-04-18 00:00:00','2007-03-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (60,123,'963253240','2007-03-20 00:00:00',67.0000,67.0000,0.0000,3,'2007-04-19 00:00:00','2007-03-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (61,123,'963253239','2007-03-20 00:00:00',147.2500,147.2500,0.0000,3,'2007-04-19 00:00:00','2007-03-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (62,123,'963253237','2007-03-20 00:00:00',172.5000,172.5000,0.0000,3,'2007-04-19 00:00:00','2007-03-23 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (63,123,'963253235','2007-03-21 00:00:00',108.2500,0.0000,0.0000,3,'2007-04-21 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (64,123,'963253234','2007-03-21 00:00:00',138.7500,0.0000,0.0000,3,'2007-04-22 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (65,123,'963253232','2007-03-21 00:00:00',127.7500,0.0000,0.0000,3,'2007-04-25 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (66,123,'963253230','2007-03-21 00:00:00',739.2000,0.0000,0.0000,3,'2007-04-25 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (67,123,'43966316','2007-03-22 00:00:00',10.0000,0.0000,0.0000,3,'2007-04-26 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (68,123,'263253273','2007-03-22 00:00:00',30.7500,0.0000,0.0000,3,'2007-04-26 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (69,37,'547479217','2007-03-17 00:00:00',116.0000,0.0000,0.0000,3,'2007-04-22 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (70,123,'263253270','2007-03-08 00:00:00',67.9200,67.9200,0.0000,3,'2007-04-07 00:00:00','2007-03-16 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (71,123,'263253268','2007-03-08 00:00:00',59.9700,59.9700,0.0000,3,'2007-04-07 00:00:00','2007-03-16 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (72,123,'263253265','2007-03-08 00:00:00',26.2500,26.2500,0.0000,3,'2007-04-07 00:00:00','2007-03-16 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (73,123,'263253257','2007-03-08 00:00:00',22.5700,22.5700,0.0000,3,'2007-04-07 00:00:00','2007-03-16 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (74,123,'263253253','2007-03-08 00:00:00',31.9500,31.9500,0.0000,3,'2007-04-07 00:00:00','2007-03-16 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (75,123,'263253250','2007-03-09 00:00:00',42.6700,42.6700,0.0000,3,'2007-04-08 00:00:00','2007-03-16 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (76,123,'263253243','2007-03-12 00:00:00',44.4400,44.4400,0.0000,3,'2007-04-11 00:00:00','2007-03-16 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (77,123,'263253241','2007-03-12 00:00:00',40.2000,40.2000,0.0000,3,'2007-04-11 00:00:00','2007-03-16 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (78,123,'94007069','2007-03-12 00:00:00',400.0000,400.0000,0.0000,3,'2007-04-11 00:00:00','2007-03-16 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (79,123,'963253262','2007-03-12 00:00:00',42.5000,42.5000,0.0000,3,'2007-04-11 00:00:00','2007-03-16 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (80,105,'94007005','2007-03-23 00:00:00',220.0000,220.0000,0.0000,1,'2007-03-30 00:00:00','2007-03-26 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (81,83,'31359783','2007-03-23 00:00:00',1575.0000,0.0000,0.0000,2,'2007-04-09 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (82,115,'25022117','2007-03-24 00:00:00',6.0000,0.0000,0.0000,3,'2007-04-21 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (83,115,'24946731','2007-03-25 00:00:00',25.6700,25.6700,0.0000,2,'2007-04-14 00:00:00','2007-03-28 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (84,115,'24863706','2007-03-27 00:00:00',6.0000,6.0000,0.0000,1,'2007-04-07 00:00:00','2007-04-01 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (85,115,'24780512','2007-03-29 00:00:00',6.0000,6.0000,0.0000,1,'2007-03-31 00:00:00','2007-03-30 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (86,88,'972110','2007-03-30 00:00:00',207.7800,207.7800,0.0000,1,'2007-04-06 00:00:00','2007-04-02 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (87,100,'587056','2007-03-31 00:00:00',2184.5000,2184.5000,0.0000,3,'2007-04-28 00:00:00','2007-04-22 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (88,86,'367447','2007-03-31 00:00:00',2433.0000,0.0000,0.0000,3,'2007-04-30 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (89,99,'509786','2007-03-31 00:00:00',6940.2500,6940.2500,0.0000,2,'2007-04-16 00:00:00','2007-04-08 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (90,108,'121897','2007-04-01 00:00:00',450.0000,450.0000,0.0000,2,'2007-04-19 00:00:00','2007-04-14 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (91,80,'134116','2007-04-01 00:00:00',90.3600,0.0000,0.0000,3,'2007-05-02 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (92,80,'133560','2007-04-01 00:00:00',175.0000,175.0000,0.0000,2,'2007-04-20 00:00:00','2007-04-03 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (93,104,'P02-3772','2007-04-03 00:00:00',7125.3400,7125.3400,0.0000,2,'2007-04-18 00:00:00','2007-04-08 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (94,106,'9982771','2007-04-03 00:00:00',503.2000,0.0000,0.0000,2,'2007-04-18 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (95,107,'RTR-72-3662-X','2007-04-04 00:00:00',1600.0000,1600.0000,0.0000,2,'2007-04-18 00:00:00','2007-04-11 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (96,113,'77290','2007-04-04 00:00:00',1750.0000,1750.0000,0.0000,2,'2007-04-18 00:00:00','2007-04-08 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (97,119,'10843','2007-04-04 00:00:00',4901.2600,4901.2600,0.0000,2,'2007-04-18 00:00:00','2007-04-11 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (98,95,'111-92R-10092','2007-04-04 00:00:00',46.2100,0.0000,0.0000,1,'2007-04-29 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (99,95,'111-92R-10093','2007-04-05 00:00:00',39.7700,0.0000,0.0000,2,'2007-04-28 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (100,96,'I77271-O01','2007-04-05 00:00:00',662.0000,0.0000,0.0000,2,'2007-04-24 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (101,103,'75C-90227','2007-04-06 00:00:00',1367.5000,1367.5000,0.0000,1,'2007-04-13 00:00:00','2007-04-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (102,48,'P02-88D77S7','2007-04-06 00:00:00',856.9200,856.9200,0.0000,1,'2007-04-13 00:00:00','2007-04-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (103,95,'111-92R-10094','2007-04-06 00:00:00',19.6700,0.0000,0.0000,1,'2007-04-27 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (104,114,'CBM9920-M-T77109','2007-04-07 00:00:00',290.0000,290.0000,0.0000,1,'2007-04-12 00:00:00','2007-04-09 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (105,95,'111-92R-10095','2007-04-07 00:00:00',32.7000,0.0000,0.0000,3,'2007-04-26 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (106,95,'111-92R-10096','2007-04-08 00:00:00',16.3300,0.0000,0.0000,2,'2007-04-25 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (107,95,'111-92R-10097','2007-04-08 00:00:00',16.3300,0.0000,0.0000,1,'2007-04-24 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (108,117,'111897','2007-04-11 00:00:00',16.6200,16.6200,0.0000,1,'2007-04-14 00:00:00','2007-04-12 00:00:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (109,102,'109596','2007-04-14 00:00:00',41.8000,0.0000,0.0000,3,'2007-05-11 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (110,72,'39104','2007-04-20 00:00:00',85.3100,0.0000,0.0000,3,'2007-05-20 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (111,37,'547480102','2007-04-20 00:00:00',224.0000,0.0000,0.0000,3,'2007-04-24 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (112,37,'547481328','2007-05-18 00:00:00',224.0000,0.0000,0.0000,3,'2007-04-25 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (113,72,'40318','2007-05-18 00:00:00',21842.0000,0.0000,0.0000,3,'2007-05-20 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (114,83,'31361833','2007-05-18 00:00:00',579.4200,0.0000,0.0000,2,'2007-04-09 00:00:00',null);
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (404,1,'475582e7-d64f-4741-8184-02e5f1a723c3','2007-08-19 16:45:00',2.0000,2.0000,0.0000,1,'2007-08-19 16:45:00','2007-08-19 16:45:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (434,1,'ae82a559-6cfd-4c71-8dd3-5289d3adabae','2007-08-19 17:05:00',1.0000,1.0000,1.0000,5,'2007-08-19 17:05:00','2007-08-19 17:05:00');
+insert into [dbo].[Invoices]([InvoiceID],[VendorID],[InvoiceNumber],[InvoiceDate],[InvoiceTotal],[PaymentTotal],[CreditTotal],[TermsID],[DueDate],[PaymentDate]) values (435,1,'1f7e4e08-f21d-4cee-a8da-4394c8336772','2007-08-19 17:07:00',5.0000,5.0000,5.0000,4,'2007-08-19 17:07:00','2007-08-19 17:07:00');
+SET IDENTITY_INSERT @initial.catalog@.dbo.Invoices OFF
diff --git a/sql/data/States.sql.template b/sql/data/States.sql.template
new file mode 100644
index 0000000..fec36ed
--- /dev/null
+++ b/sql/data/States.sql.template
@@ -0,0 +1,54 @@
+USE [@initial.catalog@];
+
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('AK','Alaska',99500,99999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('AL','Alabama',35000,36999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('AR','Arkansas',71600,72999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('AZ','Arizona',85000,86599);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('CA','California',90000,96699);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('CO','Colorado',80000,81699);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('CT','Connecticut',6000,6999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('DC','District of Columbia',20000,20599);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('DE','Delaware',19700,19999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('FL','Florida',32000,34999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('GA','Georgia',30000,31999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('HI','Hawaii',96700,96899);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('IA','Iowa',50000,52899);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('ID','Idaho',83200,83899);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('IL','Illinois',60000,62999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('IN','Indiana',46000,47999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('KS','Kansas',66000,67999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('KY','Kentucky',40000,42799);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('LA','Lousiana',70000,71499);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('MA','Massachusetts',1000,2799);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('MD','Maryland',20600,21999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('ME','Maine',3900,4999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('MI','Michigan',48000,49999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('MN','Minnesota',55000,56799);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('MO','Missouri',63000,65899);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('MS','Mississippi',38600,39799);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('MT','Montana',59000,59999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('NC','North Carolina',27000,28999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('ND','North Dakota',58000,58899);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('NE','Nebraska',68000,69399);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('NH','New Hampshire',3000,3899);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('NJ','New Jersey',7000,8999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('NM','New Mexico',87000,88499);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('NV','Nevada',89000,89899);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('NY','New York',9000,14999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('OH','Ohio',43000,45899);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('OK','Oklahoma',73000,74999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('OR','Oregon',97000,97999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('PA','Pennsylvania',15000,19699);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('RI','Rhode Island',2800,2999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('SC','South Carolina',29000,29999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('SD','South Dakota',57000,57799);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('TN','Tennessee',37000,38599);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('TX','Texas',75000,79999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('UT','Utah',84000,84799);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('VA','Virginia',22000,24699);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('VI','Virgin Islands',801,850);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('VT','Vermont',5000,5999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('WA','Washington',98000,99499);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('WI','Wisconsin',53000,54999);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('WV','West Virginia',24700,26899);
+insert into [dbo].[States]([StateCode],[StateName],[FirstZipCode],[LastZipCode]) values ('WY','Wyoming',82000,83199);
diff --git a/sql/data/Terms.sql.template b/sql/data/Terms.sql.template
new file mode 100644
index 0000000..b9c8252
--- /dev/null
+++ b/sql/data/Terms.sql.template
@@ -0,0 +1,9 @@
+USE [@initial.catalog@];
+
+SET IDENTITY_INSERT @initial.catalog@.dbo.Terms ON
+insert into [dbo].[Terms]([TermsID],[Description],[DueDays]) values (1,'Net due 10 days',10);
+insert into [dbo].[Terms]([TermsID],[Description],[DueDays]) values (2,'Net due 20 days',20);
+insert into [dbo].[Terms]([TermsID],[Description],[DueDays]) values (3,'Net due 30 days',30);
+insert into [dbo].[Terms]([TermsID],[Description],[DueDays]) values (4,'Net due 60 days',60);
+insert into [dbo].[Terms]([TermsID],[Description],[DueDays]) values (5,'Net due 90 days',90);
+SET IDENTITY_INSERT @initial.catalog@.dbo.Terms OFF
+\ No newline at end of file
diff --git a/sql/data/Vendors.sql.template b/sql/data/Vendors.sql.template
new file mode 100644
index 0000000..984986e
--- /dev/null
+++ b/sql/data/Vendors.sql.template
@@ -0,0 +1,126 @@
+USE [@initial.catalog@];
+
+SET IDENTITY_INSERT @initial.catalog@.dbo.Vendors ON
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (1,'US Postal Service','Attn:  Supt. Window Services','PO Box 7005','Madison','WI','53707','8005551205','Alberto','Francesco',1,552);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (2,'National Information Data Ctr','PO Box 96621',null,'Washington','DC','20090','3015558950','Irvin','Ania',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (3,'Register of Copyrights','Library Of Congress',null,'Washington','DC','20559',null,'Liana','Lukas',3,403);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (4,'Jobtrak','1990 Westwood Blvd Ste 260',null,'Los Angeles','CA','90025','8005558725','Quinn','Kenzie',3,572);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (5,'Newbrige Book Clubs','3000 Cindel Drive',null,'Washington','NJ','07882','8005559980','Marks','Michelle',4,394);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (6,'California Chamber Of Commerce','3255 Ramos Cir',null,'Sacramento','CA','95827','9165556670','Mauro','Anton',3,572);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (7,'Towne Advertiser''s Mailing Svcs','Kevin Minder','3441 W Macarthur Blvd','Santa Ana','CA','92704',null,'Maegen','Ted',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (8,'BFI Industries','PO Box 9369',null,'Fresno','CA','93792','5595551551','Kaleigh','Erick',3,521);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (9,'Pacific Gas & Electric','Box 52001',null,'San Francisco','CA','94152','8005556081','Anthoni','Kaitlyn',3,521);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (10,'Robbins Mobile Lock And Key','4669 N Fresno',null,'Fresno','CA','93726','5595559375','Leigh','Bill',2,523);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (11,'Bill Marvin Electric Inc','4583 E Home',null,'Fresno','CA','93703','5595555106','Hostlery','Kaitlin',2,523);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (12,'City Of Fresno','PO Box 2069',null,'Fresno','CA','93718','5595559999','Mayte','Kendall',3,574);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (13,'Golden Eagle Insurance Co','PO Box 85826',null,'San Diego','CA','92186',null,'Blanca','Korah',3,590);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (14,'Expedata Inc','4420 N. First Street, Suite 108',null,'Fresno','CA','93726','5595559586','Quintin','Marvin',3,589);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (15,'ASC Signs','1528 N Sierra Vista',null,'Fresno','CA','93703',null,'Darien','Elisabeth',1,546);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (16,'Internal Revenue Service','PO Box 5000',null,'Fresno','CA','93888',null,'Aileen','Joan',1,235);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (17,'Blanchard & Johnson Associates','27371 Valderas',null,'Mission Viejo','CA','92691','2145553647','Keeton','Gonzalo',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (18,'Fresno Photoengraving Company','1952 "H" Street','P.O. Box 1952','Fresno','CA','93718','5595553005','Chaddick','Derek',3,403);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (19,'Crown Printing','1730 "H" St',null,'Fresno','CA','93721','5595557473','Randrup','Leann',2,400);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (20,'Diversified Printing & Pub','2632 Saturn St',null,'Brea','CA','92621','7145554541','Lane','Vanesa',3,400);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (21,'The Library Ltd','7700 Forsyth',null,'St Louis','MO','63105','3145558834','Marques','Malia',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (22,'Micro Center','1555 W Lane Ave',null,'Columbus','OH','43221','6145554435','Evan','Emily',2,160);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (23,'Yale Industrial Trucks-Fresno','3711 W Franklin',null,'Fresno','CA','93706','5595552993','Alexis','Alexandro',3,532);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (24,'Zee Medical Service Co','4221 W Sierra Madre #104',null,'Washington','IA','52353',null,'Hallie','Juliana',3,570);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (25,'California Data Marketing','2818 E Hamilton',null,'Fresno','CA','93721','5595553801','Jonessen','Moises',4,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (26,'Small Press','121 E Front St - 4th Floor',null,'Traverse City','MI','49684',null,'Colette','Dusty',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (27,'Rich Advertising','12 Daniel Road',null,'Fairfield','NJ','07004','2015559742','Neil','Ingrid',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (29,'Vision Envelope & Printing','PO Box 3100',null,'Gardena','CA','90247','3105557062','Raven','Jamari',3,551);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (30,'Costco','Fresno Warehouse','4500 W Shaw','Fresno','CA','93711',null,'Jaquan','Aaron',3,570);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (31,'Enterprise Communications Inc','1483 Chain Bridge Rd, Ste 202',null,'Mclean','VA','22101','7705559558','Lawrence','Eileen',2,536);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (32,'RR Bowker','PO Box 31',null,'East Brunswick','NJ','08810','8005558110','Essence','Marjorie',3,532);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (33,'Nielson','Ohio Valley Litho Division','Location #0470','Cincinnati','OH','45264',null,'Brooklynn','Keely',2,541);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (34,'IBM','PO Box 61000',null,'San Francisco','CA','94161','8005554426','Camron','Trentin',1,160);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (35,'Cal State Termite','PO Box 956',null,'Selma','CA','93662','5595551534','Hunter','Demetrius',2,523);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (36,'Graylift','PO Box 2808',null,'Fresno','CA','93745','5595556621','Sydney','Deangelo',3,532);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (37,'Blue Cross','PO Box 9061',null,'Oxnard','CA','93031','8005550912','Eliana','Nikolas',3,510);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (38,'Venture Communications Int''l','60 Madison Ave',null,'New York','NY','10010','2125554800','Neftaly','Thalia',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (39,'Custom Printing Company','PO Box 7028',null,'St Louis','MO','63177','3015551494','Myles','Harley',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (40,'Nat Assoc of College Stores','500 East Lorain Street',null,'Oberlin','OH','44074',null,'Bernard','Lucy',3,572);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (41,'Shields Design','415 E Olive Ave',null,'Fresno','CA','93728','5595558060','Kerry','Rowan',2,403);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (42,'Opamp Technical Books','1033 N Sycamore Ave.',null,'Los Angeles','CA','90038','2135554322','Paris','Gideon',3,572);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (43,'Capital Resource Credit','PO Box 39046',null,'Minneapolis','MN','55439','6125550057','Maxwell','Jayda',3,589);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (44,'Courier Companies, Inc','PO Box 5317',null,'Boston','MA','02206','5085556351','Antavius','Troy',4,400);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (45,'Naylor Publications Inc','PO Box 40513',null,'Jacksonville','FL','32231','8005556041','Gerald','Kristofer',3,572);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (46,'Open Horizons Publishing','Book Marketing Update','PO Box 205','Fairfield','IA','52556','5155556130','Damien','Deborah',2,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (47,'Baker & Taylor Books','Five Lakepointe Plaza, Ste 500','2709 Water Ridge Parkway','Charlotte','NC','28217','7045553500','Bernardo','Brittnee',3,572);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (48,'Fresno County Tax Collector','PO Box 1192',null,'Fresno','CA','93715','5595553482','Brenton','Kila',3,574);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (49,'Mcgraw Hill Companies','PO Box 87373',null,'Chicago','IL','60680','6145553663','Holbrooke','Rashad',3,572);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (50,'Publishers Weekly','Box 1979',null,'Marion','OH','43305','8005551669','Carrollton','Priscilla',3,572);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (51,'Blue Shield of California','PO Box 7021',null,'Anaheim','CA','92850','4155555103','Smith','Kylie',3,510);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (52,'Aztek Label','Accounts Payable','1150 N Tustin Ave','Anaheim','CA','92807','7145559000','Griffin','Brian',3,551);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (53,'Gary McKeighan Insurance','3649 W Beechwood Ave #101',null,'Fresno','CA','93711','5595552420','Jair','Caitlin',3,590);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (54,'Ph Photographic Services','2384 E Gettysburg',null,'Fresno','CA','93726','5595550765','Cheyenne','Kaylea',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (55,'Quality Education Data','PO Box 95857',null,'Chicago','IL','60694','8005555811','Misael','Kayle',2,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (56,'Springhouse Corp','PO Box 7247-7051',null,'Philadelphia','PA','19170','2155558700','Maeve','Clarence',3,523);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (57,'The Windows Deck','117 W Micheltorena Top Floor',null,'Santa Barbara','CA','93101','8005553353','Wood','Liam',3,536);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (58,'Fresno Rack & Shelving Inc','4718 N Bendel Ave',null,'Fresno','CA','93722',null,'Baylee','Dakota',2,523);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (59,'Publishers Marketing Assoc','627 Aviation Way',null,'Manhatttan Beach','CA','90266','3105552732','Walker','Jovon',3,572);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (60,'The Mailers Guide Co','PO Box 1550',null,'New Rochelle','NY','10802',null,'Lacy','Karina',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (61,'American Booksellers Assoc','828 S Broadway',null,'Tarrytown','NY','10591','8005550037','Angelica','Nashalie',3,574);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (62,'Cmg Information Services','PO Box 2283',null,'Boston','MA','02107','5085557000','Randall','Yash',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (63,'Lou Gentile''s Flower Basket','722 E Olive Ave',null,'Fresno','CA','93728','5595556643','Anum','Trisha',1,570);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (64,'Texaco','PO Box 6070',null,'Inglewood','CA','90312',null,'Oren','Grace',3,582);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (65,'The Drawing Board','PO Box 4758',null,'Carol Stream','IL','60197',null,'Mckayla','Jeffery',2,551);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (66,'Ascom Hasler Mailing Systems','PO Box 895',null,'Shelton','CT','06484',null,'Lewis','Darnell',3,532);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (67,'Bill Jones','Secretary Of State','PO Box 944230','Sacramento','CA','94244',null,'Deasia','Tristin',3,589);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (68,'Computer Library','3502 W Greenway #7',null,'Phoenix','AZ','85023','6025470331','Aryn','Leroy',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (69,'Frank E Wilber Co','2437 N Sunnyside',null,'Fresno','CA','93727','5595551881','Millerton','Johnathon',3,532);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (70,'Fresno Credit Bureau','PO Box 942',null,'Fresno','CA','93714','5595557900','Braydon','Anne',2,555);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (71,'The Fresno Bee','1626 E Street',null,'Fresno','CA','93786','5595554442','Colton','Leah',2,572);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (72,'Data Reproductions Corp','4545 Glenmeade Lane',null,'Auburn Hills','MI','48326','8105553700','Arodondo','Cesar',3,400);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (73,'Executive Office Products','353 E Shaw Ave',null,'Fresno','CA','93710','5595551704','Danielson','Rachael',2,570);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (74,'Leslie Company','PO Box 610',null,'Olathe','KS','66061','8002556210','Alondra','Zev',3,570);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (75,'Retirement Plan Consultants','6435 North Palm Ave, Ste 101',null,'Fresno','CA','93704','5595557070','Edgardo','Salina',3,589);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (76,'Simon Direct Inc','4 Cornwall Dr Ste 102',null,'East Brunswick','NJ','08816','9085557222','Bradlee','Daniel',2,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (77,'State Board Of Equalization','PO Box 942808',null,'Sacramento','CA','94208','9165554911','Dean','Julissa',1,631);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (78,'The Presort Center','1627 "E" Street',null,'Fresno','CA','93706','5595556151','Marissa','Kyle',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (79,'Valprint','PO Box 12332',null,'Fresno','CA','93777','5595553112','Warren','Quentin',3,551);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (80,'Cardinal Business Media, Inc.','P O Box 7247-7844',null,'Philadelphia','PA','19170','2155551500','Eulalia','Kelsey',2,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (81,'Wang Laboratories, Inc.','P.O. Box 21209',null,'Pasadena','CA','91185','8005550344','Kapil','Robert',2,160);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (82,'Reiter''s Scientific & Pro Books','2021 K Street Nw',null,'Washington','DC','20006','2025555561','Rodolfo','Carlee',2,572);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (83,'Ingram','PO Box 845361',null,'Dallas','TX','75284',null,'Yobani','Trey',2,572);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (84,'Boucher Communications Inc','1300 Virginia Dr. Ste 400',null,'Fort Washington','PA','19034','2155558000','Carson','Julian',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (85,'Champion Printing Company','3250 Spring Grove Ave',null,'Cincinnati','OH','45225','8005551957','Clifford','Jillian',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (86,'Computerworld','Department #1872','PO Box 61000','San Francisco','CA','94161','6175550700','Lloyd','Angel',1,572);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (87,'DMV Renewal','PO Box 942894',null,'Sacramento','CA','94294',null,'Josey','Lorena',4,568);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (88,'Edward Data Services','4775 E Miami River Rd',null,'Cleves','OH','45002','5135553043','Helena','Jeanette',1,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (89,'Evans Executone Inc','4918 Taylor Ct',null,'Turlock','CA','95380',null,'Royce','Hannah',1,522);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (90,'Wakefield Co','295 W Cromwell Ave Ste 106',null,'Fresno','CA','93711','5595554744','Rothman','Nathanael',2,170);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (91,'McKesson Water Products','P O Box 7126',null,'Pasadena','CA','91109','8005557009','Destin','Luciano',2,570);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (92,'Zip Print & Copy Center','PO Box 12332',null,'Fresno','CA','93777','2335556400','Javen','Justin',2,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (93,'AT&T','PO Box 78225',null,'Phoenix','AZ','85062',null,'Wesley','Alisha',3,522);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (94,'Abbey Office Furnishings','4150 W Shaw Ave',null,'Fresno','CA','93722','5595558300','Francis','Kyra',2,150);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (95,'Pacific Bell','PO Box 21347',null,'Sacramento','CA','95887','2095557500','Nickalus','Kurt',2,522);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (96,'Wells Fargo Bank','Business Mastercard','P.O. Box 29479','Phoenix','AZ','85038','9475553900','Damion','Mikayla',2,160);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (97,'Compuserve','Dept L-742',null,'Columbus','OH','43260','6145558600','Armando','Jan',2,572);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (98,'American Express','Box 0001',null,'Los Angeles','CA','90096','8005553344','Story','Kirsten',2,160);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (99,'Bertelsmann Industry Svcs. Inc','28210 N Avenue Stanford',null,'Valencia','CA','91355','8055550584','Potter','Lance',3,400);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (100,'Cahners Publishing Company','Citibank Lock Box 4026','8725 W Sahara Zone 1127','The Lake','NV','89163','3015552162','Jacobsen','Samuel',4,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (101,'California Business Machines','Gallery Plz','5091 N Fresno','Fresno','CA','93710','5595555570','Rohansen','Anders',2,170);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (102,'Coffee Break Service','PO Box 1091',null,'Fresno','CA','93714','5595558700','Smitzen','Jeffrey',4,570);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (103,'Dean Witter Reynolds','9 River Pk Pl E 400',null,'Boston','MA','02134','5085558737','Johnson','Vance',5,589);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (104,'Digital Dreamworks','5070 N Sixth Ste. 71',null,'Fresno','CA','93711',null,'Elmert','Ron',3,589);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (105,'Dristas Groom & McCormick','7112 N Fresno St Ste 200',null,'Fresno','CA','93720','5595558484','Aaronsen','Thom',3,591);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (106,'Ford Motor Credit Company','Dept 0419',null,'Los Angeles','CA','90084','8005557000','Snyder','Karen',3,582);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (107,'Franchise Tax Board','PO Box 942857',null,'Sacramento','CA','94257',null,'Prado','Anita',4,507);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (108,'Gostanian General Building','427 W Bedford #102',null,'Fresno','CA','93711','5595555100','Bragg','Walter',4,523);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (109,'Kent H Landsberg Co','File No 72686','PO Box 61000','San Francisco','CA','94160','9165558100','Stevens','Wendy',3,540);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (110,'Malloy Lithographing Inc','5411 Jackson Road','PO Box 1124','Ann Arbor','MI','48106','3135556113','Regging','Abe',3,400);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (111,'Net Asset, Llc','1315 Van Ness Ave Ste. 103',null,'Fresno','CA','93721',null,'Kraggin','Laura',1,572);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (112,'Office Depot','File No 81901',null,'Los Angeles','CA','90074','8005551711','Pinsippi','Val',3,570);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (113,'Pollstar','4697 W Jacquelyn Ave',null,'Fresno','CA','93722','5595552631','Aranovitch','Robert',5,520);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (114,'Postmaster','Postage Due Technician','1900 E Street','Fresno','CA','93706','5595557785','Finklestein','Fyodor',1,552);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (115,'Roadway Package System, Inc','Dept La 21095',null,'Pasadena','CA','91185',null,'Smith','Sam',4,553);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (116,'State of California','Employment Development Dept','PO Box 826276','Sacramento','CA','94230','2095555132','Articunia','Mercedez',1,631);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (117,'Suburban Propane','2874 S Cherry Ave',null,'Fresno','CA','93706','5595552770','Spivak','Harold',3,521);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (118,'Unocal','P.O. Box 860070',null,'Pasadena','CA','91186','4155557600','Bluzinski','Rachael',3,582);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (119,'Yesmed, Inc','PO Box 2061',null,'Fresno','CA','93718','5595550600','Hernandez','Reba',2,589);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (120,'Dataforms/West','1617 W. Shaw Avenue','Suite F','Fresno','CA','93711',null,'Church','Charlie',3,551);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (121,'Zylka Design','3467 W Shaw Ave #103',null,'Fresno','CA','93711','5595558625','Ronaldsen','Jaime',3,403);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (122,'United Parcel Service','P.O. Box 505820',null,'Reno','NV','88905','8005550855','Beauregard','Violet',3,553);
+insert into [dbo].[Vendors]([VendorID],[Name],[Address1],[Address2],[City],[State],[ZipCode],[Phone],[ContactLName],[ContactFName],[DefaultTermsID],[DefaultAccountNo]) values (123,'Federal Express Corporation','P.O. Box 1140','Dept A','Memphis','TN','38101','8005554091','Bucket','Charlie',3,553);
+SET IDENTITY_INSERT @initial.catalog@.dbo.Vendors OFF
diff --git a/sql/db.sql.template b/sql/db.sql.template
new file mode 100644
index 0000000..09e3d4b
--- /dev/null
+++ b/sql/db.sql.template
@@ -0,0 +1,67 @@
+IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'@initial.catalog@')
+	DROP DATABASE [@initial.catalog@]
+GO
+
+CREATE DATABASE [@initial.catalog@] ON  PRIMARY 
+( NAME = N'@initial.catalog@_Data', FILENAME = N'@database.path@\@initial.catalog@.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
+ LOG ON 
+( NAME = N'@initial.catalog@_Log', FILENAME = N'@database.path@\@initial.catalog@.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
+GO
+EXEC dbo.sp_dbcmptlevel @dbname=N'@initial.catalog@', @new_cmptlevel=90
+GO
+IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
+begin
+EXEC [@initial.catalog@].[dbo].[sp_fulltext_database] @action = 'enable'
+end
+GO
+ALTER DATABASE [@initial.catalog@] SET ANSI_NULL_DEFAULT OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET ANSI_NULLS OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET ANSI_PADDING OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET ANSI_WARNINGS OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET ARITHABORT OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET AUTO_CLOSE OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET AUTO_CREATE_STATISTICS ON 
+GO
+ALTER DATABASE [@initial.catalog@] SET AUTO_SHRINK OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET AUTO_UPDATE_STATISTICS ON 
+GO
+ALTER DATABASE [@initial.catalog@] SET CURSOR_CLOSE_ON_COMMIT OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET CURSOR_DEFAULT  GLOBAL 
+GO
+ALTER DATABASE [@initial.catalog@] SET CONCAT_NULL_YIELDS_NULL OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET NUMERIC_ROUNDABORT OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET QUOTED_IDENTIFIER OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET RECURSIVE_TRIGGERS OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET  DISABLE_BROKER 
+GO
+ALTER DATABASE [@initial.catalog@] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET DATE_CORRELATION_OPTIMIZATION OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET TRUSTWORTHY OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET ALLOW_SNAPSHOT_ISOLATION OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET PARAMETERIZATION SIMPLE 
+GO
+ALTER DATABASE [@initial.catalog@] SET  READ_WRITE 
+GO
+ALTER DATABASE [@initial.catalog@] SET RECOVERY SIMPLE 
+GO
+ALTER DATABASE [@initial.catalog@] SET  MULTI_USER 
+GO
+ALTER DATABASE [@initial.catalog@] SET PAGE_VERIFY CHECKSUM  
+GO
+ALTER DATABASE [@initial.catalog@] SET DB_CHAINING OFF 
+\ No newline at end of file
diff --git a/sql/functions.sql.template b/sql/functions.sql.template
new file mode 100644
index 0000000..5ac7868
--- /dev/null
+++ b/sql/functions.sql.template
@@ -0,0 +1,58 @@
+USE [@initial.catalog@]
+SET QUOTED_IDENTIFIER ON 
+GO
+SET ANSI_NULLS ON 
+GO
+
+
+	CREATE FUNCTION dbo.fn_diagramobjects() 
+	RETURNS int
+	WITH EXECUTE AS N'dbo'
+	AS
+	BEGIN
+		declare @id_upgraddiagrams		int
+		declare @id_sysdiagrams			int
+		declare @id_helpdiagrams		int
+		declare @id_helpdiagramdefinition	int
+		declare @id_creatediagram	int
+		declare @id_renamediagram	int
+		declare @id_alterdiagram 	int 
+		declare @id_dropdiagram		int
+		declare @InstalledObjects	int
+
+		select @InstalledObjects = 0
+
+		select 	@id_upgraddiagrams = object_id(N'dbo.sp_upgraddiagrams'),
+			@id_sysdiagrams = object_id(N'dbo.sysdiagrams'),
+			@id_helpdiagrams = object_id(N'dbo.sp_helpdiagrams'),
+			@id_helpdiagramdefinition = object_id(N'dbo.sp_helpdiagramdefinition'),
+			@id_creatediagram = object_id(N'dbo.sp_creatediagram'),
+			@id_renamediagram = object_id(N'dbo.sp_renamediagram'),
+			@id_alterdiagram = object_id(N'dbo.sp_alterdiagram'), 
+			@id_dropdiagram = object_id(N'dbo.sp_dropdiagram')
+
+		if @id_upgraddiagrams is not null
+			select @InstalledObjects = @InstalledObjects + 1
+		if @id_sysdiagrams is not null
+			select @InstalledObjects = @InstalledObjects + 2
+		if @id_helpdiagrams is not null
+			select @InstalledObjects = @InstalledObjects + 4
+		if @id_helpdiagramdefinition is not null
+			select @InstalledObjects = @InstalledObjects + 8
+		if @id_creatediagram is not null
+			select @InstalledObjects = @InstalledObjects + 16
+		if @id_renamediagram is not null
+			select @InstalledObjects = @InstalledObjects + 32
+		if @id_alterdiagram  is not null
+			select @InstalledObjects = @InstalledObjects + 64
+		if @id_dropdiagram is not null
+			select @InstalledObjects = @InstalledObjects + 128
+		
+		return @InstalledObjects 
+	END
+	
+GO
+SET QUOTED_IDENTIFIER OFF 
+GO
+SET ANSI_NULLS ON 
+GO
diff --git a/sql/grants.sql.template b/sql/grants.sql.template
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/sql/grants.sql.template
diff --git a/sql/indexes.sql.template b/sql/indexes.sql.template
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/sql/indexes.sql.template
diff --git a/sql/storedprocedures.sql.template b/sql/storedprocedures.sql.template
new file mode 100644
index 0000000..fae5d32
--- /dev/null
+++ b/sql/storedprocedures.sql.template
@@ -0,0 +1,457 @@
+use[@initial.catalog@]
+
+SET QUOTED_IDENTIFIER ON 
+GO
+SET ANSI_NULLS ON 
+GO
+
+
+	CREATE PROCEDURE dbo.sp_alterdiagram
+	(
+		@diagramname 	sysname,
+		@owner_id	int	= null,
+		@version 	int,
+		@definition 	varbinary(max)
+	)
+	WITH EXECUTE AS 'dbo'
+	AS
+	BEGIN
+		set nocount on
+	
+		declare @theId 			int
+		declare @retval 		int
+		declare @IsDbo 			int
+		
+		declare @UIDFound 		int
+		declare @DiagId			int
+		declare @ShouldChangeUID	int
+	
+		if(@diagramname is null)
+		begin
+			RAISERROR ('Invalid ARG', 16, 1)
+			return -1
+		end
+	
+		execute as caller;
+		select @theId = DATABASE_PRINCIPAL_ID();	 
+		select @IsDbo = IS_MEMBER(N'db_owner'); 
+		if(@owner_id is null)
+			select @owner_id = @theId;
+		revert;
+	
+		select @ShouldChangeUID = 0
+		select @DiagId = diagram_id, @UIDFound = principal_id from dbo.sysdiagrams where principal_id = @owner_id and name = @diagramname 
+		
+		if(@DiagId IS NULL or (@IsDbo = 0 and @theId <> @UIDFound))
+		begin
+			RAISERROR ('Diagram does not exist or you do not have permission.', 16, 1);
+			return -3
+		end
+	
+		if(@IsDbo <> 0)
+		begin
+			if(@UIDFound is null or USER_NAME(@UIDFound) is null) -- invalid principal_id
+			begin
+				select @ShouldChangeUID = 1 ;
+			end
+		end
+
+		-- update dds data			
+		update dbo.sysdiagrams set definition = @definition where diagram_id = @DiagId ;
+
+		-- change owner
+		if(@ShouldChangeUID = 1)
+			update dbo.sysdiagrams set principal_id = @theId where diagram_id = @DiagId ;
+
+		-- update dds version
+		if(@version is not null)
+			update dbo.sysdiagrams set version = @version where diagram_id = @DiagId ;
+
+		return 0
+	END
+	
+GO
+SET QUOTED_IDENTIFIER OFF 
+GO
+SET ANSI_NULLS ON 
+GO
+
+SET QUOTED_IDENTIFIER ON 
+GO
+SET ANSI_NULLS ON 
+GO
+
+
+	CREATE PROCEDURE dbo.sp_creatediagram
+	(
+		@diagramname 	sysname,
+		@owner_id		int	= null, 	
+		@version 		int,
+		@definition 	varbinary(max)
+	)
+	WITH EXECUTE AS 'dbo'
+	AS
+	BEGIN
+		set nocount on
+	
+		declare @theId int
+		declare @retval int
+		declare @IsDbo	int
+		declare @userName sysname
+		if(@version is null or @diagramname is null)
+		begin
+			RAISERROR (N'E_INVALIDARG', 16, 1);
+			return -1
+		end
+	
+		execute as caller;
+		select @theId = DATABASE_PRINCIPAL_ID(); 
+		select @IsDbo = IS_MEMBER(N'db_owner');
+		revert; 
+		
+		if @owner_id is null
+		begin
+			select @owner_id = @theId;
+		end
+		else
+		begin
+			if @theId <> @owner_id
+			begin
+				if @IsDbo = 0
+				begin
+					RAISERROR (N'E_INVALIDARG', 16, 1);
+					return -1
+				end
+				select @theId = @owner_id
+			end
+		end
+		-- next 2 line only for test, will be removed after define name unique
+		if EXISTS(select diagram_id from dbo.sysdiagrams where principal_id = @theId and name = @diagramname)
+		begin
+			RAISERROR ('The name is already used.', 16, 1);
+			return -2
+		end
+	
+		insert into dbo.sysdiagrams(name, principal_id , version, definition)
+				VALUES(@diagramname, @theId, @version, @definition) ;
+		
+		select @retval = @@IDENTITY 
+		return @retval
+	END
+	
+GO
+SET QUOTED_IDENTIFIER OFF 
+GO
+SET ANSI_NULLS ON 
+GO
+
+SET QUOTED_IDENTIFIER ON 
+GO
+SET ANSI_NULLS ON 
+GO
+
+
+	CREATE PROCEDURE dbo.sp_dropdiagram
+	(
+		@diagramname 	sysname,
+		@owner_id	int	= null
+	)
+	WITH EXECUTE AS 'dbo'
+	AS
+	BEGIN
+		set nocount on
+		declare @theId 			int
+		declare @IsDbo 			int
+		
+		declare @UIDFound 		int
+		declare @DiagId			int
+	
+		if(@diagramname is null)
+		begin
+			RAISERROR ('Invalid value', 16, 1);
+			return -1
+		end
+	
+		EXECUTE AS CALLER;
+		select @theId = DATABASE_PRINCIPAL_ID();
+		select @IsDbo = IS_MEMBER(N'db_owner'); 
+		if(@owner_id is null)
+			select @owner_id = @theId;
+		REVERT; 
+		
+		select @DiagId = diagram_id, @UIDFound = principal_id from dbo.sysdiagrams where principal_id = @owner_id and name = @diagramname 
+		if(@DiagId IS NULL or (@IsDbo = 0 and @UIDFound <> @theId))
+		begin
+			RAISERROR ('Diagram does not exist or you do not have permission.', 16, 1)
+			return -3
+		end
+	
+		delete from dbo.sysdiagrams where diagram_id = @DiagId;
+	
+		return 0;
+	END
+	
+GO
+SET QUOTED_IDENTIFIER OFF 
+GO
+SET ANSI_NULLS ON 
+GO
+
+SET QUOTED_IDENTIFIER ON 
+GO
+SET ANSI_NULLS ON 
+GO
+
+
+	CREATE PROCEDURE dbo.sp_helpdiagramdefinition
+	(
+		@diagramname 	sysname,
+		@owner_id	int	= null 		
+	)
+	WITH EXECUTE AS N'dbo'
+	AS
+	BEGIN
+		set nocount on
+
+		declare @theId 		int
+		declare @IsDbo 		int
+		declare @DiagId		int
+		declare @UIDFound	int
+	
+		if(@diagramname is null)
+		begin
+			RAISERROR (N'E_INVALIDARG', 16, 1);
+			return -1
+		end
+	
+		execute as caller;
+		select @theId = DATABASE_PRINCIPAL_ID();
+		select @IsDbo = IS_MEMBER(N'db_owner');
+		if(@owner_id is null)
+			select @owner_id = @theId;
+		revert; 
+	
+		select @DiagId = diagram_id, @UIDFound = principal_id from dbo.sysdiagrams where principal_id = @owner_id and name = @diagramname;
+		if(@DiagId IS NULL or (@IsDbo = 0 and @UIDFound <> @theId ))
+		begin
+			RAISERROR ('Diagram does not exist or you do not have permission.', 16, 1);
+			return -3
+		end
+
+		select version, definition FROM dbo.sysdiagrams where diagram_id = @DiagId ; 
+		return 0
+	END
+	
+GO
+SET QUOTED_IDENTIFIER OFF 
+GO
+SET ANSI_NULLS ON 
+GO
+
+SET QUOTED_IDENTIFIER ON 
+GO
+SET ANSI_NULLS ON 
+GO
+
+
+	CREATE PROCEDURE dbo.sp_helpdiagrams
+	(
+		@diagramname sysname = NULL,
+		@owner_id int = NULL
+	)
+	WITH EXECUTE AS N'dbo'
+	AS
+	BEGIN
+		DECLARE @user sysname
+		DECLARE @dboLogin bit
+		EXECUTE AS CALLER;
+			SET @user = USER_NAME();
+			SET @dboLogin = CONVERT(bit,IS_MEMBER('db_owner'));
+		REVERT;
+		SELECT
+			[Database] = DB_NAME(),
+			[Name] = name,
+			[ID] = diagram_id,
+			[Owner] = USER_NAME(principal_id),
+			[OwnerID] = principal_id
+		FROM
+			sysdiagrams
+		WHERE
+			(@dboLogin = 1 OR USER_NAME(principal_id) = @user) AND
+			(@diagramname IS NULL OR name = @diagramname) AND
+			(@owner_id IS NULL OR principal_id = @owner_id)
+		ORDER BY
+			4, 5, 1
+	END
+	
+GO
+SET QUOTED_IDENTIFIER OFF 
+GO
+SET ANSI_NULLS ON 
+GO
+
+SET QUOTED_IDENTIFIER ON 
+GO
+SET ANSI_NULLS ON 
+GO
+
+
+	CREATE PROCEDURE dbo.sp_renamediagram
+	(
+		@diagramname 		sysname,
+		@owner_id		int	= null,
+		@new_diagramname	sysname
+	
+	)
+	WITH EXECUTE AS 'dbo'
+	AS
+	BEGIN
+		set nocount on
+		declare @theId 			int
+		declare @IsDbo 			int
+		
+		declare @UIDFound 		int
+		declare @DiagId			int
+		declare @DiagIdTarg		int
+		declare @u_name			sysname
+		if((@diagramname is null) or (@new_diagramname is null))
+		begin
+			RAISERROR ('Invalid value', 16, 1);
+			return -1
+		end
+	
+		EXECUTE AS CALLER;
+		select @theId = DATABASE_PRINCIPAL_ID();
+		select @IsDbo = IS_MEMBER(N'db_owner'); 
+		if(@owner_id is null)
+			select @owner_id = @theId;
+		REVERT;
+	
+		select @u_name = USER_NAME(@owner_id)
+	
+		select @DiagId = diagram_id, @UIDFound = principal_id from dbo.sysdiagrams where principal_id = @owner_id and name = @diagramname 
+		if(@DiagId IS NULL or (@IsDbo = 0 and @UIDFound <> @theId))
+		begin
+			RAISERROR ('Diagram does not exist or you do not have permission.', 16, 1)
+			return -3
+		end
+	
+		-- if((@u_name is not null) and (@new_diagramname = @diagramname))	-- nothing will change
+		--	return 0;
+	
+		if(@u_name is null)
+			select @DiagIdTarg = diagram_id from dbo.sysdiagrams where principal_id = @theId and name = @new_diagramname
+		else
+			select @DiagIdTarg = diagram_id from dbo.sysdiagrams where principal_id = @owner_id and name = @new_diagramname
+	
+		if((@DiagIdTarg is not null) and  @DiagId <> @DiagIdTarg)
+		begin
+			RAISERROR ('The name is already used.', 16, 1);
+			return -2
+		end		
+	
+		if(@u_name is null)
+			update dbo.sysdiagrams set [name] = @new_diagramname, principal_id = @theId where diagram_id = @DiagId
+		else
+			update dbo.sysdiagrams set [name] = @new_diagramname where diagram_id = @DiagId
+		return 0
+	END
+	
+GO
+SET QUOTED_IDENTIFIER OFF 
+GO
+SET ANSI_NULLS ON 
+GO
+
+SET QUOTED_IDENTIFIER ON 
+GO
+SET ANSI_NULLS ON 
+GO
+
+
+	CREATE PROCEDURE dbo.sp_upgraddiagrams
+	AS
+	BEGIN
+		IF OBJECT_ID(N'dbo.sysdiagrams') IS NOT NULL
+			return 0;
+	
+		CREATE TABLE dbo.sysdiagrams
+		(
+			name sysname NOT NULL,
+			principal_id int NOT NULL,	-- we may change it to varbinary(85)
+			diagram_id int PRIMARY KEY IDENTITY,
+			version int,
+	
+			definition varbinary(max)
+			CONSTRAINT UK_principal_name UNIQUE
+			(
+				principal_id,
+				name
+			)
+		);
+
+
+		/* Add this if we need to have some form of extended properties for diagrams */
+		/*
+		IF OBJECT_ID(N'dbo.sysdiagram_properties') IS NULL
+		BEGIN
+			CREATE TABLE dbo.sysdiagram_properties
+			(
+				diagram_id int,
+				name sysname,
+				value varbinary(max) NOT NULL
+			)
+		END
+		*/
+
+		IF OBJECT_ID(N'dbo.dtproperties') IS NOT NULL
+		begin
+			insert into dbo.sysdiagrams
+			(
+				[name],
+				[principal_id],
+				[version],
+				[definition]
+			)
+			select	 
+				convert(sysname, dgnm.[uvalue]),
+				DATABASE_PRINCIPAL_ID(N'dbo'),			-- will change to the sid of sa
+				0,							-- zero for old format, dgdef.[version],
+				dgdef.[lvalue]
+			from dbo.[dtproperties] dgnm
+				inner join dbo.[dtproperties] dggd on dggd.[property] = 'DtgSchemaGUID' and dggd.[objectid] = dgnm.[objectid]	
+				inner join dbo.[dtproperties] dgdef on dgdef.[property] = 'DtgSchemaDATA' and dgdef.[objectid] = dgnm.[objectid]
+				
+			where dgnm.[property] = 'DtgSchemaNAME' and dggd.[uvalue] like N'_EA3E6268-D998-11CE-9454-00AA00A3F36E_' 
+			return 2;
+		end
+		return 1;
+	END
+	
+GO
+SET QUOTED_IDENTIFIER OFF 
+GO
+SET ANSI_NULLS ON 
+GO
+
+SET QUOTED_IDENTIFIER ON 
+GO
+SET ANSI_NULLS ON 
+GO
+
+CREATE PROCEDURE dbo.GetVendor 
+	@VendorID int
+AS
+	SELECT     VendorID, Name, Address1, Address2, City, State,
+	    ZipCode, Phone, ContactFName, ContactLName,
+	    DefaultAccountNo, DefaultTermsID
+	FROM         Vendors
+	WHERE     (VendorID = @VendorID) 
+
+	RETURN
+
+GO
+SET QUOTED_IDENTIFIER OFF 
+GO
+SET ANSI_NULLS ON 
+GO
+\ No newline at end of file
diff --git a/sql/tables.sql.template b/sql/tables.sql.template
new file mode 100644
index 0000000..3eab9d7
--- /dev/null
+++ b/sql/tables.sql.template
@@ -0,0 +1,92 @@
+USE [@initial.catalog@]
+
+PRINT 'Creating table GLAccounts'
+CREATE TABLE [dbo].[GLAccounts] (
+	[AccountNo] [int] NOT NULL ,
+	[Description] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+	CONSTRAINT [PK_GLAccounts] PRIMARY KEY  CLUSTERED 
+	(
+		[AccountNo]
+	)  ON [PRIMARY] 
+) ON [PRIMARY]
+GO
+
+PRINT 'Creating table InvoiceLineItems'
+CREATE TABLE [dbo].[InvoiceLineItems] (
+	[InvoiceID] [int] NOT NULL ,
+	[InvoiceSequence] [smallint] NOT NULL ,
+	[AccountNo] [int] NOT NULL ,
+	[Amount] [money] NOT NULL ,
+	[Description] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+	CONSTRAINT [PK_InvoiceLineItems] PRIMARY KEY  CLUSTERED 
+	(
+		[InvoiceID],
+		[InvoiceSequence]
+	)  ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+PRINT 'Creating table Invoices'
+CREATE TABLE [dbo].[Invoices] (
+	[InvoiceID] [int] IDENTITY (1, 1) NOT NULL ,
+	[VendorID] [int] NOT NULL ,
+	[InvoiceNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+	[InvoiceDate] [smalldatetime] NOT NULL ,
+	[InvoiceTotal] [money] NOT NULL ,
+	[PaymentTotal] [money] NOT NULL CONSTRAINT [DF_Invoices_PaymentTotal] DEFAULT ((0)),
+	[CreditTotal] [money] NOT NULL CONSTRAINT [DF_Invoices_CreditTotal] DEFAULT ((0)),
+	[TermsID] [int] NOT NULL CONSTRAINT [DF_Invoices_TermsID] DEFAULT ((3)),
+	[DueDate] [smalldatetime] NOT NULL ,
+	[PaymentDate] [smalldatetime] NULL ,
+	CONSTRAINT [PK_Invoices] PRIMARY KEY  CLUSTERED 
+	(
+		[InvoiceID]
+	)  ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+PRINT 'Creating table States'
+CREATE TABLE [dbo].[States] (
+	[StateCode] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+	[StateName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+	[FirstZipCode] [int] NOT NULL ,
+	[LastZipCode] [int] NOT NULL ,
+	CONSTRAINT [PK_States] PRIMARY KEY  CLUSTERED 
+	(
+		[StateCode]
+	)  ON [PRIMARY] 
+) ON [PRIMARY]
+GO
+
+PRINT 'Creating table Terms'
+CREATE TABLE [dbo].[Terms] (
+	[TermsID] [int] IDENTITY (1, 1) NOT NULL ,
+	[Description] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+	[DueDays] [smallint] NOT NULL ,
+	CONSTRAINT [PK_Terms] PRIMARY KEY  CLUSTERED 
+	(
+		[TermsID]
+	)  ON [PRIMARY] 
+) ON [PRIMARY]
+GO
+
+PRINT 'Creating table Vendors'
+CREATE TABLE [dbo].[Vendors] (
+	[VendorID] [int] IDENTITY (1, 1) NOT NULL ,
+	[Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+	[Address1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+	[Address2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+	[City] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+	[State] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+	[ZipCode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+	[Phone] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+	[ContactLName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+	[ContactFName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+	[DefaultTermsID] [int] NOT NULL CONSTRAINT [DF_Vendors_DefaultTermsID] DEFAULT ((3)),
+	[DefaultAccountNo] [int] NOT NULL CONSTRAINT [DF_Vendors_DefaultAccountNo] DEFAULT ((570)),
+	CONSTRAINT [PK_Vendors] PRIMARY KEY  CLUSTERED 
+	(
+		[VendorID]
+	)  ON [PRIMARY] 
+) ON [PRIMARY]
+GO
author	mo khan <mo@mokhan.ca>	2007-08-26 20:10:42 -0600
committer	mo khan <mo@mokhan.ca>	2007-08-26 20:10:42 -0600
commit	330be9feefb6394479553be0e078b4c4df3cbff1 (patch)
tree	55618c8af0d36583cde0ea5b4b193b98815a35aa /sql