The Data Base Is

the data base is

USEmaster

GO

/****** Object: Database LabDatabase ******/

IFDB_ID('LabDatabase')ISNOTNULL

DROPDATABASE LabDatabase

GO

CREATEDATABASE LabDatabase

GO

USE LabDatabase

GO

IFOBJECT_ID('dbo.ContactUpdates','U')ISNOTNULL

DROPTABLE ContactUpdates;

IFOBJECT_ID('dbo.InvoiceArchive','U')ISNOTNULL

DROPTABLE InvoiceArchive;

IFOBJECT_ID('dbo.InvoiceLineItems','U')ISNOTNULL

DROPTABLE InvoiceLineItems;

IFOBJECT_ID('dbo.Invoices','U')ISNOTNULL

DROPTABLE Invoices;

IFOBJECT_ID('dbo.Vendors','U')ISNOTNULL

DROPTABLE Vendors;

IFOBJECT_ID('dbo.GLAccounts','U')ISNOTNULL

DROPTABLE GLAccounts;

IFOBJECT_ID('dbo.Terms','U')ISNOTNULL

DROPTABLE Terms;

/****** Object: Table ContactUpdates ******/

CREATETABLE ContactUpdates(

VendorID intIDENTITY(1,1)NOTNULL,

LastName varchar(50)NULL,

FirstName varchar(50)NULL

)

GO

/****** Object: Table GLAccounts ******/

CREATETABLE GLAccounts(

AccountNo intNOTNULL,

AccountDescription varchar(50)NOTNULL,

CONSTRAINT PK_GLAccounts PRIMARYKEYCLUSTERED (

AccountNo ASC

)

)

GO

/****** Object: Table InvoiceArchive ******/

CREATETABLE InvoiceArchive(

InvoiceID intNOTNULL,

VendorID intNOTNULL,

InvoiceNumber varchar(50)NOTNULL,

InvoiceDate smalldatetimeNOTNULL,

InvoiceTotal moneyNOTNULL,

PaymentTotal moneyNOTNULL,

CreditTotal moneyNOTNULL,

TermsID intNOTNULL,

InvoiceDueDate smalldatetimeNOTNULL,

PaymentDate smalldatetimeNULL

)

GO

/****** Object: Table InvoiceLineItems ******/

CREATETABLE InvoiceLineItems(

InvoiceID intNOTNULL,

InvoiceSequence smallintNOTNULL,

AccountNo intNOTNULL,

InvoiceLineItemAmount moneyNOTNULL,

InvoiceLineItemDescription varchar(100)NOTNULL,

CONSTRAINT PK_InvoiceLineItems PRIMARYKEYCLUSTERED (

InvoiceID ASC,

InvoiceSequence ASC

)

)

GO

/****** Object: Table Invoices ******/

CREATETABLE Invoices(

InvoiceID intIDENTITY(1,1)NOTNULL,

VendorID intNOTNULL,

InvoiceNumber varchar(50)NOTNULL,

InvoiceDate smalldatetimeNOTNULL,

InvoiceTotal moneyNOTNULL,

PaymentTotal moneyNOTNULL,

CreditTotal moneyNOTNULL,

TermsID intNOTNULL,

InvoiceDueDate smalldatetimeNOTNULL,

PaymentDate smalldatetimeNULL,

CONSTRAINT PK_Invoices PRIMARYKEYCLUSTERED (

InvoiceID ASC

)

)

GO

/****** Object: Table Terms ******/

CREATETABLE Terms(

TermsID intIDENTITY(1,1)NOTNULL,

TermsDescription varchar(50)NOTNULL,

TermsDueDays smallintNOTNULL,

CONSTRAINT PK_Terms PRIMARYKEYCLUSTERED (

TermsID ASC

)

)

GO

/****** Object: Table Vendors ******/

CREATETABLE Vendors(

VendorID intIDENTITY(1,1)NOTNULL,

VendorName varchar(50)NOTNULL,

VendorAddress1 varchar(50)NULL,

VendorAddress2 varchar(50)NULL,

VendorCity varchar(50)NOTNULL,

VendorState char(2)NOTNULL,

VendorZipCode varchar(20)NOTNULL,

VendorPhone varchar(50)NULL,

VendorContactLName varchar(50)NULL,

VendorContactFName varchar(50)NULL,

DefaultTermsID intNOTNULL,

DefaultAccountNo intNOTNULL,

CONSTRAINT PK_Vendors PRIMARYKEYCLUSTERED(

VendorID ASC

)

)

GO

SETIDENTITY_INSERT ContactUpdates ON

INSERT ContactUpdates(VendorID, LastName, FirstName)VALUES

(5,'Davison','Michelle'),

(12,'Mayteh','Kendall'),

(17,'Onandonga','Bruce'),

(44,'Antavius','Anthony'),

(76,'Bradlee','Danny'),

(94,'Suscipe','Reynaldo'),

(101,'O''Sullivan','Geraldine'),

(123,'Bucket','Charles')

SETIDENTITY_INSERT ContactUpdates OFF

GO

INSERT GLAccounts(AccountNo, AccountDescription)VALUES

(100,'Cash'),

(110,'Accounts Receivable'),

(120,'Book Inventory'),

(150,'Furniture'),

(160,'Computer Equipment'),

(162,'Capitalized Lease'),

(167,'Software'),

(170,'Other Equipment'),

(181,'Book Development'),

(200,'Accounts Payable'),

(205,'Royalties Payable'),

(221,'401K Employee Contributions'),

(230,'Sales Taxes Payable'),

(234,'Medicare Taxes Payable'),

(235,'Income Taxes Payable'),

(237,'State Payroll Taxes Payable'),

(238,'Employee FICA Taxes Payable'),

(239,'Employer FICA Taxes Payable'),

(241,'Employer FUTA Taxes Payable'),

(242,'Employee SDI Taxes Payable'),

(243,'Employer UCI Taxes Payable'),

(251,'IBM Credit Corporation Payable'),

(280,'Capital Stock'),

(290,'Retained Earnings'),

(300,'Retail Sales'),

(301,'College Sales'),

(302,'Trade Sales'),

(306,'Consignment Sales'),

(310,'Compositing Revenue'),

(394,'Book Club Royalties'),

(400,'Book Printing Costs'),

(403,'Book Production Costs'),

(500,'Salaries and Wages'),

(505,'FICA'),

(506,'FUTA'),

(507,'UCI'),

(508,'Medicare'),

(510,'Group Insurance'),

(520,'Building Lease'),

(521,'Utilities'),

(522,'Telephone'),

(523,'Building Maintenance'),

(527,'Computer Equipment Maintenance'),

(528,'IBM Lease'),

(532,'Equipment Rental'),

(536,'Card Deck Advertising'),

(540,'Direct Mail Advertising'),

(541,'Space Advertising'),

(546,'Exhibits and Shows'),

(548,'Web Site Production and Fees'),

(550,'Packaging Materials'),

(551,'Business Forms'),

(552,'Postage'),

(553,'Freight'),

(555,'Collection Agency Fees'),

(556,'Credit Card Handling'),

(565,'Bank Fees'),

(568,'Auto License Fee'),

(569,'Auto Expense'),

(570,'Office Supplies'),

(572,'Books, Dues, and Subscriptions'),

(574,'Business Licenses and Taxes'),

(576,'PC Software'),

(580,'Meals'),

(582,'Travel and Accomodations'),

(589,'Outside Services'),

(590,'Business Insurance'),

(591,'Accounting'),

(610,'Charitable Contributions'),

(611,'Profit Sharing Contributions'),

(620,'Interest Paid to Banks'),

(621,'Other Interest'),

(630,'Federal Corporation Income Taxes'),

(631,'State Corporation Income Taxes'),

(632,'Sales Tax')

GO

INSERT InvoiceLineItems(InvoiceID, InvoiceSequence, AccountNo, InvoiceLineItemAmount, InvoiceLineItemDescription)VALUES

(1, 1, 553, 3813.3300,'Freight'),

(2, 1, 553, 40.2000,'Freight'),

(3, 1, 553, 138.7500,'Freight'),

(4, 1, 553, 144.7000,'Int''l shipment'),

(5, 1, 553, 15.5000,'Freight'),

(6, 1, 553, 42.7500,'Freight'),

(7, 1, 553, 172.5000,'Freight'),

(8, 1, 522, 95.0000,'Telephone service'),

(9, 1, 403, 601.9500,'Cover design'),

(10, 1, 553, 42.6700,'Freight'),

(11, 1, 553, 42.5000,'Freight'),

(12, 1, 580, 50.0000,'DiCicco''s'),

(12, 2, 570, 75.6000,'Kinko''s'),

(12, 3, 570, 58.4000,'Office Max'),

(12, 4, 540, 478.0000,'Publishers Marketing'),

(13, 1, 522, 16.3300,'Telephone (line 5)'),

(14, 1, 553, 6.0000,'Freight out'),

(15, 1, 574, 856.9200,'Property Taxes'),

(16, 1, 572, 9.9500,'Monthly access fee'),

(17, 1, 553, 10.0000,'Address correction'),

(18, 1, 553, 104.0000,'Freight'),

(19, 1, 160, 116.5400,'MVS Online Library'),

(20, 1, 553, 6.0000,'Freight out'),

(21, 1, 589, 4901.2600,'Office lease'),

(22, 1, 553, 108.2500,'Freight'),

(23, 1, 572, 9.9500,'Monthly access fee'),

(24, 1, 520, 1750.0000,'Warehouse lease'),

(25, 1, 553, 129.0000,'Freight'),

(26, 1, 553, 10.0000,'Freight'),

(27, 1, 540, 207.7800,'Prospect list'),

(28, 1, 553, 109.5000,'Freight'),

(29, 1, 523, 450.0000,'Back office additions'),

(30, 1, 553, 63.4000,'Freight'),

(31, 1, 589, 7125.3400,'Web site design'),

(32, 1, 403, 953.1000,'Crash Course revision'),

(33, 1, 591, 220.0000,'Form 571-L'),

(34, 1, 553, 127.7500,'Freight'),

(35, 1, 507, 1600.0000,'Income Tax'),

(36, 1, 403, 565.1500,'Crash Course Ad'),

(37, 1, 553, 36.0000,'Freight'),

(38, 1, 553, 61.5000,'Freight'),

(39, 1, 400, 37966.1900,'CICS Desk Reference'),

(40, 1, 403, 639.7700,'Card deck'),

(41, 1, 553, 53.7500,'Freight'),

(42, 1, 553, 400.0000,'Freight'),

(43, 1, 400, 21842.0000,'Book repro'),

(44, 1, 522, 19.6700,'Telephone (Line 3)'),

(45, 1, 553, 2765.3600,'Freight'),

(46, 1, 510, 224.0000,'Health Insurance'),

(47, 1, 572, 1575.0000,'Catalog ad'),

(48, 1, 553, 33.0000,'Freight'),

(49, 1, 522, 16.3300,'Telephone (line 6)'),

(50, 1, 510, 116.0000,'Health Insurance'),

(51, 1, 553, 2184.1100,'Freight'),

(52, 1, 160, 1083.5800,'MSDN'),

(53, 1, 522, 46.2100,'Telephone (Line 1)'),

(54, 1, 403, 313.5500,'Card revision'),

(55, 1, 553, 40.7500,'Freight'),

(56, 1, 572, 2433.0000,'Card deck'),

(57, 1, 589, 1367.5000,'401K Contributions'),

(58, 1, 553, 53.2500,'Freight'),

(59, 1, 553, 13.7500,'Freight'),

(60, 1, 553, 2312.2000,'Freight'),

(61, 1, 553, 25.6700,'Freight out'),

(62, 1, 553, 26.7500,'Freight'),

(63, 1, 553, 2115.8100,'Freight'),

(64, 1, 553, 23.5000,'Freight'),

(65, 1, 400, 6940.2500,'OS Utilities'),

(66, 1, 553, 31.9500,'Freight'),

(67, 1, 553, 1927.5400,'Freight'),

(68, 1, 160, 936.9300,'Quarterly Maintenance'),

(69, 1, 540, 175.0000,'Card deck advertising'),

(70, 1, 553, 6.0000,'Freight'),

(71, 1, 553, 108.5000,'Freight'),

(72, 1, 553, 10.0000,'Address correction'),

(73, 1, 552, 290.0000,'International pkg.'),

(74, 1, 570, 41.8000,'Coffee'),

(75, 1, 553, 27.0000,'Freight'),

(76, 1, 553, 241.0000,'Int''l shipment'),

(77, 1, 403, 904.1400,'Cover design'),

(78, 1, 403, 1197.0000,'Cover design'),

(78, 2, 540, 765.1300,'Catalog design'),

(79, 1, 540, 2184.5000,'PC card deck'),

(80, 1, 553, 2318.0300,'Freight'),

(81, 1, 553, 26.2500,'Freight'),

(82, 1, 150, 17.5000,'Supplies'),

(83, 1, 522, 39.7700,'Telephone (Line 2)'),

(84, 1, 553, 111.0000,'Freight'),

(85, 1, 553, 158.0000,'Int''l shipment'),

(86, 1, 553, 739.2000,'Freight'),

(87, 1, 553, 60.0000,'Freight'),

(88, 1, 553, 147.2500,'Freight'),

(89, 1, 400, 85.3100,'Book copy'),

(90, 1, 553, 38.7500,'Freight'),

(91, 1, 522, 32.7000,'Telephone (line 4)'),

(92, 1, 521, 16.6200,'Propane-forklift'),

(93, 1, 553, 162.7500,'International shipment'),

(94, 1, 553, 52.2500,'Freight'),

(95, 1, 572, 600.0000,'Books for research'),

(96, 1, 400, 26881.4000,'MVS JCL'),

(97, 1, 170, 356.4800,'Network wiring'),

(98, 1, 572, 579.4200,'Catalog ad'),

(99, 1, 553, 59.9700,'Freight'),

(100, 1, 553, 67.9200,'Freight'),

(101, 1, 553, 30.7500,'Freight'),

(102, 1, 400, 20551.1800,'CICS book printing'),

(103, 1, 553, 2051.5900,'Freight'),

(104, 1, 553, 44.4400,'Freight'),

(105, 1, 582, 503.2000,'Bronco lease'),

(106, 1, 400, 23517.5800,'DB2 book printing'),

(107, 1, 553, 3689.9900,'Freight'),

(108, 1, 553, 67.0000,'Freight'),

(109, 1, 403, 1000.4600,'Crash Course covers'),

(110, 1, 540, 90.3600,'Card deck advertising'),

(111, 1, 553, 22.5700,'Freight'),

(112, 1, 400, 10976.0600,'VSAM book printing'),

(113, 1, 510, 224.0000,'Health Insurance'),

(114, 1, 553, 127.7500,'Freight')

GO

SETIDENTITY_INSERT Invoices ON

INSERT Invoices(InvoiceID, VendorID, InvoiceNumber, InvoiceDate, InvoiceTotal, PaymentTotal, CreditTotal, TermsID, InvoiceDueDate, PaymentDate)VALUES

(1, 122,'989319-457',CAST('2015-12-08 00:00:00'ASSmallDateTime), 3813.3300, 3813.3300, 0.0000, 3,CAST('2016-01-08 00:00:00'ASSmallDateTime),CAST('2016-01-07 00:00:00'ASSmallDateTime)),

(2, 123,'263253241',CAST('2015-12-10 00:00:00'ASSmallDateTime), 40.2000, 40.2000, 0.0000, 3,CAST('2016-01-10 00:00:00'ASSmallDateTime),CAST('2016-01-14 00:00:00'ASSmallDateTime)),

(3, 123,'963253234',CAST('2015-12-13 00:00:00'ASSmallDateTime), 138.7500, 138.7500, 0.0000, 3,CAST('2016-01-13 00:00:00'ASSmallDateTime),CAST('2016-01-09 00:00:00'ASSmallDateTime)),

(4, 123,'2-000-2993',CAST('2015-12-16 00:00:00'ASSmallDateTime), 144.7000, 144.7000, 0.0000, 3,CAST('2016-01-16 00:00:00'ASSmallDateTime),CAST('2016-01-12 00:00:00'ASSmallDateTime)),

(5, 123,'963253251',CAST('2015-12-16 00:00:00'ASSmallDateTime), 15.5000, 15.5000, 0.0000, 3,CAST('2016-01-16 00:00:00'ASSmallDateTime),CAST('2016-01-11 00:00:00'ASSmallDateTime)),

(6, 123,'963253261',CAST('2015-12-16 00:00:00'ASSmallDateTime), 42.7500, 42.7500, 0.0000, 3,CAST('2016-01-16 00:00:00'ASSmallDateTime),CAST('2016-01-21 00:00:00'ASSmallDateTime)),

(7, 123,'963253237',CAST('2015-12-21 00:00:00'ASSmallDateTime), 172.5000, 172.5000, 0.0000, 3,CAST('2016-01-21 00:00:00'ASSmallDateTime),CAST('2016-01-22 00:00:00'ASSmallDateTime)),

(8, 89,'125520-1',CAST('2015-12-24 00:00:00'ASSmallDateTime), 95.0000, 95.0000, 0.0000, 1,CAST('2016-01-04 00:00:00'ASSmallDateTime),CAST('2016-01-01 00:00:00'ASSmallDateTime)),

(9, 121,'97/488',CAST('2015-12-24 00:00:00'ASSmallDateTime), 601.9500, 601.9500, 0.0000, 3,CAST('2016-01-24 00:00:00'ASSmallDateTime),CAST('2016-01-21 00:00:00'ASSmallDateTime)),

(10, 123,'263253250',CAST('2015-12-24 00:00:00'ASSmallDateTime), 42.6700, 42.6700, 0.0000, 3,CAST('2016-01-24 00:00:00'ASSmallDateTime),CAST('2016-01-22 00:00:00'ASSmallDateTime)),

(11, 123,'963253262',CAST('2015-12-25 00:00:00'ASSmallDateTime), 42.5000, 42.5000, 0.0000, 3,CAST('2016-01-25 00:00:00'ASSmallDateTime),CAST('2016-01-20 00:00:00'ASSmallDateTime)),

(12, 96,'I77271-O01',CAST('2015-12-26 00:00:00'ASSmallDateTime), 662.0000, 662.0000, 0.0000, 2,CAST('2016-01-16 00:00:00'ASSmallDateTime),CAST('2016-01-13 00:00:00'ASSmallDateTime)),

(13, 95,'111-92R-10096',CAST('2015-12-30 00:00:00'ASSmallDateTime), 16.3300, 16.3300, 0.0000, 2,CAST('2016-01-20 00:00:00'ASSmallDateTime),CAST('2016-01-23 00:00:00'ASSmallDateTime)),

(14, 115,'25022117',CAST('2016-01-01 00:00:00'ASSmallDateTime), 6.0000, 6.0000, 0.0000, 4,CAST('2016-02-10 00:00:00'ASSmallDateTime),CAST('2016-02-10 00:00:00'ASSmallDateTime)),

(15, 48,'P02-88D77S7',CAST('2016-01-03 00:00:00'ASSmallDateTime), 856.9200, 856.9200, 0.0000, 3,CAST('2016-02-02 00:00:00'ASSmallDateTime),CAST('2016-01-30 00:00:00'ASSmallDateTime)),

(16, 97,'21-4748363',CAST('2016-01-03 00:00:00'ASSmallDateTime), 9.9500, 9.9500, 0.0000, 2,CAST('2016-01-23 00:00:00'ASSmallDateTime),CAST('2016-01-22 00:00:00'ASSmallDateTime)),

(17, 123,'4-321-2596',CAST('2016-01-05 00:00:00'ASSmallDateTime), 10.0000, 10.0000, 0.0000, 3,CAST('2016-02-04 00:00:00'ASSmallDateTime),CAST('2016-02-05 00:00:00'ASSmallDateTime)),

(18, 123,'963253242',CAST('2016-01-06 00:00:00'ASSmallDateTime), 104.0000, 104.0000, 0.0000, 3,CAST('2016-02-05 00:00:00'ASSmallDateTime),CAST('2016-02-05 00:00:00'ASSmallDateTime)),

(19, 34,'QP58872',CAST('2016-01-07 00:00:00'ASSmallDateTime), 116.5400, 116.5400, 0.0000, 1,CAST('2016-01-17 00:00:00'ASSmallDateTime),CAST('2016-01-19 00:00:00'ASSmallDateTime)),

(20, 115,'24863706',CAST('2016-01-10 00:00:00'ASSmallDateTime), 6.0000, 6.0000, 0.0000, 4,CAST('2016-02-19 00:00:00'ASSmallDateTime),CAST('2016-02-15 00:00:00'ASSmallDateTime)),

(21, 119,'10843',CAST('2016-01-11 00:00:00'ASSmallDateTime), 4901.2600, 4901.2600, 0.0000, 2,CAST('2016-01-31 00:00:00'ASSmallDateTime),CAST('2016-01-29 00:00:00'ASSmallDateTime)),

(22, 123,'963253235',CAST('2016-01-11 00:00:00'ASSmallDateTime), 108.2500, 108.2500, 0.0000, 3,CAST('2016-02-10 00:00:00'ASSmallDateTime),CAST('2016-02-09 00:00:00'ASSmallDateTime)),

(23, 97,'21-4923721',CAST('2016-01-13 00:00:00'ASSmallDateTime), 9.9500, 9.9500, 0.0000, 2,CAST('2016-02-02 00:00:00'ASSmallDateTime),CAST('2016-01-28 00:00:00'ASSmallDateTime)),

(24, 113,'77290',CAST('2016-01-13 00:00:00'ASSmallDateTime), 1750.0000, 1750.0000, 0.0000, 5,CAST('2016-03-02 00:00:00'ASSmallDateTime),CAST('2016-03-05 00:00:00'ASSmallDateTime)),

(25, 123,'963253246',CAST('2016-01-13 00:00:00'ASSmallDateTime), 129.0000, 129.0000, 0.0000, 3,CAST('2016-02-12 00:00:00'ASSmallDateTime),CAST('2016-02-09 00:00:00'ASSmallDateTime)),

(26, 123,'4-342-8069',CAST('2016-01-14 00:00:00'ASSmallDateTime), 10.0000, 10.0000, 0.0000, 3,CAST('2016-02-13 00:00:00'ASSmallDateTime),CAST('2016-02-13 00:00:00'ASSmallDateTime)),

(27, 88,'972110',CAST('2016-01-15 00:00:00'ASSmallDateTime), 207.7800, 207.7800, 0.0000, 1,CAST('2016-01-25 00:00:00'ASSmallDateTime),CAST('2016-01-27 00:00:00'ASSmallDateTime)),

(28, 123,'963253263',CAST('2016-01-16 00:00:00'ASSmallDateTime), 109.5000, 109.5000, 0.0000, 3,CAST('2016-02-15 00:00:00'ASSmallDateTime),CAST('2016-02-10 00:00:00'ASSmallDateTime)),

(29, 108,'121897',CAST('2016-01-19 00:00:00'ASSmallDateTime), 450.0000, 450.0000, 0.0000, 4,CAST('2016-02-28 00:00:00'ASSmallDateTime),CAST('2016-03-03 00:00:00'ASSmallDateTime)),

(30, 123,'1-200-5164',CAST('2016-01-20 00:00:00'ASSmallDateTime), 63.4000, 63.4000, 0.0000, 3,CAST('2016-02-19 00:00:00'ASSmallDateTime),CAST('2016-02-24 00:00:00'ASSmallDateTime)),

(31, 104,'P02-3772',CAST('2016-01-21 00:00:00'ASSmallDateTime), 7125.3400, 7125.3400, 0.0000, 3,CAST('2016-02-20 00:00:00'ASSmallDateTime),CAST('2016-02-24 00:00:00'ASSmallDateTime)),

(32, 121,'97/486',CAST('2016-01-21 00:00:00'ASSmallDateTime), 953.1000, 953.1000, 0.0000, 3,CAST('2016-02-20 00:00:00'ASSmallDateTime),CAST('2016-02-22 00:00:00'ASSmallDateTime)),

(33, 105,'94007005',CAST('2016-01-23 00:00:00'ASSmallDateTime), 220.0000, 220.0000, 0.0000, 3,CAST('2016-02-22 00:00:00'ASSmallDateTime),CAST('2016-02-26 00:00:00'ASSmallDateTime)),

(34, 123,'963253232',CAST('2016-01-23 00:00:00'ASSmallDateTime), 127.7500, 127.7500, 0.0000, 3,CAST('2016-02-22 00:00:00'ASSmallDateTime),CAST('2016-02-18 00:00:00'ASSmallDateTime)),

(35, 107,'RTR-72-3662-X',CAST('2016-01-25 00:00:00'ASSmallDateTime), 1600.0000, 1600.0000, 0.0000, 4,CAST('2016-03-04 00:00:00'ASSmallDateTime),CAST('2016-03-09 00:00:00'ASSmallDateTime)),

(36, 121,'97/465',CAST('2016-01-25 00:00:00'ASSmallDateTime), 565.1500, 565.1500, 0.0000, 3,CAST('2016-02-24 00:00:00'ASSmallDateTime),CAST('2016-02-24 00:00:00'ASSmallDateTime)),

(37, 123,'963253260',CAST('2016-01-25 00:00:00'ASSmallDateTime), 36.0000, 36.0000, 0.0000, 3,CAST('2016-02-24 00:00:00'ASSmallDateTime),CAST('2016-02-26 00:00:00'ASSmallDateTime)),

(38, 123,'963253272',CAST('2016-01-26 00:00:00'ASSmallDateTime), 61.5000, 61.5000, 0.0000, 3,CAST('2016-02-25 00:00:00'ASSmallDateTime),CAST('2016-02-28 00:00:00'ASSmallDateTime)),

(39, 110,'0-2058',CAST('2016-01-28 00:00:00'ASSmallDateTime), 37966.1900, 37966.1900, 0.0000, 3,CAST('2016-02-27 00:00:00'ASSmallDateTime),CAST('2016-02-28 00:00:00'ASSmallDateTime)),

(40, 121,'97/503',CAST('2016-01-30 00:00:00'ASSmallDateTime), 639.7700, 639.7700, 0.0000, 3,CAST('2016-02-28 00:00:00'ASSmallDateTime),CAST('2016-02-25 00:00:00'ASSmallDateTime)),

(41, 123,'963253255',CAST('2016-01-31 00:00:00'ASSmallDateTime), 53.7500, 53.7500, 0.0000, 3,CAST('2016-02-28 00:00:00'ASSmallDateTime),CAST('2016-02-27 00:00:00'ASSmallDateTime)),

(42, 123,'94007069',CAST('2016-01-31 00:00:00'ASSmallDateTime), 400.0000, 400.0000, 0.0000, 3,CAST('2016-02-28 00:00:00'ASSmallDateTime),CAST('2016-03-01 00:00:00'ASSmallDateTime)),

(43, 72,'40318',CAST('2016-02-01 00:00:00'ASSmallDateTime), 21842.0000, 21842.0000, 0.0000, 3,CAST('2016-03-01 00:00:00'ASSmallDateTime),CAST('2016-02-28 00:00:00'ASSmallDateTime)),

(44, 95,'111-92R-10094',CAST('2016-02-01 00:00:00'ASSmallDateTime), 19.6700, 19.6700, 0.0000, 2,CAST('2016-02-21 00:00:00'ASSmallDateTime),CAST('2016-02-24 00:00:00'ASSmallDateTime)),

(45, 122,'989319-437',CAST('2016-02-01 00:00:00'ASSmallDateTime), 2765.3600, 2765.3600, 0.0000, 3,CAST('2016-03-01 00:00:00'ASSmallDateTime),CAST('2016-02-28 00:00:00'ASSmallDateTime)),

(46, 37,'547481328',CAST('2016-02-03 00:00:00'ASSmallDateTime), 224.0000, 224.0000, 0.0000, 3,CAST('2016-03-03 00:00:00'ASSmallDateTime),CAST('2016-03-04 00:00:00'ASSmallDateTime)),

(47, 83,'31359783',CAST('2016-02-03 00:00:00'ASSmallDateTime), 1575.0000, 1575.0000, 0.0000, 2,CAST('2016-02-23 00:00:00'ASSmallDateTime),CAST('2016-02-21 00:00:00'ASSmallDateTime)),

(48, 123,'1-202-2978',CAST('2016-02-03 00:00:00'ASSmallDateTime), 33.0000, 33.0000, 0.0000, 3,CAST('2016-03-03 00:00:00'ASSmallDateTime),CAST('2016-03-05 00:00:00'ASSmallDateTime)),

(49, 95,'111-92R-10097',CAST('2016-02-04 00:00:00'ASSmallDateTime), 16.3300, 16.3300, 0.0000, 2,CAST('2016-02-24 00:00:00'ASSmallDateTime),CAST('2016-02-26 00:00:00'ASSmallDateTime)),

(50, 37,'547479217',CAST('2016-02-07 00:00:00'ASSmallDateTime), 116.0000, 116.0000, 0.0000, 3,CAST('2016-03-07 00:00:00'ASSmallDateTime),CAST('2016-03-07 00:00:00'ASSmallDateTime)),

(51, 122,'989319-477',CAST('2016-02-08 00:00:00'ASSmallDateTime), 2184.1100, 2184.1100, 0.0000, 3,CAST('2016-03-08 00:00:00'ASSmallDateTime),CAST('2016-03-08 00:00:00'ASSmallDateTime)),

(52, 34,'Q545443',CAST('2016-02-09 00:00:00'ASSmallDateTime), 1083.5800, 1083.5800, 0.0000, 1,CAST('2016-02-19 00:00:00'ASSmallDateTime),CAST('2016-02-23 00:00:00'ASSmallDateTime)),

(53, 95,'111-92R-10092',CAST('2016-02-09 00:00:00'ASSmallDateTime), 46.2100, 46.2100, 0.0000, 2,CAST('2016-02-28 00:00:00'ASSmallDateTime),CAST('2016-03-02 00:00:00'ASSmallDateTime)),

(54, 121,'97/553B',CAST('2016-02-10 00:00:00'ASSmallDateTime), 313.5500, 313.5500, 0.0000, 3,CAST('2016-03-10 00:00:00'ASSmallDateTime),CAST('2016-03-09 00:00:00'ASSmallDateTime)),

(55, 123,'963253245',CAST('2016-02-10 00:00:00'ASSmallDateTime), 40.7500, 40.7500, 0.0000, 3,CAST('2016-03-10 00:00:00'ASSmallDateTime),CAST('2016-03-12 00:00:00'ASSmallDateTime)),

(56, 86,'367447',CAST('2016-02-11 00:00:00'ASSmallDateTime), 2433.0000, 2433.0000, 0.0000, 1,CAST('2016-02-21 00:00:00'ASSmallDateTime),CAST('2016-02-17 00:00:00'ASSmallDateTime)),

(57, 103,'75C-90227',CAST('2016-02-11 00:00:00'ASSmallDateTime), 1367.5000, 1367.5000, 0.0000, 5,CAST('2016-03-31 00:00:00'ASSmallDateTime),CAST('2016-03-31 00:00:00'ASSmallDateTime)),

(58, 123,'963253256',CAST('2016-02-11 00:00:00'ASSmallDateTime), 53.2500, 53.2500, 0.0000, 3,CAST('2016-03-11 00:00:00'ASSmallDateTime),CAST('2016-03-07 00:00:00'ASSmallDateTime)),

(59, 123,'4-314-3057',CAST('2016-02-11 00:00:00'ASSmallDateTime), 13.7500, 13.7500, 0.0000, 3,CAST('2016-03-11 00:00:00'ASSmallDateTime),CAST('2016-03-15 00:00:00'ASSmallDateTime)),

(60, 122,'989319-497',CAST('2016-02-12 00:00:00'ASSmallDateTime), 2312.2000, 2312.2000, 0.0000, 3,CAST('2016-03-12 00:00:00'ASSmallDateTime),CAST('2016-03-09 00:00:00'ASSmallDateTime)),

(61, 115,'24946731',CAST('2016-02-15 00:00:00'ASSmallDateTime), 25.6700, 25.6700, 0.0000, 4,CAST('2016-03-25 00:00:00'ASSmallDateTime),CAST('2016-03-26 00:00:00'ASSmallDateTime)),

(62, 123,'963253269',CAST('2016-02-15 00:00:00'ASSmallDateTime), 26.7500, 26.7500, 0.0000, 3,CAST('2016-03-15 00:00:00'ASSmallDateTime),CAST('2016-03-11 00:00:00'ASSmallDateTime)),

(63, 122,'989319-427',CAST('2016-02-16 00:00:00'ASSmallDateTime), 2115.8100, 2115.8100, 0.0000, 3,CAST('2016-03-16 00:00:00'ASSmallDateTime),CAST('2016-03-19 00:00:00'ASSmallDateTime)),

(64, 123,'963253267',CAST('2016-02-17 00:00:00'ASSmallDateTime), 23.5000, 23.5000, 0.0000, 3,CAST('2016-03-17 00:00:00'ASSmallDateTime),CAST('2016-03-19 00:00:00'ASSmallDateTime)),

(65, 99,'509786',CAST('2016-02-18 00:00:00'ASSmallDateTime), 6940.2500, 6940.2500, 0.0000, 3,CAST('2016-03-18 00:00:00'ASSmallDateTime),CAST('2016-03-15 00:00:00'ASSmallDateTime)),

(66, 123,'263253253',CAST('2016-02-18 00:00:00'ASSmallDateTime), 31.9500, 31.9500, 0.0000, 3,CAST('2016-03-18 00:00:00'ASSmallDateTime),CAST('2016-03-21 00:00:00'ASSmallDateTime)),

(67, 122,'989319-487',CAST('2016-02-20 00:00:00'ASSmallDateTime), 1927.5400, 1927.5400, 0.0000, 3,CAST('2016-03-20 00:00:00'ASSmallDateTime),CAST('2016-03-18 00:00:00'ASSmallDateTime)),

(68, 81,'MABO1489',CAST('2016-02-21 00:00:00'ASSmallDateTime), 936.9300, 936.9300, 0.0000, 2,CAST('2016-03-11 00:00:00'ASSmallDateTime),CAST('2016-03-10 00:00:00'ASSmallDateTime)),

(69, 80,'133560',CAST('2016-02-22 00:00:00'ASSmallDateTime), 175.0000, 175.0000, 0.0000, 2,CAST('2016-03-12 00:00:00'ASSmallDateTime),CAST('2016-03-16 00:00:00'ASSmallDateTime)),

(70, 115,'24780512',CAST('2016-02-22 00:00:00'ASSmallDateTime), 6.0000, 6.0000, 0.0000, 4,CAST('2016-04-01 00:00:00'ASSmallDateTime),CAST('2016-03-29 00:00:00'ASSmallDateTime)),

(71, 123,'963253254',CAST('2016-02-22 00:00:00'ASSmallDateTime), 108.5000, 108.5000, 0.0000, 3,CAST('2016-03-22 00:00:00'ASSmallDateTime),CAST('2016-03-20 00:00:00'ASSmallDateTime)),

(72, 123,'43966316',CAST('2016-02-22 00:00:00'ASSmallDateTime), 10.0000, 10.0000, 0.0000, 3,CAST('2016-03-22 00:00:00'ASSmallDateTime),CAST('2016-03-17 00:00:00'ASSmallDateTime)),

(73, 114,'CBM9920-M-T77109',CAST('2016-02-23 00:00:00'ASSmallDateTime), 290.0000, 290.0000, 0.0000, 1,CAST('2016-03-03 00:00:00'ASSmallDateTime),CAST('2016-02-28 00:00:00'ASSmallDateTime)),

(74, 102,'109596',CAST('2016-02-24 00:00:00'ASSmallDateTime), 41.8000, 41.8000, 0.0000, 4,CAST('2016-04-03 00:00:00'ASSmallDateTime),CAST('2016-04-04 00:00:00'ASSmallDateTime)),

(75, 123,'7548906-20',CAST('2016-02-24 00:00:00'ASSmallDateTime), 27.0000, 27.0000, 0.0000, 3,CAST('2016-03-24 00:00:00'ASSmallDateTime),CAST('2016-03-24 00:00:00'ASSmallDateTime)),

(76, 123,'963253248',CAST('2016-02-24 00:00:00'ASSmallDateTime), 241.0000, 241.0000, 0.0000, 3,CAST('2016-03-24 00:00:00'ASSmallDateTime),CAST('2016-03-25 00:00:00'ASSmallDateTime)),

(77, 121,'97/553',CAST('2016-02-25 00:00:00'ASSmallDateTime), 904.1400, 904.1400, 0.0000, 3,CAST('2016-03-25 00:00:00'ASSmallDateTime),CAST('2016-03-25 00:00:00'ASSmallDateTime)),

(78, 121,'97/522',CAST('2016-02-28 00:00:00'ASSmallDateTime), 1962.1300, 1762.1300, 200.0000, 3,CAST('2016-03-28 00:00:00'ASSmallDateTime),CAST('2016-03-30 00:00:00'ASSmallDateTime)),

(79, 100,'587056',CAST('2016-02-28 00:00:00'ASSmallDateTime), 2184.5000, 2184.5000, 0.0000, 4,CAST('2016-04-09 00:00:00'ASSmallDateTime),CAST('2016-04-07 00:00:00'ASSmallDateTime)),

(80, 122,'989319-467',CAST('2016-03-01 00:00:00'ASSmallDateTime), 2318.0300, 2318.0300, 0.0000, 3,CAST('2016-03-31 00:00:00'ASSmallDateTime),CAST('2016-03-29 00:00:00'ASSmallDateTime)),

(81, 123,'263253265',CAST('2016-03-02 00:00:00'ASSmallDateTime), 26.2500, 26.2500, 0.0000, 3,CAST('2016-04-01 00:00:00'ASSmallDateTime),CAST('2016-03-28 00:00:00'ASSmallDateTime)),

(82, 94,'203339-13',CAST('2016-03-05 00:00:00'ASSmallDateTime), 17.5000, 17.5000, 0.0000, 2,CAST('2016-03-25 00:00:00'ASSmallDateTime),CAST('2016-03-27 00:00:00'ASSmallDateTime)),

(83, 95,'111-92R-10093',CAST('2016-03-06 00:00:00'ASSmallDateTime), 39.7700, 39.7700, 0.0000, 2,CAST('2016-03-26 00:00:00'ASSmallDateTime),CAST('2016-03-22 00:00:00'ASSmallDateTime)),

(84, 123,'963253258',CAST('2016-03-06 00:00:00'ASSmallDateTime), 111.0000, 111.0000, 0.0000, 3,CAST('2016-04-05 00:00:00'ASSmallDateTime),CAST('2016-04-05 00:00:00'ASSmallDateTime)),

(85, 123,'963253271',CAST('2016-03-07 00:00:00'ASSmallDateTime), 158.0000, 158.0000, 0.0000, 3,CAST('2016-04-06 00:00:00'ASSmallDateTime),CAST('2016-04-11 00:00:00'ASSmallDateTime)),

(86, 123,'963253230',CAST('2016-03-07 00:00:00'ASSmallDateTime), 739.2000, 739.2000, 0.0000, 3,CAST('2016-04-06 00:00:00'ASSmallDateTime),CAST('2016-04-06 00:00:00'ASSmallDateTime)),

(87, 123,'963253244',CAST('2016-03-08 00:00:00'ASSmallDateTime), 60.0000, 60.0000, 0.0000, 3,CAST('2016-04-07 00:00:00'ASSmallDateTime),CAST('2016-04-09 00:00:00'ASSmallDateTime)),

(88, 123,'963253239',CAST('2016-03-08 00:00:00'ASSmallDateTime), 147.2500, 147.2500, 0.0000, 3,CAST('2016-04-07 00:00:00'ASSmallDateTime),CAST('2016-04-11 00:00:00'ASSmallDateTime)),

(89, 72,'39104',CAST('2016-03-10 00:00:00'ASSmallDateTime), 85.3100, 0.0000, 0.0000, 3,CAST('2016-04-09 00:00:00'ASSmallDateTime),NULL),

(90, 123,'963253252',CAST('2016-03-12 00:00:00'ASSmallDateTime), 38.7500, 38.7500, 0.0000, 3,CAST('2016-04-11 00:00:00'ASSmallDateTime),CAST('2016-04-11 00:00:00'ASSmallDateTime)),

(91, 95,'111-92R-10095',CAST('2016-03-15 00:00:00'ASSmallDateTime), 32.7000, 32.7000, 0.0000, 2,CAST('2016-04-04 00:00:00'ASSmallDateTime),CAST('2016-04-06 00:00:00'ASSmallDateTime)),

(92, 117,'111897',CAST('2016-03-15 00:00:00'ASSmallDateTime), 16.6200, 16.6200, 0.0000, 3,CAST('2016-04-14 00:00:00'ASSmallDateTime),CAST('2016-04-14 00:00:00'ASSmallDateTime)),

(93, 123,'4-327-7357',CAST('2016-03-16 00:00:00'ASSmallDateTime), 162.7500, 162.7500, 0.0000, 3,CAST('2016-04-15 00:00:00'ASSmallDateTime),CAST('2016-04-11 00:00:00'ASSmallDateTime)),

(94, 123,'963253264',CAST('2016-03-18 00:00:00'ASSmallDateTime), 52.2500, 0.0000, 0.0000, 3,CAST('2016-04-17 00:00:00'ASSmallDateTime),NULL),

(95, 82,'C73-24',CAST('2016-03-19 00:00:00'ASSmallDateTime), 600.0000, 600.0000, 0.0000, 2,CAST('2016-04-08 00:00:00'ASSmallDateTime),CAST('2016-04-13 00:00:00'ASSmallDateTime)),

(96, 110,'P-0259',CAST('2016-03-19 00:00:00'ASSmallDateTime), 26881.4000, 26881.4000, 0.0000, 3,CAST('2016-04-18 00:00:00'ASSmallDateTime),CAST('2016-04-20 00:00:00'ASSmallDateTime)),

(97, 90,'97-1024A',CAST('2016-03-20 00:00:00'ASSmallDateTime), 356.4800, 356.4800, 0.0000, 2,CAST('2016-04-09 00:00:00'ASSmallDateTime),CAST('2016-04-07 00:00:00'ASSmallDateTime)),

(98, 83,'31361833',CAST('2016-03-21 00:00:00'ASSmallDateTime), 579.4200, 0.0000, 0.0000, 2,CAST('2016-04-10 00:00:00'ASSmallDateTime),NULL),

(99, 123,'263253268',CAST('2016-03-21 00:00:00'ASSmallDateTime), 59.9700, 0.0000, 0.0000, 3,CAST('2016-04-20 00:00:00'ASSmallDateTime),NULL),

(100, 123,'263253270',CAST('2016-03-22 00:00:00'ASSmallDateTime), 67.9200, 0.0000, 0.0000, 3,CAST('2016-04-21 00:00:00'ASSmallDateTime),NULL),

(101, 123,'263253273',CAST('2016-03-22 00:00:00'ASSmallDateTime), 30.7500, 0.0000, 0.0000, 3,CAST('2016-04-21 00:00:00'ASSmallDateTime),NULL),

(102, 110,'P-0608',CAST('2016-03-23 00:00:00'ASSmallDateTime), 20551.1800, 0.0000, 1200.0000, 3,CAST('2016-04-22 00:00:00'ASSmallDateTime),NULL),

(103, 122,'989319-417',CAST('2016-03-23 00:00:00'ASSmallDateTime), 2051.5900, 2051.5900, 0.0000, 3,CAST('2016-04-22 00:00:00'ASSmallDateTime),CAST('2016-04-24 00:00:00'ASSmallDateTime)),

(104, 123,'263253243',CAST('2016-03-23 00:00:00'ASSmallDateTime), 44.4400, 44.4400, 0.0000, 3,CAST('2016-04-22 00:00:00'ASSmallDateTime),CAST('2016-04-24 00:00:00'ASSmallDateTime)),

(105, 106,'9982771',CAST('2016-03-24 00:00:00'ASSmallDateTime), 503.2000, 0.0000, 0.0000, 3,CAST('2016-04-23 00:00:00'ASSmallDateTime),NULL),

(106, 110,'0-2060',CAST('2016-03-24 00:00:00'ASSmallDateTime), 23517.5800, 21221.6300, 2295.9500, 3,CAST('2016-04-23 00:00:00'ASSmallDateTime),CAST('2016-04-27 00:00:00'ASSmallDateTime)),

(107, 122,'989319-447',CAST('2016-03-24 00:00:00'ASSmallDateTime), 3689.9900, 3689.9900, 0.0000, 3,CAST('2016-04-23 00:00:00'ASSmallDateTime),CAST('2016-04-19 00:00:00'ASSmallDateTime)),

(108, 123,'963253240',CAST('2016-03-24 00:00:00'ASSmallDateTime), 67.0000, 67.0000, 0.0000, 3,CAST('2016-04-23 00:00:00'ASSmallDateTime),CAST('2016-04-23 00:00:00'ASSmallDateTime)),

(109, 121,'97/222',CAST('2016-03-25 00:00:00'ASSmallDateTime), 1000.4600, 1000.4600, 0.0000, 3,CAST('2016-04-24 00:00:00'ASSmallDateTime),CAST('2016-04-22 00:00:00'ASSmallDateTime)),

(110, 80,'134116',CAST('2016-03-28 00:00:00'ASSmallDateTime), 90.3600, 0.0000, 0.0000, 2,CAST('2016-04-17 00:00:00'ASSmallDateTime),NULL),

(111, 123,'263253257',CAST('2016-03-30 00:00:00'ASSmallDateTime), 22.5700, 22.5700, 0.0000, 3,CAST('2016-04-29 00:00:00'ASSmallDateTime),CAST('2016-05-03 00:00:00'ASSmallDateTime)),

(112, 110,'0-2436',CAST('2016-03-31 00:00:00'ASSmallDateTime), 10976.0600, 0.0000, 0.0000, 3,CAST('2016-04-30 00:00:00'ASSmallDateTime),NULL),

(113, 37,'547480102',CAST('2016-04-01 00:00:00'ASSmallDateTime), 224.0000, 0.0000, 0.0000, 3,CAST('2016-04-30 00:00:00'ASSmallDateTime),NULL),

(114, 123,'963253249',CAST('2016-04-02 00:00:00'ASSmallDateTime), 127.7500, 127.7500, 0.0000, 3,CAST('2016-05-01 00:00:00'ASSmallDateTime),CAST('2016-05-04 00:00:00'ASSmallDateTime))

SETIDENTITY_INSERT Invoices OFF

GO

SETIDENTITY_INSERT Terms ON

INSERT Terms(TermsID, TermsDescription, TermsDueDays)VALUES

(1,'Net due 10 days', 10),

(2,'Net due 20 days', 20),

(3,'Net due 30 days', 30),

(4,'Net due 60 days', 60),

(5,'Net due 90 days', 90)

SETIDENTITY_INSERT Terms OFF

GO

SETIDENTITY_INSERT Vendors ON

INSERT Vendors(VendorID, VendorName, VendorAddress1, VendorAddress2, VendorCity, VendorState, VendorZipCode, VendorPhone, VendorContactLName, VendorContactFName, DefaultTermsID, DefaultAccountNo)VALUES

(1,'US Postal Service','Attn: Supt. Window Services','PO Box 7005','Madison','WI','53707','(800) 555-1205','Alberto','Francesco', 1, 552),

(2,'National Information Data Ctr','PO Box 96621',NULL,'Washington','DC','20090','(301) 555-8950','Irvin','Ania', 3, 540),

(3,'Register of Copyrights','Library Of Congress',NULL,'Washington','DC','20559',NULL,'Liana','Lukas', 3, 403),

(4,'Jobtrak','1990 Westwood Blvd Ste 260',NULL,'Los Angeles','CA','90025','(800) 555-8725','Quinn','Kenzie', 3, 572),

(5,'Newbrige Book Clubs','3000 Cindel Drive',NULL,'Washington','NJ','07882','(800) 555-9980','Marks','Michelle', 4, 394),

(6,'California Chamber Of Commerce','3255 Ramos Cir',NULL,'Sacramento','CA','95827','(916) 555-6670','Mauro','Anton', 3, 572),

(7,'Towne Advertiser''s Mailing Svcs','Kevin Minder','3441 W Macarthur Blvd','Santa Ana','CA','92704',NULL,'Maegen','Ted', 3, 540),

(8,'BFI Industries','PO Box 9369',NULL,'Fresno','CA','93792','(559) 555-1551','Kaleigh','Erick', 3, 521),

(9,'Pacific Gas & Electric','Box 52001',NULL,'San Francisco','CA','94152','(800) 555-6081','Anthoni','Kaitlyn', 3, 521),

(10,'Robbins Mobile Lock And Key','4669 N Fresno',NULL,'Fresno','CA','93726','(559) 555-9375','Leigh','Bill', 2, 523),

(11,'Bill Marvin Electric Inc','4583 E Home',NULL,'Fresno','CA','93703','(559) 555-5106','Hostlery','Kaitlin', 2, 523),

(12,'City Of Fresno','PO Box 2069',NULL,'Fresno','CA','93718','(559) 555-9999','Mayte','Kendall', 3, 574),

(13,'Golden Eagle Insurance Co','PO Box 85826',NULL,'San Diego','CA','92186',NULL,'Blanca','Korah', 3, 590),

(14,'Expedata Inc','4420 N. First Street, Suite 108',NULL,'Fresno','CA','93726','(559) 555-9586','Quintin','Marvin', 3, 589),

(15,'ASC Signs','1528 N Sierra Vista',NULL,'Fresno','CA','93703',NULL,'Darien','Elisabeth', 1, 546),

(16,'Internal Revenue Service',NULL,NULL,'Fresno','CA','93888',NULL,'Aileen','Joan', 1, 235),

(17,'Blanchard & Johnson Associates','27371 Valderas',NULL,'Mission Viejo','CA','92691','(214) 555-3647','Keeton','Gonzalo', 3, 540),

(18,'Fresno Photoengraving Company','1952 "H" Street','P.O. Box 1952','Fresno','CA','93718','(559) 555-3005','Chaddick','Derek', 3, 403),

(19,'Crown Printing','1730 "H" St',NULL,'Fresno','CA','93721','(559) 555-7473','Randrup','Leann', 2, 400),

(20,'Diversified Printing & Pub','2632 Saturn St',NULL,'Brea','CA','92621','(714) 555-4541','Lane','Vanesa', 3, 400),

(21,'The Library Ltd','7700 Forsyth',NULL,'St Louis','MO','63105','(314) 555-8834','Marques','Malia', 3, 540),

(22,'Micro Center','1555 W Lane Ave',NULL,'Columbus','OH','43221','(614) 555-4435','Evan','Emily', 2, 160),

(23,'Yale Industrial Trucks-Fresno','3711 W Franklin',NULL,'Fresno','CA','93706','(559) 555-2993','Alexis','Alexandro', 3, 532),

(24,'Zee Medical Service Co','4221 W Sierra Madre #104',NULL,'Washington','IA','52353',NULL,'Hallie','Juliana', 3, 570),

(25,'California Data Marketing','2818 E Hamilton',NULL,'Fresno','CA','93721','(559) 555-3801','Jonessen','Moises', 4, 540),

(26,'Small Press','121 E Front St - 4th Floor',NULL,'Traverse City','MI','49684',NULL,'Colette','Dusty', 3, 540),

(27,'Rich Advertising','12 Daniel Road',NULL,'Fairfield','NJ','07004','(201) 555-9742','Neil','Ingrid', 3, 540),

(29,'Vision Envelope & Printing','PO Box 3100',NULL,'Gardena','CA','90247','(310) 555-7062','Raven','Jamari', 3, 551),

(30,'Costco','Fresno Warehouse','4500 W Shaw','Fresno','CA','93711',NULL,'Jaquan','Aaron', 3, 570),

(31,'Enterprise Communications Inc','1483 Chain Bridge Rd, Ste 202',NULL,'Mclean','VA','22101','(770) 555-9558','Lawrence','Eileen', 2, 536),

(32,'RR Bowker','PO Box 31',NULL,'East Brunswick','NJ','08810','(800) 555-8110','Essence','Marjorie', 3, 532),

(33,'Nielson','Ohio Valley Litho Division','Location #0470','Cincinnati','OH','45264',NULL,'Brooklynn','Keely', 2, 541),

(34,'IBM','PO Box 61000',NULL,'San Francisco','CA','94161','(800) 555-4426','Camron','Trentin', 1, 160),

(35,'Cal State Termite','PO Box 956',NULL,'Selma','CA','93662','(559) 555-1534','Hunter','Demetrius', 2, 523),

(36,'Graylift','PO Box 2808',NULL,'Fresno','CA','93745','(559) 555-6621','Sydney','Deangelo', 3, 532),

(37,'Blue Cross','PO Box 9061',NULL,'Oxnard','CA','93031','(800) 555-0912','Eliana','Nikolas', 3, 510),

(38,'Venture Communications Int''l','60 Madison Ave',NULL,'New York','NY','10010','(212) 555-4800','Neftaly','Thalia', 3, 540),

(39,'Custom Printing Company','PO Box 7028',NULL,'St Louis','MO','63177','(301) 555-1494','Myles','Harley', 3, 540),

(40,'Nat Assoc of College Stores','500 East Lorain Street',NULL,'Oberlin','OH','44074',NULL,'Bernard','Lucy', 3, 572),

(41,'Shields Design','415 E Olive Ave',NULL,'Fresno','CA','93728','(559) 555-8060','Kerry','Rowan', 2, 403),

(42,'Opamp Technical Books','1033 N Sycamore Ave.',NULL,'Los Angeles','CA','90038','(213) 555-4322','Paris','Gideon', 3, 572),

(43,'Capital Resource Credit','PO Box 39046',NULL,'Minneapolis','MN','55439','(612) 555-0057','Maxwell','Jayda', 3, 589),

(44,'Courier Companies, Inc','PO Box 5317',NULL,'Boston','MA','02206','(508) 555-6351','Antavius','Troy', 4, 400),

(45,'Naylor Publications Inc','PO Box 40513',NULL,'Jacksonville','FL','32231','(800) 555-6041','Gerald','Kristofer', 3, 572),

(46,'Open Horizons Publishing','Book Marketing Update','PO Box 205','Fairfield','IA','52556','(515) 555-6130','Damien','Deborah', 2, 540),

(47,'Baker & Taylor Books','Five Lakepointe Plaza, Ste 500','2709 Water Ridge Parkway','Charlotte','NC','28217','(704) 555-3500','Bernardo','Brittnee', 3, 572),

(48,'Fresno County Tax Collector','PO Box 1192',NULL,'Fresno','CA','93715','(559) 555-3482','Brenton','Kila', 3, 574),

(49,'Mcgraw Hill Companies','PO Box 87373',NULL,'Chicago','IL','60680','(614) 555-3663','Holbrooke','Rashad', 3, 572),

(50,'Publishers Weekly','Box 1979',NULL,'Marion','OH','43305','(800) 555-1669','Carrollton','Priscilla', 3, 572),

(51,'Blue Shield of California','PO Box 7021',NULL,'Anaheim','CA','92850','(415) 555-5103','Smith','Kylie', 3, 510),

(52,'Aztek Label','Accounts Payable','1150 N Tustin Ave','Anaheim','CA','92807','(714) 555-9000','Griffin','Brian', 3, 551),

(53,'Gary McKeighan Insurance','3649 W Beechwood Ave #101',NULL,'Fresno','CA','93711','(559) 555-2420','Jair','Caitlin', 3, 590),

(54,'Ph Photographic Services','2384 E Gettysburg',NULL,'Fresno','CA','93726','(559) 555-0765','Cheyenne','Kaylea', 3, 540),

(55,'Quality Education Data','PO Box 95857',NULL,'Chicago','IL','60694','(800) 555-5811','Misael','Kayle', 2, 540),

(56,'Springhouse Corp','PO Box 7247-7051',NULL,'Philadelphia','PA','19170','(215) 555-8700','Maeve','Clarence', 3, 523),

(57,'The Windows Deck','117 W Micheltorena Top Floor',NULL,'Santa Barbara','CA','93101','(800) 555-3353','Wood','Liam', 3, 536),

(58,'Fresno Rack & Shelving Inc','4718 N Bendel Ave',NULL,'Fresno','CA','93722',NULL,'Baylee','Dakota', 2, 523),

(59,'Publishers Marketing Assoc','627 Aviation Way',NULL,'Manhatttan Beach','CA','90266','(310) 555-2732','Walker','Jovon', 3, 572),

(60,'The Mailers Guide Co','PO Box 1550',NULL,'New Rochelle','NY','10802',NULL,'Lacy','Karina', 3, 540),

(61,'American Booksellers Assoc','828 S Broadway',NULL,'Tarrytown','NY','10591','(800) 555-0037','Angelica','Nashalie', 3, 574),

(62,'Cmg Information Services','PO Box 2283',NULL,'Boston','MA','02107','(508) 555-7000','Randall','Yash', 3, 540),

(63,'Lou Gentile''s Flower Basket','722 E Olive Ave',NULL,'Fresno','CA','93728','(559) 555-6643','Anum','Trisha', 1, 570),

(64,'Texaco','PO Box 6070',NULL,'Inglewood','CA','90312',NULL,'Oren','Grace', 3, 582),

(65,'The Drawing Board','PO Box 4758',NULL,'Carol Stream','IL','60197',NULL,'Mckayla','Jeffery', 2, 551),

(66,'Ascom Hasler Mailing Systems','PO Box 895',NULL,'Shelton','CT','06484',NULL,'Lewis','Darnell', 3, 532),

(67,'Bill Jones','Secretary Of State','PO Box 944230','Sacramento','CA','94244',NULL,'Deasia','Tristin', 3, 589),

(68,'Computer Library','3502 W Greenway #7',NULL,'Phoenix','AZ','85023','(602) 547-0331','Aryn','Leroy', 3, 540),

(69,'Frank E Wilber Co','2437 N Sunnyside',NULL,'Fresno','CA','93727','(559) 555-1881','Millerton','Johnathon', 3, 532),

(70,'Fresno Credit Bureau','PO Box 942',NULL,'Fresno','CA','93714','(559) 555-7900','Braydon','Anne', 2, 555),

(71,'The Fresno Bee','1626 E Street',NULL,'Fresno','CA','93786','(559) 555-4442','Colton','Leah', 2, 572),

(72,'Data Reproductions Corp','4545 Glenmeade Lane',NULL,'Auburn Hills','MI','48326','(810) 555-3700','Arodondo','Cesar', 3, 400),

(73,'Executive Office Products','353 E Shaw Ave',NULL,'Fresno','CA','93710','(559) 555-1704','Danielson','Rachael', 2, 570),

(74,'Leslie Company','PO Box 610',NULL,'Olathe','KS','66061','(800) 255-6210','Alondra','Zev', 3, 570),

(75,'Retirement Plan Consultants','6435 North Palm Ave, Ste 101',NULL,'Fresno','CA','93704','(559) 555-7070','Edgardo','Salina', 3, 589),

(76,'Simon Direct Inc','4 Cornwall Dr Ste 102',NULL,'East Brunswick','NJ','08816','(908) 555-7222','Bradlee','Daniel', 2, 540),

(77,'State Board Of Equalization','PO Box 942808',NULL,'Sacramento','CA','94208','(916) 555-4911','Dean','Julissa', 1, 631),

(78,'The Presort Center','1627 "E" Street',NULL,'Fresno','CA','93706','(559) 555-6151','Marissa','Kyle', 3, 540),

(79,'Valprint','PO Box 12332',NULL,'Fresno','CA','93777','(559) 555-3112','Warren','Quentin', 3, 551),

(80,'Cardinal Business Media, Inc.','P O Box 7247-7844',NULL,'Philadelphia','PA','19170','(215) 555-1500','Eulalia','Kelsey', 2, 540),

(81,'Wang Laboratories, Inc.','P.O. Box 21209',NULL,'Pasadena','CA','91185','(800) 555-0344','Kapil','Robert', 2, 160),

(82,'Reiter''s Scientific & Pro Books','2021 K Street Nw',NULL,'Washington','DC','20006','(202) 555-5561','Rodolfo','Carlee', 2, 572),

(83,'Ingram','PO Box 845361',NULL,'Dallas','TX','75284',NULL,'Yobani','Trey', 2, 541),

(84,'Boucher Communications Inc','1300 Virginia Dr. Ste 400',NULL,'Fort Washington','PA','19034','(215) 555-8000','Carson','Julian', 3, 540),

(85,'Champion Printing Company','3250 Spring Grove Ave',NULL,'Cincinnati','OH','45225','(800) 555-1957','Clifford','Jillian', 3, 540),

(86,'Computerworld','Department #1872','PO Box 61000','San Francisco','CA','94161','(617) 555-0700','Lloyd','Angel', 1, 572),

(87,'DMV Renewal','PO Box 942894',NULL,'Sacramento','CA','94294',NULL,'Josey','Lorena', 4, 568),

(88,'Edward Data Services','4775 E Miami River Rd',NULL,'Cleves','OH','45002','(513) 555-3043','Helena','Jeanette', 1, 540),

(89,'Evans Executone Inc','4918 Taylor Ct',NULL,'Turlock','CA','95380',NULL,'Royce','Hannah', 1, 522),

(90,'Wakefield Co','295 W Cromwell Ave Ste 106',NULL,'Fresno','CA','93711','(559) 555-4744','Rothman','Nathanael', 2, 170),

(91,'McKesson Water Products','P O Box 7126',NULL,'Pasadena','CA','91109','(800) 555-7009','Destin','Luciano', 2, 570),

(92,'Zip Print & Copy Center','PO Box 12332',NULL,'Fresno','CA','93777','(233) 555-6400','Javen','Justin', 2, 540),

(93,'AT&T','PO Box 78225',NULL,'Phoenix','AZ','85062',NULL,'Wesley','Alisha', 3, 522),

(94,'Abbey Office Furnishings','4150 W Shaw Ave',NULL,'Fresno','CA','93722','(559) 555-8300','Francis','Kyra', 2, 150),

(95,'Pacific Bell',NULL,NULL,'Sacramento','CA','95887','(209) 555-7500','Nickalus','Kurt', 2, 522),

(96,'Wells Fargo Bank','Business Mastercard','P.O. Box 29479','Phoenix','AZ','85038','(947) 555-3900','Damion','Mikayla', 2, 160),

(97,'Compuserve','Dept L-742',NULL,'Columbus','OH','43260','(614) 555-8600','Armando','Jan', 2, 572),

(98,'American Express','Box 0001',NULL,'Los Angeles','CA','90096','(800) 555-3344','Story','Kirsten', 2, 160),

(99,'Bertelsmann Industry Svcs. Inc','28210 N Avenue Stanford',NULL,'Valencia','CA','91355','(805) 555-0584','Potter','Lance', 3, 400),

(100,'Cahners Publishing Company','Citibank Lock Box 4026','8725 W Sahara Zone 1127','The Lake','NV','89163','(301) 555-2162','Jacobsen','Samuel', 4, 540),

(101,'California Business Machines','Gallery Plz','5091 N Fresno','Fresno','CA','93710','(559) 555-5570','Rohansen','Anders', 2, 170),