INSERT INTO
    Contracts (externalId, status, year, sapId, userId, deliveryPlaceId, proposedDeliveryPlaceId, itemGroupId, contractQuantity, deliveredQuantity, proposedQuantity, startDate, endDate, signDate, termDate, remarks, areaDetails, deliverAll, proposedDeliverAll, createdAt, updatedAt)
VALUES 
  ('930aa9e6-3e4a-11e8-8bde-3f4cb4e757aa', 'APPROVED', 2018, 'sapid-x1', '677e99fd-b854-479f-afa6-74f295052770', (SELECT id FROM DeliveryPlaces WHERE externalId = 'c17711ea-1a44-11e8-a7e4-5f91469b1a79'), (SELECT id FROM DeliveryPlaces WHERE externalId = 'c17711ea-1a44-11e8-a7e4-5f91469b1a79'), (SELECT id FROM ItemGroups WHERE externalId = '98be1d32-0f51-11e8-bb59-3b8b6bbe9a20'), 75200, 500, 75200, DATE('2020-01-05'), DATE('2020-05-01'), DATE('2019-11-03'), DATE('2020-01-06'), NULL, NULL, FALSE, FALSE, NOW(), NOW()),
  ('bdc59a1a-3e4a-11e8-b7c1-53a5303c293f', 'ON_HOLD', 2018, 'sapid-x2', '677e99fd-b854-479f-afa6-74f295052770', (SELECT id FROM DeliveryPlaces WHERE externalId = 'c17711ea-1a44-11e8-a7e4-5f91469b1a79'), (SELECT id FROM DeliveryPlaces WHERE externalId = 'c17711ea-1a44-11e8-a7e4-5f91469b1a79'), (SELECT id FROM ItemGroups WHERE externalId = '98be1d32-0f51-11e8-bb59-3b8b6bbe9a20'), 75200, 500, 75200, DATE('2020-01-05'), DATE('2020-05-01'), DATE('2019-11-03'), DATE('2020-01-06'), NULL, NULL, FALSE, FALSE, NOW(), NOW()),
  ('be2240b2-3e4a-11e8-82e8-075a90c2b0bf', 'DRAFT', 2018, 'sapid-x3', '677e99fd-b854-479f-afa6-74f295052770', (SELECT id FROM DeliveryPlaces WHERE externalId = 'c17711ea-1a44-11e8-a7e4-5f91469b1a79'), (SELECT id FROM DeliveryPlaces WHERE externalId = 'c17711ea-1a44-11e8-a7e4-5f91469b1a79'), (SELECT id FROM ItemGroups WHERE externalId = '98be1d32-0f51-11e8-bb59-3b8b6bbe9a20'), 75200, 500, 75200, DATE('2020-01-05'), DATE('2020-05-01'), DATE('2019-11-03'), DATE('2020-01-06'), NULL, NULL, FALSE, FALSE, NOW(), NOW()),
  ('be6c35dc-3e4a-11e8-9324-b3c1891fa540', 'TERMINATED', 2018, 'sapid-x4', '677e99fd-b854-479f-afa6-74f295052770', (SELECT id FROM DeliveryPlaces WHERE externalId = 'c17711ea-1a44-11e8-a7e4-5f91469b1a79'), (SELECT id FROM DeliveryPlaces WHERE externalId = 'c17711ea-1a44-11e8-a7e4-5f91469b1a79'), (SELECT id FROM ItemGroups WHERE externalId = '98be1d32-0f51-11e8-bb59-3b8b6bbe9a20'), 75200, 500, 75200, DATE('2020-01-05'), DATE('2020-05-01'), DATE('2019-11-03'), DATE('2020-01-06'), NULL, NULL, FALSE, FALSE, NOW(), NOW()),
  ('beb1ad74-3e4a-11e8-9c26-cb16081692a9', 'REJECTED', 2018, 'sapid-x5', '677e99fd-b854-479f-afa6-74f295052770', (SELECT id FROM DeliveryPlaces WHERE externalId = 'c17711ea-1a44-11e8-a7e4-5f91469b1a79'), (SELECT id FROM DeliveryPlaces WHERE externalId = 'c17711ea-1a44-11e8-a7e4-5f91469b1a79'), (SELECT id FROM ItemGroups WHERE externalId = '98be1d32-0f51-11e8-bb59-3b8b6bbe9a20'), 75200, 500, 75200, DATE('2020-01-05'), DATE('2020-05-01'), DATE('2019-11-03'), DATE('2020-01-06'), NULL, NULL, FALSE, FALSE, NOW(), NOW());