INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2766,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2026-01',
    20,
    0.00,
    7.30,
    0.00,
    NULL,
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2767,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Fixed',
    NULL,
    '2026-01',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2768,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    38,
    '2026-01',
    12,
    534.69,
    8.00,
    42.78,
    '3.00',
    16.04,
    26.73,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-02-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2769,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    47,
    '2026-01',
    13,
    255.00,
    8.00,
    20.40,
    '1.00',
    2.55,
    17.85,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-02-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2770,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Fixed',
    NULL,
    '2026-01',
    16,
    0.00,
    0.00,
    44.20,
    '0',
    0.00,
    44.20,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-16',
    1
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: company_details_table
# ------------------------------------------------------------

INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`,
    `CreatedID`
  )
VALUES
  (
    1,
    'Billing Plus, Inc.',
    '461361749',
    '3012023739',
    'ismith@billing-plus.com',
    'www.billing-plus.com',
    'Irish Smith',
    '3012023739',
    '2006-07-15',
    '1899-11-30',
    '4315 Northview Drive\r\nBowie, MD  20716',
    '',
    NULL,
    NOFORMAT_WRAP(
      "##X'[BLOB]