[BLOB]'##"
    ),
    'admin',
    1
  );
INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`,
    `CreatedID`
  )
VALUES
  (
    32,
    'TEST COMPANY',
    '',
    '0771452545',
    'testcompany@gmail.com',
    '',
    '',
    '',
    '0000-00-00',
    '2024-01-10',
    'No.14\r\nAatagf Road\r\nCanada',
    '',
    NULL,
    NOFORMAT_WRAP(
      "##X'[BLOB]'##"
    ),
    'Sajith Wickramasena',
    1
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: contractor_invoice_item_table
# ------------------------------------------------------------

INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (31, 21, 90, 210, '2024-01', 11, 5000.00, 5.00, 250.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (32, 21, 91, 210, '2024-01', 10, 28000.00, 5.00, 1400.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (33, 22, 92, 210, '2023-12', 10, 18000.00, 5.00, 900.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (34, 22, 93, 210, '2023-12', 11, 1500.00, 5.00, 75.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (35, 23, 96, 12, '2023-10', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (36, 23, 99, 12, '2023-10', 13, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (37, 23, 100, 12, '2023-10', 15, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (38, 24, 102, 210, '2023-09', 10, 50000.00, 5.00, 2500.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (39, 24, 105, 210, '2023-09', 11, 2500.00, 5.00, 125.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (40, 25, 109, 210, '2024-01', 10, 4500.00, 5.00, 225.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (41, 25, 110, 210, '2024-01', 11, 450.00, 5.00, 22.50);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (42, 26, 101, 212, '2024-01', 10, 52000.00, 3.00, 1560.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (43, 27, 112, 210, '2021-01', 10, 75000.00, 5.00, 3750.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (44, 27, 113, 210, '2021-01', 11, 7000.00, 5.00, 350.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (45, 28, 170, 210, '2024-01', 10, 200.00, 5.00, 10.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (46, 29, 114, 17, '2023-11', 12, 22910.98, 3.00, 687.33);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (47, 29, 118, 18, '2023-11', 12, 104.22, 3.00, 3.13);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (48, 29, 122, 20, '2023-11', 12, 18887.40, 3.00, 566.62);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (49, 29, 126, 21, '2023-11', 12, 5185.85, 3.00, 155.58);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (50, 29, 149, 24, '2023-11', 12, 17455.33, 3.00, 523.66);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (51, 29, 153, 12, '2023-11', 12, 5558.29, 3.00, 166.75);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (52, 29, 156, 30, '2023-11', 12, 3085.28, 3.00, 92.56);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (53, 30, 134, 26, '2023-11', 12, 1781.39, 2.50, 44.53);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (54, 31, 120, 16, '2023-11', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (55, 31, 130, 16, '2023-11', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (56, 31, 165, 15, '2023-11', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (57, 32, 115, 17, '2023-11', 13, 4099.51, 1.00, 41.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (58, 32, 123, 20, '2023-11', 13, 7838.36, 1.00, 78.38);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (59, 32, 127, 21, '2023-11', 13, 1612.20, 1.00, 16.12);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (60, 32, 137, 1, '2023-11', 13, 1030.00, 1.00, 10.30);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (61, 32, 142, 31, '2023-11', 13, 1240.00, 1.00, 12.40);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (62, 32, 150, 24, '2023-11', 13, 4390.86, 1.00, 43.91);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (63, 33, 293, 24, '2024-01', 12, 21012.89, 3.00, 630.39);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (64, 33, 297, 12, '2024-01', 12, 8736.32, 3.00, 262.09);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (65, 33, 358, 20, '2024-01', 12, 21577.36, 3.00, 647.32);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (66, 33, 362, 21, '2024-01', 12, 5784.21, 3.00, 173.53);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (67, 33, 408, 30, '2024-01', 12, 4929.00, 3.00, 147.87);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (68, 33, 410, 17, '2024-01', 12, 23182.50, 3.00, 695.48);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (69, 34, 322, 8, '2024-01', 12, 10250.11, 2.50, 256.25);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (70, 34, 325, 4, '2024-01', 12, 8736.32, 2.50, 218.41);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (71, 34, 326, 4, '2024-01', 13, 1295.00, 2.50, 32.38);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (72, 34, 328, 10, '2024-01', 12, 1372.47, 2.50, 34.31);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (73, 34, 330, 19, '2024-01', 12, 5910.83, 2.50, 147.77);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (74, 34, 332, 6, '2024-01', 12, 13302.12, 2.50, 332.55);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (75, 34, 335, 37, '2024-01', 19, 13708.58, 2.50, 342.71);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (76, 34, 336, 37, '2024-01', 20, 28408.13, 2.50, 710.20);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (77, 35, 294, 24, '2024-01', 13, 3618.51, 1.00, 36.19);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (78, 35, 338, 2, '2024-01', 13, 3368.80, 1.00, 33.69);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (79, 35, 343, 13, '2024-01', 13, 1725.45, 1.00, 17.25);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (80, 35, 347, 34, '2024-01', 13, 3101.60, 1.00, 31.02);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (81, 35, 359, 20, '2024-01', 13, 6633.52, 1.00, 66.34);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (82, 35, 363, 21, '2024-01', 13, 1840.55, 1.00, 18.41);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (83, 35, 411, 17, '2024-01', 13, 2211.54, 1.00, 22.12);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (84, 36, 371, 17, '2024-02', 12, 12753.19, 3.00, 382.60);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (85, 36, 375, 20, '2024-02', 12, 16198.61, 3.00, 485.96);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (86, 36, 379, 21, '2024-02', 12, 4636.53, 3.00, 139.10);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (87, 36, 420, 12, '2024-02', 12, 8562.59, 3.00, 256.88);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (88, 36, 423, 30, '2024-02', 12, 2451.70, 3.00, 73.55);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (89, 36, 448, 24, '2024-02', 12, 14989.87, 3.00, 449.70);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (90, 37, 385, 26, '2024-02', 12, 924.12, 2.50, 23.10);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (91, 37, 442, 8, '2024-02', 12, 9386.17, 2.50, 234.65);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (92, 37, 445, 4, '2024-02', 12, 8682.72, 2.50, 217.07);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (93, 37, 446, 4, '2024-02', 13, 6403.84, 2.50, 160.10);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (94, 37, 449, 10, '2024-02', 12, 1539.61, 2.50, 38.49);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (95, 37, 452, 19, '2024-02', 12, 6706.48, 2.50, 167.66);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (96, 37, 455, 6, '2024-02', 12, 5444.27, 2.50, 136.11);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (97, 37, 459, 37, '2024-02', 19, 10861.88, 2.50, 271.55);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (98, 37, 460, 37, '2024-02', 20, 10051.03, 2.50, 251.28);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (99, 38, 372, 17, '2024-02', 13, 5461.06, 1.00, 54.61);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (100, 38, 376, 20, '2024-02', 13, 7256.12, 1.00, 72.56);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (101, 38, 380, 21, '2024-02', 13, 2458.37, 1.00, 24.58);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (102, 38, 392, 31, '2024-02', 13, 747.45, 1.00, 7.47);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (103, 38, 401, 34, '2024-02', 13, 2963.08, 1.00, 29.63);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (104, 38, 417, 24, '2024-02', 13, 2710.29, 1.00, 27.10);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (105, 38, 425, 7, '2024-02', 13, 1500.58, 1.00, 15.01);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (106, 38, 433, 15, '2024-02', 13, 300.00, 1.00, 3.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (107, 38, 435, 14, '2024-02', 13, 1004.09, 1.00, 10.04);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (108, 38, 462, 2, '2024-02', 13, 3103.92, 1.00, 31.04);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (109, 38, 467, 13, '2024-02', 13, 2955.68, 1.00, 29.56);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (110, 39, 382, 16, '2024-02', 12, 1813.85, 2.00, 36.28);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (111, 39, 434, 14, '2024-02', 12, 983.07, 2.00, 19.66);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (112, 40, 476, 17, '2024-03', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (113, 40, 480, 20, '2024-03', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (114, 40, 484, 21, '2024-03', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (115, 40, 525, 24, '2024-03', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (116, 40, 541, 30, '2024-03', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (117, 40, 583, 12, '2024-03', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (118, 41, 542, 8, '2024-03', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (119, 41, 546, 4, '2024-03', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (120, 41, 547, 4, '2024-03', 13, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (121, 41, 561, 10, '2024-03', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (122, 41, 564, 19, '2024-03', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (123, 41, 567, 6, '2024-03', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (124, 41, 578, 37, '2024-03', 19, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (125, 41, 579, 37, '2024-03', 20, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (126, 42, 487, 16, '2024-03', 12, 2089.76, 2.00, 41.80);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (127, 42, 552, 14, '2024-03', 12, 2107.45, 2.00, 42.15);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (128, 43, 477, 17, '2024-03', 13, 2243.03, 1.00, 22.43);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (129, 43, 481, 20, '2024-03', 13, 3249.20, 1.00, 32.49);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (130, 43, 485, 21, '2024-03', 13, 1480.00, 1.00, 14.80);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (131, 43, 495, 1, '2024-03', 13, 1105.55, 1.00, 11.06);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (132, 43, 498, 31, '2024-03', 13, 270.00, 1.00, 2.70);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (133, 43, 505, 214, '2024-03', 13, 7968.76, 1.00, 79.69);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (134, 43, 510, 34, '2024-03', 13, 2207.90, 1.00, 22.08);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (135, 43, 526, 24, '2024-03', 13, 1487.30, 1.00, 14.87);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (136, 43, 534, 2, '2024-03', 13, 1772.94, 1.00, 17.73);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (137, 43, 553, 14, '2024-03', 13, 345.00, 1.00, 3.45);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (138, 43, 581, 7, '2024-03', 13, 674.73, 1.00, 6.75);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (139, 44, 476, 17, '2024-03', 12, 7648.83, 3.00, 229.46);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (140, 44, 484, 21, '2024-03', 12, 2474.24, 3.00, 74.23);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (141, 44, 525, 24, '2024-03', 12, 11890.68, 3.00, 356.72);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (142, 44, 541, 30, '2024-03', 12, 2779.40, 3.00, 83.38);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (143, 44, 583, 12, '2024-03', 12, 9832.92, 3.00, 294.99);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (144, 44, 586, 20, '2024-03', 12, 14733.60, 3.00, 442.01);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (145, 45, 542, 8, '2024-03', 12, 8609.93, 2.50, 215.25);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (146, 45, 546, 4, '2024-03', 12, 7433.02, 2.50, 185.83);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (147, 45, 547, 4, '2024-03', 13, 5738.32, 2.50, 143.46);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (148, 45, 561, 10, '2024-03', 12, 258.78, 2.50, 6.47);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (149, 45, 564, 19, '2024-03', 12, 6970.27, 2.50, 174.26);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (150, 45, 567, 6, '2024-03', 12, 28265.94, 2.50, 706.65);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (151, 45, 578, 37, '2024-03', 19, 22159.91, 2.50, 554.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (152, 45, 579, 37, '2024-03', 20, 25036.64, 2.50, 625.92);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (153, 45, 587, 26, '2024-03', 12, 109.97, 2.50, 2.75);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (154, 46, 592, 17, '2024-04', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (155, 46, 596, 18, '2024-04', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (156, 46, 627, 12, '2024-04', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (157, 46, 628, 12, '2024-04', 13, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (158, 46, 630, 30, '2024-04', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (159, 46, 659, 24, '2024-04', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (160, 46, 689, 20, '2024-04', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (161, 46, 694, 21, '2024-04', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (162, 47, 589, 26, '2024-04', 12, 895.50, 2.50, 22.39);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (163, 47, 641, 8, '2024-04', 12, 12924.32, 2.50, 323.11);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (164, 47, 644, 4, '2024-04', 12, 13319.62, 2.50, 332.99);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (165, 47, 645, 4, '2024-04', 13, 5099.29, 2.50, 127.48);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (166, 47, 647, 10, '2024-04', 12, 486.13, 2.50, 12.15);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (167, 47, 650, 19, '2024-04', 12, 9955.89, 2.50, 248.90);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (168, 47, 653, 6, '2024-04', 12, 31813.15, 2.50, 795.33);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (169, 47, 657, 37, '2024-04', 19, 53599.40, 2.50, 1339.99);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (170, 47, 658, 37, '2024-04', 20, 15391.08, 2.50, 384.78);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (171, 48, 599, 16, '2024-04', 12, 1196.39, 2.00, 23.93);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (172, 48, 666, 14, '2024-04', 12, 1572.88, 2.00, 31.46);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (173, 49, 593, 17, '2024-04', 13, 1088.48, 1.00, 10.88);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (174, 49, 603, 1, '2024-04', 13, 1455.00, 1.00, 14.55);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (175, 49, 608, 31, '2024-04', 13, 1767.81, 1.00, 17.68);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (176, 49, 615, 214, '2024-04', 13, 4183.16, 1.00, 41.83);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (177, 49, 620, 34, '2024-04', 13, 2768.30, 1.00, 27.68);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (178, 49, 632, 7, '2024-04', 13, 825.40, 1.00, 8.25);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (179, 49, 660, 24, '2024-04', 13, 2300.00, 1.00, 23.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (180, 49, 664, 15, '2024-04', 13, 420.00, 1.00, 4.20);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (181, 49, 674, 2, '2024-04', 13, 1865.32, 1.00, 18.65);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (182, 49, 679, 13, '2024-04', 13, 1245.00, 1.00, 12.45);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (183, 49, 690, 20, '2024-04', 13, 6945.21, 1.00, 69.45);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (184, 49, 695, 21, '2024-04', 13, 615.08, 1.00, 6.15);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (185, 50, 592, 17, '2024-04', 12, 9094.51, 3.00, 272.84);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (186, 50, 596, 18, '2024-04', 12, 1077.56, 3.00, 32.33);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (187, 50, 627, 12, '2024-04', 12, 9372.97, 3.00, 281.19);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (188, 50, 628, 12, '2024-04', 13, 1215.00, 3.00, 36.45);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (189, 50, 630, 30, '2024-04', 12, 4143.80, 3.00, 124.31);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (190, 50, 659, 24, '2024-04', 12, 27391.98, 3.00, 821.76);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (191, 50, 689, 20, '2024-04', 12, 21312.10, 3.00, 639.36);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (192, 50, 694, 21, '2024-04', 12, 3293.65, 3.00, 98.81);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (193, 51, 698, 17, '2024-05', 12, 2832.19, 3.00, 84.97);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (194, 51, 726, 12, '2024-05', 12, 11308.88, 3.00, 339.27);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (195, 51, 729, 30, '2024-05', 12, 4851.65, 3.00, 145.55);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (196, 51, 775, 20, '2024-05', 12, 16275.25, 3.00, 488.26);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (197, 51, 780, 21, '2024-05', 12, 4779.88, 3.00, 143.40);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (198, 52, 704, 16, '2024-05', 12, 5170.89, 2.00, 103.42);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (199, 52, 735, 15, '2024-05', 12, 1757.32, 2.00, 35.15);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (200, 52, 738, 14, '2024-05', 12, 1995.28, 2.00, 39.91);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (201, 53, 686, 1, '2024-05', 13, 905.00, 1.00, 9.05);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (202, 53, 699, 17, '2024-05', 13, 171.00, 1.00, 1.71);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (203, 53, 702, 7, '2024-05', 13, 811.04, 1.00, 8.11);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (204, 53, 711, 31, '2024-05', 13, 548.87, 1.00, 5.49);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (205, 53, 714, 214, '2024-05', 13, 4096.53, 1.00, 40.97);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (206, 53, 719, 24, '2024-05', 13, 855.00, 1.00, 8.55);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (207, 53, 736, 15, '2024-05', 13, 492.51, 1.00, 4.93);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (208, 53, 739, 14, '2024-05', 13, 535.82, 1.00, 5.36);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (209, 53, 761, 2, '2024-05', 13, 2525.94, 1.00, 25.26);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (210, 53, 766, 13, '2024-05', 13, 410.42, 1.00, 4.10);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (211, 53, 776, 20, '2024-05', 13, 7080.21, 1.00, 70.80);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (212, 53, 781, 21, '2024-05', 13, 1595.00, 1.00, 15.95);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (213, 53, 788, 34, '2024-05', 13, 2963.98, 1.00, 29.64);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (214, 54, 813, 24, '2024-05', 12, 32181.25, 3.00, 965.44);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (215, 55, 792, 17, '2024-06', 12, 1529.53, 3.00, 45.89);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (216, 55, 835, 24, '2024-06', 12, 18255.13, 3.00, 547.65);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (217, 55, 839, 12, '2024-06', 12, 9734.30, 3.00, 292.03);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (218, 55, 842, 30, '2024-06', 12, 3588.34, 3.00, 107.65);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (219, 55, 887, 20, '2024-06', 12, 20808.49, 3.00, 624.25);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (220, 55, 892, 21, '2024-06', 12, 5242.29, 3.00, 157.27);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (221, 56, 795, 16, '2024-06', 12, 1822.86, 2.00, 36.46);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (222, 56, 854, 14, '2024-06', 12, 1807.29, 2.00, 36.15);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (223, 56, 864, 217, '2024-06', 12, 4313.75, 2.00, 86.28);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (224, 57, 793, 17, '2024-06', 13, 1839.70, 1.00, 18.40);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (225, 57, 802, 1, '2024-06', 13, 900.00, 1.00, 9.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (226, 57, 806, 31, '2024-06', 13, 873.45, 1.00, 8.73);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (227, 57, 810, 34, '2024-06', 13, 3173.31, 1.00, 31.73);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (228, 57, 836, 24, '2024-06', 13, 4683.50, 1.00, 46.84);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (229, 57, 845, 7, '2024-06', 13, 500.45, 1.00, 5.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (230, 57, 855, 14, '2024-06', 13, 410.00, 1.00, 4.10);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (231, 57, 876, 2, '2024-06', 13, 2810.76, 1.00, 28.11);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (232, 57, 881, 13, '2024-06', 13, 325.00, 1.00, 3.25);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (233, 57, 888, 20, '2024-06', 13, 7311.62, 1.00, 73.12);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (234, 57, 893, 21, '2024-06', 13, 3317.75, 1.00, 33.18);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (235, 57, 895, 214, '2024-06', 13, 3284.56, 1.00, 32.85);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (236, 58, 871, 6, '2024-06', 12, 44673.36, 1.50, 670.10);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (237, 59, 814, 19, '2024-06', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (238, 60, 814, 19, '2024-06', 12, 14345.55, 1.50, 215.18);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (239, 60, 915, 6, '2024-06', 12, 44673.36, 1.50, 670.10);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (240, 61, 952, 221, '2024-01', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (241, 62, 919, 17, '2024-07', 12, 6942.74, 3.00, 208.28);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (242, 62, 922, 20, '2024-07', 12, 14596.41, 3.00, 437.89);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (243, 62, 927, 21, '2024-07', 12, 2056.47, 3.00, 61.69);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (244, 62, 955, 24, '2024-07', 12, 28850.76, 3.00, 865.52);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (245, 62, 959, 12, '2024-07', 12, 6158.88, 3.00, 184.77);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (246, 63, 930, 16, '2024-07', 12, 2665.22, 2.00, 53.30);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (247, 63, 976, 14, '2024-07', 12, 2824.04, 2.00, 56.48);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (248, 63, 989, 217, '2024-07', 12, 1283.60, 2.00, 25.67);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (249, 64, 920, 17, '2024-07', 13, 165.22, 1.00, 1.65);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (250, 64, 923, 20, '2024-07', 13, 6862.49, 1.00, 68.62);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (251, 64, 928, 21, '2024-07', 13, 1085.66, 1.00, 10.86);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (252, 64, 937, 1, '2024-07', 13, 950.00, 1.00, 9.50);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (253, 64, 941, 31, '2024-07', 13, 1366.38, 1.00, 13.66);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (254, 64, 945, 34, '2024-07', 13, 2648.73, 1.00, 26.49);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (255, 64, 948, 214, '2024-07', 13, 3209.80, 1.00, 32.10);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (256, 64, 956, 24, '2024-07', 13, 1690.20, 1.00, 16.90);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (257, 64, 974, 15, '2024-07', 13, 436.50, 1.00, 4.37);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (258, 64, 977, 14, '2024-07', 13, 300.00, 1.00, 3.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (259, 64, 980, 7, '2024-07', 13, 601.00, 1.00, 6.01);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (260, 64, 1007, 2, '2024-07', 13, 1245.92, 1.00, 12.46);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (261, 65, 999, 19, '2024-07', 12, 3309.51, 1.50, 49.64);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (262, 65, 1002, 6, '2024-07', 12, 35211.01, 1.50, 528.17);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (263, 66, 1129, 30, '2024-03', 12, 74.97, 3.00, 2.25);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (264, 67, 1130, 30, '2024-04', 12, 329.91, 3.00, 9.90);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (265, 68, 1131, 30, '2024-05', 12, 1014.75, 3.00, 30.44);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (266, 69, 1132, 30, '2024-06', 12, 1520.29, 3.00, 45.61);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (267, 70, 1124, 30, '2024-07', 12, 6158.88, 3.00, 184.77);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (268, 71, 1135, 12, '2024-07', 12, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (269, 72, 1138, 12, '2024-07', 12, 1469.29, 3.00, 44.08);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (270, 73, 1028, 17, '2024-08', 12, 252.30, 3.00, 7.57);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (271, 73, 1031, 20, '2024-08', 12, 22724.01, 3.00, 681.72);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (272, 73, 1036, 21, '2024-08', 12, 6451.95, 3.00, 193.56);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (273, 73, 1065, 24, '2024-08', 12, 22847.27, 3.00, 685.42);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (274, 73, 1090, 30, '2024-08', 12, 4233.80, 3.00, 127.01);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (275, 73, 1136, 12, '2024-08', 12, 9476.67, 3.00, 284.30);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (276, 74, 1103, 19, '2024-08', 12, 10512.14, 1.50, 157.68);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (277, 74, 1106, 6, '2024-08', 12, 26696.99, 1.50, 400.45);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (278, 75, 1047, 16, '2024-08', 12, 2570.44, 2.00, 51.41);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (279, 75, 1092, 217, '2024-08', 12, 1004.22, 2.00, 20.08);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (280, 75, 1139, 14, '2024-08', 12, 4533.98, 2.00, 90.68);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (281, 76, 1029, 17, '2024-08', 13, 0.00, 1.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (282, 76, 1032, 20, '2024-08', 13, 7006.10, 1.00, 70.06);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (283, 76, 1037, 21, '2024-08', 13, 2105.06, 1.00, 21.05);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (284, 76, 1044, 34, '2024-08', 13, 3671.27, 1.00, 36.71);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (285, 76, 1054, 1, '2024-08', 13, 1775.38, 1.00, 17.75);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (286, 76, 1058, 31, '2024-08', 13, 705.00, 1.00, 7.05);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (287, 76, 1061, 214, '2024-08', 13, 2597.30, 1.00, 25.97);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (288, 76, 1066, 24, '2024-08', 13, 3019.12, 1.00, 30.19);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (289, 76, 1074, 7, '2024-08', 13, 385.12, 1.00, 3.85);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (290, 76, 1081, 29, '2024-08', 13, 719.12, 1.00, 7.19);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (291, 76, 1084, 14, '2024-08', 13, 230.00, 1.00, 2.30);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (292, 76, 1087, 216, '2024-08', 13, 2205.13, 1.00, 22.05);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (293, 76, 1113, 2, '2024-08', 13, 5193.11, 1.00, 51.93);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (294, 76, 1118, 13, '2024-08', 13, 1153.20, 1.00, 11.53);

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: contractor_invoice_table
# ------------------------------------------------------------

INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    21,
    'CIN000001',
    '2024-01-09',
    48,
    '2024-01',
    '2024-01-23',
    33000.00,
    1650.00,
    1650.00,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    'Fahad Razzaq',
    58,
    '2024-01-09',
    NULL,
    NULL,
    NULL,
    32
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    22,
    'CIN000002',
    '2024-01-09',
    48,
    '2023-12',
    '2024-01-23',
    19500.00,
    975.00,
    975.00,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    'Fahad Razzaq',
    58,
    '2024-01-09',
    NULL,
    NULL,
    NULL,
    32
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    23,
    'CIN000003',
    '2023-12-06',
    38,
    '2023-10',
    '2023-12-26',
    0.00,
    0.00,
    0.00,
    0.00,
    NULL,
    'CANCELLED',
    'Manual',
    0,
    'Irish  Smith',
    2,
    '2024-01-10',
    'Irish  Smith',
    2,
    '2024-01-16',
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    24,
    'CIN000004',
    '2024-01-11',
    48,
    '2023-09',
    '2024-01-25',
    52500.00,
    2625.00,
    0.00,
    2625.00,
    '',
    'PAID',
    'Auto',
    0,
    'Fahad Razzaq',
    58,
    '2024-01-11',
    NULL,
    NULL,
    NULL,
    32
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    25,
    'CIN000005',
    '2024-01-14',
    48,
    '2024-01',
    '2024-01-28',
    4950.00,
    247.50,
    247.50,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    'Fahad Razzaq',
    58,
    '2024-01-14',
    NULL,
    NULL,
    NULL,
    32
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    26,
    'CIN000006',
    '2024-01-14',
    49,
    '2024-01',
    '2024-01-28',
    52000.00,
    1560.00,
    1560.00,
    0.00,
    '',
    'UNPAID',
    'Auto',
    1,
    'Fahad Razzaq',
    58,
    '2024-01-14',
    NULL,
    NULL,
    NULL,
    32
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    27,
    'CIN000007',
    '2024-01-16',
    48,
    '2021-01',
    '2024-01-30',
    82000.00,
    4100.00,
    4100.00,
    0.00,
    '',
    'UNPAID',
    'Auto',
    1,
    'Fahad Razzaq',
    58,
    '2024-01-16',
    NULL,
    NULL,
    NULL,
    32
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    28,
    'CIN000008',
    '2024-02-23',
    48,
    '2024-01',
    '2024-03-08',
    200.00,
    10.00,
    10.00,
    0.00,
    '',
    'UNPAID',
    'Auto',
    1,
    'Fahad Razzaq',
    58,
    '2024-02-23',
    NULL,
    NULL,
    NULL,
    32
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    29,
    'CIN000009',
    '2024-03-11',
    38,
    '2023-11',
    '2024-03-25',
    73187.35,
    2195.63,
    2195.63,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    'Irish  Smith',
    2,
    '2024-03-11',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    30,
    'CIN000010',
    '2024-03-11',
    39,
    '2023-11',
    '2024-03-25',
    1781.39,
    44.53,
    44.53,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    'Irish  Smith',
    2,
    '2024-03-11',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    31,
    'CIN000011',
    '2024-03-11',
    42,
    '2023-11',
    '2024-03-25',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    0,
    'Irish  Smith',
    2,
    '2024-03-11',
    'Irish  Smith',
    2,
    '2024-03-11',
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    32,
    'CIN000012',
    '2024-03-11',
    47,
    '2023-11',
    '2024-03-25',
    20210.93,
    202.11,
    202.11,
    0.00,
    '',
    'UNPAID',
    'Auto',
    1,
    'Irish  Smith',
    2,
    '2024-03-11',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    33,
    'CIN000013',
    '2024-03-22',
    38,
    '2024-01',
    '2024-03-26',
    85222.28,
    2556.68,
    2556.68,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    0,
    'Irish  Smith',
    2,
    '2024-03-22',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    34,
    'CIN000014',
    '2024-03-22',
    39,
    '2024-01',
    '2024-03-26',
    82983.56,
    2074.58,
    2074.58,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    0,
    'Irish  Smith',
    2,
    '2024-03-22',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    35,
    'CIN000015',
    '2024-03-22',
    47,
    '2024-01',
    '2024-03-26',
    22499.97,
    225.02,
    225.02,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    0,
    'Irish  Smith',
    2,
    '2024-03-22',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    36,
    'CIN000016',
    '2024-04-19',
    38,
    '2024-02',
    '2024-04-26',
    59592.49,
    1787.79,
    1787.79,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-04-19',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    37,
    'CIN000017',
    '2024-04-19',
    39,
    '2024-02',
    '2024-04-26',
    60000.12,
    1500.01,
    1500.01,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-04-19',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    38,
    'CIN000018',
    '2024-04-19',
    47,
    '2024-02',
    '2024-04-26',
    30460.64,
    304.60,
    304.60,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-04-19',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    39,
    'CIN000019',
    '2024-04-19',
    42,
    '2024-02',
    '2024-04-26',
    2796.92,
    55.94,
    55.94,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-04-19',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    40,
    'CIN000020',
    '2024-05-14',
    38,
    '2024-03',
    '2024-05-28',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    1,
    'Fahad Razzaq',
    58,
    '2024-05-14',
    'Irish  Smith',
    2,
    '2024-05-20',
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    41,
    'CIN000021',
    '2024-05-14',
    39,
    '2024-03',
    '2024-05-28',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    1,
    'Fahad Razzaq',
    58,
    '2024-05-14',
    'Irish  Smith',
    2,
    '2024-05-20',
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    42,
    'CIN000022',
    '2024-05-14',
    42,
    '2024-03',
    '2024-05-28',
    4197.21,
    83.95,
    0.00,
    83.95,
    '',
    'PAID',
    'Auto',
    1,
    'Fahad Razzaq',
    58,
    '2024-05-14',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    43,
    'CIN000023',
    '2024-05-14',
    47,
    '2024-03',
    '2024-05-28',
    22804.41,
    228.05,
    228.05,
    0.00,
    '',
    'UNPAID',
    'Auto',
    1,
    'Fahad Razzaq',
    58,
    '2024-05-14',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    44,
    'CIN000024',
    '2024-05-20',
    38,
    '2024-03',
    '2024-05-26',
    49359.67,
    1480.79,
    0.00,
    1480.79,
    NULL,
    'PAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-05-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    45,
    'CIN000025',
    '2024-05-20',
    39,
    '2024-03',
    '2024-05-26',
    104582.78,
    2614.59,
    0.00,
    2614.59,
    NULL,
    'PAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-05-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    46,
    'CIN000026',
    '2024-06-25',
    38,
    '2024-04',
    '2024-07-09',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    0,
    'Irish  Smith',
    2,
    '2024-06-25',
    'Irish  Smith',
    2,
    '2024-06-25',
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    47,
    'CIN000027',
    '2024-06-25',
    39,
    '2024-04',
    '2024-07-09',
    143484.38,
    3587.12,
    3587.12,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    'Irish  Smith',
    2,
    '2024-06-25',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    48,
    'CIN000028',
    '2024-06-25',
    42,
    '2024-04',
    '2024-07-09',
    2769.27,
    55.39,
    55.39,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    'Irish  Smith',
    2,
    '2024-06-25',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    49,
    'CIN000029',
    '2024-06-25',
    47,
    '2024-04',
    '2024-07-09',
    25478.76,
    254.77,
    254.77,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    'Irish  Smith',
    2,
    '2024-06-25',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    50,
    'CIN000030',
    '2024-06-25',
    38,
    '2024-04',
    '2024-06-26',
    76901.57,
    2307.05,
    2307.05,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    0,
    'Irish  Smith',
    2,
    '2024-06-25',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    51,
    'CIN000031',
    '2024-07-25',
    38,
    '2024-05',
    '2024-08-08',
    40047.85,
    1201.45,
    0.00,
    1201.45,
    '',
    'PAID',
    'Auto',
    0,
    'Irish  Smith',
    2,
    '2024-07-25',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    52,
    'CIN000032',
    '2024-07-25',
    42,
    '2024-05',
    '2024-08-08',
    8923.49,
    178.48,
    0.00,
    178.48,
    '',
    'PAID',
    'Auto',
    0,
    'Irish  Smith',
    2,
    '2024-07-25',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    53,
    'CIN000033',
    '2024-07-25',
    47,
    '2024-05',
    '2024-07-26',
    22991.32,
    229.92,
    0.00,
    229.92,
    '',
    'PAID',
    'Auto',
    0,
    'Irish  Smith',
    2,
    '2024-07-25',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    54,
    'CIN000034',
    '2024-07-25',
    38,
    '2024-05',
    '2024-07-26',
    32181.25,
    965.44,
    0.00,
    965.44,
    NULL,
    'PAID',
    'Manual',
    0,
    'Irish  Smith',
    2,
    '2024-07-29',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    55,
    'CIN000035',
    '2024-08-06',
    38,
    '2024-06',
    '2024-08-26',
    59158.08,
    1774.74,
    0.00,
    1774.74,
    '',
    'PAID',
    'Auto',
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    56,
    'CIN000036',
    '2024-08-06',
    42,
    '2024-06',
    '2024-08-26',
    7943.90,
    158.89,
    158.89,
    0.00,
    '',
    'UNPAID',
    'Auto',
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    57,
    'CIN000037',
    '2024-08-06',
    47,
    '2024-06',
    '2024-08-26',
    29430.10,
    294.31,
    294.31,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    58,
    'CIN000038',
    '2024-08-06',
    52,
    '2024-06',
    '2024-08-20',
    44673.36,
    670.10,
    670.10,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    59,
    'CIN000039',
    '2024-08-06',
    53,
    '2024-06',
    '2024-08-20',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    0,
    'Irish  Smith',
    2,
    '2024-08-06',
    'Irish  Smith',
    2,
    '2024-08-07',
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    60,
    'CIN000040',
    '2024-08-14',
    53,
    '2024-06',
    '2024-08-26',
    59018.91,
    885.28,
    0.00,
    885.28,
    NULL,
    'PAID',
    'Manual',
    0,
    'Irish  Smith',
    2,
    '2024-08-13',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    61,
    'CIN000041',
    '2024-01-01',
    50,
    '2024-01',
    '2024-01-01',
    0.00,
    0.00,
    0.00,
    0.00,
    NULL,
    'CANCELLED',
    'Manual',
    1,
    'Fahad Razzaq',
    58,
    '2024-09-03',
    'Fahad Razzaq',
    58,
    '2024-09-03',
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    62,
    'CIN000042',
    '2024-09-24',
    38,
    '2024-07',
    '2024-09-26',
    58605.26,
    1758.15,
    0.00,
    1758.15,
    'Danielle is missing from this invoice, we have to go back and recalculate all her invoices and the difference will reflect on next months invoice ',
    'PAID',
    'Auto',
    1,
    'Irish  Smith',
    2,
    '2024-09-24',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    63,
    'CIN000043',
    '2024-09-24',
    42,
    '2024-07',
    '2024-09-26',
    6772.86,
    135.45,
    0.00,
    135.45,
    '',
    'PAID',
    'Auto',
    1,
    'Irish  Smith',
    2,
    '2024-09-24',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    64,
    'CIN000044',
    '2024-09-24',
    47,
    '2024-07',
    '2024-09-26',
    20561.90,
    205.62,
    0.00,
    205.62,
    '',
    'PAID',
    'Auto',
    1,
    'Irish  Smith',
    2,
    '2024-09-24',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    65,
    'CIN000045',
    '2024-09-24',
    53,
    '2024-07',
    '2024-09-26',
    38520.52,
    577.81,
    0.00,
    577.81,
    '',
    'PAID',
    'Auto',
    1,
    'Irish  Smith',
    2,
    '2024-09-24',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    66,
    'CIN000046',
    '2024-10-01',
    38,
    '2024-03',
    '2024-10-09',
    74.97,
    2.25,
    0.00,
    2.25,
    'additional CF income',
    'PAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    67,
    'CIN000047',
    '2024-10-01',
    38,
    '2024-04',
    '2024-10-09',
    329.91,
    9.90,
    0.00,
    9.90,
    'additional CF income',
    'PAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    68,
    'CIN000048',
    '2024-10-01',
    38,
    '2024-05',
    '2024-10-09',
    1014.75,
    30.44,
    0.00,
    30.44,
    'additional BCBS income BCBS posted 8/13/2024',
    'PAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    69,
    'CIN000049',
    '2024-10-01',
    38,
    '2024-06',
    '2024-10-09',
    1520.29,
    45.61,
    0.00,
    45.61,
    'additional BCBS income BCBS posted 8/13/2024',
    'PAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    70,
    'CIN000050',
    '2024-10-01',
    38,
    '2024-07',
    '2024-10-09',
    6158.88,
    184.77,
    0.00,
    184.77,
    'additional BCBS income BCBS posted 8/13/2024',
    'PAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    71,
    'CIN000051',
    '2024-10-01',
    38,
    '2024-07',
    '2024-10-09',
    0.00,
    0.00,
    0.00,
    0.00,
    'corrected invoice',
    'CANCELLED',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-09-30',
    'Irish  Smith',
    2,
    '2024-10-01',
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    72,
    'CIN000052',
    '2024-10-01',
    38,
    '2024-07',
    '2024-10-09',
    1469.29,
    44.08,
    0.00,
    44.08,
    'correct income for JH',
    'PAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-10-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    73,
    'CIN000053',
    '2024-10-15',
    38,
    '2024-08',
    '2024-10-26',
    65986.00,
    1979.58,
    1979.58,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-10-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    74,
    'CIN000054',
    '2024-10-15',
    53,
    '2024-08',
    '2024-10-26',
    37209.13,
    558.13,
    558.13,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-10-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    75,
    'CIN000055',
    '2024-10-15',
    42,
    '2024-08',
    '2024-10-26',
    8108.64,
    162.17,
    162.17,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-10-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    76,
    'CIN000056',
    '2024-10-15',
    47,
    '2024-08',
    '2024-10-26',
    30764.91,
    307.63,
    307.63,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    1,
    'Irish  Smith',
    2,
    '2024-10-15',
    NULL,
    NULL,
    NULL,
    1
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: contractor_payment_item_table
# ------------------------------------------------------------

INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    24,
    16,
    24,
    '2024-01-11',
    'CIN000004',
    2625.00,
    2625.00,
    2625.00
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    25,
    17,
    45,
    '2024-05-20',
    'CIN000025',
    2614.59,
    2614.59,
    2614.59
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    26,
    18,
    42,
    '2024-05-14',
    'CIN000022',
    83.95,
    83.95,
    83.95
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    27,
    19,
    44,
    '2024-05-20',
    'CIN000024',
    1480.79,
    1480.79,
    1480.79
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    28,
    20,
    53,
    '2024-07-25',
    'CIN000033',
    229.92,
    229.92,
    229.92
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    29,
    21,
    52,
    '2024-07-25',
    'CIN000032',
    178.48,
    178.48,
    178.48
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    30,
    22,
    51,
    '2024-07-25',
    'CIN000031',
    1201.45,
    1201.45,
    1201.45
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    31,
    23,
    54,
    '2024-07-25',
    'CIN000034',
    965.44,
    965.44,
    965.44
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    32,
    24,
    55,
    '2024-08-06',
    'CIN000035',
    1774.74,
    1774.74,
    1774.74
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (33, 25, 55, '2024-08-06', 'CIN000035', 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    34,
    26,
    62,
    '2024-09-24',
    'CIN000042',
    1758.15,
    1758.15,
    1758.15
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    35,
    27,
    55,
    '2024-08-06',
    'CIN000035',
    1774.74,
    1774.74,
    1774.74
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (36, 28, 66, '2024-10-01', 'CIN000046', 2.25, 2.25, 2.25);
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (37, 28, 67, '2024-10-01', 'CIN000047', 9.90, 9.90, 9.90);
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    38,
    28,
    68,
    '2024-10-01',
    'CIN000048',
    30.44,
    30.44,
    30.44
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    39,
    28,
    69,
    '2024-10-01',
    'CIN000049',
    45.61,
    45.61,
    45.61
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    40,
    28,
    70,
    '2024-10-01',
    'CIN000050',
    184.77,
    184.77,
    184.77
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    41,
    28,
    72,
    '2024-10-01',
    'CIN000052',
    44.08,
    44.08,
    44.08
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    42,
    29,
    64,
    '2024-09-24',
    'CIN000044',
    205.62,
    205.62,
    205.62
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    43,
    30,
    63,
    '2024-09-24',
    'CIN000043',
    135.45,
    135.45,
    135.45
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    44,
    31,
    65,
    '2024-09-24',
    'CIN000045',
    577.81,
    577.81,
    577.81
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    45,
    32,
    60,
    '2024-08-14',
    'CIN000040',
    885.28,
    885.28,
    885.28
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: contractor_payment_table
# ------------------------------------------------------------

INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    16,
    'CRE000001',
    '2024-01-11',
    48,
    'Cash',
    NULL,
    2625.00,
    'POSTED',
    'Fahad Razzaq',
    58,
    '2024-01-11',
    NULL,
    NULL,
    NULL,
    32
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    17,
    'CRE000002',
    '2024-05-24',
    39,
    'Bank Transfer',
    'DD',
    2614.59,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-05-24',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    18,
    'CRE000003',
    '2024-05-24',
    42,
    'Bank Transfer',
    'DD',
    83.95,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-05-24',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    19,
    'CRE000004',
    '2024-05-24',
    38,
    'Bank Transfer',
    'DD',
    1480.79,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-05-24',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    20,
    'CRE000005',
    '2024-07-26',
    47,
    'Bank Transfer',
    'ACH Transfer',
    229.92,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-25',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    21,
    'CRE000006',
    '2024-07-26',
    42,
    'Bank Transfer',
    'ACH',
    178.48,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-25',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    22,
    'CRE000007',
    '2024-07-26',
    38,
    'Bank Transfer',
    'ACH',
    1201.45,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-25',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    23,
    'CRE000008',
    '2024-07-29',
    38,
    'Bank Transfer',
    'ACH',
    965.44,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-29',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    24,
    'CRE000009',
    '2024-08-26',
    38,
    'Bank Transfer',
    NULL,
    1774.74,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-24',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    25,
    'CRE000010',
    '2024-08-26',
    38,
    'Bank Transfer',
    NULL,
    0.00,
    'CANCELLED',
    'Irish  Smith',
    2,
    '2024-09-24',
    'Irish  Smith',
    2,
    '2024-09-24',
    1
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    26,
    'CRE000011',
    '2024-09-26',
    38,
    'Bank Transfer',
    NULL,
    1758.15,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    27,
    'CRE000012',
    '2024-08-26',
    38,
    'Bank Transfer',
    NULL,
    1774.74,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    28,
    'CRE000013',
    '2024-10-09',
    38,
    'Bank Transfer',
    'ACH on regular paycheck',
    317.05,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-10-08',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    29,
    'CRE000014',
    '2024-09-26',
    47,
    'Bank Transfer',
    'ACH',
    205.62,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-10-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    30,
    'CRE000015',
    '2024-09-26',
    42,
    'Bank Transfer',
    'ACH',
    135.45,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-10-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    31,
    'CRE000016',
    '2024-09-26',
    53,
    'Bank Transfer',
    'ACH',
    577.81,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-10-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    32,
    'CRE000017',
    '2024-08-26',
    53,
    'Bank Transfer',
    NULL,
    885.28,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-10-23',
    NULL,
    NULL,
    NULL,
    1
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: customer_table
# ------------------------------------------------------------

INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    1,
    'PRO000076',
    'Jacqueline R. Williams, LCSW',
    '240-535-8013',
    'jrbrownllc@yahoo.com',
    '9500 Medical Center Drive, Suite 230B, Upper Marlboro, MD  20774',
    'JRBrown, LLC',
    '1899-11-30',
    '1899-11-30',
    8.00,
    '15th_1st',
    1,
    'ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    2,
    'PRO000077',
    'Create Your Life, LLC',
    '301-857-1848',
    'amw0804@yahoo.com',
    '10665 Stanhaven Place, Rm 3119, White Plains, MD  20695',
    'Create Your Life, LLC',
    '1899-11-30',
    '1899-11-30',
    8.00,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    3,
    'PRO000078',
    'Karena Wilson-Plater, PsyD',
    '301-938-7276',
    'kplater@thebridgetherapeutic.com',
    '7360 Grace Drive, Columbia, MD  21044',
    'The Bridge Therapeutic and Evaluation Services, LLC',
    '1899-11-30',
    '1899-11-30',
    8.50,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    4,
    'PRO000079',
    'Onyx Therapy Group',
    '202-400-7524',
    'admin@onyxtherapygroup.com',
    '529 14th Street, NW Suite 988, Washington, DC  20045',
    'EMC2 Educational Consulting',
    '1899-11-30',
    '1899-11-30',
    9.00,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    5,
    'PRO000080',
    'LaCole Cole, LCPC',
    '240-346-1974',
    'lacole@dynamiccounselinggroup.com',
    '3195 Old Washington RD, Suite 110, Waldorf, MD 20602',
    'Dynamic Counseling Group, LLC',
    '1899-11-30',
    '1899-11-30',
    8.50,
    '15th_1st',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    6,
    'PRO000081',
    'Lenese Stephens, LCPC',
    '301-844-1752',
    'drstephens@hopefulcounseling.org',
    '4601 Presidents Drive, Suit 135, Lanham, MD  20706',
    'Hopeful Counseling, LLC',
    '1899-11-30',
    '1899-11-30',
    8.50,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    7,
    'PRO000082',
    'Nji J. Fru, CNPR',
    '301-675-1652',
    'nfijru2003@yahoo.com',
    '2670 Crain Highway, Suite 408, Waldorf, MD  20601',
    'F and N Renounce Healthcare Services, Inc.',
    '1899-11-30',
    '1899-11-30',
    8.50,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    8,
    'PRO000083',
    'Samantha Knox, LPC',
    '202-746-5838',
    'samanthaknoxlpc@gmail.com',
    '1638 R Street, NW, Suite 311, Washington, DC  20009',
    'AYA Behavioral Health, LLC',
    '1899-11-30',
    '1899-11-30',
    9.00,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    9,
    'PRO000084',
    'Thomas Patota, LCSW',
    '301-593-8111',
    'tompatota@gmail.com',
    '1413 Annapolis Road, Suite 207, Odenton, MD 21113',
    'Thomas Patota, LCSW',
    '0000-00-00',
    '0000-00-00',
    0.00,
    '',
    0,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    10,
    'PRO000085',
    'Yetta Lyle, LCPC',
    '240-731-2830',
    'yettalyle@gmail.com',
    '1304 Kings Heather Drive, Mitchellville, MD  20721',
    'Metamorphosis',
    '1899-11-30',
    '1899-11-30',
    8.00,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    11,
    'PRO000086',
    'Judith Rose Wilson, LCPC',
    '301-605-3509',
    'jsallywally@hotmail.com',
    '',
    'Social Solutions, Inc.',
    '0000-00-00',
    '0000-00-00',
    0.00,
    '',
    0,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    12,
    'PRO000087',
    'Joy R. Hart, LCSW-C',
    '571-236-7012',
    'joy.hart76@yahoo.com',
    '14300 Gallant Fox Lane, Suite 115, Bowie, MD  20715',
    'DJLS Therapy Services, LLC',
    '1899-11-30',
    '1899-11-30',
    10.00,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    13,
    'PRO000088',
    'Karen L. Allen, LCSW-C',
    '301-741-7934',
    'imaniconsulting12@gmail.com',
    '4329 Northview Drive, Bowie, MD 20716',
    'Imani Consulting',
    '1899-11-30',
    '1899-11-30',
    8.00,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    14,
    'PRO000089',
    'Gillian Blackman-Diarra, LCSW-C',
    '240-354-8552',
    'diarragillian@yahoo.com',
    '7015 Dolphin RD, Lanham, MD 20706',
    'Gillian Blackman-Diarra, LCSW-C',
    '1899-11-30',
    '1899-11-30',
    8.50,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    15,
    'PRO000090',
    'Glenda Bullock-Willis, LCPC',
    '301-832-6295',
    'glendawillis@hotmail.com',
    '5211 Auth RD, Suite 202, Suitland, MD  20746',
    'Glenda Bullock-Willis, LCPC',
    '1899-11-30',
    '1899-11-30',
    8.50,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    16,
    'PRO000091',
    'Donna R. Inman, LPC',
    '703-975-7322',
    'donna.inman.lpc@gmail.com',
    '1629 K Street, NW, Suite 300, Washington, DC 20006',
    'Rosebud Counseling',
    '1899-11-30',
    '1899-11-30',
    8.50,
    '15th_1st',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    17,
    'PRO000092',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    '571-432-9454',
    'bharat@apexhandtherapy.com',
    '226 Maple Avenue, West, Suite 405, Vienna VA 22180',
    'Apex Hand Therapy, PLLC',
    '1899-11-30',
    '1899-11-30',
    8.00,
    '15th_1st',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    18,
    'PRO000093',
    'DC HT - Bharat Vallurapalli, MS, OTR/L',
    '571-236-7012',
    'bharat@dchandtherapy.com',
    '1020 19th Street, NW, Suite 775, Washington, DC 20036',
    'DC Hand Therapy, PLLC',
    '1899-11-30',
    '1899-11-30',
    8.00,
    '15th_1st',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    19,
    'PRO000094',
    'Nicole Rudd, LCPC',
    '202-406-0929',
    'nicolewrudd@gmail.com',
    '4315 Northview Drive, Bowie, MD 20716',
    'Nicole Rudd, LCPC',
    '1899-11-30',
    '1899-11-30',
    7.50,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    20,
    'PRO000095',
    'Carla D. Washington, LPC',
    '301-906-3449',
    'carlawashington@aol.com',
    '1629 K Street, NW, Suite 300, Washington, DC  20006',
    'Carla D. Washington, LPC',
    '1899-11-30',
    '1899-11-30',
    8.50,
    '15th_1st',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    21,
    'PRO000096',
    'Donna Reid Washington, LPC',
    '301-526-3971',
    'reidwash214@comcast.net',
    '1775 Eye Street, NW Suite 1150, Washington, DC 20006',
    'Donna Reid Washington, LPC',
    '1899-11-30',
    '1899-11-30',
    8.00,
    '15th_1st',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    22,
    'PRO000097',
    'Dr. Jamila Winn ',
    '301-458-8123',
    'drwinn@drjamilawinn.com',
    '9500 Medical Center Drive, Suite 230B, Upper Marlboro, MD 20774',
    'Mindset Therapy and Wellness, Inc.',
    '0000-00-00',
    '0000-00-00',
    0.00,
    '',
    0,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    23,
    'PRO000098',
    'Tammy Miller, Ph.D',
    '000-000-0000',
    'tammymiller@mirrormentalhealth.com',
    '2110 PRIEST BRIDGE DRIVE, Suite 1, Crofton, MD  21114',
    'Mirror Mental Health',
    '0000-00-00',
    '0000-00-00',
    0.00,
    '',
    0,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    24,
    'PRO000099',
    'Winnie Moore, LCPC',
    '240-232-5554',
    'wmoore@ajscounseling.net',
    '2670 Crain Hwy, Suite 408, Waldorf, MD 20601',
    'AJs Counseling and Consulting Services',
    '1899-11-30',
    '1899-11-30',
    8.00,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    26,
    'PRO000101',
    'Wanda D. Smith, LCSW-C',
    '000-000-0000',
    'wdsmith330@mac.com',
    '13005 Martha\'s Choice Circle, Bowie, MD  20720',
    'JW Smith, LLC',
    '1899-11-30',
    '1899-11-30',
    8.50,
    '15th_1st',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    27,
    'PRO000102',
    'Veronica Watkins, LCSW-C',
    '(301) 909-4606',
    'templebuilders@gmail.com',
    '9701 Apollo Drive, Suite 410, Upper Marlboro, MD 20774',
    'Temple Builders, LLC',
    '0000-00-00',
    '0000-00-00',
    0.00,
    '',
    0,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    29,
    'PRO000105',
    'Dalton Johnson, LCPC',
    '301-848-6793',
    'djjohnson@smcps.org',
    '4660 Prestancia Place, Apt 107, Waldorf, MD  20602',
    'n/a',
    '1899-11-30',
    '1899-11-30',
    8.50,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    30,
    'PRO000106',
    'Danielle Rogal-Hudespeth, LCPC',
    '202-604-5687',
    'lcmftdanielle@gmail.com',
    '3124 Applegate Terrace, Bowie, MD 20716',
    'Inclusive Community Counseling, LLC',
    '1899-11-30',
    '1899-11-30',
    9.00,
    '15th_1st',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    31,
    'PRO000108',
    'The Bridges Wellness Group',
    '0',
    'info@billing-plus.com',
    '7100 Chesapeake RD, Suite 104, Landover, MD  20785',
    'The Bridges Wellness Group',
    '1899-11-30',
    '1899-11-30',
    8.50,
    '15th_1st',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    32,
    'PRO000109',
    'Sonia Ross',
    '0',
    'sonia@fullcircletherapyservices.com',
    '',
    'Full Circle Therapy Services',
    '0000-00-00',
    '0000-00-00',
    0.00,
    '',
    0,
    'ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    33,
    'PRO000110',
    'Semi Monthly',
    '3012023739',
    'none@noemail.com',
    '4315 Northview Drive',
    'Semi Monthly ',
    '0000-00-00',
    '0000-00-00',
    0.00,
    '',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    34,
    'PRO000111',
    'Better Days Counseling, LLC',
    '240-803-3297',
    'betterdayscounselingllc@gmail.com',
    '7404 Executive BLVD, Suite 102, Lanham, MD 20706',
    'Better Days Counseling, LLC',
    '1899-11-30',
    '1899-11-30',
    8.50,
    '15th_1st',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    35,
    'PRO000112',
    'FirstStep Rehab - Jay Neal',
    '(410) 921-6846',
    'wecare@firststeprehabllc.com',
    '1875 Candle Light CT, Owings, MD  20736',
    'FirstStep Rehab, LLC',
    '0000-00-00',
    '0000-00-00',
    0.00,
    '',
    0,
    'ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    36,
    'PRO000113',
    'Sothia Green, PsyD',
    '301-379-0987',
    'sothiagreen@yahoo.com',
    '5211 Auth RD, Suite 202B',
    'Transformations, LLC',
    '1899-11-30',
    '1899-11-30',
    5.00,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    37,
    'PRO000114',
    'Caring Hands  Behavioral Health Center',
    '4437895556',
    'rrmomodu@chbhc.com',
    '2637-39 Greenmount Avenue, Baltimore MD 21218',
    'Caring Hands Behavioral Health Center',
    '1899-11-30',
    '1899-11-30',
    7.30,
    '1st_15th',
    1,
    'Ismith01',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    210,
    'PRO000115',
    'Test Provider',
    '8454811999',
    'frazzaq2@gmail.com',
    '150 E Palme',
    'Test practice',
    '2024-01-09',
    '2999-01-01',
    10.00,
    '1st_15th',
    1,
    'Fahad Razzaq',
    32
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    211,
    'PRO000116',
    'Test2 Provider',
    '8454811999',
    'frazzaq2@gmail.com',
    'Palmetto Park Ro]',
    'Allmed',
    '2023-09-01',
    '2025-06-30',
    10.00,
    '1st_15th',
    1,
    'Fahad Razzaq',
    32
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    212,
    'PRO000117',
    'Sajith',
    '1234',
    'sajith.wickramasena@gmail.com',
    'Sri Lanka',
    'Sajith',
    '2024-01-11',
    '2025-12-31',
    10.00,
    '1st_15th',
    1,
    'Sajith Wickramasena',
    32
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    213,
    'PRO000118',
    'Fortitude Counseling Center, LLC',
    '301',
    'stamps@fortitudecounseling.com',
    'Upper Marlboro, MD',
    'Fortitude Counseling Services',
    '2023-02-01',
    '2029-02-01',
    0.00,
    '1st_15th',
    1,
    'Irish  Smith',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    214,
    'PRO000119',
    'For Every Mountain Counseling Services, LLC',
    '202-907-6516',
    'dial@foreverymountain.org',
    '15480 Annapolis Road, Suite 202, Unit 229 Bowie, MD 20715',
    'Lindsey Dial - For Every Mountain Counseling Services, LLC',
    '2023-07-01',
    '2024-07-01',
    7.50,
    '15th_1st',
    1,
    'Irish  Smith',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    216,
    'PRO000121',
    'Elisa Ndombele-Sisler, Psy.D.',
    '(301) 202-4453',
    'endombele@sonabatapsychology.com',
    '601 7th Street\nSuite 302\nLaurel, MD 20707-4011',
    'Sona Bata Psychological Services, LLC',
    '2022-01-01',
    NULL,
    9.00,
    '1st_15th',
    1,
    'Irish  Smith',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    217,
    'PRO000122',
    'Elizabeth Merrill, LCSW',
    '2024231751',
    'liz.merrill.lcsw@gmail.com',
    '4011 Oglethorpe Street, Hyattsville, MD ',
    'Well Aware, LLC',
    '2024-02-01',
    NULL,
    7.00,
    '1st_15th',
    1,
    'Irish  Smith',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    220,
    'PRO000125',
    'Amina Hall, LCSW',
    '2025386103',
    'ahall@legacycounselingmd.com',
    '11203 Champlain Circle, Bowie, MD 20720',
    'Legacy Counseling Services',
    '2024-06-01',
    NULL,
    7.50,
    '1st_15th',
    1,
    'Irish  Smith',
    1
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    221,
    'PRO000126',
    'Test Provider',
    '1234567890',
    'frazzaq2@gmail.com',
    '150 E Palmetto Park Road',
    'Test Group',
    '2023-12-31',
    NULL,
    8.00,
    '1st_15th',
    1,
    'Fahad Razzaq',
    1
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: file_upload_table
# ------------------------------------------------------------

INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    42,
    'Fahad Razzaq',
    '1704851730716-tet doc.txt',
    'test document',
    '2024-01-10',
    'No',
    'Fahad Razzaq',
    32,
    58
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    43,
    'Fahad Razzaq',
    '1705225663105-tet doc.txt',
    'Test ABC1',
    '2024-01-14',
    'No',
    'Fahad Razzaq',
    32,
    58
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: invoice_scheduler_table
# ------------------------------------------------------------

INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    6,
    '2024-01',
    'Provider',
    1,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-01-09',
    32
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    7,
    '2024-01',
    'Contractor',
    1,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-01-09',
    32
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    8,
    '2023-12',
    'Provider',
    1,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-01-09',
    32
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    9,
    '2023-12',
    'Contractor',
    1,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-01-09',
    32
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    10,
    '2023-09',
    'Provider',
    1,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-01-11',
    32
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    11,
    '2023-09',
    'Contractor',
    1,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-01-11',
    32
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    12,
    '2024-01',
    'Provider',
    1,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-01-14',
    32
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    13,
    '2024-01',
    'Contractor',
    2,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-01-14',
    32
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    14,
    '2021-01',
    'Provider',
    1,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-01-16',
    32
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    15,
    '2021-01',
    'Contractor',
    1,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-01-16',
    32
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    16,
    '2023-11',
    'Provider',
    1,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-01-17',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    17,
    '2023-12',
    'Provider',
    20,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-02-02',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    18,
    '2024-01',
    'Provider',
    1,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-02-23',
    32
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    19,
    '2024-01',
    'Contractor',
    1,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-02-23',
    32
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    20,
    '2021-02',
    'Provider',
    1,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-02-23',
    32
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    21,
    '2023-11',
    'Contractor',
    4,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-03-11',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    22,
    '2024-03',
    'Contractor',
    4,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-05-14',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    23,
    '2024-02',
    'Provider',
    2,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-05-14',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    24,
    '2024-04',
    'Provider',
    1,
    'SUCCESS',
    'Fahad Razzaq',
    58,
    '2024-05-14',
    32
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    25,
    '2024-04',
    'Provider',
    6,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-05-20',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    26,
    '2024-04',
    'Provider',
    20,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-06-10',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    27,
    '2024-04',
    'Provider',
    2,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-06-21',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    28,
    '2024-05',
    'Provider',
    7,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-06-21',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    29,
    '2024-04',
    'Contractor',
    4,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-06-25',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    30,
    '2024-05',
    'Provider',
    17,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-07-04',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    31,
    '2024-06',
    'Provider',
    6,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    32,
    '2024-05',
    'Provider',
    4,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-07-17',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    33,
    '2024-05',
    'Contractor',
    3,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-07-25',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    34,
    '2024-06',
    'Provider',
    22,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    35,
    '2024-06',
    'Contractor',
    5,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    36,
    '2024-07',
    'Provider',
    10,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-08-16',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    37,
    '2024-07',
    'Provider',
    10,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-08-16',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    38,
    '2024-07',
    'Provider',
    23,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-09-06',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    39,
    '2024-08',
    'Provider',
    29,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-09-20',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    40,
    '2024-07',
    'Contractor',
    4,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-09-24',
    1
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    41,
    '2024-09',
    'Provider',
    24,
    'SUCCESS',
    'Irish  Smith',
    2,
    '2024-11-01',
    1
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: pay_slip_table
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: provider_invoice_item_table
# ------------------------------------------------------------

INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (30, 24, 89, 9, 0.00, 0.00, 0.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (31, 25, 90, 11, 5000.00, 10.00, 500.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (32, 25, 91, 10, 28000.00, 10.00, 2800.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (33, 26, 92, 10, 18000.00, 10.00, 1800.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (34, 26, 93, 11, 1500.00, 10.00, 150.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (35, 27, 94, 10, 4500.00, 10.00, 450.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (36, 27, 95, 11, 800.00, 10.00, 80.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (37, 28, 96, 12, 0.00, 0.00, 0.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (38, 28, 99, 13, 0.00, 0.00, 0.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (39, 28, 100, 15, 0.00, 0.00, 0.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (40, 29, 101, 10, 52000.00, 10.00, 5200.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (41, 30, 102, 10, 50000.00, 10.00, 5000.00);
