This DB HOLDS WAY MORE THAN JUST THIS DATA BELOW!
id`, `post_date`, `bank_id`, `account_number`, `account_name`, `transaction_name`, `status`, `debit_credit`, `amount`, `bank_reference`, `customer_reference`, `transaction_detail`, `detail`, `BAI_code`, `type`, `details`, `CCY`, `image`, `advice_reference`, `year`, `season
(2, '2024-04-26', '122016066', '363591035', 'TORO FRANCHISE ANCILLARY L L91035', 'PreAuthorized ACH Credit', 'Pending', 'Credit', '201.00', '096017411461224', '', 'PREAUTHORIZED CREDIT TPG PRODUCTS SBTPG LLC PPD TORO TAXES FRA V4OEHGOUOW7PAKI', 'V4OEHGOUOW7PAKI', '165', 'ACH', '', 'USD', 'N', '', 2024, 2024),
(3, '2024-04-26', '122016066', '363591035', 'TORO FRANCHISE ANCILLARY L L91035', 'PreAuthorized ACH Credit', 'Pending', 'Credit', '177.00', '096017411461306', '', 'PREAUTHORIZED CREDIT TPG PRODUCTS SBTPG LLC PPD TORO TAXES FRA S5RRBSMNQ7EHNZA', 'S5RRBSMNQ7EHNZA', '165', 'ACH', '', 'USD', 'N', '', 2024, 2024),
(4, '2024-04-26', '122016066', '363591035', 'TORO FRANCHISE ANCILLARY L L91035', 'PreAuthorized ACH Credit', 'Pending', 'Credit', '471.00', '096017411461321', '', 'PREAUTHORIZED CREDIT TPG PRODUCTS SBTPG LLC PPD TORO TAXES FRA CZLRL24JHHE4LRA', 'CZLRL24JHHE4LRA', '165', 'ACH', '', 'USD', 'N', '', 2024, 2024),
id`, `post_date`, `bank_id`, `account_number`, `account_name`, `transaction_name`, `status`, `debit_credit`, `amount`, `bank_reference`, `customer_reference`, `transaction_detail`, `detail`, `BAI_code`, `type`, `details`, `CCY`, `image`, `advice_reference`, `year`, `season
(2, '2024-04-26', '122016066', '363591035', 'TORO FRANCHISE ANCILLARY L L91035', 'PreAuthorized ACH Credit', 'Pending', 'Credit', '201.00', '096017411461224', '', 'PREAUTHORIZED CREDIT TPG PRODUCTS SBTPG LLC PPD TORO TAXES FRA V4OEHGOUOW7PAKI', 'V4OEHGOUOW7PAKI', '165', 'ACH', '', 'USD', 'N', '', 2024, 2024),
(3, '2024-04-26', '122016066', '363591035', 'TORO FRANCHISE ANCILLARY L L91035', 'PreAuthorized ACH Credit', 'Pending', 'Credit', '177.00', '096017411461306', '', 'PREAUTHORIZED CREDIT TPG PRODUCTS SBTPG LLC PPD TORO TAXES FRA S5RRBSMNQ7EHNZA', 'S5RRBSMNQ7EHNZA', '165', 'ACH', '', 'USD', 'N', '', 2024, 2024),
(4, '2024-04-26', '122016066', '363591035', 'TORO FRANCHISE ANCILLARY L L91035', 'PreAuthorized ACH Credit', 'Pending', 'Credit', '471.00', '096017411461321', '', 'PREAUTHORIZED CREDIT TPG PRODUCTS SBTPG LLC PPD TORO TAXES FRA CZLRL24JHHE4LRA', 'CZLRL24JHHE4LRA', '165', 'ACH', '', 'USD', 'N', '', 2024, 2024),
id`, `id_periods`, `user_id`, `type`, `amount`, `description`, `status_process`, `status`, `created_at`, `updated_at
(1953, 96, '30651', 'Past Due Balance', '2319.05', 'Period 3.1', 'Pending', 'active', '2024-02-01 15:57:12', '2024-02-01 15:57:12'),
(1954, 96, '65644', 'Past Due Balance', '2227.00', 'Period 3.1', 'Pending', 'active', '2024-02-01 15:57:12', '2024-02-01 15:57:12'),
(1955, 96, '22674', 'Past Due Balance', '3165.18', 'Period 3.1', 'Pending', 'active', '2024-02-01 15:57:12', '2024-02-01 15:57:12'),
(1956, 96, '23648', 'Past Due Balance', '8672.86', 'Period 3.1', 'Pending', 'active', '2024-02-01 15:57:12', '2024-02-01 15:57:12'),
(1957, 96, '22670', 'Past Due Balance', '5525.69', 'Period 3.1', 'Pending', 'active', '2024-02-01 15:57:12', '2024-02-01 15:57:12'),
(1953, 96, '30651', 'Past Due Balance', '2319.05', 'Period 3.1', 'Pending', 'active', '2024-02-01 15:57:12', '2024-02-01 15:57:12'),
(1954, 96, '65644', 'Past Due Balance', '2227.00', 'Period 3.1', 'Pending', 'active', '2024-02-01 15:57:12', '2024-02-01 15:57:12'),
(1955, 96, '22674', 'Past Due Balance', '3165.18', 'Period 3.1', 'Pending', 'active', '2024-02-01 15:57:12', '2024-02-01 15:57:12'),
(1956, 96, '23648', 'Past Due Balance', '8672.86', 'Period 3.1', 'Pending', 'active', '2024-02-01 15:57:12', '2024-02-01 15:57:12'),
(1957, 96, '22670', 'Past Due Balance', '5525.69', 'Period 3.1', 'Pending', 'active', '2024-02-01 15:57:12', '2024-02-01 15:57:12'),
id`, `transmitter_efin`, `partner_product_code`, `ssb_efin`, `sub_ssb_efin`, `sb_efin`, `sb_business_owner_name`, `sb_business_name`, `efin_ero_site`, `ero_business_owner_name`, `ero_business_name`, `efin_owner_name`, `office_id`, `ptin`, `application_reference_number`, `taxpayer_name`, `ssn`, `product_type`, `disbursed_date`, `ero_site_fees_requested`, `ero_site_fees_paid`, `deposits`, `collection`, `trace_number`, `comment`, `deposit_type`, `year`, `season`
'2024-02-21', '434.10', '434.10', '0.00', '0.00', '', 'ERO Prep Fees', '', 2024, 2024),
(2918, '411106', '1106', '', '', '884199', '', '', '886613', 'DAYNA GONZALEZ LOPEZ', '2034 AMERICA SERVICES', 'DAYNA GONZALEZ LOPEZ', '00000', 'P02500572', 'RMJGWYHJR3DZNHQKR', 'MIGUEL, RODRIGUEZ-LEGRA', 'XXX-XX-9791', 'Refund Transfer', '2024-02-21', '570.00', '570.00', '0.00', '0.00', '', 'ERO Prep Fees', '', 2024, 2024),
(2919, '411106', '1106', '', '', '884199', '', '', '886613', 'DAYNA GONZALEZ LOPEZ', '2034 AMERICA SERVICES', 'DAYNA GONZALEZ LOPEZ', '00000', 'P03075076', 'RML5X22OMVUBCXJ4O', 'DANIELA, BLANCO ORTIZ', 'XXX-XX-0382', 'Refund Transfer', '2024-02-21', '480.00', '480.00', '0.00', '0.00', '', 'ERO Prep Fees', '', 2024, 2024),
(2920, '411106', '1106', '', '', '884199', '', '', '886613', 'DAYNA GONZALEZ LOPEZ', '2034 AMERICA SERVICES', 'DAYNA GONZALEZ LOPEZ', '00000', 'P03075076', 'RNAF4ERNZUSE6YIBM', 'VERENICE, HERNANDEZ NAVA', 'XXX-XX-3485', 'Refund Transfer', '2024-02-21', '715.00', '715.00', '0.00', '0.00', '', 'ERO Prep Fees', '', 2024, 2024),
(2921, '411106', '1106', '', '', '884199', '', '', '886613', 'DAYNA GONZALEZ LOPEZ', '2034 AMERICA SERVICES', 'DAYNA GONZALEZ LOPEZ', '00000', 'P02500572', 'RNF4H46XUXPHGCTEF', 'JOSUE, DEL CAMPO RODRI', 'XXX-XX-3158', 'Refund Transfer', '2024-02-21', '283.00', '283.00', '0.00', '0.00', '', 'ERO Prep Fees', '', 2024, 2024);
'2024-02-21', '434.10', '434.10', '0.00', '0.00', '', 'ERO Prep Fees', '', 2024, 2024),
(2918, '411106', '1106', '', '', '884199', '', '', '886613', 'DAYNA GONZALEZ LOPEZ', '2034 AMERICA SERVICES', 'DAYNA GONZALEZ LOPEZ', '00000', 'P02500572', 'RMJGWYHJR3DZNHQKR', 'MIGUEL, RODRIGUEZ-LEGRA', 'XXX-XX-9791', 'Refund Transfer', '2024-02-21', '570.00', '570.00', '0.00', '0.00', '', 'ERO Prep Fees', '', 2024, 2024),
(2919, '411106', '1106', '', '', '884199', '', '', '886613', 'DAYNA GONZALEZ LOPEZ', '2034 AMERICA SERVICES', 'DAYNA GONZALEZ LOPEZ', '00000', 'P03075076', 'RML5X22OMVUBCXJ4O', 'DANIELA, BLANCO ORTIZ', 'XXX-XX-0382', 'Refund Transfer', '2024-02-21', '480.00', '480.00', '0.00', '0.00', '', 'ERO Prep Fees', '', 2024, 2024),
(2920, '411106', '1106', '', '', '884199', '', '', '886613', 'DAYNA GONZALEZ LOPEZ', '2034 AMERICA SERVICES', 'DAYNA GONZALEZ LOPEZ', '00000', 'P03075076', 'RNAF4ERNZUSE6YIBM', 'VERENICE, HERNANDEZ NAVA', 'XXX-XX-3485', 'Refund Transfer', '2024-02-21', '715.00', '715.00', '0.00', '0.00', '', 'ERO Prep Fees', '', 2024, 2024),
(2921, '411106', '1106', '', '', '884199', '', '', '886613', 'DAYNA GONZALEZ LOPEZ', '2034 AMERICA SERVICES', 'DAYNA GONZALEZ LOPEZ', '00000', 'P02500572', 'RNF4H46XUXPHGCTEF', 'JOSUE, DEL CAMPO RODRI', 'XXX-XX-3158', 'Refund Transfer', '2024-02-21', '283.00', '283.00', '0.00', '0.00', '', 'ERO Prep Fees', '', 2024, 2024);
To view this hidden content, you need to get a premium subscription. Click here to purchase.
