INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    228,
    'INV000205',
    '2024-08-01',
    '3',
    '2024-06',
    '2024-08-15',
    1445.77,
    152.90,
    0.00,
    152.90,
    'PNC Invoice: J10102',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    229,
    'INV000206',
    '2024-08-01',
    '4',
    '2024-06',
    '2024-08-15',
    16248.89,
    1612.40,
    0.00,
    1612.40,
    'PNC Invoice: J10109',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    230,
    'INV000207',
    '2024-08-15',
    '5',
    '2024-06',
    '2024-09-01',
    15737.27,
    1367.67,
    1367.67,
    0.00,
    'PNC Invoice: J10120',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    231,
    'INV000208',
    '2024-08-01',
    '6',
    '2024-06',
    '2024-08-15',
    54095.42,
    4628.12,
    0.00,
    4628.12,
    'PNC Invoice: J10112',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    232,
    'INV000209',
    '2024-08-01',
    '7',
    '2024-06',
    '2024-08-15',
    4393.30,
    410.95,
    0.00,
    410.95,
    'PNC Invoice: J10101',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    233,
    'INV000210',
    '2024-08-01',
    '10',
    '2024-06',
    '2024-08-15',
    257.04,
    28.56,
    0.00,
    28.56,
    'PNC Invoice: J10110',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    234,
    'INV000211',
    '2024-08-01',
    '12',
    '2024-06',
    '2024-08-15',
    11069.24,
    1181.92,
    0.00,
    1181.92,
    'PNC Invoice: J10099',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    235,
    'INV000212',
    '2024-08-01',
    '13',
    '2024-06',
    '2024-08-15',
    4889.53,
    421.16,
    0.00,
    421.16,
    'PNC Invoice: J10115',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    236,
    'INV000213',
    '2024-07-01',
    '14',
    '2024-06',
    '2024-07-15',
    2217.29,
    194.17,
    0.00,
    194.17,
    '',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    237,
    'INV000214',
    '2024-08-01',
    '15',
    '2024-06',
    '2024-08-15',
    1007.61,
    105.60,
    0.00,
    105.60,
    'PNC Invoice: J10103',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    238,
    'INV000215',
    '2024-08-01',
    '19',
    '2024-06',
    '2024-08-15',
    14700.55,
    1102.55,
    0.00,
    1102.55,
    'PNC Invoice: J10111',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    239,
    'INV000216',
    '2024-08-15',
    '20',
    '2024-06',
    '2024-09-01',
    28120.11,
    3003.58,
    0.00,
    3003.58,
    'PNC Invoice: J10019',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    240,
    'INV000217',
    '2024-08-15',
    '21',
    '2024-06',
    '2024-09-01',
    8560.04,
    1108.70,
    0.00,
    1108.70,
    'PNC Invoice: J10118',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    241,
    'INV000218',
    '2024-08-01',
    '24',
    '2024-06',
    '2024-08-15',
    22938.63,
    1895.82,
    0.00,
    1895.82,
    'PNC Invoice: J10098',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    242,
    'INV000219',
    '2024-08-01',
    '29',
    '2024-06',
    '2024-08-15',
    4930.99,
    419.13,
    0.00,
    419.13,
    'PNC Invoice: J10105',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    243,
    'INV000220',
    '2024-08-01',
    '30',
    '2024-06',
    '2024-08-15',
    3588.34,
    325.95,
    0.00,
    325.95,
    'PNC Invoice: J10100',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    244,
    'INV000221',
    '2024-08-01',
    '36',
    '2024-06',
    '2024-08-15',
    451.77,
    30.19,
    30.19,
    0.00,
    'PNC Invoice: J10116',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    245,
    'INV000222',
    '2024-08-01',
    '37',
    '2024-06',
    '2024-08-15',
    30961.69,
    2260.21,
    0.00,
    2260.21,
    'PNC Invoice: J10113',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    246,
    'INV000223',
    '2024-07-15',
    '214',
    '2024-06',
    '2024-08-01',
    28521.09,
    2273.03,
    0.00,
    2273.03,
    'PNC invoice J10097',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    247,
    'INV000224',
    '2024-08-01',
    '216',
    '2024-06',
    '2024-08-15',
    16469.58,
    1512.26,
    1512.26,
    0.00,
    'PNC Invoice: J10106',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    248,
    'INV000225',
    '2024-08-01',
    '217',
    '2024-06',
    '2024-08-15',
    4313.75,
    301.96,
    0.00,
    301.96,
    'PNC Invoice: J10107',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    249,
    'INV000226',
    '2024-08-01',
    '8',
    '2024-06',
    '2024-08-15',
    12557.56,
    1130.18,
    0.00,
    1130.18,
    'PNC Invoice; J10108',
    'PAID',
    'Manual',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    250,
    'INV000227',
    '2024-08-15',
    '1',
    '2024-07',
    '2024-09-01',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-08-16',
    'Irish  Smith',
    2,
    '2024-08-16',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    251,
    'INV000228',
    '2024-08-15',
    '16',
    '2024-07',
    '2024-09-01',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-08-16',
    'Irish  Smith',
    2,
    '2024-08-16',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    252,
    'INV000229',
    '2024-08-15',
    '17',
    '2024-07',
    '2024-09-01',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-08-16',
    'Irish  Smith',
    2,
    '2024-08-16',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    253,
    'INV000230',
    '2024-09-15',
    '20',
    '2024-07',
    '2024-10-01',
    21458.90,
    2466.06,
    0.00,
    2466.06,
    'PNC invoice: J10151',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-16',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    254,
    'INV000227',
    '2024-08-15',
    '1',
    '2024-07',
    '2024-09-01',
    10149.51,
    976.96,
    976.96,
    0.00,
    'PNC Invoice: J10125',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-16',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    255,
    'INV000231',
    '2024-09-15',
    '21',
    '2024-07',
    '2024-10-01',
    3142.13,
    656.89,
    0.00,
    656.89,
    'PNC invoice: J10152',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-16',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    256,
    'INV000228',
    '2024-08-15',
    '16',
    '2024-07',
    '2024-09-01',
    3413.18,
    305.12,
    0.00,
    305.12,
    'PNC Invoice: J10123',
    'PAID',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-08-16',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    257,
    'INV000232',
    '2024-08-15',
    '26',
    '2024-07',
    '2024-09-01',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-08-16',
    'Irish  Smith',
    2,
    '2024-08-16',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    258,
    'INV000233',
    '2024-08-15',
    '31',
    '2024-07',
    '2024-09-01',
    10315.61,
    946.82,
    946.82,
    0.00,
    'PNC Invoice: J10126',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-16',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    259,
    'INV000234',
    '2024-09-15',
    '34',
    '2024-07',
    '2024-10-01',
    18197.73,
    1621.81,
    1621.81,
    0.00,
    'PNC invoice: J10150',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-16',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    260,
    'INV000235',
    '2024-08-15',
    '214',
    '2024-07',
    '2024-09-01',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-08-16',
    'Irish  Smith',
    2,
    '2024-08-16',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    261,
    'INV000236',
    '2024-08-01',
    '220',
    '2024-07',
    '2024-08-15',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-08-16',
    'Irish  Smith',
    2,
    '2024-09-03',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    262,
    'INV000229',
    '2024-08-15',
    '17',
    '2024-07',
    '2024-09-01',
    7107.96,
    850.82,
    0.00,
    850.82,
    '',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-16',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    263,
    'INV000230',
    '2024-09-15',
    '20',
    '2024-07',
    '2024-10-01',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-08-16',
    'Irish  Smith',
    2,
    '2024-09-20',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    264,
    'INV000231',
    '2024-08-15',
    '21',
    '2024-07',
    '2024-09-01',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-08-16',
    'Irish  Smith',
    2,
    '2024-09-20',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    265,
    'INV000232',
    '2024-08-15',
    '26',
    '2024-07',
    '2024-09-01',
    895.50,
    76.12,
    76.12,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-16',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    266,
    'INV000233',
    '2024-08-15',
    '31',
    '2024-07',
    '2024-09-01',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-08-16',
    'Irish  Smith',
    2,
    '2024-08-16',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    267,
    'INV000234',
    '2024-08-15',
    '34',
    '2024-07',
    '2024-09-01',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-08-16',
    'Irish  Smith',
    2,
    '2024-09-20',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    268,
    'INV000235',
    '2024-08-15',
    '214',
    '2024-07',
    '2024-09-01',
    23352.64,
    1882.47,
    1882.47,
    0.00,
    'PNC Invoice: J10127',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-16',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    269,
    'INV000236',
    '2024-09-01',
    '220',
    '2024-07',
    '2024-09-15',
    9502.15,
    712.66,
    712.66,
    0.00,
    'PNC Invoice: J10129',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-08-16',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    270,
    'INV000237',
    '2024-01-01',
    '221',
    '2024-01',
    '2024-02-15',
    0.00,
    0.00,
    0.00,
    0.00,
    NULL,
    'CANCELLED',
    'Manual',
    0,
    0,
    'Fahad Razzaq',
    58,
    '2024-09-03',
    'Fahad Razzaq',
    58,
    '2024-09-03',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    271,
    'INV000238',
    '2024-08-15',
    '1',
    '2024-07',
    '2024-09-01',
    10149.51,
    976.96,
    976.96,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    272,
    'INV000239',
    '2024-09-01',
    '2',
    '2024-07',
    '2024-09-15',
    16348.89,
    1404.16,
    1404.16,
    0.00,
    'pnc invoice: J10145',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    273,
    'INV000240',
    '2024-08-01',
    '3',
    '2024-07',
    '2024-08-15',
    1648.59,
    200.04,
    200.04,
    0.00,
    'PNC Invoice: J10133',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    274,
    'INV000241',
    '2024-09-01',
    '6',
    '2024-07',
    '2024-09-15',
    44126.91,
    3780.79,
    3780.79,
    0.00,
    'pnc invoice: J10143\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    275,
    'INV000242',
    '2024-09-01',
    '7',
    '2024-07',
    '2024-09-15',
    5013.28,
    431.21,
    431.21,
    0.00,
    'pnc invoice: J10132',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    276,
    'INV000243',
    '2024-09-01',
    '8',
    '2024-07',
    '2024-09-15',
    23072.53,
    2076.53,
    2076.53,
    0.00,
    'pnc invoice: J10139',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    277,
    'INV000244',
    '2024-09-01',
    '10',
    '2024-07',
    '2024-09-15',
    631.15,
    50.49,
    50.49,
    0.00,
    'pnc invoice: J10141',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    278,
    'INV000245',
    '2024-09-01',
    '12',
    '2024-07',
    '2024-09-15',
    8003.88,
    875.39,
    875.39,
    0.00,
    'PNC Invoice: J10131',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    279,
    'INV000246',
    '2024-09-01',
    '13',
    '2024-07',
    '2024-09-15',
    3891.36,
    369.70,
    369.70,
    0.00,
    'pnc invoice: J10146',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    280,
    'INV000247',
    '2024-08-01',
    '14',
    '2024-07',
    '2024-08-15',
    3124.04,
    267.44,
    0.00,
    267.44,
    'PNC Invoice: J10135',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    281,
    'INV000248',
    '2024-09-01',
    '15',
    '2024-07',
    '2024-09-15',
    2536.95,
    247.77,
    247.77,
    0.00,
    'PNC Invoice: J10134',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    282,
    'INV000249',
    '2024-08-15',
    '16',
    '2024-07',
    '2024-09-01',
    3413.18,
    305.12,
    305.12,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    283,
    'INV000250',
    '2024-08-15',
    '17',
    '2024-07',
    '2024-09-01',
    7107.96,
    850.82,
    850.82,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    284,
    'INV000251',
    '2024-09-01',
    '19',
    '2024-07',
    '2024-09-15',
    3359.51,
    251.96,
    251.96,
    0.00,
    'pnc invoice: J10142',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    285,
    'INV000252',
    '2024-09-01',
    '24',
    '2024-07',
    '2024-09-15',
    30540.96,
    2473.28,
    2473.28,
    0.00,
    'PNC Invoice: J10130',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    286,
    'INV000253',
    '2024-08-15',
    '26',
    '2024-07',
    '2024-09-01',
    895.50,
    76.12,
    76.12,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    287,
    'INV000254',
    '2024-09-01',
    '29',
    '2024-07',
    '2024-09-15',
    5057.27,
    485.31,
    0.00,
    485.31,
    'Pnc invoice: J10136',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    288,
    'INV000255',
    '2024-08-15',
    '31',
    '2024-07',
    '2024-09-01',
    10315.61,
    946.82,
    946.82,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    289,
    'INV000256',
    '2024-09-01',
    '36',
    '2024-07',
    '2024-09-15',
    7265.86,
    392.22,
    392.22,
    0.00,
    'pnc invoice: J10147',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    290,
    'INV000257',
    '2024-08-15',
    '214',
    '2024-07',
    '2024-09-01',
    23352.64,
    1882.47,
    0.00,
    1882.47,
    'PNC INVOICE: j10127',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    291,
    'INV000258',
    '2024-09-01',
    '216',
    '2024-07',
    '2024-09-15',
    5800.06,
    616.59,
    616.59,
    0.00,
    'pnc invoice: J10137',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    292,
    'INV000259',
    '2024-09-01',
    '217',
    '2024-07',
    '2024-09-15',
    1283.60,
    89.85,
    89.85,
    0.00,
    'pnc invoice: J10138',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    293,
    'INV000260',
    '2024-08-01',
    '220',
    '2024-07',
    '2024-08-15',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-09-06',
    'Irish  Smith',
    2,
    '2024-09-06',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    294,
    'INV000261',
    '2024-09-01',
    '4',
    '2024-07',
    '2024-09-15',
    0.00,
    0.00,
    0.00,
    0.00,
    'pnc invoice: J10140',
    'CANCELLED',
    'Manual',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-09-06',
    'Irish  Smith',
    2,
    '2024-09-06',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    295,
    'INV000262',
    '2024-09-01',
    '4',
    '2024-07',
    '2024-09-15',
    19203.74,
    1903.34,
    0.00,
    1903.34,
    'pnc invoice: J10140',
    'PAID',
    'Manual',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    296,
    'INV000263',
    '2024-09-01',
    '37',
    '2024-07',
    '2024-09-15',
    29430.34,
    2148.42,
    0.00,
    2148.42,
    'pnc invoice: J10144',
    'PAID',
    'Manual',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    297,
    'INV000264',
    '2024-09-15',
    '5',
    '2024-07',
    '2024-10-01',
    8036.84,
    713.14,
    713.14,
    0.00,
    'PNC Invoice: J10153',
    'UNPAID',
    'Manual',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    298,
    'INV000265',
    '2024-09-15',
    '1',
    '2024-08',
    '2024-10-01',
    15962.96,
    1468.09,
    1468.09,
    0.00,
    'PNC Invoice #: A10158',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    299,
    'INV000266',
    '2024-10-01',
    '2',
    '2024-08',
    '2024-10-15',
    16388.75,
    1683.89,
    1683.89,
    0.00,
    'PNC Invoice #: A10179',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    300,
    'INV000267',
    '2024-10-01',
    '3',
    '2024-08',
    '2024-10-15',
    183.25,
    50.99,
    50.99,
    0.00,
    'Pnc Invoice #: A10168',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    301,
    'INV000268',
    '2024-10-01',
    '4',
    '2024-08',
    '2024-10-15',
    19299.79,
    1886.98,
    0.00,
    1886.98,
    'PNC Invoice #: A10174\n',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    302,
    'INV000269',
    '2024-10-15',
    '5',
    '2024-08',
    '2024-11-01',
    10446.59,
    949.20,
    0.00,
    949.20,
    'PNC Invoice #: A10192',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    303,
    'INV000270',
    '2024-10-01',
    '6',
    '2024-08',
    '2024-10-15',
    33411.35,
    2869.96,
    2869.96,
    0.00,
    'PNC Invoice #: A10177',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    304,
    'INV000271',
    '2024-10-01',
    '7',
    '2024-08',
    '2024-10-15',
    2284.40,
    195.37,
    195.37,
    0.00,
    'PNC Invoice #: A10167\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    305,
    'INV000272',
    '2024-10-01',
    '8',
    '2024-08',
    '2024-10-15',
    22347.61,
    2011.29,
    2011.29,
    0.00,
    'PNC Invoice #: A10173\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    306,
    'INV000273',
    '2024-10-01',
    '10',
    '2024-08',
    '2024-10-15',
    1282.73,
    102.62,
    102.62,
    0.00,
    'PNC Invoice #: A10175',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    307,
    'INV000274',
    '2024-10-01',
    '12',
    '2024-08',
    '2024-10-15',
    0.00,
    0.00,
    0.00,
    0.00,
    '',
    'CANCELLED',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-09-20',
    'Irish  Smith',
    2,
    '2024-09-30',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    308,
    'INV000275',
    '2024-10-01',
    '13',
    '2024-08',
    '2024-10-15',
    6129.21,
    761.37,
    0.00,
    761.37,
    'PNC Invoice #: A10180',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    309,
    'INV000276',
    '2024-09-01',
    '14',
    '2024-08',
    '2024-09-15',
    0.00,
    0.00,
    0.00,
    0.00,
    'PNC Invoice #: A10155',
    'CANCELLED',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-09-20',
    'Irish  Smith',
    2,
    '2024-10-05',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    310,
    'INV000277',
    '2024-09-15',
    '16',
    '2024-08',
    '2024-10-01',
    3361.42,
    300.72,
    0.00,
    300.72,
    'PNC Invoice #: A10156',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    311,
    'INV000278',
    '2024-09-15',
    '17',
    '2024-08',
    '2024-10-01',
    252.30,
    302.36,
    0.00,
    302.36,
    'PNC Invoice #: A10154\n',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    312,
    'INV000279',
    '2024-10-01',
    '19',
    '2024-08',
    '2024-10-15',
    10562.14,
    792.16,
    0.00,
    792.16,
    'PNC Invoice #: A10176\n',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    313,
    'INV000280',
    '2024-10-15',
    '20',
    '2024-08',
    '2024-11-01',
    29730.11,
    3169.12,
    3169.12,
    0.00,
    'PNC Invoice #: A10190',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    314,
    'INV000281',
    '2024-10-15',
    '21',
    '2024-08',
    '2024-11-01',
    8557.01,
    1090.08,
    0.00,
    1090.08,
    'PNC Invoice #: A10191',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    315,
    'INV000282',
    '2024-10-01',
    '24',
    '2024-08',
    '2024-10-15',
    25866.39,
    2472.16,
    0.00,
    2472.16,
    'PNC invoice A10163',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    316,
    'INV000283',
    '2024-09-15',
    '26',
    '2024-08',
    '2024-10-01',
    549.85,
    46.74,
    46.74,
    0.00,
    'PNC Invoice #: A10157',
    'UNPAID',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    317,
    'INV000284',
    '2024-10-01',
    '29',
    '2024-08',
    '2024-10-15',
    4988.79,
    442.87,
    442.87,
    0.00,
    'PNC Invoice #: A10170',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    318,
    'INV000285',
    '2024-10-01',
    '30',
    '2024-08',
    '2024-10-15',
    4233.80,
    385.04,
    0.00,
    385.04,
    'PNC Invoice: Invoice #: A10166\n',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    319,
    'INV000286',
    '2024-09-15',
    '31',
    '2024-08',
    '2024-10-01',
    12666.01,
    1399.77,
    1399.77,
    0.00,
    'PNC Invoice #: A10159',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    320,
    'INV000287',
    '2024-10-15',
    '34',
    '2024-08',
    '2024-11-01',
    16913.03,
    1777.36,
    0.00,
    1777.36,
    'PNC Invoice #: A10193',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    321,
    'INV000288',
    '2024-10-01',
    '36',
    '2024-08',
    '2024-10-15',
    3697.69,
    226.26,
    226.26,
    0.00,
    'PNC Invoice #: A10181',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    322,
    'INV000289',
    '2024-09-01',
    '37',
    '2024-08',
    '2024-09-15',
    24053.96,
    1755.94,
    1755.94,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    323,
    'INV000290',
    '2024-09-15',
    '214',
    '2024-08',
    '2024-10-01',
    23783.89,
    1892.24,
    1892.24,
    0.00,
    'PNC Invoice #: A10160',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    324,
    'INV000291',
    '2024-10-01',
    '216',
    '2024-08',
    '2024-10-15',
    4927.87,
    492.68,
    0.00,
    492.68,
    'Pnc Invoice #: A10171',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    325,
    'INV000292',
    '2024-10-01',
    '217',
    '2024-08',
    '2024-10-15',
    1004.22,
    74.30,
    74.30,
    0.00,
    'PNC Invoice #: A10172',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    326,
    'INV000293',
    '2024-10-01',
    '220',
    '2024-08',
    '2024-10-15',
    7282.55,
    546.19,
    0.00,
    546.19,
    'PNC Invoice #: A10165\n',
    'PAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    327,
    'INV000294',
    '2024-09-01',
    '30',
    '2024-07',
    '2024-09-15',
    6158.88,
    554.30,
    0.00,
    554.30,
    'PNC invoice: J10161',
    'PAID',
    'Manual',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-27',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    328,
    'INV000295',
    '2024-10-01',
    '30',
    '2024-03',
    '2024-10-15',
    0.00,
    0.00,
    0.00,
    0.00,
    'additional BCBS income BCBS posted 8/13/2024',
    'CANCELLED',
    'Manual',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-09-30',
    'Irish  Smith',
    2,
    '2024-09-30',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    329,
    'INV000296',
    '2024-10-01',
    '30',
    '2024-03',
    '2024-10-15',
    74.97,
    6.75,
    6.75,
    0.00,
    'additional BCBS income BCBS posted 8/13/2024',
    'UNPAID',
    'Manual',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    330,
    'INV000297',
    '2024-10-01',
    '30',
    '2024-04',
    '2024-10-15',
    329.91,
    29.69,
    29.69,
    0.00,
    'additional BCBS income BCBS posted 8/13/2024',
    'UNPAID',
    'Manual',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    331,
    'INV000298',
    '2024-10-01',
    '30',
    '2024-05',
    '2024-10-15',
    1014.75,
    91.33,
    91.33,
    0.00,
    'additional BCBS income BCBS posted 8/13/2024',
    'UNPAID',
    'Manual',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    332,
    'INV000299',
    '2024-10-01',
    '30',
    '2024-06',
    '2024-10-15',
    1520.29,
    136.83,
    136.83,
    0.00,
    'additional BCBS income BCBS posted 8/13/2024',
    'UNPAID',
    'Manual',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    333,
    'INV000300',
    '2024-10-01',
    '12',
    '2024-08',
    '2024-10-15',
    0.00,
    0.00,
    0.00,
    0.00,
    NULL,
    'CANCELLED',
    'Manual',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-09-30',
    'Irish  Smith',
    2,
    '2024-09-30',
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    334,
    'INV000301',
    '2024-10-01',
    '12',
    '2024-08',
    '2024-10-15',
    12472.01,
    1322.20,
    0.00,
    1322.20,
    'PNC Invoice #: A10164\n',
    'PAID',
    'Manual',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    335,
    'INV000302',
    '2024-10-01',
    '14',
    '2024-08',
    '2024-10-15',
    4763.98,
    412.54,
    0.00,
    412.54,
    'PNC Invoice #: A10169',
    'PAID',
    'Manual',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-10-05',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    336,
    'INV000303',
    '2024-10-15',
    '17',
    '2024-09',
    '2024-11-01',
    0.00,
    214.65,
    214.65,
    0.00,
    'PNC Invoice #: S10184',
    'UNPAID',
    'Manual',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-10-17',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    337,
    'INV000304',
    '2024-10-15',
    '16',
    '2024-09',
    '2024-11-01',
    3775.34,
    335.90,
    335.90,
    0.00,
    'PNC Invoice #: S10185',
    'UNPAID',
    'Manual',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-10-17',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    338,
    'INV000305',
    '2024-10-15',
    '26',
    '2024-09',
    '2024-11-01',
    1335.38,
    113.51,
    0.00,
    113.51,
    'PNC Invoice #: S10186',
    'PAID',
    'Manual',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-10-17',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    339,
    'INV000306',
    '2024-10-15',
    '1',
    '2024-09',
    '2024-11-01',
    13208.93,
    1257.02,
    0.00,
    1257.02,
    'PNC Invoice #: S10187',
    'PAID',
    'Manual',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-10-17',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    340,
    'INV000307',
    '2024-10-15',
    '31',
    '2024-09',
    '2024-11-01',
    7782.74,
    992.68,
    0.00,
    992.68,
    'PNC Invoice #: S10188',
    'PAID',
    'Manual',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-10-17',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    341,
    'INV000308',
    '2024-10-15',
    '214',
    '2024-09',
    '2024-11-01',
    21883.66,
    1746.28,
    0.00,
    1746.28,
    'PNC Invoice #: S10189',
    'PAID',
    'Manual',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-10-17',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    342,
    'INV000309',
    '2024-11-01',
    '2',
    '2024-09',
    '2024-11-15',
    22065.99,
    2377.18,
    2377.18,
    0.00,
    'PNC Invoice Summary:\n\nInvoice #: S10212\nAmount Due: $2,377.18\nDue Date: 11/15/24\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    343,
    'INV000310',
    '2024-11-01',
    '3',
    '2024-09',
    '2024-11-15',
    263.30,
    57.50,
    57.50,
    0.00,
    'PNC Invoice #: S10200',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    344,
    'INV000311',
    '2024-11-01',
    '4',
    '2024-09',
    '2024-11-15',
    19186.63,
    1876.80,
    1876.80,
    0.00,
    'PNC Invoice Summary:\n\nInvoice #: S10207\nAmount Due: $1,876.80\nDue Date: 11/15/24',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    345,
    'INV000312',
    '2024-11-15',
    '5',
    '2024-09',
    '2024-12-01',
    9247.37,
    847.14,
    847.14,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    346,
    'INV000313',
    '2024-11-01',
    '6',
    '2024-09',
    '2024-11-15',
    31708.80,
    2725.25,
    2725.25,
    0.00,
    'PNC Invoice Summary:\n\nInvoice #: S10210\nAmount Due: $2,725.25\nDue Date: 11/15/24',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    347,
    'INV000314',
    '2024-11-01',
    '7',
    '2024-09',
    '2024-11-15',
    3363.93,
    304.94,
    304.94,
    0.00,
    'PNC Invoice #: S10199',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    348,
    'INV000315',
    '2024-11-01',
    '8',
    '2024-09',
    '2024-11-15',
    19674.17,
    1770.68,
    1770.68,
    0.00,
    'PNC Invoice Summary:\nInvoice #: S10206\nAmount Due: $1,770.68\nDue Date: 11/15/24\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    349,
    'INV000316',
    '2024-11-01',
    '10',
    '2024-09',
    '2024-11-15',
    642.77,
    63.42,
    63.42,
    0.00,
    'PNC Invoice Summary:\n\nInvoice #: S10208\nAmount Due: $63.42\nDue Date: 11/15/24\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    350,
    'INV000317',
    '2024-11-01',
    '12',
    '2024-09',
    '2024-11-15',
    7784.59,
    853.46,
    853.46,
    0.00,
    'PNC Invoice #: S10196',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    351,
    'INV000318',
    '2024-11-01',
    '13',
    '2024-09',
    '2024-11-15',
    5107.44,
    1012.96,
    1012.96,
    0.00,
    'PNC Invoice Summary:\n\nInvoice #: S10213\nAmount Due: $1,012.96\nDue Date: 11/15/24\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    352,
    'INV000319',
    '2024-11-01',
    '14',
    '2024-09',
    '2024-11-15',
    3145.95,
    294.68,
    294.68,
    0.00,
    'PNC Invoice Summary:\nInvoice #: S10202\nAmount Due: $294.68\nDue Date: 11/15/24\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    353,
    'INV000320',
    '2024-11-01',
    '15',
    '2024-09',
    '2024-11-15',
    384.60,
    58.89,
    58.89,
    0.00,
    'PNC Invoice Summary:\nInvoice #: S10201\nAmount Due: $58.89\nDue Date: 11/15/24\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    354,
    'INV000321',
    '2024-11-01',
    '19',
    '2024-09',
    '2024-11-15',
    5378.00,
    403.35,
    403.35,
    0.00,
    'PNC Invoice Summary:\n\nInvoice #: S10209\nAmount Due: $403.35\nDue Date: 11/15/24\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    355,
    'INV000322',
    '2024-11-15',
    '20',
    '2024-09',
    '2024-12-01',
    20735.18,
    2399.47,
    2399.47,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    356,
    'INV000323',
    '2024-11-15',
    '21',
    '2024-09',
    '2024-12-01',
    5352.90,
    765.37,
    765.37,
    0.00,
    'PNC',
    'UNPAID',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    357,
    'INV000324',
    '2024-11-01',
    '24',
    '2024-09',
    '2024-11-15',
    17237.20,
    1716.03,
    1716.03,
    0.00,
    'PNC Invoice #: S10195',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    358,
    'INV000325',
    '2024-11-01',
    '29',
    '2024-09',
    '2024-11-15',
    5960.93,
    521.71,
    521.71,
    0.00,
    'PNC Invoice Summary:\nInvoice #: S10203\nAmount Due: $521.71\nDue Date: 11/15/24\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    359,
    'INV000326',
    '2024-11-01',
    '30',
    '2024-09',
    '2024-11-15',
    3153.23,
    283.79,
    283.79,
    0.00,
    'PNC Invoice #: S10198',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    360,
    'INV000327',
    '2024-11-15',
    '34',
    '2024-09',
    '2024-12-01',
    10679.30,
    1249.19,
    1249.19,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    0,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    361,
    'INV000328',
    '2024-11-01',
    '36',
    '2024-09',
    '2024-11-15',
    51432.10,
    2645.86,
    2645.86,
    0.00,
    'PNC Invoice Summary:\n\nInvoice #: S10214\nAmount Due: $2,645.86\nDue Date: 11/15/24\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    362,
    'INV000329',
    '2024-11-01',
    '37',
    '2024-09',
    '2024-11-15',
    42479.34,
    3100.99,
    3100.99,
    0.00,
    'PNC Invoice Summary:\n\nInvoice #: S10211\nAmount Due: $3,100.99\nDue Date: 11/15/24\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    363,
    'INV000330',
    '2024-11-01',
    '216',
    '2024-09',
    '2024-11-15',
    10620.62,
    1005.55,
    1005.55,
    0.00,
    'PNC Invoice Summary:\nInvoice #: S10204\nAmount Due: $1,005.55\nDue Date: 11/15/24\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    364,
    'INV000331',
    '2024-11-01',
    '217',
    '2024-09',
    '2024-11-15',
    800.71,
    60.05,
    60.05,
    0.00,
    'PNC Invoice Summary:\nInvoice #: S10205\nAmount Due: $60.05\nDue Date: 11/15/24\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    365,
    'INV000332',
    '2024-11-01',
    '220',
    '2024-09',
    '2024-11-15',
    5068.53,
    380.14,
    380.14,
    0.00,
    'PNC Invoice #: S10197\n',
    'UNPAID',
    'Auto',
    0,
    1,
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: provider_receipt_item_table
# ------------------------------------------------------------

INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (20, 12, 25, '2024-02-01', 'INV000002', 0.00, 0.00, 0.00);
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (21, 12, 26, '2024-01-01', 'INV000003', 0.00, 0.00, 0.00);
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (22, 13, 27, '2023-12-01', 'INV000004', 0.00, 0.00, 0.00);
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    23,
    14,
    26,
    '2024-01-01',
    'INV000003',
    1950.00,
    1950.00,
    1950.00
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    24,
    15,
    34,
    '2023-12-15',
    'INV000011',
    2441.61,
    2441.61,
    2441.61
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (25, 16, 55, '2024-02-01', 'INV000032', 0.00, 0.00, 0.00);
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    26,
    17,
    58,
    '2024-02-15',
    'INV000035',
    1390.67,
    1390.67,
    1390.67
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (27, 18, 65, '2024-02-01', 'INV000042', 0.00, 0.00, 0.00);
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    28,
    19,
    65,
    '2024-02-01',
    'INV000042',
    870.00,
    870.00,
    870.00
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    29,
    20,
    68,
    '2024-02-15',
    'INV000045',
    2444.97,
    2444.97,
    2444.97
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    30,
    21,
    84,
    '2024-03-01',
    'INV000061',
    3074.52,
    3074.52,
    3074.52
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    31,
    22,
    70,
    '2024-03-01',
    'INV000047',
    2002.33,
    2002.33,
    2002.33
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    32,
    23,
    102,
    '2024-03-15',
    'INV000079',
    300.54,
    300.54,
    300.54
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    33,
    24,
    93,
    '2024-03-15',
    'INV000070',
    1978.17,
    1978.17,
    1978.17
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    34,
    25,
    121,
    '2024-04-15',
    'INV000098',
    1126.03,
    1126.03,
    1126.03
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    35,
    26,
    122,
    '2024-04-15',
    'INV000099',
    302.45,
    302.45,
    302.45
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    36,
    27,
    94,
    '2024-03-15',
    'INV000071',
    2947.29,
    2947.29,
    2947.29
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    37,
    28,
    128,
    '2024-04-15',
    'INV000105',
    2485.25,
    2485.25,
    2485.25
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    38,
    29,
    155,
    '2024-05-15',
    'INV000132',
    1999.49,
    1999.49,
    1999.49
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    39,
    30,
    153,
    '2024-03-01',
    'INV000130',
    1485.02,
    1485.02,
    1485.02
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    40,
    31,
    159,
    '2024-05-15',
    'INV000136',
    1133.71,
    1133.71,
    1133.71
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    41,
    32,
    160,
    '2024-05-15',
    'INV000137',
    145.20,
    145.20,
    145.20
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    42,
    33,
    156,
    '2024-05-15',
    'INV000133',
    619.82,
    619.82,
    619.82
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    43,
    34,
    162,
    '2024-05-15',
    'INV000139',
    210.36,
    210.36,
    210.36
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    44,
    35,
    187,
    '2024-06-15',
    'INV000164',
    3043.05,
    3043.05,
    3043.05
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    45,
    36,
    192,
    '2024-06-15',
    'INV000169',
    513.74,
    513.74,
    513.74
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    46,
    37,
    193,
    '2024-06-15',
    'INV000170',
    554.00,
    554.00,
    554.00
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    47,
    38,
    165,
    '2024-06-15',
    'INV000142',
    1146.83,
    1146.83,
    1146.83
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    48,
    39,
    195,
    '2024-06-15',
    'INV000172',
    323.17,
    323.17,
    323.17
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    49,
    40,
    196,
    '2024-06-15',
    'INV000173',
    2426.12,
    2426.12,
    2426.12
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    50,
    41,
    170,
    '2024-06-15',
    'INV000147',
    1139.88,
    1139.88,
    1139.88
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    51,
    42,
    194,
    '2024-06-15',
    'INV000171',
    66.60,
    66.60,
    66.60
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    52,
    43,
    190,
    '2024-06-15',
    'INV000167',
    1610.15,
    1610.15,
    1610.15
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    53,
    44,
    158,
    '2024-05-15',
    'INV000135',
    28.99,
    28.99,
    28.99
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    54,
    44,
    163,
    '2024-05-15',
    'INV000140',
    85.30,
    85.30,
    85.30
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    55,
    45,
    186,
    '2024-06-01',
    'INV000163',
    139.09,
    139.09,
    139.09
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    56,
    46,
    169,
    '2024-06-01',
    'INV000146',
    1807.71,
    1807.71,
    1807.71
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    57,
    47,
    182,
    '2024-06-01',
    'INV000159',
    372.94,
    372.94,
    372.94
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    58,
    48,
    191,
    '2024-06-01',
    'INV000168',
    382.95,
    382.95,
    382.95
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    59,
    49,
    172,
    '2024-06-01',
    'INV000149',
    485.58,
    485.58,
    485.58
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    60,
    50,
    214,
    '2024-06-01',
    'INV000191',
    905.46,
    905.46,
    905.46
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    61,
    51,
    225,
    '2024-07-15',
    'INV000202',
    2270.44,
    2270.44,
    2270.44
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    62,
    52,
    245,
    '2024-08-01',
    'INV000222',
    0.00,
    0.00,
    0.00
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    63,
    53,
    223,
    '2024-07-15',
    'INV000200',
    2626.40,
    2626.40,
    2626.40
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    64,
    54,
    218,
    '2024-07-15',
    'INV000195',
    590.88,
    590.88,
    590.88
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    65,
    55,
    217,
    '2024-07-15',
    'INV000194',
    225.62,
    225.62,
    225.62
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    66,
    56,
    236,
    '2024-07-01',
    'INV000213',
    194.17,
    194.17,
    194.17
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    67,
    57,
    229,
    '2024-08-01',
    'INV000206',
    1612.40,
    1612.40,
    1612.40
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    68,
    58,
    248,
    '2024-08-01',
    'INV000225',
    301.96,
    301.96,
    301.96
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    69,
    59,
    247,
    '2024-08-01',
    'INV000224',
    0.00,
    0.00,
    0.00
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    70,
    60,
    245,
    '2024-08-01',
    'INV000222',
    2260.21,
    2260.21,
    2260.21
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    71,
    61,
    231,
    '2024-08-01',
    'INV000208',
    4628.12,
    4628.12,
    4628.12
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    72,
    62,
    233,
    '2024-08-01',
    'INV000210',
    28.56,
    28.56,
    28.56
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    73,
    63,
    235,
    '2024-08-01',
    'INV000212',
    421.16,
    421.16,
    421.16
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    74,
    64,
    238,
    '2024-08-01',
    'INV000215',
    1102.55,
    1102.55,
    1102.55
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    75,
    65,
    237,
    '2024-08-01',
    'INV000214',
    105.60,
    105.60,
    105.60
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    76,
    66,
    249,
    '2024-08-01',
    'INV000226',
    1130.18,
    1130.18,
    1130.18
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    77,
    67,
    241,
    '2024-08-01',
    'INV000218',
    1895.82,
    1895.82,
    1895.82
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    78,
    68,
    234,
    '2024-08-01',
    'INV000211',
    1181.92,
    1181.92,
    1181.92
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    79,
    69,
    227,
    '2024-08-01',
    'INV000204',
    1498.67,
    1498.67,
    1498.67
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    80,
    70,
    228,
    '2024-08-01',
    'INV000205',
    152.90,
    152.90,
    152.90
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    81,
    71,
    232,
    '2024-08-01',
    'INV000209',
    410.95,
    410.95,
    410.95
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    82,
    72,
    242,
    '2024-08-01',
    'INV000219',
    419.13,
    419.13,
    419.13
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    83,
    73,
    246,
    '2024-07-15',
    'INV000223',
    2273.03,
    2273.03,
    2273.03
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    84,
    74,
    256,
    '2024-08-15',
    'INV000228',
    305.12,
    305.12,
    305.12
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    85,
    75,
    262,
    '2024-08-15',
    'INV000229',
    850.82,
    850.82,
    850.82
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    86,
    76,
    239,
    '2024-08-15',
    'INV000216',
    3003.58,
    3003.58,
    3003.58
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    87,
    77,
    212,
    '2024-07-01',
    'INV000189',
    457.88,
    457.88,
    457.88
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    88,
    78,
    185,
    '2024-06-01',
    'INV000162',
    508.63,
    508.63,
    508.63
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    89,
    79,
    138,
    '2024-05-01',
    'INV000115',
    1080.81,
    1080.81,
    1080.81
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    90,
    80,
    290,
    '2024-08-15',
    'INV000257',
    1882.47,
    1882.47,
    1882.47
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    91,
    81,
    157,
    '2024-05-15',
    'INV000134',
    1019.85,
    1019.85,
    1019.85
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    92,
    82,
    139,
    '2024-04-15',
    'INV000116',
    1588.71,
    1588.71,
    1588.71
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    93,
    83,
    87,
    '2024-03-15',
    'INV000064',
    1350.66,
    1350.66,
    1350.66
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    94,
    84,
    50,
    '2024-01-01',
    'INV000027',
    1439.90,
    1439.90,
    1439.90
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    95,
    85,
    296,
    '2024-09-01',
    'INV000263',
    2148.42,
    2148.42,
    2148.42
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    96,
    86,
    295,
    '2024-09-01',
    'INV000262',
    1903.34,
    1903.34,
    1903.34
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    97,
    87,
    287,
    '2024-09-01',
    'INV000254',
    485.31,
    485.31,
    485.31
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    98,
    88,
    280,
    '2024-08-01',
    'INV000247',
    267.44,
    267.44,
    267.44
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    99,
    89,
    327,
    '2024-09-01',
    'INV000294',
    554.30,
    554.30,
    554.30
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    100,
    90,
    49,
    '2024-01-15',
    'INV000026',
    200.88,
    200.88,
    200.88
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    101,
    91,
    105,
    '2024-04-01',
    'INV000082',
    220.65,
    220.65,
    220.65
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    102,
    92,
    92,
    '2024-03-01',
    'INV000069',
    443.61,
    443.61,
    443.61
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    103,
    93,
    132,
    '2024-05-01',
    'INV000109',
    253.15,
    253.15,
    253.15
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    104,
    94,
    209,
    '2024-07-01',
    'INV000186',
    436.65,
    436.65,
    436.65
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    105,
    95,
    243,
    '2024-08-01',
    'INV000220',
    325.95,
    325.95,
    325.95
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    106,
    96,
    311,
    '2024-09-15',
    'INV000278',
    302.36,
    302.36,
    302.36
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    107,
    97,
    310,
    '2024-09-15',
    'INV000277',
    300.72,
    300.72,
    300.72
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    108,
    98,
    253,
    '2024-09-15',
    'INV000230',
    2466.06,
    2466.06,
    2466.06
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    109,
    99,
    308,
    '2024-10-01',
    'INV000275',
    761.37,
    761.37,
    761.37
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    110,
    100,
    341,
    '2024-10-15',
    'INV000308',
    1746.28,
    1746.28,
    1746.28
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    111,
    101,
    320,
    '2024-10-15',
    'INV000287',
    1777.36,
    1777.36,
    1777.36
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    112,
    102,
    302,
    '2024-10-15',
    'INV000269',
    949.20,
    949.20,
    949.20
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    113,
    103,
    338,
    '2024-10-15',
    'INV000305',
    113.51,
    113.51,
    113.51
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    114,
    104,
    339,
    '2024-10-15',
    'INV000306',
    1257.02,
    1257.02,
    1257.02
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    115,
    105,
    312,
    '2024-10-01',
    'INV000279',
    792.16,
    792.16,
    792.16
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    116,
    106,
    318,
    '2024-10-01',
    'INV000285',
    385.04,
    385.04,
    385.04
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    117,
    107,
    324,
    '2024-10-01',
    'INV000291',
    492.68,
    492.68,
    492.68
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    118,
    108,
    326,
    '2024-10-01',
    'INV000293',
    546.19,
    546.19,
    546.19
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    119,
    109,
    301,
    '2024-10-01',
    'INV000268',
    1886.98,
    1886.98,
    1886.98
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    120,
    110,
    340,
    '2024-10-15',
    'INV000307',
    992.68,
    992.68,
    992.68
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    121,
    111,
    335,
    '2024-10-01',
    'INV000302',
    412.54,
    412.54,
    412.54
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    122,
    112,
    334,
    '2024-10-01',
    'INV000301',
    1322.20,
    1322.20,
    1322.20
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    123,
    113,
    315,
    '2024-09-01',
    'INV000282',
    2472.16,
    2472.16,
    2472.16
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    124,
    114,
    240,
    '2024-08-15',
    'INV000217',
    1108.70,
    1108.70,
    1108.70
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    125,
    115,
    255,
    '2024-09-15',
    'INV000231',
    656.89,
    656.89,
    656.89
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    126,
    116,
    314,
    '2024-10-15',
    'INV000281',
    1090.08,
    1090.08,
    1090.08
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: provider_receipt_table
# ------------------------------------------------------------

INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    12,
    'REC000001',
    '2024-01-10',
    210,
    'Bank Transfer',
    NULL,
    0.00,
    'CANCELLED',
    'Fahad Razzaq',
    58,
    '2024-01-09',
    'Fahad Razzaq',
    58,
    '2024-01-09',
    32
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    13,
    'REC000002',
    '2024-01-10',
    211,
    'Cash',
    NULL,
    0.00,
    'CANCELLED',
    'Fahad Razzaq',
    58,
    '2024-01-09',
    'Fahad Razzaq',
    58,
    '2024-01-09',
    32
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    14,
    'REC000003',
    '2024-01-10',
    210,
    'Cash',
    NULL,
    1950.00,
    'POSTED',
    'Fahad Razzaq',
    58,
    '2024-01-09',
    NULL,
    NULL,
    NULL,
    32
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    15,
    'REC000004',
    '2024-01-01',
    17,
    'Bank Transfer',
    'CC',
    2441.61,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-01-17',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000005',
    '2024-02-15',
    216,
    'Bank Transfer',
    'ACH Transfer',
    0.00,
    'CANCELLED',
    'Irish  Smith',
    2,
    '2024-02-20',
    'Irish  Smith',
    2,
    '2024-02-23',
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000006',
    '2024-02-15',
    5,
    'Bank Transfer',
    'ACH',
    1390.67,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-02-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000007',
    '2024-02-23',
    210,
    'Cash',
    '123',
    0.00,
    'CANCELLED',
    'Fahad Razzaq',
    58,
    '2024-02-23',
    'Fahad Razzaq',
    58,
    '2024-02-23',
    32
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000008',
    '2024-02-23',
    210,
    'Cash',
    '12345',
    870.00,
    'POSTED',
    'Fahad Razzaq',
    58,
    '2024-02-23',
    NULL,
    NULL,
    NULL,
    32
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000009',
    '2024-03-01',
    17,
    'Card Payment',
    NULL,
    2444.97,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-03-14',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000010',
    '2024-03-20',
    37,
    'Bank Transfer',
    NULL,
    3074.52,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-03-22',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000011',
    '2024-03-20',
    24,
    'Bank Transfer',
    NULL,
    2002.33,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-03-22',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000012',
    '2024-04-01',
    16,
    'Card Payment',
    'CC Pmt',
    300.54,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-04-04',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000013',
    '2024-04-01',
    17,
    'Card Payment',
    NULL,
    1978.17,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-04-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000014',
    '2024-05-01',
    17,
    'Card Payment',
    '27075G',
    1126.03,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-05-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000015',
    '2024-05-01',
    16,
    'Card Payment',
    '08930C',
    302.45,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-05-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000016',
    '2024-04-01',
    20,
    'Card Payment',
    NULL,
    2947.29,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-05-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000017',
    '2024-05-01',
    20,
    'Card Payment',
    ' 187833',
    2485.25,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-05-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000018',
    '2024-06-04',
    20,
    'Card Payment',
    '162429',
    1999.49,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-06-04',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000019',
    '2024-03-15',
    24,
    'Bank Transfer',
    NULL,
    1485.02,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-06-10',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000020',
    '2024-06-01',
    17,
    'Bank Transfer',
    NULL,
    1133.71,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-06-10',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `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,
    'REC000021',
    '2024-06-10',
    18,
    'Card Payment',
    NULL,
    145.20,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-06-10',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    33,
    'REC000022',
    '2024-06-03',
    21,
    'Bank Transfer',
    'NFCU',
    619.82,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-06-10',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    34,
    'REC000023',
    '2024-06-01',
    16,
    'Card Payment',
    NULL,
    210.36,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-06-10',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    35,
    'REC000024',
    '2024-07-01',
    20,
    'Card Payment',
    '123030',
    3043.05,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    36,
    'REC000025',
    '2024-07-01',
    16,
    'Card Payment',
    '06695C',
    513.74,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    37,
    'REC000026',
    '2024-07-01',
    17,
    'Card Payment',
    '74642G',
    554.00,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    38,
    'REC000027',
    '2024-07-01',
    34,
    'Bank Transfer',
    'n/a',
    1146.83,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    39,
    'REC000028',
    '2024-07-01',
    31,
    'Bank Transfer',
    'ACH transfer',
    323.17,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    40,
    'REC000029',
    '2024-07-03',
    214,
    'Bank Transfer',
    'ACH transfer',
    2426.12,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    41,
    'REC000030',
    '2024-07-01',
    5,
    'Bank Transfer',
    'ACH transfer',
    1139.88,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    42,
    'REC000031',
    '2024-07-01',
    26,
    'Bank Transfer',
    'ACH transfer',
    66.60,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    43,
    'REC000032',
    '2024-07-01',
    1,
    'Bank Transfer',
    'ACH transfer',
    1610.15,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    44,
    'REC000033',
    '2024-07-01',
    26,
    'Bank Transfer',
    'ACH transfer',
    114.29,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    45,
    'REC000034',
    '2024-06-15',
    217,
    'Bank Transfer',
    'ACH transfer',
    139.09,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    46,
    'REC000035',
    '2024-06-15',
    4,
    'Bank Transfer',
    'ACH transfer',
    1807.71,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    47,
    'REC000036',
    '2024-06-15',
    30,
    'Card Payment',
    'ACH transfer',
    372.94,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    48,
    'REC000037',
    '2024-06-15',
    7,
    'Bank Transfer',
    'ACH transfer',
    382.95,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    49,
    'REC000038',
    '2024-06-15',
    7,
    'Bank Transfer',
    'ACH transfer',
    485.58,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-04',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    50,
    'REC000039',
    '2024-06-15',
    19,
    'Bank Transfer',
    'ACH Transfer',
    905.46,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-07-04',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    51,
    'REC000040',
    '2024-08-01',
    34,
    'Bank Transfer',
    'ACH',
    2270.44,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    52,
    'REC000041',
    '2024-08-01',
    37,
    'Card Payment',
    'APPROVAL 107270',
    0.00,
    'CANCELLED',
    'Irish  Smith',
    2,
    '2024-08-06',
    'Irish  Smith',
    2,
    '2024-08-06',
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    53,
    'REC000042',
    '2024-08-01',
    20,
    'Card Payment',
    'Approved (APPROVAL 107270)\t',
    2626.40,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    54,
    'REC000043',
    '2024-08-01',
    17,
    'Card Payment',
    '75156G',
    590.88,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    55,
    'REC000044',
    '2024-08-01',
    16,
    'Card Payment',
    '01902C',
    225.62,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    56,
    'REC000045',
    '2024-08-19',
    14,
    'Bank Transfer',
    'ACH',
    194.17,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    57,
    'REC000046',
    '2024-08-19',
    4,
    'Bank Transfer',
    NULL,
    1612.40,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    58,
    'REC000047',
    '2024-08-19',
    217,
    'Bank Transfer',
    NULL,
    301.96,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    59,
    'REC000048',
    '2024-08-19',
    216,
    'Bank Transfer',
    NULL,
    0.00,
    'CANCELLED',
    'Irish  Smith',
    2,
    '2024-08-15',
    'Irish  Smith',
    2,
    '2024-09-03',
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    60,
    'REC000049',
    '2024-08-19',
    37,
    'Bank Transfer',
    NULL,
    2260.21,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    61,
    'REC000050',
    '2024-08-19',
    6,
    'Bank Transfer',
    NULL,
    4628.12,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    62,
    'REC000051',
    '2024-08-19',
    10,
    'Bank Transfer',
    NULL,
    28.56,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    63,
    'REC000052',
    '2024-08-16',
    13,
    'Bank Transfer',
    NULL,
    421.16,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    64,
    'REC000053',
    '2024-08-16',
    19,
    'Bank Transfer',
    NULL,
    1102.55,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    65,
    'REC000054',
    '2024-08-16',
    15,
    'Bank Transfer',
    NULL,
    105.60,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    66,
    'REC000055',
    '2024-08-16',
    8,
    'Bank Transfer',
    NULL,
    1130.18,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    67,
    'REC000056',
    '2024-08-16',
    24,
    'Bank Transfer',
    NULL,
    1895.82,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    68,
    'REC000057',
    '2024-08-16',
    12,
    'Bank Transfer',
    NULL,
    1181.92,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    69,
    'REC000058',
    '2024-08-16',
    2,
    'Bank Transfer',
    NULL,
    1498.67,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    70,
    'REC000059',
    '2024-08-16',
    3,
    'Bank Transfer',
    NULL,
    152.90,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    71,
    'REC000060',
    '2024-08-16',
    7,
    'Bank Transfer',
    NULL,
    410.95,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    72,
    'REC000061',
    '2024-08-16',
    29,
    'Bank Transfer',
    NULL,
    419.13,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    73,
    'REC000062',
    '2024-08-09',
    214,
    'Bank Transfer',
    NULL,
    2273.03,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-08-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    74,
    'REC000063',
    '2024-09-03',
    16,
    'Card Payment',
    '02790C',
    305.12,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-03',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    75,
    'REC000064',
    '2024-09-03',
    17,
    'Card Payment',
    '56906G',
    850.82,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-03',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    76,
    'REC000065',
    '2024-09-03',
    20,
    'Card Payment',
    '127963',
    3003.58,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-03',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    77,
    'REC000066',
    '2024-07-15',
    216,
    'Bank Transfer',
    NULL,
    457.88,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-03',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    78,
    'REC000067',
    '2024-08-15',
    216,
    'Bank Transfer',
    NULL,
    508.63,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-03',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    79,
    'REC000068',
    '2024-05-15',
    216,
    'Bank Transfer',
    NULL,
    1080.81,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-03',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    80,
    'REC000069',
    '2024-09-01',
    214,
    'Bank Transfer',
    NULL,
    1882.47,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    81,
    'REC000070',
    '2024-06-01',
    34,
    'Bank Transfer',
    NULL,
    1019.85,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    82,
    'REC000071',
    '2024-05-01',
    34,
    'Bank Transfer',
    NULL,
    1588.71,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    83,
    'REC000072',
    '2024-04-01',
    34,
    'Bank Transfer',
    NULL,
    1350.66,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    84,
    'REC000073',
    '2024-01-15',
    34,
    'Bank Transfer',
    NULL,
    1439.90,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    85,
    'REC000074',
    '2024-09-15',
    37,
    'Bank Transfer',
    NULL,
    2148.42,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    86,
    'REC000075',
    '2024-09-15',
    4,
    'Bank Transfer',
    NULL,
    1903.34,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    87,
    'REC000076',
    '2024-09-15',
    29,
    'Bank Transfer',
    NULL,
    485.31,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    88,
    'REC000077',
    '2024-08-15',
    14,
    'Bank Transfer',
    NULL,
    267.44,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-20',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    89,
    'REC000078',
    '2024-09-27',
    30,
    'Bank Transfer',
    NULL,
    554.30,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    90,
    'REC000079',
    '2024-02-15',
    30,
    'Bank Transfer',
    NULL,
    200.88,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    91,
    'REC000080',
    '2024-04-15',
    30,
    'Bank Transfer',
    NULL,
    220.65,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    92,
    'REC000081',
    '2024-03-15',
    30,
    'Bank Transfer',
    NULL,
    443.61,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    93,
    'REC000082',
    '2024-05-15',
    30,
    'Bank Transfer',
    NULL,
    253.15,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    94,
    'REC000083',
    '2024-07-15',
    30,
    'Bank Transfer',
    NULL,
    436.65,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    95,
    'REC000084',
    '2024-08-29',
    30,
    'Bank Transfer',
    NULL,
    325.95,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-09-30',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    96,
    'REC000085',
    '2024-10-05',
    17,
    'Bank Transfer',
    '49604G',
    302.36,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-10-05',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    97,
    'REC000086',
    '2024-10-05',
    16,
    'Bank Transfer',
    '05639C',
    300.72,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-10-05',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    98,
    'REC000087',
    '2024-10-05',
    20,
    'Card Payment',
    '182701',
    2466.06,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-10-05',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    99,
    'REC000088',
    '2024-10-15',
    13,
    'Bank Transfer',
    NULL,
    761.37,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-10-15',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    100,
    'REC000089',
    '2024-11-01',
    214,
    'Bank Transfer',
    'ACH',
    1746.28,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    101,
    'REC000090',
    '2024-11-01',
    34,
    'Bank Transfer',
    'ACH',
    1777.36,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    102,
    'REC000091',
    '2024-11-01',
    5,
    'Bank Transfer',
    'ACH',
    949.20,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    103,
    'REC000092',
    '2024-11-01',
    26,
    'Bank Transfer',
    'ACH',
    113.51,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    104,
    'REC000093',
    '2024-11-01',
    1,
    'Bank Transfer',
    'ACH',
    1257.02,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    105,
    'REC000094',
    '2024-11-01',
    19,
    'Bank Transfer',
    'ACH',
    792.16,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    106,
    'REC000095',
    '2024-10-15',
    30,
    'Bank Transfer',
    'ACH',
    385.04,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    107,
    'REC000096',
    '2024-10-15',
    216,
    'Bank Transfer',
    'ACH',
    492.68,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    108,
    'REC000097',
    '2024-10-15',
    220,
    'Bank Transfer',
    'ACH',
    546.19,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    109,
    'REC000098',
    '2024-10-15',
    4,
    'Bank Transfer',
    'ACH',
    1886.98,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    110,
    'REC000099',
    '2024-11-01',
    31,
    'Bank Transfer',
    'ACH',
    992.68,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    111,
    'REC000100',
    '2024-10-15',
    14,
    'Bank Transfer',
    'ACH',
    412.54,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    112,
    'REC000101',
    '2024-10-15',
    12,
    'Bank Transfer',
    'ACH',
    1322.20,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    113,
    'REC000102',
    '2024-10-15',
    24,
    'Bank Transfer',
    'ACH',
    2472.16,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-01',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    114,
    'REC000103',
    '2024-09-01',
    21,
    'Bank Transfer',
    'NFCU Transfer',
    1108.70,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    115,
    'REC000104',
    '2024-10-01',
    21,
    'Bank Transfer',
    'NFCU Transfer',
    656.89,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-06',
    NULL,
    NULL,
    NULL,
    1
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    116,
    'REC000105',
    '2024-11-01',
    21,
    'Bank Transfer',
    'NFCU Transfer',
    1090.08,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-11-06',
    NULL,
    NULL,
    NULL,
    1
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: provider_service_table
# ------------------------------------------------------------

INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    10,
    'Insurance Collections',
    'Fahad Razzaq',
    '2024-01-09 21:13:04',
    32
  );
INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    11,
    'Patient Collections',
    'Fahad Razzaq',
    '2024-01-09 21:13:18',
    32
  );
INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    12,
    'Insurance Income',
    'Irish  Smith',
    '2024-01-10 10:20:24',
    1
  );
INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    13,
    'Patient Income',
    'Irish  Smith',
    '2024-01-10 10:20:31',
    1
  );
INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    14,
    'EHR Fee',
    'Irish  Smith',
    '2024-01-10 10:20:44',
    1
  );
INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    15,
    'Verification of Benefits',
    'Irish  Smith',
    '2024-01-10 10:20:59',
    1
  );
INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    16,
    'Statement Fees',
    'Irish  Smith',
    '2024-01-10 10:21:07',
    1
  );
INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    17,
    'EHR Fee',
    'Fahad Razzaq',
    '2024-01-14 04:10:49',
    32
  );
INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    18,
    'Website link',
    'Irish  Smith',
    '2024-02-01 12:00:16',
    1
  );
INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    19,
    'OMHC Income',
    'Irish  Smith',
    '2024-02-01 15:05:08',
    1
  );
INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    20,
    'PRP Income',
    'Irish  Smith',
    '2024-02-01 15:05:16',
    1
  );
INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    22,
    'Merchant Fee - Provider Paid for Svc with CC',
    'Irish  Smith',
    '2024-06-21 09:01:42',
    1
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: settings_table
# ------------------------------------------------------------

INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (1, 'POS01', 'CutePDF Writer');
INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (2, 'NP01', 'CutePDF Writer');
INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (3, 'TAX01', '45');
INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (4, 'VAT01', '15');
INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (5, 'COM01', 'ABC COMPANY PVT LTD');
INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (6, 'DateFormat', 'MM/DD/YYYY');

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: shared_document_table
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: task_table
# ------------------------------------------------------------

INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    22,
    48,
    'Fahad Razzaq',
    'Urgent',
    'test task',
    'abc',
    '2024-01-15',
    'In Progress',
    'Fahad Razzaq',
    32
  );

