INSERT INTO northwind.customers (id, company, last_name, first_name, email_address, job_title, business_phone, home_phone, mobile_phone, fax_number, address, city, state_province, zip_postal_code, country_region, web_page, notes, attachments)
      SELECT 1,  'Company A' , 'Bedecs'           , 'Anna'      , NULL, 'Owner'                    , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 1st Street' , 'Seattle'       , 'WA', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 2,  'Company B' , 'Gratacos Solsona' , 'Antonio'   , NULL, 'Owner'                    , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 2nd Street' , 'Boston'        , 'MA', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 3,  'Company C' , 'Axen'             , 'Thomas'    , NULL, 'Purchasing Representative', '(123)555-0100', NULL, NULL, '(123)555-0101', '123 3rd Street' , 'Los Angelas'   , 'CA', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 4,  'Company D' , 'Lee'              , 'Christina' , NULL, 'Purchasing Manager'       , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 4th Street' , 'New York'      , 'NY', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 5,  'Company E' , 'O’Donnell'        , 'Martin'    , NULL, 'Owner'                    , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 5th Street' , 'Minneapolis'   , 'MN', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 6,  'Company F' , 'Pérez-Olaeta'     , 'Francisco' , NULL, 'Purchasing Manager'       , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 6th Street' , 'Milwaukee'     , 'WI', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 7,  'Company G' , 'Xie'              , 'Ming-Yang' , NULL, 'Owner'                    , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 7th Street' , 'Boise'         , 'ID', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 8,  'Company H' , 'Andersen'         , 'Elizabeth' , NULL, 'Purchasing Representative', '(123)555-0100', NULL, NULL, '(123)555-0101', '123 8th Street' , 'Portland'      , 'OR', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 9,  'Company I' , 'Mortensen'        , 'Sven'      , NULL, 'Purchasing Manager'       , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 9th Street' , 'Salt Lake City', 'UT', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 10, 'Company J' , 'Wacker'           , 'Roland'    , NULL, 'Purchasing Manager'       , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 10th Street', 'Chicago'       , 'IL', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 11, 'Company K' , 'Krschne'          , 'Peter'     , NULL, 'Purchasing Manager'       , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 11th Street', 'Miami'         , 'FL', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 12, 'Company L' , 'Edwards'          , 'John'      , NULL, 'Purchasing Manager'       , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 12th Street', 'Las Vegas'     , 'NV', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 13, 'Company M' , 'Ludick'           , 'Andre'     , NULL, 'Purchasing Representative', '(123)555-0100', NULL, NULL, '(123)555-0101', '456 13th Street', 'Memphis'       , 'TN', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 14, 'Company N' , 'Grilo'            , 'Carlos'    , NULL, 'Purchasing Representative', '(123)555-0100', NULL, NULL, '(123)555-0101', '456 14th Street', 'Denver'        , 'CO', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 15, 'Company O' , 'Kupkova'          , 'Helena'    , NULL, 'Purchasing Manager'       , '(123)555-0100', NULL, NULL, '(123)555-0101', '456 15th Street', 'Honolulu'      , 'HI', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 16, 'Company P' , 'Goldschmidt'      , 'Daniel'    , NULL, 'Purchasing Representative', '(123)555-0100', NULL, NULL, '(123)555-0101', '456 16th Street', 'San Francisco' , 'CA', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 17, 'Company Q' , 'Bagel'            , 'Jean Philippe', NULL, 'Owner'                 , '(123)555-0100', NULL, NULL, '(123)555-0101', '456 17th Street', 'Seattle'       , 'WA', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 18, 'Company R' , 'Autier Miconi'    , 'Catherine' , NULL, 'Purchasing Representative', '(123)555-0100', NULL, NULL, '(123)555-0101', '456 18th Street', 'Boston'        , 'MA', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 19, 'Company S' , 'Eggerer'          , 'Alexander' , NULL, 'Accounting Assistant'     , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 19th Street', 'Los Angelas'   , 'CA', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 20, 'Company T' , 'Li'               , 'George'    , NULL, 'Purchasing Manager'       , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 20th Street', 'New York'      , 'NY', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 21, 'Company U' , 'Tham'             , 'Bernard'   , NULL, 'Accounting Manager'       , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 21th Street', 'Minneapolis'   , 'MN', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 22, 'Company V' , 'Ramos'            , 'Luciana'   , NULL, 'Purchasing Assistant'     , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 22th Street', 'Milwaukee'     , 'WI', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 23, 'Company W' , 'Entin'            , 'Michael'   , NULL, 'Purchasing Manager'       , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 23th Street', 'Portland'      , 'OR', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 24, 'Company X' , 'Hasselberg'       , 'Jonas'     , NULL, 'Owner'                    , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 24th Street', 'Salt Lake City', 'UT', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 25, 'Company Y' , 'Rodman'           , 'John'      , NULL, 'Purchasing Manager'       , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 25th Street', 'Chicago'       , 'IL', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 26, 'Company Z' , 'Liu'              , 'Run'       , NULL, 'Accounting Assistant'     , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 26th Street', 'Miami'         , 'FL', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 27, 'Company AA', 'Toh'              , 'Karen'     , NULL, 'Purchasing Manager'       , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 27th Street', 'Las Vegas'     , 'NV', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 28, 'Company BB', 'Raghav'           , 'Amritansh' , NULL, 'Purchasing Manager'       , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 28th Street', 'Memphis'       , 'TN', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 29, 'Company CC', 'Lee'              , 'Soo Jung'  , NULL, 'Purchasing Manager'       , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 29th Street', 'Denver'        , 'CO', '99999', 'USA', NULL, NULL, '' FROM dual;

/* 'employees' */
INSERT INTO northwind.employees (id, company, last_name, first_name, email_address, job_title, business_phone, home_phone, mobile_phone, fax_number, address, city, state_province, zip_postal_code, country_region, web_page, notes, attachments) 
      SELECT 1, 'Northwind Traders', 'Freehafer', 'Nancy'  , 'nancy@northwindtraders.com'  , 'Sales Representative' , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 1st Avenue', 'Seattle' , 'WA', '99999', 'USA', '#http://northwindtraders.com#', NULL, '' FROM dual UNION ALL 
     SELECT 2, 'Northwind Traders', 'Cencini'  , 'Andrew' , 'andrew@northwindtraders.com' , 'Vice President, Sales', '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 2nd Avenue', 'Bellevue', 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', 'Joined the company as a sales representative, was promoted to sales manager and was then named vice president of sales.', '' FROM dual UNION ALL 
     SELECT 3, 'Northwind Traders', 'Kotas'    , 'Jan'    , 'jan@northwindtraders.com'    , 'Sales Representative' , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 3rd Avenue', 'Redmond' , 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', 'Was hired as a sales associate and was promoted to sales representative.', '' FROM dual UNION ALL 
     SELECT 4, 'Northwind Traders', 'Sergienko', 'Mariya' , 'mariya@northwindtraders.com' , 'Sales Representative' , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 4th Avenue', 'Kirkland', 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', NULL, '' FROM dual UNION ALL 
     SELECT 5, 'Northwind Traders', 'Thorpe'   , 'Steven' , 'steven@northwindtraders.com' , 'Sales Manager'        , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 5th Avenue', 'Seattle' , 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', 'Joined the company as a sales representative and was promoted to sales manager.  Fluent in French.', '' FROM dual UNION ALL 
     SELECT 6, 'Northwind Traders', 'Neipper'  , 'Michael', 'michael@northwindtraders.com', 'Sales Representative' , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 6th Avenue', 'Redmond' , 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', 'Fluent in Japanese and can read and write French, Portuguese, and Spanish.', '' FROM dual UNION ALL 
     SELECT 7, 'Northwind Traders', 'Zare'     , 'Robert' , 'robert@northwindtraders.com' , 'Sales Representative' , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 7th Avenue', 'Seattle' , 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', NULL, '' FROM dual UNION ALL 
     SELECT 8, 'Northwind Traders', 'Giussani' , 'Laura'  , 'laura@northwindtraders.com'  , 'Sales Coordinator'    , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 8th Avenue', 'Redmond' , 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', 'Reads and writes French.', '' FROM dual UNION ALL 
     SELECT 9, 'Northwind Traders', 'Hellung-Larsen', 'Anne', 'anne@northwindtraders.com' , 'Sales Representative' , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 9th Avenue', 'Seattle' , 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', 'Fluent in French and German.', '' FROM dual;

/* products */
INSERT INTO northwind.products (supplier_ids, id, product_code, product_name, description, standard_cost, list_price, reorder_level, target_level, quantity_per_unit, discontinued, minimum_reorder_quantity, category, attachments) 
      SELECT '4' , 1 , 'NWTB-1'   , 'Northwind Traders Chai'              , NULL, 13.50, 18   , 10 , 40 , '10 boxes x 20 bags' , 0, 10  , 'Beverages' , '' FROM dual UNION ALL 
     SELECT '10', 3 , 'NWTCO-3'  , 'Northwind Traders Syrup'             , NULL, 7.50 , 10   , 25 , 100, '12 - 550 ml bottles', 0, 25  , 'Condiments', '' FROM dual UNION ALL 
     SELECT '10', 4 , 'NWTCO-4'  , 'Northwind Traders Cajun Seasoning'   , NULL, 16.5 , 22   , 10 , 40 , '48 - 6 oz jars'     , 0, 10  , 'Condiments', '' FROM dual UNION ALL 
     SELECT '10', 5 , 'NWTO-5'   , 'Northwind Traders Olive Oil'         , NULL, 16.25, 21.35, 10 , 40 , '36 boxes'           , 0, 10  , 'Oil'       , '' FROM dual UNION ALL 
     SELECT '26', 6 , 'NWTJP-6'  , 'Northwind Traders Boysenberry Spread', NULL, 18.75, 25   , 25 , 100, '12 - 8 oz jars'     , 0, 25  , 'Jams, Preserves', '' FROM dual UNION ALL 
     SELECT '2' , 7 , 'NWTDFN-7' , 'Northwind Traders Dried Pears'       , NULL, 22.50, 30   , 10 , 40 , '12 - 1 lb pkgs.'    , 0, 10  , 'Dried Fruit & Nuts', '' FROM dual UNION ALL 
     SELECT '8' , 8 , 'NWTS-8'   , 'Northwind Traders Curry Sauce'       , NULL, 30   , 40   , 10 , 40 , '12 - 12 oz jars'    , 0, 10  , 'Sauces'    , '' FROM dual UNION ALL 
     SELECT '26', 14, 'NWTDFN-14', 'Northwind Traders Walnuts'           , NULL, 17.75, 23.25, 10 , 40 , '40 - 100 g pkgs.'   , 0, 10  , 'Dried Fruit & Nuts', '' FROM dual UNION ALL 
     SELECT '6' , 17, 'NWTCFV-17', 'Northwind Traders Fruit Cocktail'    , NULL, 29.25, 39   , 10 , 40 , '15.25 OZ'           , 0, 10  , 'Canned Fruit & Vegetables', '' FROM dual UNION ALL 
     SELECT '1' , 19, 'NWTBGM-19', 'Northwind Traders Chocolate Biscuits Mix', NULL, 6, 9.20 , 5  , 20 , '10 boxes x 12 pieces', 0, 5  , 'Baked Goods & Mixes', '' FROM dual UNION ALL 
     SELECT '26', 20, 'NWTJP-6'  , 'Northwind Traders Marmalade'         , NULL, 60.75, 81   , 10 , 40 , '30 gift boxes'      , 0, 10  , 'Jams, Preserves', '' FROM dual UNION ALL 
     SELECT '1' , 21, 'NWTBGM-21', 'Northwind Traders Scones'            , NULL, 7.50 , 10   , 5  , 20 , '24 pkgs. x 4 pieces', 0, 5   , 'Baked Goods & Mixes', '' FROM dual UNION ALL 
     SELECT '4' , 34, 'NWTB-34'  , 'Northwind Traders Beer'              , NULL, 10.50, 14   , 15 , 60 , '24 - 12 oz bottles' , 0, 15  , 'Beverages', '' FROM dual UNION ALL 
     SELECT '7' , 40, 'NWTCM-40' , 'Northwind Traders Crab Meat'         , NULL, 13.80, 18.40, 30 , 120, '24 - 4 oz tins'     , 0, 30  , 'Canned Meat', '' FROM dual UNION ALL 
     SELECT '6' , 41, 'NWTSO-41' , 'Northwind Traders Clam Chowder'      , NULL, 7.75 , 9.65 , 10 , 40 , '12 - 12 oz cans'    , 0, 10  , 'Soups', '' FROM dual UNION ALL 
     SELECT '34', 43, 'NWTB-43'  , 'Northwind Traders Coffee'            , NULL, 34.50, 46   , 25 , 100, '16 - 500 g tins'    , 0, 25  , 'Beverages', '' FROM dual UNION ALL 
     SELECT '10', 48, 'NWTCA-48' , 'Northwind Traders Chocolate'         , NULL, 9.25 , 12.75, 25 , 100, '10 pkgs'            , 0, 25  , 'Candy', '' FROM dual UNION ALL 
     SELECT '2' , 51, 'NWTDFN-51', 'Northwind Traders Dried Apples'      , NULL, 39.75, 53   , 10 , 40 , '50 - 300 g pkgs.'   , 0, 10  , 'Dried Fruit & Nuts', '' FROM dual UNION ALL 
     SELECT '1' , 52, 'NWTG-52'  , 'Northwind Traders Long Grain Rice'   , NULL, 5.25 , 7    , 25 , 100, '16 - 2 kg boxes'    , 0, 25  , 'Grains', '' FROM dual UNION ALL 
     SELECT '1' , 56, 'NWTP-56'  , 'Northwind Traders Gnocchi'           , NULL, 28.50, 38   , 30 , 120, '24 - 250 g pkgs.'   , 0, 30  , 'Pasta', '' FROM dual UNION ALL 
     SELECT '1' , 57, 'NWTP-57'  , 'Northwind Traders Ravioli'           , NULL, 14.25, 19.50, 20 , 80 , '24 - 250 g pkgs.'   , 0, 20  , 'Pasta', '' FROM dual UNION ALL 
     SELECT '8' , 65, 'NWTS-65'  , 'Northwind Traders Hot Pepper Sauce'  , NULL, 15.75, 21.05, 10 , 40 , '32 - 8 oz bottles'  , 0, 10  , 'Sauces', '' FROM dual UNION ALL 
     SELECT '8' , 66, 'NWTS-66'  , 'Northwind Traders Tomato Sauce'      , NULL, 12.75, 17   , 20 , 80 , '24 - 8 oz jars'     , 0, 20  , 'Sauces', '' FROM dual UNION ALL 
     SELECT '5' , 72, 'NWTD-72'  , 'Northwind Traders Mozzarella'        , NULL, 26.10, 34.8 , 10 , 40 , '24 - 200 g pkgs.'   , 0, 10  , 'Dairy products', '' FROM dual UNION ALL 
     SELECT '26', 74, 'NWTDFN-74', 'Northwind Traders Almonds'           , NULL, 7.50 , 10   , 5  , 20 , '5 kg pkg.'          , 0, 5   , 'Dried Fruit & Nuts', '' FROM dual UNION ALL 
     SELECT '10', 77, 'NWTCO-77' , 'Northwind Traders Mustard'           , NULL, 9.75 , 13   , 15 , 60 , '12 boxes'           , 0, 15  , 'Condiments', '' FROM dual UNION ALL 
     SELECT '2' , 80, 'NWTDFN-80', 'Northwind Traders Dried Plums'       , NULL, 3    , 3.50 , 50 , 75 , '1 lb bag'           , 0, 25  , 'Dried Fruit & Nuts', '' FROM dual UNION ALL 
     SELECT '3' , 81, 'NWTB-81'  , 'Northwind Traders Green Tea'         , NULL, 2    , 2.99 , 100, 125, '20 bags per box'    , 0, 25  , 'Beverages', '' FROM dual UNION ALL 
     SELECT '1' , 82, 'NWTC-82'  , 'Northwind Traders Granola'           , NULL, 2    , 4    , 20 , 100, NULL                 , 0, NULL, 'Cereal', '' FROM dual UNION ALL 
     SELECT '9' , 83, 'NWTCS-83' , 'Northwind Traders Potato Chips'      , NULL, .50  , 1.80 , 30 , 200, NULL                 , 0, NULL, 'Chips, Snacks', '' FROM dual UNION ALL 
     SELECT '1' , 85, 'NWTBGM-85', 'Northwind Traders Brownie Mix'       , NULL, 9    , 12.49, 10 , 20 , '3 boxes'            , 0, 5   , 'Baked Goods & Mixes', '' FROM dual UNION ALL 
     SELECT '1' , 86, 'NWTBGM-86', 'Northwind Traders Cake Mix'          , NULL, 10.50, 15.99, 10 , 20 , '4 boxes'            , 0, 5   , 'Baked Goods & Mixes', '' FROM dual UNION ALL 
     SELECT '7' , 87, 'NWTB-87'  , 'Northwind Traders Tea'               , NULL, 2    , 40   , 20 , 50 , '100 count per box'  , 0, NULL, 'Beverages', '' FROM dual UNION ALL 
     SELECT '6' , 88, 'NWTCFV-88', 'Northwind Traders Pears'             , NULL, 1    , 1.3  , 10 , 40 , '15.25 OZ'           , 0, NULL, 'Canned Fruit & Vegetables', '' FROM dual UNION ALL 
     SELECT '6' , 89, 'NWTCFV-89', 'Northwind Traders Peaches'           , NULL, 1    , 1.5  , 10 , 40 , '15.25 OZ'           , 0, NULL, 'Canned Fruit & Vegetables', '' FROM dual UNION ALL 
     SELECT '6' , 90, 'NWTCFV-90', 'Northwind Traders Pineapple'         , NULL, 1    , 1.8  , 10 , 40 , '15.25 OZ'           , 0, NULL, 'Canned Fruit & Vegetables', '' FROM dual UNION ALL 
     SELECT '6' , 91, 'NWTCFV-91', 'Northwind Traders Cherry Pie Filling', NULL, 1    , 2    , 10 , 40 , '15.25 OZ'           , 0, NULL, 'Canned Fruit & Vegetables', '' FROM dual UNION ALL 
     SELECT '6' , 92, 'NWTCFV-92', 'Northwind Traders Green Beans'       , NULL, 1    , 1.20 , 10 , 40 , '14.5 OZ'            , 0, NULL, 'Canned Fruit & Vegetables', '' FROM dual UNION ALL 
     SELECT '6' , 93, 'NWTCFV-93', 'Northwind Traders Corn'              , NULL, 1    , 1.20 , 10 , 40 , '14.5 OZ'            , 0, NULL, 'Canned Fruit & Vegetables', '' FROM dual UNION ALL 
     SELECT '6' , 94, 'NWTCFV-94', 'Northwind Traders Peas'              , NULL, 1    , 1.50 , 10 , 40 , '14.5 OZ'            , 0, NULL, 'Canned Fruit & Vegetables', '' FROM dual UNION ALL 
     SELECT '7' , 95, 'NWTCM-95' , 'Northwind Traders Tuna Fish'         , NULL, .50  , 2    , 30 , 50 , '5 oz'               , 0, NULL, 'Canned Meat', '' FROM dual UNION ALL 
     SELECT '7' , 96, 'NWTCM-96' , 'Northwind Traders Smoked Salmon'     , NULL, 2    , 4    , 30 , 50 , '5 oz'               , 0, NULL, 'Canned Meat', '' FROM dual UNION ALL 
     SELECT '1' , 97, 'NWTC-82'  , 'Northwind Traders Hot Cereal'        , NULL, 3    , 5    , 50 , 200, NULL                 , 0, NULL, 'Cereal', '' FROM dual UNION ALL 
     SELECT '6' , 98, 'NWTSO-98' , 'Northwind Traders Vegetable Soup'    , NULL, 1    , 1.89 , 100, 200, NULL                 , 0, NULL, 'Soups', '' FROM dual UNION ALL 
     SELECT '6' , 99, 'NWTSO-99' , 'Northwind Traders Chicken Soup'      , NULL, 1    , 1.95 , 100, 200, NULL                 , 0, NULL, 'Soups', '' FROM dual;

/* suppliers */
INSERT INTO northwind.suppliers (id, company, last_name, first_name, email_address, job_title, business_phone, home_phone, mobile_phone, fax_number, address, city, state_province, zip_postal_code, country_region, web_page, notes, attachments) 
      SELECT 1, 'Supplier A', 'Andersen'  , 'Elizabeth A.'  , NULL, 'Sales Manager'       , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL 
     SELECT 2, 'Supplier B', 'Weiler'    , 'Cornelia'      , NULL, 'Sales Manager'       , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL 
     SELECT 3, 'Supplier C', 'Kelley'    , 'Madeleine'     , NULL, 'Sales Representative', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL 
     SELECT 4, 'Supplier D', 'Sato'      , 'Naoki'         , NULL, 'Marketing Manager'   , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL 
     SELECT 5, 'Supplier E', 'Hernandez-Echevarria','Amaya', NULL, 'Sales Manager'       , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL 
     SELECT 6, 'Supplier F', 'Hayakawa'  , 'Satomi'        , NULL, 'Marketing Assistant' , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL 
     SELECT 7, 'Supplier G', 'Glasson'   , 'Stuart'        , NULL, 'Marketing Manager'   , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL 
     SELECT 8, 'Supplier H', 'Dunton'    , 'Bryn Paul'     , NULL, 'Sales Representative', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL 
     SELECT 9, 'Supplier I', 'Sandberg'  , 'Mikael'        , NULL, 'Sales Manager'       , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL 
     SELECT 10,'Supplier J', 'Sousa'     , 'Luis'          , NULL, 'Sales Manager'       , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual;

/* shippers */
INSERT INTO northwind.shippers (id, company, last_name, first_name, email_address, job_title, business_phone, home_phone, mobile_phone, fax_number, address, city, state_province, zip_postal_code, country_region, web_page, notes, attachments) 
      SELECT 1, 'Shipping Company A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123 Any Street', 'Memphis', 'TN', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 2, 'Shipping Company B', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123 Any Street', 'Memphis', 'TN', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL 
     SELECT 3, 'Shipping Company C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123 Any Street', 'Memphis', 'TN', '99999', 'USA', NULL, NULL, '' FROM dual;

/* inventory_transaction_types */
INSERT INTO northwind.inventory_transaction_types (id, type_name) 
     SELECT 1, 'Purchased' FROM dual UNION ALL 
     SELECT 2, 'Sold' FROM dual UNION ALL 
     SELECT 3, 'On Hold' FROM dual UNION ALL 
     SELECT 4, 'Waste' FROM dual;

/* order_details_status - None, Allocated, Invoiced,Shipped, On Order, No Stock */
INSERT INTO northwind.order_details_status (id, status_name) 
      SELECT 0, 'None' FROM dual UNION ALL 
     SELECT 1, 'Allocated' FROM dual UNION ALL 
     SELECT 2, 'Invoiced' FROM dual UNION ALL 
     SELECT 3, 'Shipped' FROM dual UNION ALL 
     SELECT 4, 'On Order' FROM dual UNION ALL 
     SELECT 5, 'No Stock' FROM dual;

/* orders_status' - New, Invoiced, Shipped, Closed */
INSERT INTO northwind.orders_status (id, status_name) 
      SELECT 0, 'New' FROM dual UNION ALL 
     SELECT 1, 'Invoiced' FROM dual UNION ALL 
     SELECT 2, 'Shipped' FROM dual UNION ALL 
     SELECT 3, 'Closed' FROM dual;

/* orders_tax_status */
INSERT INTO northwind.orders_tax_status (id, tax_status_name) 
      SELECT 0, 'Tax Exempt' FROM dual UNION ALL 
     SELECT 1, 'Taxable' FROM dual;

/* purchase_order_status */
INSERT INTO northwind.purchase_order_status (id, status) 
      SELECT 0, 'New' FROM dual UNION ALL 
     SELECT 1, 'Submitted' FROM dual UNION ALL 
     SELECT 2, 'Approved' FROM dual UNION ALL 
     SELECT 3, 'Closed' FROM dual;

/* orders */
INSERT INTO northwind.orders (id, employee_id, customer_id, order_date, shipped_date, shipper_id, ship_name, ship_address, ship_city, ship_state_province, ship_zip_postal_code, ship_country_region, shipping_fee, taxes, payment_type, paid_date, notes, tax_rate, tax_status_id, status_id) 
     SELECT 30, 9, 27, to_timestamp('2006-01-15', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, 'Karen Toh'             , '789 27th Street', 'Las Vegas'     , 'NV', '99999', 'USA', 200, 0, 'Check'      , to_timestamp('2006-01-15', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 31, 3, 4 , to_timestamp('2006-01-20', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 'Christina Lee'         , '123 4th Street' , 'New York'      , 'NY', '99999', 'USA', 5  , 0, 'Credit Card', to_timestamp('2006-01-20', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 32, 4, 12, to_timestamp('2006-01-22', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, 'John Edwards'          , '123 12th Street', 'Las Vegas'     , 'NV', '99999', 'USA', 5  , 0, 'Credit Card', to_timestamp('2006-01-22', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 33, 6, 8 , to_timestamp('2006-01-30', 'YY-MM-DD'), to_timestamp('2006-01-31', 'YY-MM-DD'), 3, 'Elizabeth Andersen'    , '123 8th Street' , 'Portland'      , 'OR', '99999', 'USA', 50 , 0, 'Credit Card', to_timestamp('2006-01-30', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 34, 9, 4 , to_timestamp('2006-02-06', 'YY-MM-DD'), to_timestamp('2006-02-07', 'YY-MM-DD'), 3, 'Christina Lee'         , '123 4th Street' , 'New York'      , 'NY', '99999', 'USA', 4  , 0, 'Check'      , to_timestamp('2006-02-06', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 35, 3, 29, to_timestamp('2006-02-10', 'YY-MM-DD'), to_timestamp('2006-02-12', 'YY-MM-DD'), 2, 'Soo Jung Lee'          , '789 29th Street', 'Denver'        , 'CO', '99999', 'USA', 7  , 0, 'Check'      , to_timestamp('2006-02-10', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 36, 4, 3 , to_timestamp('2006-02-23', 'YY-MM-DD'), to_timestamp('2006-02-25', 'YY-MM-DD'), 2, 'Thomas Axen'           , '123 3rd Street' , 'Los Angelas'   , 'CA', '99999', 'USA', 7  , 0, 'Cash'       , to_timestamp('2006-02-23', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 37, 8, 6 , to_timestamp('2006-03-06', 'YY-MM-DD'), to_timestamp('2006-03-09', 'YY-MM-DD'), 2, 'Francisco Pérez-Olaeta', '123 6th Street' , 'Milwaukee'     , 'WI', '99999', 'USA', 12 , 0, 'Credit Card', to_timestamp('2006-03-06', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 38, 9, 28, to_timestamp('2006-03-10', 'YY-MM-DD'), to_timestamp('2006-03-11', 'YY-MM-DD'), 3, 'Amritansh Raghav'      , '789 28th Street', 'Memphis'       , 'TN', '99999', 'USA', 10 , 0, 'Check'      , to_timestamp('2006-03-10', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 39, 3, 8 , to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 3, 'Elizabeth Andersen'    , '123 8th Street' , 'Portland'      , 'OR', '99999', 'USA', 5  , 0, 'Check'      , to_timestamp('2006-03-22', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 40, 4, 10, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, 'Roland Wacker'         , '123 10th Street', 'Chicago'       , 'IL', '99999', 'USA', 9  , 0, 'Credit Card', to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 41, 1, 7 , to_timestamp('2006-03-24', 'YY-MM-DD'), NULL        , NULL, 'Ming-Yang Xie'      , '123 7th Street' , 'Boise'         , 'ID', '99999', 'USA', 0  , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL 
     SELECT 42, 1, 10, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-07', 'YY-MM-DD'), 1, 'Roland Wacker'         , '123 10th Street', 'Chicago'       , 'IL', '99999', 'USA', 0  , 0, NULL, NULL, NULL, 0, NULL, 2 FROM dual UNION ALL 
     SELECT 43, 1, 11, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL        , 3, 'Peter Krschne'         , '123 11th Street', 'Miami'         , 'FL', '99999', 'USA', 0  , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL 
     SELECT 44, 1, 1 , to_timestamp('2006-03-24', 'YY-MM-DD'), NULL        , NULL, 'Anna Bedecs'        , '123 1st Street' , 'Seattle'       , 'WA', '99999', 'USA', 0  , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL 
     SELECT 45, 1, 28, to_timestamp('2006-04-07', 'YY-MM-DD'), to_timestamp('2006-04-07', 'YY-MM-DD'), 3, 'Amritansh Raghav'      , '789 28th Street', 'Memphis'       , 'TN', '99999', 'USA', 40 , 0, 'Credit Card', to_timestamp('2006-04-07', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 46, 7, 9 , to_timestamp('2006-04-05', 'YY-MM-DD'), to_timestamp('2006-04-05', 'YY-MM-DD'), 1, 'Sven Mortensen'        , '123 9th Street' , 'Salt Lake City', 'UT', '99999', 'USA', 100, 0, 'Check'      , to_timestamp('2006-04-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 47, 6, 6 , to_timestamp('2006-04-08', 'YY-MM-DD'), to_timestamp('2006-04-08', 'YY-MM-DD'), 2, 'Francisco Pérez-Olaeta', '123 6th Street' , 'Milwaukee'     , 'WI', '99999', 'USA', 300, 0, 'Credit Card', to_timestamp('2006-04-08', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 48, 4, 8 , to_timestamp('2006-04-05', 'YY-MM-DD'), to_timestamp('2006-04-05', 'YY-MM-DD'), 2, 'Elizabeth Andersen'    , '123 8th Street' , 'Portland'      , 'OR', '99999', 'USA', 50 , 0, 'Check'      , to_timestamp('2006-04-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 50, 9, 25, to_timestamp('2006-04-05', 'YY-MM-DD'), to_timestamp('2006-04-05', 'YY-MM-DD'), 1, 'John Rodman'           , '789 25th Street', 'Chicago'       , 'IL', '99999', 'USA', 5  , 0, 'Cash', to_timestamp('2006-04-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 51, 9, 26, to_timestamp('2006-04-05', 'YY-MM-DD'), to_timestamp('2006-04-05', 'YY-MM-DD'), 3, 'Run Liu'               , '789 26th Street', 'Miami'         , 'FL', '99999', 'USA', 60 , 0, 'Credit Card', to_timestamp('2006-04-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 55, 1, 29, to_timestamp('2006-04-05', 'YY-MM-DD'), to_timestamp('2006-04-05', 'YY-MM-DD'), 2, 'Soo Jung Lee'          , '789 29th Street', 'Denver'        , 'CO', '99999', 'USA', 200, 0, 'Check'      , to_timestamp('2006-04-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 56, 2, 6 , to_timestamp('2006-04-03', 'YY-MM-DD'), to_timestamp('2006-04-03', 'YY-MM-DD'), 3, 'Francisco Pérez-Olaeta', '123 6th Street' , 'Milwaukee'     , 'WI', '99999', 'USA', 0  , 0, 'Check'      , to_timestamp('2006-04-03', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 57, 9, 27, to_timestamp('2006-04-22', 'YY-MM-DD'), to_timestamp('2006-04-22', 'YY-MM-DD'), 2, 'Karen Toh'             , '789 27th Street', 'Las Vegas'     , 'NV', '99999', 'USA', 200, 0, 'Check'      , to_timestamp('2006-04-22', 'YY-MM-DD'), NULL, 0, NULL, 0 FROM dual UNION ALL 
     SELECT 58, 3, 4 , to_timestamp('2006-04-22', 'YY-MM-DD'), to_timestamp('2006-04-22', 'YY-MM-DD'), 1, 'Christina Lee'         , '123 4th Street' , 'New York'      , 'NY', '99999', 'USA', 5  , 0, 'Credit Card', to_timestamp('2006-04-22', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 59, 4, 12, to_timestamp('2006-04-22', 'YY-MM-DD'), to_timestamp('2006-04-22', 'YY-MM-DD'), 2, 'John Edwards'          , '123 12th Street', 'Las Vegas'     , 'NV', '99999', 'USA', 5  , 0, 'Credit Card', to_timestamp('2006-04-22', 'YY-MM-DD'), NULL, 0, NULL, 0 FROM dual UNION ALL 
     SELECT 60, 6, 8 , to_timestamp('2006-04-30', 'YY-MM-DD'), to_timestamp('2006-04-30', 'YY-MM-DD'), 3, 'Elizabeth Andersen'    , '123 8th Street' , 'Portland'      , 'OR', '99999', 'USA', 50 , 0, 'Credit Card', to_timestamp('2006-04-30', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 61, 9, 4 , to_timestamp('2006-04-07', 'YY-MM-DD'), to_timestamp('2006-04-07', 'YY-MM-DD'), 3, 'Christina Lee'         , '123 4th Street' , 'New York'      , 'NY', '99999', 'USA', 4  , 0, 'Check'      , to_timestamp('2006-04-07', 'YY-MM-DD'), NULL, 0, NULL, 0 FROM dual UNION ALL 
     SELECT 62, 3, 29, to_timestamp('2006-04-12', 'YY-MM-DD'), to_timestamp('2006-04-12', 'YY-MM-DD'), 2, 'Soo Jung Lee'          , '789 29th Street', 'Denver'        , 'CO', '99999', 'USA', 7  , 0, 'Check'      , to_timestamp('2006-04-12', 'YY-MM-DD'), NULL, 0, NULL, 0 FROM dual UNION ALL 
     SELECT 63, 4, 3 , to_timestamp('2006-04-25', 'YY-MM-DD'), to_timestamp('2006-04-25', 'YY-MM-DD'), 2, 'Thomas Axen'           , '123 3rd Street' , 'Los Angelas'   , 'CA', '99999', 'USA', 7  , 0, 'Cash', to_timestamp('2006-04-25', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 64, 8, 6 , to_timestamp('2006-05-09', 'YY-MM-DD'), to_timestamp('2006-05-09', 'YY-MM-DD'), 2, 'Francisco Pérez-Olaeta', '123 6th Street' , 'Milwaukee'     , 'WI', '99999', 'USA', 12 , 0, 'Credit Card', to_timestamp('2006-05-09', 'YY-MM-DD'), NULL, 0, NULL, 0 FROM dual UNION ALL 
     SELECT 65, 9, 28, to_timestamp('2006-05-11', 'YY-MM-DD'), to_timestamp('2006-05-11', 'YY-MM-DD'), 3, 'Amritansh Raghav'      , '789 28th Street', 'Memphis'       , 'TN', '99999', 'USA', 10 , 0, 'Check'      , to_timestamp('2006-05-11', 'YY-MM-DD'), NULL, 0, NULL, 0 FROM dual UNION ALL 
     SELECT 66, 3, 8 , to_timestamp('2006-05-24', 'YY-MM-DD'), to_timestamp('2006-05-24', 'YY-MM-DD'), 3, 'Elizabeth Andersen'    , '123 8th Street' , 'Portland'      , 'OR', '99999', 'USA', 5  , 0, 'Check'      , to_timestamp('2006-05-24', 'YY-MM-DD'), NULL, 0, NULL, 0 FROM dual UNION ALL 
     SELECT 67, 4, 10, to_timestamp('2006-05-24', 'YY-MM-DD'), to_timestamp('2006-05-24', 'YY-MM-DD'), 2, 'Roland Wacker'         , '123 10th Street', 'Chicago'       , 'IL', '99999', 'USA', 9  , 0, 'Credit Card', to_timestamp('2006-05-24', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 68, 1, 7 , to_timestamp('2006-05-24', 'YY-MM-DD'), NULL        , NULL, 'Ming-Yang Xie'      , '123 7th Street' , 'Boise'         , 'ID', '99999', 'USA', 0  , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL 
     SELECT 69, 1, 10, to_timestamp('2006-05-24', 'YY-MM-DD'), NULL        , 1, 'Roland Wacker'         , '123 10th Street', 'Chicago'       , 'IL', '99999', 'USA', 0  , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL 
     SELECT 70, 1, 11, to_timestamp('2006-05-24', 'YY-MM-DD'), NULL        , 3, 'Peter Krschne'         , '123 11th Street', 'Miami'         , 'FL', '99999', 'USA', 0  , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL 
     SELECT 71, 1, 1 , to_timestamp('2006-05-24', 'YY-MM-DD'), NULL        , 3, 'Anna Bedecs'           , '123 1st Street' , 'Seattle'       , 'WA', '99999', 'USA', 0  , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL 
     SELECT 72, 1, 28, to_timestamp('2006-06-07', 'YY-MM-DD'), to_timestamp('2006-06-07', 'YY-MM-DD'), 3, 'Amritansh Raghav'      , '789 28th Street', 'Memphis'       , 'TN', '99999', 'USA', 40 , 0, 'Credit Card', to_timestamp('2006-06-07', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 73, 7, 9 , to_timestamp('2006-06-05', 'YY-MM-DD'), to_timestamp('2006-06-05', 'YY-MM-DD'), 1, 'Sven Mortensen'        , '123 9th Street' , 'Salt Lake City', 'UT', '99999', 'USA', 100, 0, 'Check'      , to_timestamp('2006-06-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 74, 6, 6 , to_timestamp('2006-06-08', 'YY-MM-DD'), to_timestamp('2006-06-08', 'YY-MM-DD'), 2, 'Francisco Pérez-Olaeta', '123 6th Street' , 'Milwaukee'     , 'WI', '99999', 'USA', 300, 0, 'Credit Card', to_timestamp('2006-06-08', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 75, 4, 8 , to_timestamp('2006-06-05', 'YY-MM-DD'), to_timestamp('2006-06-05', 'YY-MM-DD'), 2, 'Elizabeth Andersen'    , '123 8th Street' , 'Portland'      , 'OR', '99999', 'USA', 50 , 0, 'Check'      , to_timestamp('2006-06-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 76, 9, 25, to_timestamp('2006-06-05', 'YY-MM-DD'), to_timestamp('2006-06-05', 'YY-MM-DD'), 1, 'John Rodman'           , '789 25th Street', 'Chicago'       , 'IL', '99999', 'USA', 5  , 0, 'Cash', to_timestamp('2006-06-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 77, 9, 26, to_timestamp('2006-06-05', 'YY-MM-DD'), to_timestamp('2006-06-05', 'YY-MM-DD'), 3, 'Run Liu'               , '789 26th Street', 'Miami'         , 'FL', '99999', 'USA', 60 , 0, 'Credit Card', to_timestamp('2006-06-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 78, 1, 29, to_timestamp('2006-06-05', 'YY-MM-DD'), to_timestamp('2006-06-05', 'YY-MM-DD'), 2, 'Soo Jung Lee'          , '789 29th Street', 'Denver'        , 'CO', '99999', 'USA', 200, 0, 'Check'      , to_timestamp('2006-06-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 79, 2, 6 , to_timestamp('2006-06-23', 'YY-MM-DD'), to_timestamp('2006-06-23', 'YY-MM-DD'), 3, 'Francisco Pérez-Olaeta', '123 6th Street' , 'Milwaukee'     , 'WI', '99999', 'USA', 0  , 0, 'Check'      , to_timestamp('2006-06-23', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL 
     SELECT 80, 2, 4 , to_timestamp('2006-04-25', 'YY-MM-DD'), NULL        , NULL, 'Christina Lee'      , '123 4th Street' , 'New York'      , 'NY', '99999', 'USA', 0  , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL 
     SELECT 81, 2, 3 , to_timestamp('2006-04-25', 'YY-MM-DD'), NULL        , NULL, 'Thomas Axen'        , '123 3rd Street' , 'Los Angelas'   , 'CA', '99999', 'USA', 0  , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual;


/* order_details */
INSERT INTO northwind.order_details (id, order_id, product_id, quantity, unit_price, discount, status_id, date_allocated, purchase_order_id, inventory_id) 
      SELECT 27, 30, 34, 100, 14    , 0, 2, NULL, 96  , 83 FROM dual UNION ALL 
     SELECT 28, 30, 80, 30 , 3.5   , 0, 2, NULL, NULL, 63 FROM dual UNION ALL 
     SELECT 29, 31, 7 , 10 , 30    , 0, 2, NULL, NULL, 64 FROM dual UNION ALL 
     SELECT 30, 31, 51, 10 , 53    , 0, 2, NULL, NULL, 65 FROM dual UNION ALL 
     SELECT 31, 31, 80, 10 , 3.5   , 0, 2, NULL, NULL, 66 FROM dual UNION ALL 
     SELECT 32, 32, 1 , 15 , 18    , 0, 2, NULL, NULL, 67 FROM dual UNION ALL 
     SELECT 33, 32, 43, 20 , 46    , 0, 2, NULL, NULL, 68 FROM dual UNION ALL 
     SELECT 34, 33, 19, 30 , 9.2   , 0, 2, NULL, 97  , 81 FROM dual UNION ALL 
     SELECT 35, 34, 19, 20 , 9.2   , 0, 2, NULL, NULL, 69 FROM dual UNION ALL 
     SELECT 36, 35, 48, 10 , 12.75 , 0, 2, NULL, NULL, 70 FROM dual UNION ALL 
     SELECT 37, 36, 41, 200, 9.65  , 0, 2, NULL, 98  , 79 FROM dual UNION ALL 
     SELECT 38, 37, 8 , 17 , 40    , 0, 2, NULL, NULL, 71 FROM dual UNION ALL 
     SELECT 39, 38, 43, 300, 46    , 0, 2, NULL, 99  , 77 FROM dual UNION ALL 
     SELECT 40, 39, 48, 100, 12.75 , 0, 2, NULL, 100 , 75 FROM dual UNION ALL 
     SELECT 41, 40, 81, 200, 2.99  , 0, 2, NULL, 101 , 73 FROM dual UNION ALL 
     SELECT 42, 41, 43, 300, 46    , 0, 1, NULL, 102 , 104 FROM dual UNION ALL 
     SELECT 43, 42, 6 , 10 , 25    , 0, 2, NULL, NULL, 84 FROM dual UNION ALL 
     SELECT 44, 42, 4 , 10 , 22    , 0, 2, NULL, NULL, 85 FROM dual UNION ALL 
     SELECT 45, 42, 19, 10 , 9.2   , 0, 2, NULL, 103 , 110 FROM dual UNION ALL 
     SELECT 46, 43, 80, 20 , 3.5   , 0, 1, NULL, NULL, 86 FROM dual UNION ALL 
     SELECT 47, 43, 81, 50 , 2.99  , 0, 1, NULL, NULL, 87 FROM dual UNION ALL 
     SELECT 48, 44, 1 , 25 , 18    , 0, 1, NULL, NULL, 88 FROM dual UNION ALL 
     SELECT 49, 44, 43, 25 , 46    , 0, 1, NULL, NULL, 89 FROM dual UNION ALL 
     SELECT 50, 44, 81, 25 , 2.99  , 0, 1, NULL, NULL, 90 FROM dual UNION ALL 
     SELECT 51, 45, 41, 50 , 9.65  , 0, 2, NULL, 104 , 116 FROM dual UNION ALL 
     SELECT 52, 45, 40, 50 , 18.4  , 0, 2, NULL, NULL, 91 FROM dual UNION ALL 
     SELECT 53, 46, 57, 100, 19.5  , 0, 2, NULL, 105 , 101 FROM dual UNION ALL 
     SELECT 54, 46, 72, 50 , 34.8  , 0, 2, NULL, 106 , 114 FROM dual UNION ALL 
     SELECT 55, 47, 34, 300, 14    , 0, 2, NULL, 107 , 108 FROM dual UNION ALL 
     SELECT 56, 48, 8 , 25 , 40    , 0, 2, NULL, 108 , 106 FROM dual UNION ALL 
     SELECT 57, 48, 19, 25 , 9.2   , 0, 2, NULL, 109 , 112 FROM dual UNION ALL 
     SELECT 59, 50, 21, 20 , 10    , 0, 2, NULL, NULL, 92 FROM dual UNION ALL 
     SELECT 60, 51, 5 , 25 , 21.35 , 0, 2, NULL, NULL, 93 FROM dual UNION ALL 
     SELECT 61, 51, 41, 30 , 9.65  , 0, 2, NULL, NULL, 94 FROM dual UNION ALL 
     SELECT 62, 51, 40, 30 , 18.4  , 0, 2, NULL, NULL, 95 FROM dual UNION ALL 
     SELECT 66, 56, 48, 10 , 12.75 , 0, 2, NULL, 111 , 99 FROM dual UNION ALL 
     SELECT 67, 55, 34, 87 , 14    , 0, 2, NULL, NULL, 117 FROM dual UNION ALL 
     SELECT 68, 79, 7 , 30 , 30    , 0, 2, NULL, NULL, 119 FROM dual UNION ALL 
     SELECT 69, 79, 51, 30 , 53    , 0, 2, NULL, NULL, 118 FROM dual UNION ALL 
     SELECT 70, 78, 17, 40 , 39    , 0, 2, NULL, NULL, 120 FROM dual UNION ALL 
     SELECT 71, 77, 6 , 90 , 25    , 0, 2, NULL, NULL, 121 FROM dual UNION ALL 
     SELECT 72, 76, 4 , 30 , 22    , 0, 2, NULL, NULL, 122 FROM dual UNION ALL 
     SELECT 73, 75, 48, 40 , 12.75 , 0, 2, NULL, NULL, 123 FROM dual UNION ALL 
     SELECT 74, 74, 48, 40 , 12.75 , 0, 2, NULL, NULL, 124 FROM dual UNION ALL 
     SELECT 75, 73, 41, 10 , 9.65  , 0, 2, NULL, NULL, 125 FROM dual UNION ALL 
     SELECT 76, 72, 43, 5  , 46    , 0, 2, NULL, NULL, 126 FROM dual UNION ALL 
     SELECT 77, 71, 40, 40 , 18.4  , 0, 2, NULL, NULL, 127 FROM dual UNION ALL 
     SELECT 78, 70, 8 , 20 , 40    , 0, 2, NULL, NULL, 128 FROM dual UNION ALL 
     SELECT 79, 69, 80, 15 , 3.5   , 0, 2, NULL, NULL, 129 FROM dual UNION ALL 
     SELECT 80, 67, 74, 20 , 10    , 0, 2, NULL, NULL, 130 FROM dual UNION ALL 
     SELECT 81, 60, 72, 40 , 34.8  , 0, 2, NULL, NULL, 131 FROM dual UNION ALL 
     SELECT 82, 63, 3 , 50 , 10    , 0, 2, NULL, NULL, 132 FROM dual UNION ALL 
     SELECT 83, 63, 8 , 3  , 40    , 0, 2, NULL, NULL, 133 FROM dual UNION ALL 
     SELECT 84, 58, 20, 40 , 81    , 0, 2, NULL, NULL, 134 FROM dual UNION ALL 
     SELECT 85, 58, 52, 40 , 7     , 0, 2, NULL, NULL, 135 FROM dual UNION ALL 
     SELECT 86, 80, 56, 10 , 38    , 0, 1, NULL, NULL, 136 FROM dual UNION ALL 
     SELECT 90, 81, 81, 0  , 2.99  , 0, 5, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 91, 81, 56, 0  , 38    , 0, 0, NULL, NULL, NULL FROM dual;
/*  End of order_details */

/*  purchase_orders */
INSERT INTO northwind.purchase_orders (id, supplier_id, created_by, submitted_date, creation_date, status_id, expected_date, shipping_fee, taxes, payment_date, payment_amount, payment_method, notes, approved_by, approved_date, submitted_by) 
     SELECT 90,  1, 2, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 2 FROM dual UNION ALL 
     SELECT 91,  3, 2, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 2 FROM dual UNION ALL 
     SELECT 92,  2, 2, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 2 FROM dual UNION ALL 
     SELECT 93,  5, 2, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 2 FROM dual UNION ALL 
     SELECT 94,  6, 2, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 2 FROM dual UNION ALL 
     SELECT 95,  4, 2, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 2 FROM dual UNION ALL 
     SELECT 96,  1, 5, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #30', 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 5 FROM dual UNION ALL 
     SELECT 97,  2, 7, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #33', 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 7 FROM dual UNION ALL 
     SELECT 98,  2, 4, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #36', 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 4 FROM dual UNION ALL 
     SELECT 99,  1, 3, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #38', 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 3 FROM dual UNION ALL 
     SELECT 100, 2, 9, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #39', 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 9 FROM dual UNION ALL 
     SELECT 101, 1, 2, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #40', 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 2 FROM dual UNION ALL 
     SELECT 102, 1, 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #41', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 1 FROM dual UNION ALL 
     SELECT 103, 2, 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #42', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 1 FROM dual UNION ALL 
     SELECT 104, 2, 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #45', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 1 FROM dual UNION ALL 
     SELECT 105, 5, 7, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, 'Check'      , 'Purchase generated based on Order #46', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 7 FROM dual UNION ALL 
     SELECT 106, 6, 7, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #46', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 7 FROM dual UNION ALL 
     SELECT 107, 1, 6, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #47', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 6 FROM dual UNION ALL 
     SELECT 108, 2, 4, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #48', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 4 FROM dual UNION ALL 
     SELECT 109, 2, 4, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #48', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 4 FROM dual UNION ALL 
     SELECT 110, 1, 3, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #49', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 3 FROM dual UNION ALL 
     SELECT 111, 1, 2, to_timestamp('2006-03-31', 'YY-MM-DD'), to_timestamp('2006-03-31', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #56', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 2 FROM dual UNION ALL 
     SELECT 140, 6, 7, to_timestamp('2006-04-25', 'YY-MM-DD'), to_timestamp('2006-04-25', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-04-25', 'YY-MM-DD'), 2 FROM dual UNION ALL 
     SELECT 141, 8, 7, to_timestamp('2006-04-25', 'YY-MM-DD'), to_timestamp('2006-04-25', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-04-25', 'YY-MM-DD'), 2 FROM dual UNION ALL 
     SELECT 142, 8, 3, to_timestamp('2006-04-25', 'YY-MM-DD'), to_timestamp('2006-04-25', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, 'Check'      , NULL, 2, to_timestamp('2006-04-25', 'YY-MM-DD'), 2 FROM dual UNION ALL 
     SELECT 146, 2, 2, to_timestamp('2006-04-26', 'YY-MM-DD'), to_timestamp('2006-04-26', 'YY-MM-DD'), 1, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, 2 FROM dual UNION ALL 
     SELECT 147, 7, 2, to_timestamp('2006-04-26', 'YY-MM-DD'), to_timestamp('2006-04-26', 'YY-MM-DD'), 1, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, 2 FROM dual UNION ALL 
     SELECT 148, 5, 2, to_timestamp('2006-04-26', 'YY-MM-DD'), to_timestamp('2006-04-26', 'YY-MM-DD'), 1, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, 2 FROM dual;
/* end of purchase_orders; */


/* inventory_transactions */
INSERT INTO northwind.inventory_transactions (id, transaction_type, transaction_created_date, transaction_modified_date, product_id, quantity, purchase_order_id, customer_order_id, comments) 
     SELECT 35 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 80, 75 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 36 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 72, 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 37 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 52, 100, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 38 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 56, 120, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 39 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 57, 80 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 40 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 6 , 100, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 41 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 7 , 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 42 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 8 , 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 43 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 14, 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 44 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 17, 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 45 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 19, 20 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 46 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 20, 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 47 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 21, 20 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 48 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 40, 120, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 49 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 41, 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 50 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 48, 100, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 51 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 51, 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 52 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 74, 20 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 53 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 77, 60 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 54 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 3 , 100, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 55 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 4 , 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 56 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 5 , 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 57 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 65, 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 58 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 66, 80 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 59 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 1 , 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 60 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 34, 60 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 61 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 43, 100, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 62 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 81, 125, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 63 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 80, 30 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 64 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 7 , 10 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 65 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 51, 10 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 66 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 80, 10 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 67 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 1 , 15 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 68 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 43, 20 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 69 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 19, 20 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 70 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 48, 10 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 71 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 8 , 17 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 72 , 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 81, 200, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 73 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 81, 200, NULL, NULL, 'Fill Back Ordered product, Order #40' FROM dual UNION ALL 
     SELECT 74 , 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 48, 100, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 75 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 48, 100, NULL, NULL, 'Fill Back Ordered product, Order #39' FROM dual UNION ALL 
     SELECT 76 , 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 43, 300, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 77 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 43, 300, NULL, NULL, 'Fill Back Ordered product, Order #38' FROM dual UNION ALL 
     SELECT 78 , 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 41, 200, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 79 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 41, 200, NULL, NULL, 'Fill Back Ordered product, Order #36' FROM dual UNION ALL 
     SELECT 80 , 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 19, 30 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 81 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 19, 30 , NULL, NULL, 'Fill Back Ordered product, Order #33' FROM dual UNION ALL 
     SELECT 82 , 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 34, 100, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 83 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 34, 100, NULL, NULL, 'Fill Back Ordered product, Order #30' FROM dual UNION ALL 
     SELECT 84 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 6 , 10 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 85 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 4 , 10 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 86 , 3, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 80, 20 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 87 , 3, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 81, 50 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 88 , 3, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 1 , 25 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 89 , 3, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 43, 25 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 90 , 3, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 81, 25 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 91 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 40, 50 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 92 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 21, 20 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 93 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 5 , 25 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 94 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 41, 30 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 95 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 40, 30 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 96 , 3, to_timestamp('2006-03-30', 'YY-MM-DD'), to_timestamp('2006-03-30', 'YY-MM-DD'), 34, 12 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 97 , 3, to_timestamp('2006-03-30', 'YY-MM-DD'), to_timestamp('2006-03-30', 'YY-MM-DD'), 34, 10 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 98 , 3, to_timestamp('2006-03-30', 'YY-MM-DD'), to_timestamp('2006-03-30', 'YY-MM-DD'), 34, 1  , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 99 , 2, to_timestamp('2006-04-03', 'YY-MM-DD'), to_timestamp('2006-04-03', 'YY-MM-DD'), 48, 10 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 100, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 57, 100, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 101, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 57, 100, NULL, NULL, 'Fill Back Ordered product, Order #46' FROM dual UNION ALL 
     SELECT 102, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 34, 50 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 103, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 43, 250, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 104, 3, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 43, 300, NULL, NULL, 'Fill Back Ordered product, Order #41' FROM dual UNION ALL 
     SELECT 105, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 8 , 25 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 106, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 8 , 25 , NULL, NULL, 'Fill Back Ordered product, Order #48' FROM dual UNION ALL 
     SELECT 107, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 34, 300, NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 108, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 34, 300, NULL, NULL, 'Fill Back Ordered product, Order #47' FROM dual UNION ALL 
     SELECT 109, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 19, 25 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 110, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 19, 10 , NULL, NULL, 'Fill Back Ordered product, Order #42' FROM dual UNION ALL 
     SELECT 111, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 19, 10 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 112, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 19, 25 , NULL, NULL, 'Fill Back Ordered product, Order #48' FROM dual UNION ALL 
     SELECT 113, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 72, 50 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 114, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 72, 50 , NULL, NULL, 'Fill Back Ordered product, Order #46' FROM dual UNION ALL 
     SELECT 115, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 41, 50 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 116, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 41, 50 , NULL, NULL, 'Fill Back Ordered product, Order #45' FROM dual UNION ALL 
     SELECT 117, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 34, 87 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 118, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 51, 30 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 119, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 7 , 30 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 120, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 17, 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 121, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 6 , 90 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 122, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 4 , 30 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 123, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 48, 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 124, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 48, 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 125, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 41, 10 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 126, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 43, 5  , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 127, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 40, 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 128, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 8 , 20 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 129, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 80, 15 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 130, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 74, 20 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 131, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 72, 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 132, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 3 , 50 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 133, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 8 , 3  , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 134, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 20, 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 135, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 52, 40 , NULL, NULL, NULL FROM dual UNION ALL 
     SELECT 136, 3, to_timestamp('2006-04-25', 'YY-MM-DD'), to_timestamp('2006-04-25', 'YY-MM-DD'), 56, 110, NULL, NULL, NULL FROM dual;
/* End of inventory_transactions */


/* purchase_order_details  */
INSERT INTO northwind.purchase_order_details (id, purchase_order_id, product_id, quantity, unit_cost, date_received, posted_to_inventory, inventory_id) 
     SELECT 238, 90 , 1 , 40 , 14, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 59 FROM dual UNION ALL 
     SELECT 239, 91 , 3 , 100, 8 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 54 FROM dual UNION ALL 
     SELECT 240, 91 , 4 , 40 , 16, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 55 FROM dual UNION ALL 
     SELECT 241, 91 , 5 , 40 , 16, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 56 FROM dual UNION ALL 
     SELECT 242, 92 , 6 , 100, 19, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 40 FROM dual UNION ALL 
     SELECT 243, 92 , 7 , 40 , 22, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 41 FROM dual UNION ALL 
     SELECT 244, 92 , 8 , 40 , 30, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 42 FROM dual UNION ALL 
     SELECT 245, 92 , 14, 40 , 17, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 43 FROM dual UNION ALL 
     SELECT 246, 92 , 17, 40 , 29, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 44 FROM dual UNION ALL 
     SELECT 247, 92 , 19, 20 , 7 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 45 FROM dual UNION ALL 
     SELECT 248, 92 , 20, 40 , 61, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 46 FROM dual UNION ALL 
     SELECT 249, 92 , 21, 20 , 8 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 47 FROM dual UNION ALL 
     SELECT 250, 90 , 34, 60 , 10, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 60 FROM dual UNION ALL 
     SELECT 251, 92 , 40, 120, 14, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 48 FROM dual UNION ALL 
     SELECT 252, 92 , 41, 40 , 7 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 49 FROM dual UNION ALL 
     SELECT 253, 90 , 43, 100, 34, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 61 FROM dual UNION ALL 
     SELECT 254, 92 , 48, 100, 10, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 50 FROM dual UNION ALL 
     SELECT 255, 92 , 51, 40 , 40, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 51 FROM dual UNION ALL 
     SELECT 256, 93 , 52, 100, 5,  to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 37 FROM dual UNION ALL 
     SELECT 257, 93 , 56, 120, 28, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 38 FROM dual UNION ALL 
     SELECT 258, 93 , 57, 80 , 15, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 39 FROM dual UNION ALL 
     SELECT 259, 91 , 65, 40 , 16, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 57 FROM dual UNION ALL 
     SELECT 260, 91 , 66, 80 , 13, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 58 FROM dual UNION ALL 
     SELECT 261, 94 , 72, 40 , 26, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 36 FROM dual UNION ALL 
     SELECT 262, 92 , 74, 20 , 8,  to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 52 FROM dual UNION ALL 
     SELECT 263, 92 , 77, 60 , 10, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 53 FROM dual UNION ALL 
     SELECT 264, 95 , 80, 75 , 3 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 35 FROM dual UNION ALL 
     SELECT 265, 90 , 81, 125, 2 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 62 FROM dual UNION ALL 
     SELECT 266, 96 , 34, 100, 10, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 82 FROM dual UNION ALL 
     SELECT 267, 97 , 19, 30 , 7 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 80 FROM dual UNION ALL 
     SELECT 268, 98 , 41, 200, 7 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 78 FROM dual UNION ALL 
     SELECT 269, 99 , 43, 300, 34, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 76 FROM dual UNION ALL 
     SELECT 270, 100, 48, 100, 10, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 74 FROM dual UNION ALL 
     SELECT 271, 101, 81, 200, 2 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 72 FROM dual UNION ALL 
     SELECT 272, 102, 43, 300, 34, NULL, 0, NULL FROM dual UNION ALL 
     SELECT 273, 103, 19, 10 , 7 , to_timestamp('2006-04-17', 'YY-MM-DD'), 1, 111 FROM dual UNION ALL 
     SELECT 274, 104, 41, 50 , 7 , to_timestamp('2006-04-06', 'YY-MM-DD'), 1, 115 FROM dual UNION ALL 
     SELECT 275, 105, 57, 100, 15, to_timestamp('2006-04-05', 'YY-MM-DD'), 1, 100 FROM dual UNION ALL 
     SELECT 276, 106, 72, 50 , 26, to_timestamp('2006-04-05', 'YY-MM-DD'), 1, 113 FROM dual UNION ALL 
     SELECT 277, 107, 34, 300, 10, to_timestamp('2006-04-05', 'YY-MM-DD'), 1, 107 FROM dual UNION ALL 
     SELECT 278, 108, 8 , 25 , 30, to_timestamp('2006-04-05', 'YY-MM-DD'), 1, 105 FROM dual UNION ALL 
     SELECT 279, 109, 19, 25 , 7 , to_timestamp('2006-04-05', 'YY-MM-DD'), 1, 109 FROM dual UNION ALL 
     SELECT 280, 110, 43, 250, 34, to_timestamp('2006-04-10', 'YY-MM-DD'), 1, 103 FROM dual UNION ALL 
     SELECT 281, 90 , 1 , 40 , 14, NULL, 0, NULL FROM dual UNION ALL 
     SELECT 282, 92 , 19, 20 , 7 , NULL, 0, NULL FROM dual UNION ALL 
     SELECT 283, 111, 34, 50 , 10, to_timestamp('2006-04-04', 'YY-MM-DD'), 1, 102 FROM dual UNION ALL 
     SELECT 285, 91 , 3 , 50 , 8 , NULL, 0, NULL FROM dual UNION ALL 
     SELECT 286, 91 , 4 , 40 , 16, NULL, 0, NULL FROM dual UNION ALL 
     SELECT 288, 140, 85, 10 , 9 , NULL, 0, NULL FROM dual UNION ALL 
     SELECT 289, 141, 6 , 10 , 18.75, NULL, 0, NULL FROM dual UNION ALL 
     SELECT 290, 142, 1 , 1  , 13.5, NULL, 0, NULL FROM dual UNION ALL 
     SELECT 292, 146, 20, 40 , 60, NULL, 0, NULL FROM dual UNION ALL 
     SELECT 293, 146, 51, 40 , 39, NULL, 0, NULL FROM dual UNION ALL 
     SELECT 294, 147, 40, 120, 13, NULL, 0, NULL FROM dual UNION ALL 
     SELECT 295, 148, 72, 40 , 26, NULL, 0, NULL FROM dual;
/* purchase_order_details */

/* invoices */
INSERT INTO northwind.invoices (id, order_id, invoice_date, due_date, tax, shipping, amount_due) 
     SELECT 5 , 31, to_timestamp('2006-03-22', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 6 , 32, to_timestamp('2006-03-22', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 7 , 40, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 8 , 39, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 9 , 38, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 10, 37, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 11, 36, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 12, 35, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 13, 34, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 14, 33, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 15, 30, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 16, 56, to_timestamp('2006-04-03', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 17, 55, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 18, 51, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 19, 50, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 20, 48, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 21, 47, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 22, 46, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 23, 45, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 24, 79, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 25, 78, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 26, 77, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 27, 76, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 28, 75, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 29, 74, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 30, 73, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 31, 72, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 32, 71, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 33, 70, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 34, 69, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 35, 67, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 36, 42, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 37, 60, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 38, 63, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL 
     SELECT 39, 58, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual;
/* end of invoices */

/* strings */
INSERT INTO northwind.strings (string_id, string_data) 
     SELECT 2 , 'Northwind Traders' FROM dual UNION ALL 
     SELECT 3 , 'Cannot remove posted inventory!' FROM dual UNION ALL 
     SELECT 4 , 'Back ordered product filled for Order #|' FROM dual UNION ALL 
     SELECT 5 , 'Discounted price below cost!' FROM dual UNION ALL 
     SELECT 6 , 'Insufficient inventory.' FROM dual UNION ALL 
     SELECT 7 , 'Insufficient inventory. Do you want to create a purchase order?' FROM dual UNION ALL 
     SELECT 8 , 'Purchase orders were successfully created for | products' FROM dual UNION ALL 
     SELECT 9 , 'There are no products below their respective reorder levels' FROM dual UNION ALL 
     SELECT 10, 'Must specify customer name!' FROM dual UNION ALL 
     SELECT 11, 'Restocking will generate purchase orders for all products below desired inventory levels.  Do you want to continue?' FROM dual UNION ALL 
     SELECT 12, 'Cannot create purchase order.  No suppliers listed for specified product' FROM dual UNION ALL 
     SELECT 13, 'Discounted price is below cost!' FROM dual UNION ALL 
     SELECT 14, 'Do you want to continue?' FROM dual UNION ALL 
     SELECT 15, 'Order is already invoiced. Do you want to print the invoice?' FROM dual UNION ALL 
     SELECT 16, 'Order does not contain any line items' FROM dual UNION ALL 
     SELECT 17, 'Cannot create invoice!  Inventory has not been allocated for each specified product.' FROM dual UNION ALL 
     SELECT 18, 'Sorry, there are no sales in the specified time period' FROM dual UNION ALL 
     SELECT 19, 'Product successfully restocked.' FROM dual UNION ALL 
     SELECT 21, 'Product does not need restocking! Product is already at desired inventory level.' FROM dual UNION ALL 
     SELECT 22, 'Product restocking failed!' FROM dual UNION ALL 
     SELECT 23, 'Invalid login specified!' FROM dual UNION ALL 
     SELECT 24, 'Must first select reported!' FROM dual UNION ALL 
     SELECT 25, 'Changing supplier will remove purchase line items, continue?' FROM dual UNION ALL 
     SELECT 26, 'Purchase orders were successfully submitted for | products.  Do you want to view the restocking report?' FROM dual UNION ALL 
     SELECT 27, 'There was an error attempting to restock inventory levels.' FROM dual UNION ALL 
     SELECT 28, '| product(s) were successfully restocked.  Do you want to view the restocking report?' FROM dual UNION ALL 
     SELECT 29, 'You cannot remove purchase line items already posted to inventory!' FROM dual UNION ALL 
     SELECT 30, 'There was an error removing one or more purchase line items.' FROM dual UNION ALL 
     SELECT 31, 'You cannot modify quantity for purchased product already received or posted to inventory.' FROM dual UNION ALL 
     SELECT 32, 'You cannot modify price for purchased product already received or posted to inventory.' FROM dual UNION ALL 
     SELECT 33, 'Product has been successfully posted to inventory.' FROM dual UNION ALL 
     SELECT 34, 'Sorry, product cannot be successfully posted to inventory.' FROM dual UNION ALL 
     SELECT 35, 'There are orders with this product on back order.  Would you like to fill them now?' FROM dual UNION ALL 
     SELECT 36, 'Cannot post product to inventory without specifying received date!' FROM dual UNION ALL 
     SELECT 37, 'Do you want to post received product to inventory?' FROM dual UNION ALL 
     SELECT 38, 'Initialize purchase, orders, and inventory data?' FROM dual UNION ALL 
     SELECT 39, 'Must first specify employee name!' FROM dual UNION ALL 
     SELECT 40, 'Specified user must be logged in to approve purchase!' FROM dual UNION ALL 
     SELECT 41, 'Purchase order must contain completed line items before it can be approved' FROM dual UNION ALL 
     SELECT 42, 'Sorry, you do not have permission to approve purchases.' FROM dual UNION ALL 
     SELECT 43, 'Purchase successfully approved' FROM dual UNION ALL 
     SELECT 44, 'Purchase cannot be approved' FROM dual UNION ALL 
     SELECT 45, 'Purchase successfully submitted for approval' FROM dual UNION ALL 
     SELECT 46, 'Purchase cannot be submitted for approval' FROM dual UNION ALL 
     SELECT 47, 'Sorry, purchase order does not contain line items' FROM dual UNION ALL 
     SELECT 48, 'Do you want to cancel this order?' FROM dual UNION ALL 
     SELECT 49, 'Canceling an order will permanently delete the order.  Are you sure you want to cancel?' FROM dual UNION ALL 
     SELECT 100, 'Your order was successfully canceled.' FROM dual UNION ALL 
     SELECT 101, 'Cannot cancel an order that has items received and posted to inventory.' FROM dual UNION ALL 
     SELECT 102, 'There was an error trying to cancel this order.' FROM dual UNION ALL 
     SELECT 103, 'The invoice for this order has not yet been created.' FROM dual UNION ALL 
     SELECT 104, 'Shipping information is not complete.  Please specify all shipping information and try again.' FROM dual UNION ALL 
     SELECT 105, 'Cannot mark as shipped.  Order must first be invoiced!' FROM dual UNION ALL 
     SELECT 106, 'Cannot cancel an order that has already shipped!' FROM dual UNION ALL 
     SELECT 107, 'Must first specify salesperson!' FROM dual UNION ALL 
     SELECT 108, 'Order is now marked closed.' FROM dual UNION ALL 
     SELECT 109, 'Order must first be marked shipped before closing.' FROM dual UNION ALL 
     SELECT 110, 'Must first specify payment information!' FROM dual UNION ALL 
     SELECT 111, 'There was an error attempting to restock inventory levels.  | product(s) were successfully restocked.' FROM dual UNION ALL 
     SELECT 112, 'You must supply a Unit Cost.' FROM dual UNION ALL 
     SELECT 113, 'Fill back ordered product, Order #|' FROM dual UNION ALL 
     SELECT 114, 'Purchase generated based on Order #|' FROM dual;