/*
|| Script:  APInitialization.sql
|| Version: 11.1.0.6.0
|| Object:  Loads prototype Accounts Payable (AP) schema with test data
|| Author:  Jim Czuprynski (Fujitsu Consulting)
*/

-----
-- Deactivate constraints before table reloading
-----
ALTER TABLE ap.invoices 
    DISABLE CONSTRAINT invoices_vendor_fk;
ALTER TABLE ap.invoice_items 
    DISABLE CONSTRAINT invoice_items_invoice_fk;
TRUNCATE TABLE ap.invoice_items;
TRUNCATE TABLE ap.invoices;
TRUNCATE TABLE ap.vendors;

-----
-- Load test data into AP.VENDORS
-----
insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (101, 'Y', 'AT+T Corp.', '72 Firenze Street', 'Purley', 'United Kingdom', '376434449021748', 513291);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (102, 'Y', 'Inspiration Software', '475 Dushku', 'Colorado Springs', 'CO', 'USA', '372534433224561', 227134);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (103, 'Y', 'Data Company', '36 Herndon Road', 'Haverhill', 'United Kingdom', '373334665723469', 415898);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (104, 'Y', 'Nestle', '573 Media Drive', 'Kanata', 'Canada', '378233947121626', 260424);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (105, 'Y', 'Reckitt Benckiser', '10 Edmonton Blvd', 'Suite 100', 'Portland', 'ME', 'USA', '378433735921326', 432332);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (106, 'Y', 'Evergreen Resources', '80 Cesena Street', 'Carlsbad', 'CA', 'USA', '373833403124834', 105077);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (107, 'Y', 'Questar Capital', '78 Reilly Street', 'Banbury', 'United Kingdom', '376934280721694', 336060);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (108, 'Y', 'Conquest', '46 Dortmund Blvd', 'Delafield', 'WI', 'USA', '375234655021950', 373989);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (109, 'Y', 'Learning Voyage', '69 Dunst Road', 'Mount Laurel', 'NJ', 'USA', '378334289624106', 299626);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (110, 'Y', 'Connected', '76 Jackson Street', 'Waite Park', 'MN', 'USA', '378833541521936', 716173);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (111, 'Y', 'Lynk Systems', '56 Phillippe', 'Tours', 'France', '377133513224568', 425335);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (112, 'Y', 'Yum Brands', '49 Gilberto Road', 'Sao caetano do sul', 'Brazil', '378434349123812', 133840);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (113, 'Y', 'Oneida Financial', '33 Okayama Road', 'Research Triangle', 'NC', 'USA', '378933545924649', 252428);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (114, 'Y', 'Pyramid Digital Solutions', '98 Harriet Road', 'Ehningen', 'Germany', '376133556123129', 690585);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (115, 'Y', 'Progressive Medical', '81 Celia', 'San Jose', 'Costa Rica', '377534697124556', 684909);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (116, 'Y', 'American Pan and Engineering', '62nd Street', 'Verdun', 'Canada', '378733697424451', 92827);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (117, 'Y', 'Unicru', '19 Capshaw Drive', 'Nagoya', 'Japan', '372733830424993', 317152);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (118, 'Y', 'ComGlobal Systems', '998 Bedelia Street', 'Pusan-city', 'South Korea', '379534246521456', 135018);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (119, 'Y', 'Print-Tech', '51 Miles Street', 'Rochester', 'NY', 'USA', '376634868722405', 59525);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (120, 'Y', 'Miller Systems', '62 Suvari Road', 'Mendoza', 'Argentina', '375933896922553', 92369);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (121, 'Y', 'Intrasphere Technologies', '52 Durning Drive', 'Fort worth', 'TX', 'USA', '377133542224757', 108038);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (122, 'Y', 'Hencie', '3 Remar Road', 'Billerica', 'MA', 'USA', '377034903824533', 366566);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (123, 'Y', 'Urstadt Biddle Properties', '964 Pryce Street', 'Milton', 'Australia', '377034263722811', 525099);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (124, 'Y', 'Neogen', '83 Don Street', 'Flushing', 'NY', 'USA', '374333586923187', 454988);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (125, 'Y', 'Custom Solutions International', '85 Paltrow Road', 'Altstätten', 'Switzerland', '379533687021263', 307008);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (126, 'Y', 'Angie''s List', '28 Palminteri Ave', 'Kristiansand', 'Norway', '374234482622480', 716259);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (127, 'Y', 'Integrated Decisions and Systems', '86 Manu Ave', 'Building 10', 'Adelaide', 'Australia', '373634284023206', 440342);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (128, 'Y', 'Eastman Kodak Co.', '95 Page', 'Paris', 'France', '375934235623500', 372859);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (129, 'Y', 'Cold Stone Creamery', '918 Keith Street', 'Birmensdorf', 'Switzerland', '377134399823888', 583441);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (130, 'Y', 'Coadvantage Resources', '23rd Street', 'Media', 'PA', 'USA', '374234357323177', 411822);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (131, 'Y', 'Cowlitz Bancorp', '83 Cumming Road', 'São paulo', 'Brazil', '373534847324051', 643506);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (132, 'Y', 'Coca-Cola Co.', '49 Uggams Road', 'Itu', 'Brazil', '373934061222025', 738605);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (133, 'Y', 'Black Mountain Management', '56 Benjamin', 'Wellington', 'New Zealand', '374633169824561', 195004);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (134, 'Y', 'Schering-Plough Corp.', '6 Olyphant Ave', 'Tbilisi', 'Georgia', '377433987522529', 75500);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (135, 'Y', 'Walt Disney Co.', '26 Pusan Street', 'Helsingborg', 'Sweden', '375934025921083', 200700);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (136, 'Y', 'Wells Financial', '30 Sharp Street', 'Orlando', 'FL', 'USA', '377034135722429', 553776);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (137, 'Y', 'Palm Beach Tan', '16 Berry Street', 'Hunt Valley', 'MD', 'USA', '376734267322743', 746050);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (138, 'Y', 'J.C. Penney Corp.', '39 Osment Drive', 'Bradenton', 'FL', 'USA', '379433356522360', 320232);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (139, 'Y', 'Urstadt Biddle Properties', '90 Heiligenhaus', 'Sugar Hill', 'GA', 'USA', '379533500921109', 588562);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (140, 'Y', 'Flow Management Technologies', '56 Joshua', 'Concordville', 'PA', 'USA', '373933866621140', 660472);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (141, 'Y', 'Prosperity Bancshares', '12 Freddie Road', 'Lehi', 'UT', 'USA', '373134873122933', 368206);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (142, 'Y', '3t Systems', '178 Madeleine Drive', 'Grand-mere', 'Canada', '378034130324085', 442068);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (143, 'Y', 'Caliber Collision Centers', '4 Boyle Road', 'Chiba', 'Japan', '379534841721190', 440432);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (144, 'Y', 'Bio-Reference Labs', '91 Berry Street', 'Fairview Heights', 'IL', 'USA', '377833515823872', 214866);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (145, 'Y', 'Cima Consulting Group', '30 Rhames Road', 'Frankfurt am Main', 'Germany', '380134428223569', 304220);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (146, 'Y', 'Phoenix Rehabilitation and Health Services', '21 Ty Street', 'Salisbury', 'NC', 'USA', '379234184621620', 612978);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (147, 'Y', 'EPIQ Systems', '35 Cassel', 'Brentwood', 'TN', 'USA', '375534694622968', 727296);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (148, 'Y', 'IBM Corp.', '1 Trick Street', 'Soest', 'Netherlands', '378734444424972', 130674);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (149, 'Y', 'Advanced Vision Research', '83 Boothe', 'Suite 200', 'West Launceston', 'Australia', '376233927622489', 41544);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (150, 'Y', 'Lindin Consulting', '56 Bingham Farms Road', 'Anyang-si', 'South Korea', '377833138223331', 525405);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (151, 'Y', 'Comnet International', '24 Englund Road', 'Suite 200', 'Belgrad', 'Yugoslavia', '376434228023022', 176094);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (152, 'Y', 'Tripwire', '47 Darren', 'Almaty', 'Kazakstan', '377534921821984', 253301);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (153, 'Y', 'SafeHome Security', '38 Jonny Lee Drive', 'Birmingham', 'United Kingdom', '375634403521629', 621063);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (154, 'Y', 'E Group', '32 Rhea Road', 'Rothenburg', 'Germany', '376133826421299', 549687);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (155, 'Y', 'Direct Data', '8 Debra Road', 'Milano', 'Italy', '374634948421795', 446638);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (156, 'Y', 'GTS Refreshment Services', '31 Goteborg Road', 'Sursee', 'Switzerland', '375834911221414', 447548);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (157, 'Y', 'Educational Development', '82 Hatfield Street', 'Manaus', 'Brazil', '372733486423570', 557688);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (158, 'Y', 'America''s Choice Healthplans', '87 Voight Road', 'Nara', 'Japan', '375834343221582', 388628);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (159, 'Y', 'Visionary Systems', '72 Perez Road', 'Colombes', 'France', '374234188621332', 630498);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (160, 'Y', 'Partnership in Building', '23 Bryson Drive', 'Tilst', 'Denmark', '379834042322458', 435859);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (161, 'Y', 'FFLC Bancorp', '565 Gershon Road', 'Steyr', 'Austria', '375333375922692', 304084);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (162, 'Y', 'Staff Force', '69 Rich Drive', 'Sant Cugat Del Valle', 'Spain', '372433800524925', 296871);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (163, 'Y', 'Gap Inc.', '944 Hannah Street', 'Mclean', 'VA', 'USA', '373734939422108', 736384);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (164, 'Y', 'Serentec', '46 McNeice Ave', 'Milsons Point', 'Australia', '377834675824016', 615414);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (165, 'Y', 'StoneTech Professional', '51 Santa Cruz Road', 'Portland', 'ME', 'USA', '375234777922198', 400769);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (166, 'Y', 'Staff Force', '51st Street', 'Building 10', 'Ipswich', 'United Kingdom', '378633508922043', 410911);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (167, 'Y', 'ZonePerfect Nutrition Company', '62nd Street', 'Wehrheim', 'Germany', '379233670021049', 125907);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (168, 'Y', 'Prosoft Technology Group', '47 Lake Forest', 'Suite 101', 'Salisbury', 'NC', 'USA', '374933361522953', 459642);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (169, 'Y', 'May Department Stores Co.', '56 Vince Road', 'Echirolles', 'France', '379234564121140', 247483);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (170, 'Y', 'Solipsys', '97 Whitford Blvd', 'Charleston', 'TN', 'USA', '376333323521841', 336905);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (171, 'Y', 'Turner Professional Services', '60 Carlin Road', 'Vilafranca Penedes', 'Spain', '377933659623671', 85428);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (172, 'Y', 'Diamond Group', '651 El Segundo Drive', 'Paço de Arcos', 'Portugal', '373134471424236', 445827);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (173, 'Y', 'Montpelier Plastics', '30 Lisbon Drive', 'California', 'MD', 'USA', '378833532722472', 115500);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (174, 'Y', 'Tilson Landscape', '9 Taryn Drive', 'Utrecht', 'Netherlands', '379934270623147', 27385);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (175, 'Y', 'Elite Computers and Software', '11 Voight Blvd', 'Mito', 'Japan', '375833977924705', 136434);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (176, 'Y', 'Wal-Mart Stores', '30 Liv Street', 'Suwon-city', 'South Korea', '376333115723807', 82000);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (177, 'Y', 'MidAmerica Auto Glass', '39 Fiennes Street', 'Brossard', 'Canada', '375333466523234', 584569);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (178, 'Y', 'ORI Services', '261 Bragg Drive', 'Newton-le-willows', 'United Kingdom', '377733573422346', 452988);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (179, 'Y', 'Authoria', '100 Cesena Ave', 'Springville', 'CA', 'USA', '373733173223516', 130373);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (180, 'Y', 'Grant Harrison Advertising', '68 Neil Road', 'Ankara', 'Turkey', '377934357721870', 701039);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (181, 'Y', 'Cody-Kramer Imports', '68 Richie Ave', 'Joinville', 'Brazil', '377634001921656', 444972);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (182, 'Y', 'Coridian Technologies', '95 Wincott Blvd', 'Valencia', 'Spain', '380033930823978', 210494);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (183, 'Y', 'Prometheus Laboratories', '927 Colm Street', 'Birmensdorf', 'Switzerland', '373034599422004', 358256);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (184, 'Y', 'Peerless Manufacturing', '84 Solido Road', 'Burlington', 'Canada', '375934161621529', 302335);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (185, 'Y', 'Global Science and Technology', '272 Harriet', 'Hiroshima', 'Japan', '375434074824297', 140505);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (186, 'Y', 'Business Plus Corporation', '73 Knutsford Ave', 'Building 10', 'Itu', 'Brazil', '379834931922245', 340773);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (187, 'Y', 'Market-Based Solutions', '74 Bruxelles', 'Ankara', 'Turkey', '379833392921341', 690599);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (188, 'Y', 'Vertex Solutions', '571 Loveless Drive', 'Tartu', 'Estonia', '375534469621175', 667940);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (189, 'Y', 'Gold Crest Distributing', '445 Guy Ave', 'Solikamsk', 'Russia', '374733521123943', 130572);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (190, 'Y', 'American Service Systems', '99 Akita Street', 'Drogenbos', 'Belgium', '377433226724224', 303642);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (191, 'Y', 'Strategic Management Initiatives', '33 Juno Beach Ave', 'Ringwood', 'Australia', '372834347523532', 327204);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (192, 'Y', 'Liners Direct', '850 Connie', 'St Leonards', 'Australia', '377634440724486', 744767);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (193, 'Y', 'Sandy Spring Bancorp', '82 Geneva Street', 'Sarasota', 'FL', 'USA', '378934635822435', 665999);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (194, 'Y', 'RS Information Systems', '68 Liam Drive', 'Lake Forest', 'CA', 'USA', '374133871321694', 567911);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (195, 'Y', 'Evinco', '92nd Street', 'Radovljica', 'Slovenia', '379733108123566', 719943);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (196, 'Y', 'ScriptSave', '8 Goran Ave', 'North bethesda', 'MD', 'USA', '373734689624935', 419899);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (197, 'Y', 'Synhrgy HR Technologies', '23rd Street', 'Brossard', 'Canada', '380134491824399', 335130);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (198, 'Y', 'Unicru', '481 Botti Street', 'Eiksmarka', 'Norway', '376333204523112', 549994);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (199, 'Y', 'Cima Labs', '903 Hoskins Drive', 'Nagoya', 'Japan', '372534371722151', 713949);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (200, 'Y', 'SSCI', '8 Bette Ave', 'Rotterdam', 'Netherlands', '379334912821474', 705724);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (201, 'Y', 'Hospital Solutions', '23 Kurtz Blvd', 'O''fallon', 'IL', 'USA', '376834310723899', 593658);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (202, 'Y', 'Telechem International', '793 Rossellini Street', 'Mendoza', 'Argentina', '380034345924810', 108495);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (203, 'Y', 'Veri-Tek International', '91st Street', 'Nashua', 'NH', 'USA', '379234922523349', 162621);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (204, 'Y', 'Parksite', '895 Unger Street', 'Dortmund', 'Germany', '373433849124542', 362673);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (205, 'Y', 'Genghis Grill', '278 Mykelti Road', 'Los Angeles', 'CA', 'USA', '377533831321447', 636419);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (206, 'Y', 'Imports By Four Hands', '95 Marina Street', 'Lathrop', 'CA', 'USA', '375533694824328', 729281);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (207, 'Y', 'Extra Mile Transportation', '34 Macclesfield Blvd', 'Ebersberg', 'Germany', '374433557223728', 386344);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (208, 'Y', 'Greenwich Technology Partners', '56 Balin Street', 'Durban', 'South Africa', '375334634224722', 260007);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (209, 'Y', 'Arkidata', '88 Rodgers Road', 'Storrington', 'United Kingdom', '376333637921832', 670179);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (210, 'Y', 'Kia Motors Corp.', '11 Clarence Blvd', 'Newnan', 'GA', 'USA', '374233687923382', 565658);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (211, 'Y', 'Mission West Properties', '34 Reiner Street', 'Manaus', 'Brazil', '377334547321543', 302236);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (212, 'Y', 'Toyota Motor Corp.', '15 Geoffrey Road', 'Cesena', 'Italy', '376634956921266', 343546);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (213, 'Y', 'Black Mountain Management', '55 DiCaprio Blvd', 'Bracknell', 'United Kingdom', '375533342922873', 93576);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (214, 'Y', 'U.S. Government', '50 Thomas Street', 'Fuerth', 'Germany', '376134251323234', 473014);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (215, 'Y', 'Pacific Data Designs', '8 Nicolas Street', 'Stoneham', 'MA', 'USA', '375334721422833', 335833);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (216, 'Y', 'Miller Systems', '1 Raybon Street', 'Bingham Farms', 'MI', 'USA', '375133398023251', 620689);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (217, 'Y', 'Carteret Mortgage', '91st Street', 'Münster', 'Germany', '378034684624050', 100627);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (218, 'Y', 'American Vanguard', '6 Gloria Road', 'Suite 101', 'Alleroed', 'Denmark', '378834720222697', 116168);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (219, 'Y', 'ACS International Resources', '9 Lang Road', 'Key Biscayne', 'FL', 'USA', '379633560922588', 369185);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (220, 'Y', 'Glacier Bancorp', '87 Marietta Ave', 'Murray', 'UT', 'USA', '376734378521339', 393308);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (221, 'Y', 'White Wave', '4 Ellis Ave', 'Streamwood', 'IL', 'USA', '373634985321920', 492928);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (222, 'Y', 'Quicksilver Resources', '32 Elkins Park Blvd', 'Suite 200', 'Santa Clarita', 'CA', 'USA', '374934202822119', 692663);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (223, 'Y', 'Astute', '78 Curt Road', 'Office 99', 'Holderbank', 'Switzerland', '376533395624214', 171133);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (224, 'Y', 'Keller Williams Realty Ahwatukee Foothills', '33 Zahn Ave', 'Suite 100', 'Farmington Hills', 'MI', 'USA', '379234547623754', 375241);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (225, 'Y', 'WCI', '63rd Street', 'San Francisco', 'CA', 'USA', '372633433723143', 426351);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (226, 'Y', 'Caliber Collision Centers', '8 North Point Road', 'Summerside', 'Canada', '379134740124231', 235174);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (227, 'Y', 'FirstFed America Bancorp', '11 Sulzbach Road', 'Salisbury', 'NC', 'USA', '375734080523615', 398629);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (228, 'Y', 'Intrasphere Technologies', '13rd Street', 'Caguas', 'PR', 'USA', '376433252721861', 666044);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (229, 'Y', 'First South Bancorp', '904 Fountain Hills Ave', 'Blacksburg', 'VA', 'USA', '379634387223137', 337420);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (230, 'Y', 'SEI/Aaron''s', '62nd Street', 'Nordhausen', 'Germany', '376434836723520', 173674);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (231, 'Y', 'Denali Ventures', '99 Maura Street', 'Suite 200', 'Kloten', 'Switzerland', '377233734222434', 184279);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (232, 'Y', 'Capital Crossing Bank', '11 Eliza Road', 'Santa Clarita', 'CA', 'USA', '377133334321285', 488030);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (233, 'Y', 'Summit Energy', '733 Chesnutt Street', 'Suite 100', 'Eindhoven', 'Netherlands', '376733526924012', 529464);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (234, 'Y', 'Microsoft Corp.', '17 Ohita Street', 'Birmensdorf', 'Switzerland', '377633413723886', 563995);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (235, 'Y', 'Telwares Communications', '56 Tate Drive', 'Erpe-Mere', 'Belgium', '374133836623929', 556963);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (236, 'Y', 'Telechem International', '707 Lipnicki Ave', 'Gersthofen', 'Germany', '379734355623746', 314982);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (237, 'Y', 'Advanced Neuromodulation', '23 Sydney', 'Suite 100', 'Fountain Hills', 'AZ', 'USA', '374034534222000', 549879);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (238, 'Y', 'L.E.M. Products', '68 Stanton Blvd', 'Moscow', 'Russia', '379934286423082', 626670);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (239, 'Y', 'Commercial Energy of Montana', '73 Ifans Street', 'Hohenfels', 'Germany', '379633860223130', 464405);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (240, 'Y', 'WestNet Learning Technologies', '588 Varzea grande Road', 'San Jose', 'Costa Rica', '376233736522494', 206851);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (241, 'Y', 'Multimedia Live', '24 Bartlett Blvd', 'Annandale', 'PA', 'USA', '376433949624613', 137745);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (242, 'Y', 'MRE Consulting', '61 McBride Street', 'North Sydney', 'Australia', '379434138521693', 242956);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (243, 'Y', 'Adolph Coors Co.', '82 Maury Street', 'Mantova', 'Italy', '373534645622503', 415050);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (244, 'Y', 'Meritage Technologies', '76 Syracuse Road', 'Bellevue', 'NE', 'USA', '374333776324547', 462998);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (245, 'Y', 'Computer Engineering Organization', '30 McConaughey Road', 'Suite 101', 'Englewood Cliffs', 'NJ', 'USA', '379333718323056', 221492);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (246, 'Y', 'In Zone', '91 Nelligan Ave', 'Oulu', 'Finland', '372634580924631', 588144);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (247, 'Y', 'Montpelier Plastics', '66 Weisz Blvd', 'Plymouth Meeting', 'PA', 'USA', '372733369423931', 92042);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (248, 'Y', 'Greenwich Technology Partners', '96 Carnes Street', 'Gothenburg', 'Sweden', '376334915624332', 107271);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (249, 'Y', 'TeleSynthesis', '740 Cromwell Drive', 'Yogyakarta', 'Indonesia', '372933475824024', 417810);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (250, 'Y', 'Global Wireless Data', '41st Street', 'Spring Valley', 'NY', 'USA', '377334935122741', 533887);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (251, 'Y', 'SCI', '92 Stockholm Drive', 'Helsingborg', 'Sweden', '376933531021287', 545840);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (252, 'Y', 'Travizon', '25 Storrington Road', 'Suite 201', 'Encinitas', 'CA', 'USA', '375534236922165', 343811);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (253, 'Y', 'Lynk Systems', '971 Hayes Road', 'Herne', 'Germany', '377533883021372', 282257);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (254, 'Y', 'Progressive Medical', '43 Weisberg Road', 'Kungki', 'South Korea', '378833369223581', 280256);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (255, 'Y', 'Greyhawk North America', '92nd Street', 'Mechanicsburg', 'PA', 'USA', '375433761121016', 283276);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (256, 'Y', 'Laboratory Management Systems', '43 Curitiba Street', 'Farnham', 'United Kingdom', '377133791321782', 652779);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (257, 'Y', 'Fiberlink Communications', '83 Portsmouth Ave', 'Dortmund', 'Germany', '379334571023585', 256984);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (258, 'Y', 'Abatix', '25 Charlton Road', 'Valencia', 'CA', 'USA', '372433268322733', 314357);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (259, 'Y', 'Kmart Corp.', '29 Macht Drive', 'Pecs', 'Hungary', '375334119224752', 49069);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (260, 'Y', 'CapTech Ventures', '52 Berkoff Drive', 'Maintenon', 'France', '379934971221669', 303972);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (261, 'Y', 'Imaging Business Machines', '72 Assante Street', 'South Weber', 'UT', 'USA', '380133450522423', 256712);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (262, 'Y', 'Taycor Financial', '87 Ernie Street', 'Milton Keynes', 'United Kingdom', '377234551723280', 440505);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (263, 'Y', 'eCopy', '831 Houston Ave', 'Sao paulo', 'Brazil', '377533694422951', 356514);

insert into AP.VENDORS (VENDOR_ID, ACTIVE_IND, NAME, ADDRESS_LINE_1, CITY, STATE, COUNTRY, CREDIT_CARD, CREDIT_LIMIT)
values (264, 'Y', 'Biosite', '25 Ferraz  vasconcelos Drive', 'Lecanto', 'FL', 'USA', '378334362822401', 211729);

COMMIT;

ALTER TABLE ap.invoices 
    ENABLE CONSTRAINT invoices_vendor_fk;

-----
-- Load test data into AP.INVOICES AND AP.INVOICE_ITEMS
-----
@pkg_load_generator.spc;
@pkg_load_generator.bdy;

GRANT EXECUTE ON ap.pkg_load_generator TO ap_secured;

BEGIN
    ap.pkg_load_generator.RandomDML(25);
    COMMIT;
END;
/

ALTER TABLE ap.invoice_items 
    ENABLE CONSTRAINT invoice_items_invoice_fk;

BEGIN
    DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'ADMIN', cascade => TRUE);
    DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'AP', cascade => TRUE);
END;
/

-----
-- Create DBRControl directory object for storage of DBReplay client scripts
-----
DROP DIRECTORY DBRControl;
CREATE DIRECTORY DBRControl AS '/home/oracle/DBRControl';
GRANT READ, WRITE ON DIRECTORY DBRControl TO PUBLIC;