-- Container Rate INSERT Statements
-- Generiert aus Excel-Datei

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Aurangabad'),
             (SELECT id FROM node WHERE external_mapping_id = 'ExM'),
             'ROAD',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Aurangabad'),
             (SELECT id FROM node WHERE external_mapping_id = 'INJNPT'),
             'ROAD',
             250.00,
             400.00,
             425.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             (SELECT id FROM node WHERE external_mapping_id = 'AB'),
             'POST_RUN',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             (SELECT id FROM node WHERE external_mapping_id = 'FGG'),
             'POST_RUN',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             (SELECT id FROM node WHERE external_mapping_id = 'KWS'),
             'POST_RUN',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             (SELECT id FROM node WHERE external_mapping_id = 'Urban AB'),
             'POST_RUN',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             (SELECT id FROM node WHERE external_mapping_id = 'Urban Wörth'),
             'POST_RUN',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Bangalore'),
             (SELECT id FROM node WHERE external_mapping_id = 'ExM'),
             'ROAD',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Bangalore'),
             (SELECT id FROM node WHERE external_mapping_id = 'INMAA'),
             'ROAD',
             546.00,
             774.00,
             828.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNSHA'),
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             'SEA',
             13795.00,
             22472.00,
             23448.00,
             24,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNSHA'),
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             'SEA',
             13803.00,
             22485.00,
             23463.00,
             24,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNTAO'),
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             'SEA',
             14208.00,
             23133.00,
             24134.00,
             25,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNTAO'),
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             'SEA',
             14216.00,
             23146.00,
             24148.00,
             25,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNTGS'),
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             'SEA',
             14689.00,
             23902.00,
             24950.00,
             26,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNTGS'),
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             'SEA',
             14697.00,
             23915.00,
             24963.00,
             26,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNXMN'),
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             'SEA',
             13893.00,
             22629.00,
             23615.00,
             24,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNXMN'),
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             'SEA',
             13901.00,
             22642.00,
             23629.00,
             24,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNXMN'),
             (SELECT id FROM node WHERE external_mapping_id = 'FRLEH'),
             'SEA',
             13789.00,
             22462.00,
             23437.00,
             24,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNXMN'),
             (SELECT id FROM node WHERE external_mapping_id = 'ITGOA'),
             'SEA',
             12528.00,
             20445.00,
             21346.00,
             22,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNYTN'),
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             'SEA',
             13771.00,
             22434.00,
             23408.00,
             24,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNYTN'),
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             'SEA',
             13779.00,
             22447.00,
             23422.00,
             24,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Chennai'),
             (SELECT id FROM node WHERE external_mapping_id = 'ExM'),
             'ROAD',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Chennai'),
             (SELECT id FROM node WHERE external_mapping_id = 'INMAA'),
             'ROAD',
             626.00,
             901.00,
             965.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             (SELECT id FROM node WHERE external_mapping_id = 'EGD'),
             'POST_RUN',
             250.00,
             400.00,
             425.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             (SELECT id FROM node WHERE external_mapping_id = 'HH'),
             'POST_RUN',
             250.00,
             400.00,
             425.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             (SELECT id FROM node WHERE external_mapping_id = 'KOL'),
             'POST_RUN',
             250.00,
             400.00,
             425.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             (SELECT id FROM node WHERE external_mapping_id = 'LiPo'),
             'POST_RUN',
             250.00,
             400.00,
             425.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             (SELECT id FROM node WHERE external_mapping_id = 'Pfaff Rade'),
             'POST_RUN',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             (SELECT id FROM node WHERE external_mapping_id = 'STR'),
             'POST_RUN',
             250.00,
             400.00,
             425.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             (SELECT id FROM node WHERE external_mapping_id = 'Urban AB'),
             'POST_RUN',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             (SELECT id FROM node WHERE external_mapping_id = 'Urban Wörth'),
             'POST_RUN',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             (SELECT id FROM node WHERE external_mapping_id = 'VOP'),
             'POST_RUN',
             250.00,
             400.00,
             425.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             (SELECT id FROM node WHERE external_mapping_id = 'Zbůch'),
             'POST_RUN',
             250.00,
             400.00,
             425.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'ExM'),
             (SELECT id FROM node WHERE external_mapping_id = 'INJNPT'),
             'ROAD',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'FRLEH'),
             (SELECT id FROM node WHERE external_mapping_id = 'Bat3'),
             'POST_RUN',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'FRLEH'),
             (SELECT id FROM node WHERE external_mapping_id = 'CTT'),
             'POST_RUN',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'FRLEH'),
             (SELECT id FROM node WHERE external_mapping_id = 'Jeantet'),
             'POST_RUN',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Fuqin'),
             (SELECT id FROM node WHERE external_mapping_id = 'CNXMN'),
             'ROAD',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'HKMBP'),
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             'SEA',
             5000.00,
             5500.00,
             6000.00,
             45,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Hangzhou'),
             (SELECT id FROM node WHERE external_mapping_id = 'CNSHA'),
             'ROAD',
             372.00,
             535.00,
             562.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INJNPT'),
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             'SEA',
             10303.00,
             16885.00,
             17614.00,
             18,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INJNPT'),
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             'SEA',
             10311.00,
             16897.00,
             17627.00,
             18,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INJNPT'),
             (SELECT id FROM node WHERE external_mapping_id = 'FRLEH'),
             'SEA',
             9751.00,
             16002.00,
             16692.00,
             17,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INJNPT'),
             (SELECT id FROM node WHERE external_mapping_id = 'ITGOA'),
             'SEA',
             6025.00,
             9640.00,
             10342.00,
             11,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INMAA'),
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             'SEA',
             10347.00,
             16955.00,
             17688.00,
             18,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INMAA'),
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             'SEA',
             10355.00,
             16968.00,
             17702.00,
             18,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INMAA'),
             (SELECT id FROM node WHERE external_mapping_id = 'FRLEH'),
             'SEA',
             9795.00,
             16072.00,
             16765.00,
             17,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INMAA'),
             (SELECT id FROM node WHERE external_mapping_id = 'ITGOA'),
             'SEA',
             6069.00,
             9710.00,
             10417.00,
             11,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'ITGOA'),
             (SELECT id FROM node WHERE external_mapping_id = 'LZZ'),
             'POST_RUN',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'ITGOA'),
             (SELECT id FROM node WHERE external_mapping_id = 'Urban Rolo'),
             'POST_RUN',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'JJ'),
             (SELECT id FROM node WHERE external_mapping_id = 'CNXMN'),
             'ROAD',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Jinjiang'),
             (SELECT id FROM node WHERE external_mapping_id = 'CNXMN'),
             'ROAD',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'LX'),
             (SELECT id FROM node WHERE external_mapping_id = 'CNXMN'),
             'ROAD',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Linfen'),
             (SELECT id FROM node WHERE external_mapping_id = 'CNTAO'),
             'ROAD',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Linfen'),
             (SELECT id FROM node WHERE external_mapping_id = 'CNTGS'),
             'ROAD',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Pune'),
             (SELECT id FROM node WHERE external_mapping_id = 'ExM'),
             'ROAD',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Pune'),
             (SELECT id FROM node WHERE external_mapping_id = 'INJNPT'),
             'ROAD',
             200.00,
             300.00,
             350.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Pune'),
             (SELECT id FROM node WHERE external_mapping_id = 'INMAA'),
             'ROAD',
             250.00,
             400.00,
             425.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Qingdao'),
             (SELECT id FROM node WHERE external_mapping_id = 'CNTAO'),
             'ROAD',
             100.00,
             160.00,
             170.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Shanghai'),
             (SELECT id FROM node WHERE external_mapping_id = 'CNSHA'),
             'ROAD',
             127.00,
             144.00,
             147.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Taicang'),
             (SELECT id FROM node WHERE external_mapping_id = 'CNSHA'),
             'ROAD',
             183.00,
             263.00,
             276.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Xiamen'),
             (SELECT id FROM node WHERE external_mapping_id = 'CNXMN'),
             'ROAD',
             118.00,
             129.00,
             131.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Yangzhong'),
             (SELECT id FROM node WHERE external_mapping_id = 'CNSHA'),
             'ROAD',
             394.00,
             570.00,
             599.00,
             1,
             @validity_period_id
         );

INSERT INTO container_rate (
    from_node_id,
    to_node_id,
    container_rate_type,
    rate_teu,
    rate_feu,
    rate_hc,
    lead_time,
    validity_period_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Yantian'),
             (SELECT id FROM node WHERE external_mapping_id = 'CNYTN'),
             'ROAD',
             264.00,
             423.00,
             449.00,
             1,
             @validity_period_id
         );

