INSERT INTO "MSTR"."CITY_MDA" VALUES(0,10,40,40.105320,-85.680254,2,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(1,20,10,33.748995,-84.387982,3,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(2,30,21,42.358431,-71.059773,1,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(3,40,44,41.110777,-112.026054,7,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(4,50,7,41.763711,-72.685093,1,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(5,60,42,35.149534,-90.048980,5,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(6,70,9,25.788969,-80.226439,3,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(7,80,49,43.038903,-87.906474,4,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(8,90,18,29.951066,-90.071532,5,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(9,100,32,40.714353,-74.005973,1,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(10,110,3,33.448377,-112.074037,7,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(11,120,5,37.774930,-122.419416,6,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(12,130,5,37.339386,-121.894956,7,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(13,140,47,47.606210,-122.332071,6,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(14,150,51,38.895112,-77.036366,2,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(15,160,34,46.877186,-96.789803,4,1);
INSERT INTO "MSTR"."CITY_MDA" VALUES(16,502,0,40.416775,-3.703790,0,2);
INSERT INTO "MSTR"."CITY_MDA" VALUES(17,503,0,51.511214,-0.119824,0,3);
INSERT INTO "MSTR"."CITY_MDA" VALUES(18,504,0,45.764043,4.835659,0,4);
INSERT INTO "MSTR"."CITY_MDA" VALUES(19,505,0,52.519171,13.406091,0,5);
INSERT INTO "MSTR"."CITY_MDA" VALUES(20,506,0,37.983716,23.729310,0,6);
INSERT INTO "MSTR"."CITY_MDA" VALUES(21,507,0,51.924216,4.481776,0,7);
INSERT INTO "MSTR"."CITY_MDA" VALUES(22,508,0,50.850340,4.351710,0,8);
INSERT INTO "MSTR"."CITY_MDA" VALUES(23,509,0,41.892916,12.482520,0,9);
INSERT INTO "MSTR"."CITY_MDA" VALUES(24,510,0,48.208174,16.373819,0,10);
INSERT INTO "MSTR"."CITY_MDA" VALUES(25,511,0,59.913869,10.752245,0,11);

INSERT INTO "MSTR"."CITY_TXT" VALUES(0,10,'Anderson');
INSERT INTO "MSTR"."CITY_TXT" VALUES(1,20,'Atlanta');
INSERT INTO "MSTR"."CITY_TXT" VALUES(2,30,'Boston');
INSERT INTO "MSTR"."CITY_TXT" VALUES(3,40,'Clearfield');
INSERT INTO "MSTR"."CITY_TXT" VALUES(4,50,'Hartford');
INSERT INTO "MSTR"."CITY_TXT" VALUES(5,60,'Memphis');
INSERT INTO "MSTR"."CITY_TXT" VALUES(6,70,'Miami');
INSERT INTO "MSTR"."CITY_TXT" VALUES(7,80,'Milwaukee');
INSERT INTO "MSTR"."CITY_TXT" VALUES(8,90,'New Orleans');
INSERT INTO "MSTR"."CITY_TXT" VALUES(9,100,'New York');
INSERT INTO "MSTR"."CITY_TXT" VALUES(10,110,'Phoenix');
INSERT INTO "MSTR"."CITY_TXT" VALUES(11,120,'San Francisco');
INSERT INTO "MSTR"."CITY_TXT" VALUES(12,130,'San Jose');
INSERT INTO "MSTR"."CITY_TXT" VALUES(13,140,'Seattle');
INSERT INTO "MSTR"."CITY_TXT" VALUES(14,150,'Washington');
INSERT INTO "MSTR"."CITY_TXT" VALUES(15,160,'West Fargo');
INSERT INTO "MSTR"."CITY_TXT" VALUES(16,502,'Madrid');
INSERT INTO "MSTR"."CITY_TXT" VALUES(17,503,'London');
INSERT INTO "MSTR"."CITY_TXT" VALUES(18,504,'Paris');
INSERT INTO "MSTR"."CITY_TXT" VALUES(19,505,'Berlin');
INSERT INTO "MSTR"."CITY_TXT" VALUES(20,506,'Athens');
INSERT INTO "MSTR"."CITY_TXT" VALUES(21,507,'Rotterdam');
INSERT INTO "MSTR"."CITY_TXT" VALUES(22,508,'Brussels');
INSERT INTO "MSTR"."CITY_TXT" VALUES(23,509,'Rome');
INSERT INTO "MSTR"."CITY_TXT" VALUES(24,510,'Vienna');
INSERT INTO "MSTR"."CITY_TXT" VALUES(25,511,'Oslo');

INSERT INTO "MSTR"."STATE_TXT" VALUES(0,3,'Arizona'); 
INSERT INTO "MSTR"."STATE_TXT" VALUES(1,5,'California');
INSERT INTO "MSTR"."STATE_TXT" VALUES(2,7,'Connecticut');
INSERT INTO "MSTR"."STATE_TXT" VALUES(3,9,'Florida');
INSERT INTO "MSTR"."STATE_TXT" VALUES(4,10,'Georgia');
INSERT INTO "MSTR"."STATE_TXT" VALUES(5,18,'Louisiana');
INSERT INTO "MSTR"."STATE_TXT" VALUES(6,21,'Massachusetts');
INSERT INTO "MSTR"."STATE_TXT" VALUES(7,32,'New York');
INSERT INTO "MSTR"."STATE_TXT" VALUES(8,34,'North Dakota');
INSERT INTO "MSTR"."STATE_TXT" VALUES(9,40,'South Carolina');
INSERT INTO "MSTR"."STATE_TXT" VALUES(10,42,'Tennessee');
INSERT INTO "MSTR"."STATE_TXT" VALUES(11,44,'Utah');
INSERT INTO "MSTR"."STATE_TXT" VALUES(12,47,'Washington');
INSERT INTO "MSTR"."STATE_TXT" VALUES(13,49,'Wisconsin');
INSERT INTO "MSTR"."STATE_TXT" VALUES(14,51,'District of Columbia');

INSERT INTO "MSTR"."COUNTRY_TXT" VALUES(0,1,'USA');
INSERT INTO "MSTR"."COUNTRY_TXT" VALUES(1,2,'Spain');
INSERT INTO "MSTR"."COUNTRY_TXT" VALUES(2,3,'England');
INSERT INTO "MSTR"."COUNTRY_TXT" VALUES(3,4,'France');
INSERT INTO "MSTR"."COUNTRY_TXT" VALUES(4,5,'Germany');
INSERT INTO "MSTR"."COUNTRY_TXT" VALUES(5,6,'Greece');
INSERT INTO "MSTR"."COUNTRY_TXT" VALUES(6,7,'Netherlands');
INSERT INTO "MSTR"."COUNTRY_TXT" VALUES(7,8,'Belgium');
INSERT INTO "MSTR"."COUNTRY_TXT" VALUES(8,9,'Italy');
INSERT INTO "MSTR"."COUNTRY_TXT" VALUES(9,10,'Austria');
INSERT INTO "MSTR"."COUNTRY_TXT" VALUES(10,11,'Norway');

INSERT INTO "MSTR"."REGION_TXT" VALUES(0,1,'Northeast');
INSERT INTO "MSTR"."REGION_TXT" VALUES(1,2,'Mid-Atlantic');
INSERT INTO "MSTR"."REGION_TXT" VALUES(2,3,'Southeast');
INSERT INTO "MSTR"."REGION_TXT" VALUES(3,4,'Central');
INSERT INTO "MSTR"."REGION_TXT" VALUES(4,5,'South');
INSERT INTO "MSTR"."REGION_TXT" VALUES(5,6,'Northwest');
INSERT INTO "MSTR"."REGION_TXT" VALUES(6,7,'Southwest');

INSERT INTO "MSTR"."VENDOR_MDA" VALUES(0,101,502);
INSERT INTO "MSTR"."VENDOR_MDA" VALUES(1,102,503);
INSERT INTO "MSTR"."VENDOR_MDA" VALUES(2,103,504);
INSERT INTO "MSTR"."VENDOR_MDA" VALUES(3,104,505);
INSERT INTO "MSTR"."VENDOR_MDA" VALUES(4,105,506);
INSERT INTO "MSTR"."VENDOR_MDA" VALUES(5,106,507);
INSERT INTO "MSTR"."VENDOR_MDA" VALUES(6,107,508);
INSERT INTO "MSTR"."VENDOR_MDA" VALUES(7,108,509);
INSERT INTO "MSTR"."VENDOR_MDA" VALUES(8,109,510);
INSERT INTO "MSTR"."VENDOR_MDA" VALUES(9,110,511);

INSERT INTO "MSTR"."VENDOR_TXT" VALUES(0,101,'Mosca espanja');
INSERT INTO "MSTR"."VENDOR_TXT" VALUES(1,102,'Hammond & Rich ltd');
INSERT INTO "MSTR"."VENDOR_TXT" VALUES(2,103,'Allesen de Certains Entreprise');
INSERT INTO "MSTR"."VENDOR_TXT" VALUES(3,104,'Bratt und Seuhne');
INSERT INTO "MSTR"."VENDOR_TXT" VALUES(4,105,'Athens Specials');
INSERT INTO "MSTR"."VENDOR_TXT" VALUES(5,106,'S&J BV');
INSERT INTO "MSTR"."VENDOR_TXT" VALUES(6,107,'Lambic Brussels');
INSERT INTO "MSTR"."VENDOR_TXT" VALUES(7,108,'Berlusco e Figli');
INSERT INTO "MSTR"."VENDOR_TXT" VALUES(8,109,'Vienna Inc.');
INSERT INTO "MSTR"."VENDOR_TXT" VALUES(9,110,'Fira Kylling Satay');

INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(0,5,10);
INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(1,6,20);
INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(2,1,30);
INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(3,15,40);
INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(4,3,50);
INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(5,11,60);
INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(6,7,70);
INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(7,8,80);
INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(8,10,90);
INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(9,2,100);
INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(10,16,110);
INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(11,12,120);
INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(12,14,130);
INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(13,13,140);
INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(14,4,150);
INSERT INTO "MSTR"."PO_ORG_MDA" VALUES(15,9,160);

INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(0,1,'Purchase Organization Northeast 001');
INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(1,2,'Purchase Organization Northeast 002');
INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(2,3,'Purchase Organization Northeast 003');
INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(3,4,'Purchase Organization Mid-Atlantic 001');
INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(4,5,'Purchase Organization Mid-Atlantic 002');
INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(5,6,'Purchase Organization Southeast 001');
INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(6,7,'Purchase Organization Southeast 002');
INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(7,8,'Purchase Organization Central 001');
INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(8,9,'Purchase Organization Central 002');
INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(9,10,'Purchase Organization South 001');
INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(10,11,'Purchase Organization South 002');
INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(11,12,'Purchase Organization Northwest 001');
INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(12,13,'Purchase Organization Northwest 002');
INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(13,14,'Purchase Organization Southwest 001');
INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(14,15,'Purchase Organization Southwest 002');
INSERT INTO "MSTR"."PO_ORG_TXT" VALUES(15,16,'Purchase Organization Southwest 003');

INSERT INTO "MSTR"."MATCL_TXT" VALUES(0,11,'Art & Architecture');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(1,12,'Business');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(2,13,'Literature');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(3,14,'Books - Miscellaneous');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(4,15,'Science & Technology');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(5,16,'Sports & Health');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(6,21,'Audio Equipment');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(7,22,'Cameras');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(8,23,'Computers');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(9,24,'Electronics - Miscellaneous');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(10,25,'TV');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(11,26,'Video Equipment');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(12,31,'Action');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(13,32,'Comedy');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(14,33,'Drama');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(15,34,'Horror');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(16,35,'Kids / Family');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(17,36,'Special Interests');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(18,41,'Alternative');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(19,42,'Country');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(20,43,'Music - Miscellaneous');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(21,44,'Pop');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(22,45,'Rock');
INSERT INTO "MSTR"."MATCL_TXT" VALUES(23,46,'Soul / R&B');