INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    202,
    192,
    669,
    '2025-09-01',
    'INV000636',
    433.69,
    433.69,
    433.69
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    203,
    193,
    663,
    '2025-09-01',
    'INV000630',
    1202.62,
    1202.62,
    1202.62
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    204,
    194,
    666,
    '2025-09-01',
    'INV000633',
    394.66,
    394.66,
    394.66
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    205,
    195,
    672,
    '2025-08-01',
    'INV000639',
    473.84,
    473.84,
    473.84
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    206,
    196,
    675,
    '2025-09-01',
    'INV000642',
    1305.40,
    1305.40,
    1305.40
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    207,
    197,
    671,
    '2025-09-01',
    'INV000638',
    193.59,
    193.59,
    193.59
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    208,
    198,
    682,
    '2025-09-01',
    'INV000649',
    347.57,
    347.57,
    347.57
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    209,
    199,
    650,
    '2025-08-15',
    'INV000617',
    1453.20,
    1453.20,
    1453.20
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    210,
    200,
    661,
    '2025-08-15',
    'INV000628',
    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
  (
    211,
    201,
    662,
    '2025-08-15',
    'INV000629',
    1886.50,
    1886.50,
    1886.50
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    212,
    202,
    660,
    '2025-08-15',
    'INV000627',
    954.28,
    954.28,
    954.28
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    213,
    203,
    657,
    '2025-08-15',
    'INV000624',
    724.72,
    724.72,
    724.72
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    214,
    204,
    639,
    '2025-08-01',
    'INV000606',
    73.66,
    73.66,
    73.66
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    215,
    205,
    649,
    '2025-08-01',
    'INV000616',
    946.07,
    946.07,
    946.07
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    216,
    206,
    620,
    '2025-07-01',
    'INV000587',
    1150.33,
    1150.33,
    1150.33
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    217,
    207,
    688,
    '2025-09-15',
    'INV000655',
    300.94,
    300.94,
    300.94
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    218,
    208,
    687,
    '2025-09-15',
    'INV000654',
    1062.34,
    1062.34,
    1062.34
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    219,
    209,
    673,
    '2025-09-15',
    'INV000640',
    2695.72,
    2695.72,
    2695.72
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    220,
    210,
    681,
    '2025-09-01',
    'INV000648',
    412.31,
    412.31,
    412.31
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    221,
    211,
    637,
    '2025-08-01',
    'INV000604',
    331.63,
    331.63,
    331.63
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    222,
    212,
    608,
    '2025-07-01',
    'INV000575',
    544.51,
    544.51,
    544.51
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    223,
    213,
    571,
    '2025-06-01',
    'INV000538',
    600.12,
    600.12,
    600.12
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    224,
    214,
    696,
    '2025-10-01',
    'INV000663',
    183.72,
    183.72,
    183.72
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    225,
    215,
    583,
    '2025-06-01',
    'INV000550',
    125.39,
    125.39,
    125.39
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    226,
    216,
    680,
    '2025-09-01',
    'INV000647',
    200.40,
    200.40,
    200.40
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    227,
    217,
    638,
    '2025-08-01',
    'INV000605',
    2697.95,
    2697.95,
    2697.95
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    228,
    218,
    609,
    '2025-07-01',
    'INV000576',
    2744.08,
    2744.08,
    2744.08
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    229,
    219,
    692,
    '2025-09-01',
    'INV000659',
    730.14,
    730.14,
    730.14
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    230,
    220,
    684,
    '2025-09-01',
    'INV000651',
    542.24,
    542.24,
    542.24
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    231,
    221,
    683,
    '2025-09-01',
    'INV000650',
    123.35,
    123.35,
    123.35
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    232,
    222,
    686,
    '2025-09-15',
    'INV000653',
    1963.53,
    1963.53,
    1963.53
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    233,
    223,
    645,
    '2025-08-15',
    'INV000612',
    2415.10,
    2415.10,
    2415.10
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    234,
    224,
    658,
    '2025-08-15',
    'INV000625',
    1127.24,
    1127.24,
    1127.24
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    235,
    225,
    674,
    '2025-09-15',
    'INV000641',
    700.56,
    700.56,
    700.56
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    236,
    226,
    659,
    '2025-08-15',
    'INV000626',
    400.31,
    400.31,
    400.31
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    237,
    227,
    646,
    '2025-08-15',
    'INV000613',
    699.26,
    699.26,
    699.26
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    238,
    228,
    559,
    '2025-05-15',
    'INV000526',
    601.44,
    601.44,
    601.44
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    239,
    229,
    617,
    '2025-07-15',
    'INV000584',
    763.95,
    763.95,
    763.95
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    240,
    230,
    707,
    '2025-10-01',
    'INV000674',
    1238.01,
    1238.01,
    1238.01
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    241,
    231,
    709,
    '2025-10-01',
    'INV000676',
    449.51,
    449.51,
    449.51
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    242,
    232,
    706,
    '2025-10-01',
    'INV000673',
    70.45,
    70.45,
    70.45
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    243,
    233,
    700,
    '2025-10-01',
    'INV000667',
    309.06,
    309.06,
    309.06
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    244,
    234,
    703,
    '2025-10-01',
    'INV000670',
    408.80,
    408.80,
    408.80
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    245,
    235,
    704,
    '2025-10-01',
    'INV000671',
    432.44,
    432.44,
    432.44
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    246,
    236,
    697,
    '2025-10-01',
    'INV000664',
    1391.97,
    1391.97,
    1391.97
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    247,
    237,
    698,
    '2025-10-01',
    'INV000665',
    684.06,
    684.06,
    684.06
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    248,
    238,
    708,
    '2025-10-01',
    'INV000675',
    924.51,
    924.51,
    924.51
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    249,
    239,
    699,
    '2025-10-01',
    'INV000666',
    3735.73,
    3735.73,
    3735.73
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    250,
    240,
    715,
    '2025-10-01',
    'INV000682',
    252.08,
    252.08,
    252.08
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    251,
    241,
    717,
    '2025-10-01',
    'INV000684',
    89.71,
    89.71,
    89.71
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    252,
    242,
    705,
    '2025-10-01',
    'INV000672',
    100.27,
    100.27,
    100.27
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    253,
    243,
    677,
    '2025-09-01',
    'INV000644',
    800.69,
    800.69,
    800.69
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    254,
    244,
    702,
    '2025-10-01',
    'INV000669',
    155.99,
    155.99,
    155.99
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    255,
    245,
    718,
    '2025-10-01',
    'INV000685',
    1035.30,
    1035.30,
    1035.30
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    256,
    246,
    716,
    '2025-10-01',
    'INV000683',
    208.36,
    208.36,
    208.36
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    257,
    247,
    714,
    '2025-10-01',
    'INV000681',
    33.84,
    33.84,
    33.84
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    258,
    248,
    712,
    '2025-10-01',
    'INV000679',
    584.72,
    584.72,
    584.72
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    259,
    249,
    701,
    '2025-10-01',
    'INV000668',
    2231.89,
    2231.89,
    2231.89
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    260,
    250,
    754,
    '2025-11-15',
    'INV000721',
    793.05,
    793.05,
    793.05
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    261,
    251,
    755,
    '2025-11-15',
    'INV000722',
    444.03,
    444.03,
    444.03
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    262,
    252,
    759,
    '2025-11-15',
    'INV000726',
    91.00,
    91.00,
    91.00
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    263,
    253,
    758,
    '2025-11-15',
    'INV000725',
    1660.07,
    1660.07,
    1660.07
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    264,
    254,
    757,
    '2025-11-15',
    'INV000724',
    533.14,
    533.14,
    533.14
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    265,
    255,
    756,
    '2025-11-15',
    'INV000723',
    888.57,
    888.57,
    888.57
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    266,
    256,
    753,
    '2025-11-15',
    'INV000720',
    1633.47,
    1633.47,
    1633.47
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    267,
    257,
    582,
    '2025-06-01',
    'INV000549',
    5283.58,
    5283.58,
    5283.58
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    268,
    258,
    781,
    '2025-12-15',
    'INV000748',
    395.36,
    395.36,
    395.36
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    269,
    259,
    750,
    '2025-11-15',
    'INV000717',
    2750.56,
    2750.56,
    2750.56
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    270,
    260,
    779,
    '2025-12-15',
    'INV000746',
    2194.20,
    2194.20,
    2194.20
  );

# ------------------------------------------------------------
# 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',
    0.00,
    'CANCELLED',
    'Irish  Smith',
    2,
    '2024-11-01',
    'Irish  Smith',
    2,
    '2024-11-19',
    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
  );
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
  (
    117,
    'REC000106',
    '2024-12-02',
    16,
    'Card Payment',
    '01217C',
    326.95,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    118,
    'REC000107',
    '2024-12-02',
    17,
    'Card Payment',
    '52676G',
    224.80,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    119,
    'REC000108',
    '2024-12-02',
    21,
    'Bank Transfer',
    NULL,
    765.37,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    120,
    'REC000109',
    '2024-12-02',
    20,
    'Card Payment',
    '184132',
    2399.47,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    121,
    'REC000110',
    '2024-12-04',
    224,
    'Bank Transfer',
    NULL,
    531.33,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    122,
    'REC000111',
    '2024-12-04',
    34,
    'Bank Transfer',
    NULL,
    1249.19,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    123,
    'REC000112',
    '2024-12-04',
    31,
    'Bank Transfer',
    NULL,
    1074.96,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    124,
    'REC000113',
    '2024-12-04',
    214,
    'Bank Transfer',
    NULL,
    2235.72,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    125,
    'REC000114',
    '2024-12-03',
    5,
    'Bank Transfer',
    NULL,
    847.14,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    126,
    'REC000115',
    '2024-12-03',
    1,
    'Bank Transfer',
    NULL,
    1116.59,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    127,
    'REC000116',
    '2024-11-25',
    222,
    'Bank Transfer',
    NULL,
    15.00,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    128,
    'REC000117',
    '2024-11-19',
    30,
    'Bank Transfer',
    NULL,
    283.79,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    129,
    'REC000118',
    '2024-11-19',
    220,
    'Bank Transfer',
    NULL,
    380.14,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    130,
    'REC000119',
    '2024-11-19',
    216,
    'Bank Transfer',
    NULL,
    1005.55,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    131,
    'REC000120',
    '2024-11-19',
    217,
    'Bank Transfer',
    NULL,
    60.05,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    132,
    'REC000121',
    '2024-11-19',
    37,
    'Bank Transfer',
    NULL,
    3100.99,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    133,
    'REC000122',
    '2024-11-19',
    4,
    'Bank Transfer',
    NULL,
    1876.80,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    134,
    'REC000123',
    '2024-11-19',
    14,
    'Bank Transfer',
    NULL,
    294.68,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    135,
    'REC000124',
    '2024-11-19',
    10,
    'Bank Transfer',
    NULL,
    63.42,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    136,
    'REC000125',
    '2024-09-17',
    220,
    'Bank Transfer',
    NULL,
    712.66,
    'POSTED',
    'Irish  Smith',
    2,
    '2024-12-02',
    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
  (
    137,
    'REC000126',
    '2025-01-03',
    20,
    'Card Payment',
    'Amex',
    2574.10,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-01-21',
    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
  (
    138,
    'REC000127',
    '2025-01-06',
    21,
    'Card Payment',
    'NFCU',
    0.00,
    'CANCELLED',
    'Irish  Smith',
    2,
    '2025-01-21',
    'Irish  Smith',
    2,
    '2025-01-21',
    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
  (
    139,
    'REC000128',
    '2025-01-06',
    21,
    'Bank Transfer',
    'NFCU',
    800.29,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-01-21',
    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
  (
    140,
    'REC000129',
    '2025-01-01',
    17,
    'Card Payment',
    NULL,
    609.99,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-01-21',
    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
  (
    141,
    'REC000130',
    '2025-02-01',
    20,
    'Card Payment',
    '103462',
    2520.69,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-02-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
  (
    142,
    'REC000131',
    '2025-02-01',
    17,
    'Card Payment',
    '34513G',
    2378.32,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-02-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
  (
    143,
    'REC000132',
    '2025-02-01',
    16,
    'Card Payment',
    '07617C',
    319.37,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-02-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
  (
    144,
    'REC000133',
    '2025-01-31',
    21,
    'Bank Transfer',
    'NFCU Transfer',
    707.29,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-02-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
  (
    145,
    'REC000134',
    '2025-02-05',
    214,
    'Bank Transfer',
    NULL,
    1719.44,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-02-07',
    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
  (
    146,
    'REC000135',
    '2025-02-05',
    34,
    'Bank Transfer',
    NULL,
    1745.51,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-02-07',
    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
  (
    147,
    'REC000136',
    '2025-02-05',
    31,
    'Bank Transfer',
    NULL,
    603.77,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-02-07',
    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
  (
    148,
    'REC000137',
    '2025-02-15',
    225,
    'Bank Transfer',
    NULL,
    181.50,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-02-27',
    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
  (
    149,
    'REC000138',
    '2025-03-01',
    214,
    'Bank Transfer',
    NULL,
    1072.93,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-03-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
  (
    150,
    'REC000139',
    '2025-03-01',
    225,
    'Bank Transfer',
    NULL,
    383.07,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-03-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
  (
    151,
    'REC000140',
    '2025-03-01',
    31,
    'Bank Transfer',
    NULL,
    625.89,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-03-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
  (
    152,
    'REC000141',
    '2025-02-15',
    24,
    'Bank Transfer',
    NULL,
    1171.01,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-03-09',
    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
  (
    153,
    'REC000142',
    '2025-04-15',
    4,
    'Bank Transfer',
    NULL,
    2704.77,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-05-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
  (
    154,
    'REC000143',
    '2025-04-15',
    10,
    'Bank Transfer',
    NULL,
    56.69,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-05-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
  (
    155,
    'REC000144',
    '2025-04-15',
    222,
    'Bank Transfer',
    NULL,
    179.36,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-05-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
  (
    156,
    'REC000145',
    '2025-01-01',
    30,
    'Bank Transfer',
    NULL,
    398.60,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-06-16',
    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
  (
    157,
    'REC000146',
    '2025-07-02',
    20,
    'Card Payment',
    NULL,
    3182.02,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-07-02',
    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
  (
    158,
    'REC000147',
    '2025-07-02',
    16,
    'Bank Transfer',
    NULL,
    478.49,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-07-02',
    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
  (
    159,
    'REC000148',
    '2025-07-02',
    17,
    'Bank Transfer',
    NULL,
    1075.33,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-07-02',
    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
  (
    160,
    'REC000149',
    '2025-07-07',
    21,
    'Bank Transfer',
    'NFCU',
    767.23,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-07-09',
    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
  (
    161,
    'REC000150',
    '2025-07-18',
    2,
    'Bank Transfer',
    NULL,
    1130.12,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-07-18',
    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
  (
    162,
    'REC000151',
    '2025-07-18',
    227,
    'Bank Transfer',
    NULL,
    192.03,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-07-18',
    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
  (
    163,
    'REC000152',
    '2025-07-18',
    222,
    'Bank Transfer',
    NULL,
    97.03,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-07-18',
    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
  (
    164,
    'REC000153',
    '2025-07-18',
    220,
    'Bank Transfer',
    NULL,
    332.89,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-07-18',
    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
  (
    165,
    'REC000154',
    '2025-07-01',
    214,
    'Bank Transfer',
    NULL,
    1790.74,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-07-18',
    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
  (
    166,
    'REC000155',
    '2025-08-02',
    17,
    'Card Payment',
    '99703G',
    966.59,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    167,
    'REC000156',
    '2025-08-02',
    20,
    'Card Payment',
    '161285',
    2697.19,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    168,
    'REC000157',
    '2025-08-02',
    16,
    'Card Payment',
    '03628C',
    315.40,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    169,
    'REC000158',
    '2025-06-01',
    16,
    'Card Payment',
    NULL,
    316.09,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    170,
    'REC000159',
    '2025-08-01',
    31,
    'Bank Transfer',
    NULL,
    1394.19,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    171,
    'REC000160',
    '2025-08-01',
    34,
    'Bank Transfer',
    NULL,
    1811.23,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    172,
    'REC000161',
    '2025-08-01',
    214,
    'Bank Transfer',
    NULL,
    2010.28,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    173,
    'REC000162',
    '2025-08-01',
    1,
    'Bank Transfer',
    NULL,
    865.79,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    174,
    'REC000163',
    '2025-08-01',
    5,
    'Bank Transfer',
    NULL,
    1248.40,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    175,
    'REC000164',
    '2025-07-29',
    30,
    'Bank Transfer',
    NULL,
    1155.37,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    176,
    'REC000165',
    '2025-07-15',
    217,
    'Bank Transfer',
    NULL,
    32.69,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    177,
    'REC000166',
    '2025-06-16',
    222,
    'Bank Transfer',
    NULL,
    14.23,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    178,
    'REC000167',
    '2025-06-15',
    227,
    'Bank Transfer',
    NULL,
    13.90,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    179,
    'REC000168',
    '2025-06-16',
    227,
    'Bank Transfer',
    NULL,
    77.70,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    180,
    'REC000169',
    '2025-06-16',
    220,
    'Bank Transfer',
    NULL,
    396.14,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    181,
    'REC000170',
    '2025-07-15',
    37,
    'Bank Transfer',
    NULL,
    3773.18,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-02',
    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
  (
    182,
    'REC000171',
    '2025-07-15',
    24,
    'Bank Transfer',
    NULL,
    967.01,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    183,
    'REC000172',
    '2025-08-18',
    15,
    'Bank Transfer',
    NULL,
    100.92,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-18',
    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
  (
    184,
    'REC000173',
    '2025-08-18',
    14,
    'Bank Transfer',
    NULL,
    200.20,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-18',
    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
  (
    185,
    'REC000174',
    '2025-08-18',
    227,
    'Bank Transfer',
    NULL,
    54.62,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-18',
    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
  (
    186,
    'REC000175',
    '2025-08-18',
    222,
    'Bank Transfer',
    NULL,
    101.24,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-18',
    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
  (
    187,
    'REC000176',
    '2025-08-18',
    220,
    'Bank Transfer',
    NULL,
    380.59,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-18',
    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
  (
    188,
    'REC000177',
    '2025-08-18',
    217,
    'Bank Transfer',
    NULL,
    72.04,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-18',
    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
  (
    189,
    'REC000178',
    '2025-07-17',
    37,
    'Bank Transfer',
    NULL,
    3706.88,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-08-18',
    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
  (
    190,
    'REC000179',
    '2025-09-16',
    8,
    'Bank Transfer',
    NULL,
    2711.45,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-16',
    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
  (
    191,
    'REC000180',
    '2025-09-16',
    29,
    'Bank Transfer',
    NULL,
    705.72,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-16',
    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
  (
    192,
    'REC000181',
    '2025-09-16',
    12,
    'Bank Transfer',
    NULL,
    433.69,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-16',
    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
  (
    193,
    'REC000182',
    '2025-09-16',
    2,
    'Bank Transfer',
    NULL,
    1202.62,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-16',
    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
  (
    194,
    'REC000183',
    '2025-09-16',
    7,
    'Bank Transfer',
    NULL,
    394.66,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-16',
    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
  (
    195,
    'REC000184',
    '2025-09-16',
    19,
    'Bank Transfer',
    NULL,
    473.84,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-16',
    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
  (
    196,
    'REC000185',
    '2025-09-16',
    24,
    'Bank Transfer',
    NULL,
    1305.40,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-16',
    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
  (
    197,
    'REC000186',
    '2025-09-16',
    15,
    'Bank Transfer',
    NULL,
    193.59,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-16',
    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
  (
    198,
    'REC000187',
    '2025-09-16',
    222,
    'Bank Transfer',
    NULL,
    347.57,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-16',
    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
  (
    199,
    'REC000188',
    '2025-09-04',
    34,
    'Bank Transfer',
    NULL,
    1453.20,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-16',
    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
  (
    200,
    'REC000189',
    '2025-09-04',
    31,
    'Bank Transfer',
    NULL,
    0.00,
    'CANCELLED',
    'Irish  Smith',
    2,
    '2025-09-16',
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    201,
    'REC000190',
    '2025-09-04',
    214,
    'Bank Transfer',
    NULL,
    1886.50,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-16',
    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
  (
    202,
    'REC000191',
    '2025-09-03',
    1,
    'Bank Transfer',
    NULL,
    954.28,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-16',
    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
  (
    203,
    'REC000192',
    '2025-09-03',
    5,
    'Bank Transfer',
    NULL,
    724.72,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-16',
    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
  (
    204,
    'REC000193',
    '2025-08-19',
    10,
    'Bank Transfer',
    NULL,
    73.66,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-16',
    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
  (
    205,
    'REC000194',
    '2025-09-19',
    30,
    'Bank Transfer',
    NULL,
    946.07,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    206,
    'REC000195',
    '2025-07-16',
    30,
    'Bank Transfer',
    NULL,
    1150.33,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    207,
    'REC000196',
    '2025-10-03',
    16,
    'Card Payment',
    '01114C',
    300.94,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    208,
    'REC000197',
    '2025-10-03',
    17,
    'Card Payment',
    '66167G',
    1062.34,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    209,
    'REC000198',
    '2025-10-03',
    20,
    'Bank Transfer',
    '169667',
    2695.72,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    210,
    'REC000199',
    '2025-09-15',
    220,
    'Bank Transfer',
    NULL,
    412.31,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-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
  (
    211,
    'REC000200',
    '2025-08-15',
    7,
    'Bank Transfer',
    NULL,
    331.63,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-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
  (
    212,
    'REC000201',
    '2025-07-15',
    7,
    'Bank Transfer',
    NULL,
    544.51,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-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
  (
    213,
    'REC000202',
    '2025-06-15',
    7,
    'Bank Transfer',
    NULL,
    600.12,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-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
  (
    214,
    'REC000203',
    '2025-09-15',
    15,
    'Bank Transfer',
    NULL,
    183.72,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-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
  (
    215,
    'REC000204',
    '2025-06-15',
    217,
    'Bank Transfer',
    NULL,
    125.39,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-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
  (
    216,
    'REC000205',
    '2025-09-15',
    217,
    'Bank Transfer',
    NULL,
    200.40,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-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
  (
    217,
    'REC000206',
    '2025-08-15',
    8,
    'Bank Transfer',
    NULL,
    2697.95,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-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
  (
    218,
    'REC000207',
    '2025-07-15',
    8,
    'Bank Transfer',
    NULL,
    2744.08,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-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
  (
    219,
    'REC000208',
    '2025-09-15',
    13,
    'Bank Transfer',
    NULL,
    730.14,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-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
  (
    220,
    'REC000209',
    '2025-09-15',
    230,
    'Bank Transfer',
    NULL,
    542.24,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-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
  (
    221,
    'REC000210',
    '2025-09-15',
    227,
    'Bank Transfer',
    NULL,
    123.35,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-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
  (
    222,
    'REC000211',
    '2025-10-01',
    214,
    'Bank Transfer',
    NULL,
    1963.53,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-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
  (
    223,
    'REC000212',
    '2025-09-01',
    20,
    'Card Payment',
    NULL,
    2415.10,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-07',
    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
  (
    224,
    'REC000213',
    '2025-09-01',
    17,
    'Card Payment',
    NULL,
    1127.24,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-07',
    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
  (
    225,
    'REC000214',
    '2025-10-01',
    21,
    'Bank Transfer',
    NULL,
    700.56,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-07',
    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
  (
    226,
    'REC000215',
    '2025-09-01',
    16,
    'Bank Transfer',
    NULL,
    400.31,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-07',
    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
  (
    227,
    'REC000216',
    '2025-09-01',
    21,
    'Bank Transfer',
    NULL,
    699.26,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-07',
    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
  (
    228,
    'REC000217',
    '2025-06-01',
    21,
    'Bank Transfer',
    NULL,
    601.44,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-07',
    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
  (
    229,
    'REC000218',
    '2025-08-01',
    21,
    'Bank Transfer',
    NULL,
    763.95,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-07',
    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
  (
    230,
    'REC000219',
    '2025-10-15',
    19,
    'Bank Transfer',
    NULL,
    1238.01,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    231,
    'REC000220',
    '2025-10-15',
    29,
    'Bank Transfer',
    NULL,
    449.51,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    232,
    'REC000221',
    '2025-10-15',
    15,
    'Bank Transfer',
    NULL,
    70.45,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    233,
    'REC000222',
    '2025-10-17',
    7,
    'Bank Transfer',
    NULL,
    309.06,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    234,
    'REC000223',
    '2025-10-17',
    12,
    'Bank Transfer',
    NULL,
    408.80,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    235,
    'REC000224',
    '2025-10-17',
    13,
    'Bank Transfer',
    NULL,
    432.44,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    236,
    'REC000225',
    '2025-10-17',
    2,
    'Bank Transfer',
    NULL,
    1391.97,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    237,
    'REC000226',
    '2025-10-17',
    2,
    'Bank Transfer',
    'this is for  AR Rep pay ONLY',
    684.06,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    238,
    'REC000227',
    '2025-10-16',
    24,
    'Bank Transfer',
    NULL,
    924.51,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    239,
    'REC000228',
    '2025-10-20',
    4,
    'Bank Transfer',
    NULL,
    3735.73,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    240,
    'REC000229',
    '2025-10-17',
    220,
    'Bank Transfer',
    NULL,
    252.08,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    241,
    'REC000230',
    '2025-10-17',
    227,
    'Bank Transfer',
    NULL,
    89.71,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    242,
    'REC000231',
    '2025-10-17',
    14,
    'Bank Transfer',
    NULL,
    100.27,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    243,
    'REC000232',
    '2025-10-17',
    30,
    'Bank Transfer',
    NULL,
    800.69,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    244,
    'REC000233',
    '2025-10-17',
    10,
    'Bank Transfer',
    NULL,
    155.99,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    245,
    'REC000234',
    '2025-10-17',
    230,
    'Bank Transfer',
    NULL,
    1035.30,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    246,
    'REC000235',
    '2025-10-17',
    222,
    'Bank Transfer',
    NULL,
    208.36,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    247,
    'REC000236',
    '2025-10-17',
    217,
    'Bank Transfer',
    NULL,
    33.84,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    248,
    'REC000237',
    '2025-10-17',
    37,
    'Bank Transfer',
    NULL,
    584.72,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    249,
    'REC000238',
    '2025-10-17',
    8,
    'Bank Transfer',
    NULL,
    2231.89,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-10-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
  (
    250,
    'REC000239',
    '2025-12-02',
    17,
    'Card Payment',
    '05592G',
    793.05,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-12-02',
    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
  (
    251,
    'REC000240',
    '2025-12-02',
    16,
    'Card Payment',
    '09076C',
    444.03,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-12-02',
    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
  (
    252,
    'REC000241',
    '2025-12-02',
    234,
    'Card Payment',
    NULL,
    91.00,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-12-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
  (
    253,
    'REC000242',
    '2025-12-02',
    214,
    'Card Payment',
    NULL,
    1660.07,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-12-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
  (
    254,
    'REC000243',
    '2025-12-02',
    31,
    'Card Payment',
    NULL,
    533.14,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-12-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
  (
    255,
    'REC000244',
    '2025-12-02',
    1,
    'Card Payment',
    NULL,
    888.57,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-12-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
  (
    256,
    'REC000245',
    '2025-12-01',
    34,
    'Card Payment',
    NULL,
    1633.47,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-12-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
  (
    257,
    'REC000246',
    '2025-06-15',
    37,
    'Bank Transfer',
    NULL,
    5283.58,
    'POSTED',
    'Irish  Smith',
    2,
    '2025-12-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
  (
    258,
    'REC000247',
    '2026-01-05',
    17,
    'Bank Transfer',
    NULL,
    395.36,
    'POSTED',
    'Irish  Smith',
    2,
    '2026-01-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
  (
    259,
    'REC000248',
    '2025-12-01',
    20,
    'Card Payment',
    NULL,
    2750.56,
    'POSTED',
    'Irish  Smith',
    2,
    '2026-01-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
  (
    260,
    'REC000249',
    '2026-01-05',
    20,
    'Card Payment',
    NULL,
    2194.20,
    'POSTED',
    'Irish  Smith',
    2,
    '2026-01-05',
    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
  (
    23,
    'Statement w/Merchant Fees',
    'Irish  Smith',
    '2025-09-04 16:07:11',
    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
  );

