[Horsefucker]

Site: massivepurple.pt
Rows: - 17056 Customers
          - 62415 Invoices record


Customer Fields:

Spoiler Spoiler

CREATE TABLE `customers`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `facebook` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `source` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `agency_id` int(10) UNSIGNED NOT NULL,
  `enabled_services` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `customer_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `view_parent_shipments` tinyint(1) NOT NULL DEFAULT 0,
  `assigned_recipient_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `code` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `code_abbrv` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `zip_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `state` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `country` varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `map_lat` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `map_lng` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `map_preview` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `vat` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `is_particular` tinyint(1) NULL DEFAULT 0,
  `billing_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `billing_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `billing_zip_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `billing_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `billing_state` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `billing_country` varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `billing_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `billing_reference` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `refunds_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `balance_count_expired` int(11) NULL DEFAULT NULL,
  `balance_count_unpaid` int(11) NULL DEFAULT NULL,
  `balance_total_unpaid` decimal(10, 2) NULL DEFAULT NULL,
  `balance_last_update` timestamp NULL DEFAULT NULL,
  `balance_divergence` decimal(10, 2) NULL DEFAULT NULL,
  `wallet_balance` decimal(10, 2) NULL DEFAULT NULL,
  `responsable` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `contact_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `website` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `weight_chargeable_price` decimal(10, 2) NULL DEFAULT NULL,
  `volume_chargeable_price` decimal(10, 2) NULL DEFAULT NULL,
  `air_chargeable_price` decimal(10, 2) NULL DEFAULT NULL,
  `maritime_chargeable_price` decimal(10, 2) NULL DEFAULT NULL,
  `average_weight` tinyint(1) NOT NULL DEFAULT 0,
  `next_services_table` timestamp NULL DEFAULT NULL,
  `type_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `seller_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `payment_method` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `currency` varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '€',
  `has_billing_info` tinyint(1) NOT NULL DEFAULT 0,
  `billing_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `iban_payments` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `iban_refunds` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bank_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bank_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bank_iban` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bank_swift` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bank_mandate` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `bank_mandate_date` date NULL DEFAULT NULL,
  `courier` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `enabled_providers` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `enabled_packages` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `enabled_pudo_providers` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `complementar_services` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `default_print` enum('all','labels','guide','cmr','labels_a4') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `default_service` int(11) NULL DEFAULT NULL,
  `default_printer_a4` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `default_printer_labels` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `avg_cost` decimal(10, 2) NULL DEFAULT NULL,
  `distance_km` int(11) NULL DEFAULT NULL,
  `distance_from_agency` tinyint(1) NULL DEFAULT 0,
  `shipping_status_notify` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `shipping_status_notify_recipient` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `shipping_status_notify_method` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `default_invoice_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `price_table_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `prices_tables` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `has_prices` tinyint(1) NOT NULL DEFAULT 0,
  `has_webservices` tinyint(1) NOT NULL DEFAULT 0,
  `is_prospect` tinyint(1) NOT NULL DEFAULT 0,
  `final_consumer` tinyint(1) NOT NULL DEFAULT 0,
  `display_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `uncrypted_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `filehost` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `filepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `obs` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `other_name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `obs_shipments` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `obs_business` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `remember_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `last_login` timestamp NULL DEFAULT NULL,
  `ip` int(11) NULL DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `hide_old_shipments` tinyint(1) NOT NULL DEFAULT 0,
  `login_created_at` timestamp NULL DEFAULT NULL,
  `daily_report` tinyint(1) NULL DEFAULT 0,
  `daily_report_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `daily_report_locale` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `unpaid_invoices_limit` int(11) NULL DEFAULT NULL,
  `unpaid_invoices_credit` decimal(10, 2) NULL DEFAULT NULL,
  `monthly_plafound` decimal(10, 2) NULL DEFAULT NULL,
  `volumetric_coeficient` int(11) NULL DEFAULT NULL,
  `fuel_tax` decimal(10, 2) NULL DEFAULT NULL,
  `insurance_tax` decimal(10, 2) NULL DEFAULT NULL,
  `shipments_daily_limit_hour` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `route_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `operator_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `shipments_features` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `shipments_format` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `shipments_service` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `shipments_qtd_day` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `shipments_qtd_week` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `shipments_qtd_month` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `shipments_qtd_local` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `shipments_qtd_nacional` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `shipments_qtd_spain` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `shipments_qtd_internacional` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `shipments_qtd_islands` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `shipments_qtd_charge` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `shipments_qtd_devolutions` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `shipments_qtd_pickups` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `shipments_average_weight` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `pickup_daily` tinyint(1) NULL DEFAULT 0,
  `pickup_schedule` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `business_status` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `ignored_counter` int(11) NULL DEFAULT NULL,
  `hide_billing` tinyint(1) NOT NULL DEFAULT 0,
  `hide_budget_btn` tinyint(1) NOT NULL DEFAULT 0,
  `show_reference` tinyint(1) NULL DEFAULT NULL,
  `always_cod` tinyint(4) NULL DEFAULT 0,
  `sms_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `ignore_mass_billing` tinyint(1) NOT NULL DEFAULT 0,
  `customer_sms_text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `shipping_services_notify` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `settings` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `locale` varchar(2) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pt',
  `is_active` tinyint(1) NULL DEFAULT 1,
  `is_validated` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  `is_mensal` tinyint(1) NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `customers_type_id_foreign`(`type_id`) USING BTREE,
  INDEX `customers_agency_id_foreign`(`agency_id`) USING BTREE,
  INDEX `customers_seller_id_foreign`(`seller_id`) USING BTREE,
  INDEX `customers_customer_id_foreign`(`customer_id`) USING BTREE,
  INDEX `code`(`code`) USING BTREE,
  INDEX `name`(`name`) USING BTREE,
  INDEX `vat`(`vat`) USING BTREE,
  INDEX `phone`(`phone`) USING BTREE,
  INDEX `mobile`(`mobile`) USING BTREE,
  INDEX `customers_price_table_foreign`(`price_table_id`) USING BTREE,
  INDEX `customers_route_id_foreign`(`route_id`) USING BTREE,
  INDEX `source`(`source`) USING BTREE,
  INDEX `customers_operator_id_foreign`(`operator_id`) USING BTREE,
  CONSTRAINT `customers_agency_id_foreign` FOREIGN KEY (`agency_id`) REFERENCES `agencies` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `customers_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `customers_operator_id_foreign` FOREIGN KEY (`operator_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `customers_price_table_foreign` FOREIGN KEY (`price_table_id`) REFERENCES `prices_tables` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `customers_route_id_foreign` FOREIGN KEY (`route_id`) REFERENCES `routes` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `customers_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `customers_type_id_foreign` FOREIGN KEY (`type_id`) REFERENCES `customers_types` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 19418 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

Invoices Field:

Spoiler Spoiler

CREATE TABLE `invoices`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `target` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `target_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `source` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `gateway` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `customer_id` int(10) UNSIGNED NOT NULL,
  `internal_code` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `doc_id` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `doc_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `doc_series` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `doc_series_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `assigned_receipt` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `doc_date` date NULL DEFAULT NULL,
  `due_date` date NULL DEFAULT NULL,
  `payment_condition` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `payment_method` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `payment_date` date NULL DEFAULT NULL,
  `reference` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `total` decimal(10, 2) NULL DEFAULT NULL,
  `total_vat` decimal(10, 2) NULL DEFAULT NULL,
  `total_no_vat` decimal(10, 2) NULL DEFAULT NULL,
  `total_discount` decimal(10, 2) NULL DEFAULT NULL,
  `doc_subtotal` decimal(10, 2) NULL DEFAULT NULL,
  `doc_vat` decimal(10, 2) NULL DEFAULT NULL,
  `doc_total` decimal(10, 2) NULL DEFAULT NULL,
  `doc_total_pending` decimal(10, 2) NULL DEFAULT NULL,
  `irs_tax` decimal(10, 2) NULL DEFAULT NULL,
  `fuel_tax` decimal(10, 2) NULL DEFAULT NULL,
  `vat` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `billing_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `billing_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `billing_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `billing_zip_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `billing_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `billing_country` varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `billing_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `obs` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `mb_entity` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `mb_reference` varchar(9) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `mbw_phone` varchar(9) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `paypal_account` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `is_draft` tinyint(1) NOT NULL DEFAULT 1,
  `is_settle` tinyint(1) NOT NULL DEFAULT 0,
  `is_scheduled` tinyint(1) NOT NULL DEFAULT 0,
  `is_particular` tinyint(1) NOT NULL DEFAULT 0,
  `is_hidden` tinyint(1) NULL DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `is_reversed` tinyint(1) NULL DEFAULT 0,
  `delete_date` timestamp NULL DEFAULT NULL,
  `delete_user` int(10) UNSIGNED NULL DEFAULT NULL,
  `credit_note_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `delete_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `settle_date` date NULL DEFAULT NULL,
  `settle_method` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `settle_obs` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `doc_after_payment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `assigned_invoice_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `sepa_payment_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `api_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `created_by` int(10) UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `invoices_customer_id_foreign`(`customer_id`) USING BTREE,
  INDEX `invoices_target_index`(`target`) USING BTREE,
  INDEX `invoices_target_id_index`(`target_id`) USING BTREE,
  INDEX `invoices_source_index`(`source`) USING BTREE,
  INDEX `invoices_gateway_index`(`gateway`) USING BTREE,
  CONSTRAINT `invoices_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 75298 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

Customers Sample

Spoiler Spoiler

INSERT INTO `customers` VALUES (1, NULL, 'massivepurple', 226, '[\"3\",\"5\"]', NULL, 0, NULL, 'CFINAL', NULL, 'Cliente Final MP', 'Rua de Aires Ornelas, 252', '4000-024', 'Porto', NULL, 'pt', '', '', NULL, '999999990', 0, NULL, NULL, NULL, NULL, NULL, 'pt', '', '', '', 0, 0, 0.00, '2023-08-07 11:35:04', NULL, NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, 0, NULL, 4, NULL, '', '€', 0, NULL, '', '', NULL, NULL, '', NULL, NULL, NULL, NULL, '[\"4\",\"1\",\"2\",\"8\",\"9\"]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, NULL, NULL, NULL, 'simplified-invoice', 8, NULL, 1, 1, 0, 1, 'Cliente Final - CENT', 'teste@massivepurple.pt', '$2y$10$w7KmD0VGC6u4zQ5oSs5Rs.5s0vRgH1MIdwtz7inHmhOMmOKnBG30S', NULL, NULL, NULL, NULL, '', '', '', NULL, 'Nha18s74dMOFxwOABf309do1jSEtG8rie0Db6Gfn1Nxuw89XEZjtZ47Mi6nV', '2023-05-30 15:55:49', 1503222676, 1, 1, '2022-07-13 17:20:54', 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 'pt', 1, '1', 1, '2022-07-12 10:11:55', '2023-08-07 11:35:04', NULL);
INSERT INTO `customers` VALUES (2, NULL, 'massivepurple', 226, '[\"3\",\"5\"]', NULL, 0, NULL, '9003', NULL, 'INFORMATOWEB, LDA', 'TV PINHEIRO CAMPANHA N 22', '4300-420', 'PORTO', NULL, 'pt', '', '', NULL, '505112094', 0, NULL, NULL, NULL, NULL, NULL, 'pt', 'cristinamachado@informatoweb.pt', '', 'cristinamachado@informatoweb.pt', 2, 2, 176.87, '2023-10-02 12:23:20', NULL, NULL, '', 'cristinamachado@informatoweb.pt', '', '962447675', '', NULL, NULL, NULL, NULL, 0, NULL, 4, NULL, '', '€', 0, NULL, '', '', NULL, NULL, '', NULL, NULL, NULL, NULL, '[\"4\",\"2\"]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, NULL, NULL, NULL, 'invoice', 4, NULL, 1, 1, 0, 0, 'INFORMATOWEB, LDA', 'cristinamachado@informatoweb.pt', '$2y$10$AN/s5r6YdCTT8kQFP7ddCefu.arlv6sfu8FH0RI6zn1tI7t17WnTW', NULL, NULL, NULL, NULL, '', '', '', NULL, 'aPtmvsGSG8Vp1SLIa4SaHLhTHFxwSu7AHjdCYV8J6KEshlBYGtBxioU8K5er', '2023-07-06 14:36:17', 1385924855, 1, 1, '2022-07-18 17:17:09', 1, 'cristinamachado@informatoweb.pt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 'pt', 1, '1', 1, '2022-07-13 12:20:28', '2023-10-02 12:23:20', NULL);
INSERT INTO `customers` VALUES (3, NULL, 'massivepurple', 228, NULL, NULL, 0, NULL, '9004', NULL, 'OFICIAL GESTÃO E ADMINISTRAÇÃO DE IMOVEIS LDA', 'R BRITO CAPELO N 641 1', '4450-075', 'MATOSINHOS', NULL, 'pt', '', '', NULL, '505365359', 0, NULL, NULL, NULL, NULL, NULL, 'pt', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, 0, NULL, 1, NULL, '30d', '€', 0, NULL, '', '', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, NULL, NULL, NULL, 'invoice', 3, NULL, 1, 1, 0, 0, NULL, '_1657812623_', NULL, NULL, NULL, NULL, NULL, '', '', '', NULL, NULL, NULL, NULL, 1, 0, NULL, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 0, NULL, 0, 0, 0, NULL, NULL, NULL, 'pt', 1, '1', 1, '2022-07-13 12:20:28', '2022-07-14 16:30:23', '2022-07-14 16:30:23');
INSERT INTO `customers` VALUES (4, NULL, 'massivepurple', 226, NULL, NULL, 0, NULL, '9005', NULL, 'TIAGO DUARTE ANDREZ LDA', 'AV CONDE VALBOM 102', '1050-070', 'LISBOA', NULL, 'pt', NULL, NULL, NULL, '514237732', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, 0, NULL, 4, NULL, '30d', '€', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 'invoice', 4, NULL, 1, 1, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 0, NULL, 0, 0, 0, NULL, NULL, NULL, 'pt', 1, '1', 1, '2022-07-13 12:20:28', '2022-07-17 18:08:40', NULL);
INSERT INTO `customers` VALUES (5, NULL, 'massivepurple', 226, '[\"3\"]', NULL, 0, NULL, '9007', NULL, 'ANA CATARINA BARTOLOMEU FIGUEIRINHA - AMÊNDOAS DO CÔA', 'RUA DAS MERCÊS, NRº 68', '4200-401', 'PORTO', NULL, 'pt', '', '', NULL, '256300437', 0, NULL, NULL, NULL, NULL, NULL, 'pt', 'a.catarina.b.f@gmail.com', '', 'a.catarina.b.f@gmail.com', 11, 11, 234.79, '2023-06-30 01:01:21', NULL, NULL, '', '', '', '917878875', '', NULL, NULL, NULL, NULL, 0, NULL, 4, NULL, '', '€', 0, NULL, '', '', NULL, NULL, '', NULL, NULL, NULL, NULL, '[\"2\"]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, NULL, NULL, NULL, 'invoice', 4, NULL, 1, 1, 0, 0, 'ANA CATARINA BARTOLO', 'a.catarina.b.f@gmail.com', '$2y$10$.wlD2MUaD8jddYowvUr8iOD497TsqKWoOEc/FrSDNL2IBJmre0Bpm', NULL, NULL, NULL, NULL, '', '', '', NULL, 'qof8YEGLzaAS4vIRYElhGQw59pwOrOhdDBFvdoNnWkZWAdxd6XCXRqj1USEE', '2023-06-30 01:01:14', -719917418, 1, 1, '2022-07-28 10:23:40', 1, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 'pt', 1, '1', 1, '2022-07-13 12:20:28', '2023-06-30 01:01:21', NULL);

Invoices Sample

Spoiler Spoiler

INSERT INTO `invoices` VALUES (17, 'CustomerBilling', '17', 'massivepurple', 'KeyInvoice', 10578, NULL, '1', 'invoice', 'FTSP22', '23', NULL, '2022-08-02', '2022-08-02', 'prt', 'transfer', NULL, 'Ago/2022', 9.52, 0.00, 9.52, 0.00, 9.52, 0.00, 9.52, 0.00, 0.00, NULL, '901880671', '5169', '5169 CONDOMINIO 9 DE JULHO', 'RUA DE CEUTA 43 3ºDRT', '4050-191', 'Porto', 'pt', 'faturacao@nosadministramos.pt', 'Período Ago/2022\r\nEnvios Relativos ao dia 01 do mês de Agosto de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '154783ndap518140d42a35f2550eefd7d84ea55827', 13, '2022-08-02 20:00:24', '2023-09-15 15:47:02', NULL);
INSERT INTO `invoices` VALUES (20, 'CustomerBilling', '19', 'massivepurple', 'KeyInvoice', 10541, NULL, '2', 'invoice', 'FTSP22', '23', NULL, '2022-08-02', '2022-08-02', 'prt', 'transfer', NULL, 'Ago/2022', 96.35, 0.00, 96.35, 0.00, 96.35, 0.00, 96.35, 0.00, 0.00, NULL, '900288159', '5129', '5129 CONDOMINIO ALENTEJO', 'RUA DE CEUTA 43 3ºDRT', '4050-191', 'Porto', 'pt', 'faturacao@nosadministramos.pt', 'Período Ago/2022\r\nEnvios Relativos ao mês de Agosto de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '154783ndap518140d42a35f2550eefd7d84ea55827', 13, '2022-08-04 16:36:05', '2023-09-15 17:01:28', NULL);
INSERT INTO `invoices` VALUES (21, 'CustomerBilling', '20', 'massivepurple', 'KeyInvoice', 1, NULL, '17', 'simplified-invoice', 'FSMP22', '25', NULL, '2022-07-31', '2022-07-31', 'prt', 'money', '2022-08-07', 'Jul/2022', 54.49, 35.17, 19.32, 0.00, 54.49, 12.53, 67.02, NULL, 0.00, NULL, '999999990', 'CFINAL', 'Cliente Final - CENTRAL PORTO', 'Rua de Aires Ornelas, 252', '4000-024', 'Porto', 'pt', 'jna1976xxxx@gmail.com', 'Período Jul/2022\r\nEnvios Relativos ao mês de Julho de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '154834n9epf193962eac911b22465a73bcf7a8de7d', 3, '2022-08-07 10:37:41', '2022-08-07 10:37:43', NULL);
INSERT INTO `invoices` VALUES (22, 'CustomerBilling', '21', 'massivepurple', 'KeyInvoice', 9900, NULL, '3', 'invoice', 'FTSP22', '23', NULL, '2022-08-02', '2022-08-02', 'prt', 'transfer', NULL, '2022-08-01 a 2022-08-02', 80.94, 0.00, 80.94, 0.00, 80.94, 0.00, 80.94, 0.00, 0.00, NULL, '900950587', '1117', '1117 ADMIN CONDOMINIO ED. GUILHERME FELGUEIRAS NR 29-41-55', 'RUA GULHERME FELGUEIRAS NR 29', '4450-153', 'MATOSINHOS', 'pt', 'faturas@oficial.pt', 'Período faturação 2022-08-01 a 2022-08-02\r\nEnvios Relativos ao mês de Agosto de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '154783ndap518140d42a35f2550eefd7d84ea55827', 13, '2022-08-07 10:54:33', '2023-09-18 19:12:17', NULL);
INSERT INTO `invoices` VALUES (23, 'CustomerBilling', '22', 'massivepurple', 'KeyInvoice', 10298, NULL, '4', 'invoice', 'FTSP22', '23', NULL, '2022-08-03', '2022-08-03', 'prt', 'transfer', NULL, '2022-08-03 a 2022-08-03', 11.37, 0.00, 11.37, 0.00, 11.37, 0.00, 11.37, 0.00, 0.00, NULL, '901202312', '2875', '2875 CONDOMINIO JOÃO VILLARET', 'Praceta João Villaret nº15', '4460-337', 'SENHORA DA HORA', 'pt', 'isabel.moura@comdominio.eu', 'Período faturação 2022-08-03 a 2022-08-03\r\nEnvios Relativos ao mês de Agosto de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '154783ndap518140d42a35f2550eefd7d84ea55827', 13, '2022-08-07 11:05:44', '2023-09-21 23:01:20', NULL);
INSERT INTO `invoices` VALUES (24, 'CustomerBilling', '23', 'massivepurple', 'KeyInvoice', 10458, NULL, '5', 'invoice', 'FTSP22', '23', NULL, '2022-08-03', '2022-08-03', 'prt', '', NULL, '2022-08-03 a 2022-08-03', 74.11, 0.00, 74.11, 0.00, 74.11, 0.00, 74.11, 0.00, 0.00, NULL, '901053872', '5038', '5038 CONDOMINIO CENTRAL PLAZA', 'RUA DE CEUTA 43 3ºDRT', '4050-191', 'Porto', 'pt', 'faturacao@nosadministramos.pt', 'Período faturação 2022-08-03 a 2022-08-03\r\nEnvios Relativos ao mês de Agosto de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '', 13, '2022-08-07 11:06:39', '2023-09-07 10:39:48', NULL);
INSERT INTO `invoices` VALUES (25, 'CustomerBilling', '24', 'massivepurple', 'KeyInvoice', 10695, NULL, '6', 'invoice', 'FTSP22', '23', NULL, '2022-08-03', '2022-08-03', 'prt', 'transfer', NULL, '2022-08-03 a 2022-08-03', 59.91, 0.00, 59.91, 0.00, 59.91, 0.00, 59.91, 0.00, 0.00, NULL, '901877387', '5289', '5289 CONDOMINIO ENCOSTA DO SOL', 'RUA DE CEUTA 43, 3º DTO', '4050-191', 'PORTO', 'pt', 'faturacao@nosadministramos.pt', 'Período faturação 2022-08-03 a 2022-08-03\r\nEnvios Relativos ao mês de Agosto de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '', 13, '2022-08-07 11:09:22', '2023-08-29 10:47:38', NULL);
INSERT INTO `invoices` VALUES (26, 'CustomerBilling', '25', 'massivepurple', 'KeyInvoice', 10705, NULL, '7', 'invoice', 'FTSP22', '23', NULL, '2022-08-07', '2022-08-07', 'prt', 'transfer', NULL, 'Ago/2022', 90.43, 0.00, 90.43, 0.00, 90.43, 0.00, 90.43, 0.00, 0.00, NULL, '901147290', '5299', '5299 CONDOMINIO BELOS ARES', 'RUA DE BELOS ARES 40-80', '4100-000', 'PORTO', 'pt', 'faturacao@nosadministramos.pt', 'Período Ago/2022\r\nEnvios Relativos ao mês de Agosto de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '154783ndap518140d42a35f2550eefd7d84ea55827', 13, '2022-08-07 11:11:20', '2023-08-08 18:02:27', NULL);
INSERT INTO `invoices` VALUES (28, 'CustomerBilling', '26', 'massivepurple', 'KeyInvoice', 11609, NULL, '8', 'invoice', 'FTSP22', '23', NULL, '2022-08-07', '2022-08-07', 'prt', 'transfer', NULL, 'Ago/2022', 159.78, 0.00, 159.78, 0.00, 159.78, 0.00, 159.78, 0.00, 0.00, NULL, '900732180', 'BC31', 'Condomínio da Praceta José Magalhães Godinho, 1', 'Praceta José Magalhães Godinho, nº1', '2725-580', 'MEM MARTINS', 'pt', 'smis@burgocarisma.pt', 'Período Ago/2022\r\nEnvios Relativos ao mês de Agosto de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '154783ndap518140d42a35f2550eefd7d84ea55827', 13, '2022-08-07 11:20:02', '2022-10-06 15:44:02', NULL);
INSERT INTO `invoices` VALUES (29, 'CustomerBilling', '27', 'massivepurple', 'KeyInvoice', 10919, NULL, '9', 'invoice', 'FTSP22', '23', NULL, '2022-08-07', '2022-08-07', 'prt', 'transfer', NULL, 'Ago/2022', 2.35, 0.00, 2.35, 0.00, 2.35, 0.00, 2.35, 0.00, 0.00, NULL, '901491624', '7FRR110', '7FRR110 CONDOMINIO FERRARIA 110', 'RUA DA FERRARIA 110', '4435-250', 'RIO TINTO', 'pt', 'confere@conferecondominios.com', 'Período Ago/2022\r\nEnvios Relativos ao mês de Agosto de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '154783ndap518140d42a35f2550eefd7d84ea55827', 13, '2022-08-07 11:23:46', '2023-07-26 15:33:48', NULL);
INSERT INTO `invoices` VALUES (30, 'CustomerBilling', '28', 'massivepurple', 'KeyInvoice', 10950, NULL, '10', 'invoice', 'FTSP22', '23', NULL, '2022-08-07', '2022-08-07', 'prt', 'transfer', NULL, 'Ago/2022', 6.48, 0.00, 6.48, 0.00, 6.48, 0.00, 6.48, 0.00, 0.00, NULL, '901298190', '7PP5', '7PP5 CONDOMINIO PENTA PARK V', 'R. DR. JOAQUIM MAIA DE AGUIAR 108,110,114', '4445-655', 'Ermesinde', 'pt', 'confere@conferecondominios.com', 'Período Ago/2022\r\nEnvios Relativos ao mês de Agosto de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '154783ndap518140d42a35f2550eefd7d84ea55827', 13, '2022-08-07 11:24:12', '2023-09-06 10:08:07', NULL);
INSERT INTO `invoices` VALUES (31, 'CustomerBilling', '29', 'massivepurple', 'KeyInvoice', 12950, NULL, '11', 'invoice', 'FTSP22', '23', NULL, '2022-08-07', '2022-08-07', 'prt', 'transfer', NULL, 'Ago/2022', 4.09, 0.00, 4.09, 0.00, 4.09, 0.00, 4.09, 0.00, 0.00, NULL, '902014986', 'MC98', 'Adm Cond R Oceano Índico 3', 'R Oceano Índico 3', '2830-530', 'Barreiro', 'pt', 'geral@m-condominios.pt', 'Período Ago/2022\r\nEnvios Relativos ao mês de Agosto de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '154783ndap518140d42a35f2550eefd7d84ea55827', 13, '2022-08-07 11:25:48', '2023-06-06 13:26:08', NULL);
INSERT INTO `invoices` VALUES (32, 'CustomerBilling', '30', 'massivepurple', 'KeyInvoice', 12390, NULL, '12', 'invoice', 'FTSP22', '23', NULL, '2022-08-07', '2022-08-07', 'prt', 'transfer', NULL, 'Ago/2022', 218.60, 0.00, 218.60, 0.00, 218.60, 0.00, 218.60, 0.00, 0.00, NULL, '901159158', 'HP50', 'Edifício Torre', 'Rua da Torre nºNº 30', '3740-267', 'VOUGA', 'pt', 'geral@houseprime.pt', 'Período Ago/2022\r\nEnvios Relativos ao mês de Agosto de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '154783ndap518140d42a35f2550eefd7d84ea55827', 13, '2022-08-07 11:27:02', '2022-09-07 11:32:22', NULL);
INSERT INTO `invoices` VALUES (33, 'CustomerBilling', '31', 'massivepurple', 'KeyInvoice', 11009, NULL, '13', 'invoice', 'FTSP22', '23', NULL, '2022-08-07', '2022-09-06', '30d', '', NULL, 'Ago/2022', 1.70, 0.00, 1.70, NULL, 1.70, 0.00, 1.70, 0.00, NULL, NULL, '505365359', '9004', '9004 OFICIAL GESTÃO E ADMINISTRAÇÃO DE IMOVEIS LDA', 'R BRITO CAPELO N 641 1 MATOSINHOS', '4450-075', 'MATOSINHOS', 'pt', 'faturas@oficial.pt', 'Período Ago/2022\nEnvios Relativos ao mês de Agosto de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '154783ndap518140d42a35f2550eefd7d84ea55827', 13, '2022-08-07 11:29:25', '2023-03-27 10:58:03', NULL);
INSERT INTO `invoices` VALUES (34, 'CustomerBilling', '32', 'massivepurple', 'KeyInvoice', 12919, NULL, '14', 'invoice', 'FTSP22', '23', NULL, '2022-08-07', '2022-09-06', '30d', '', NULL, 'Ago/2022', 13.26, 0.00, 13.26, NULL, 13.26, 0.00, 13.26, 0.00, NULL, NULL, '900276479', 'MC44', 'Adm Cond R Portugal Durão 12', 'R Portugal Durão 12', '1600-186', 'Lisboa', 'pt', 'geral@m-condominios.pt', 'Período Ago/2022\nEnvios Relativos ao mês de Agosto de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '154783ndap518140d42a35f2550eefd7d84ea55827', 13, '2022-08-07 11:29:29', '2023-08-31 17:27:01', NULL);
INSERT INTO `invoices` VALUES (35, 'CustomerBilling', '33', 'massivepurple', 'KeyInvoice', 12898, NULL, '15', 'invoice', 'FTSP22', '23', NULL, '2022-08-07', '2022-09-06', '30d', '', NULL, 'Ago/2022', 4.07, 0.00, 4.07, NULL, 4.07, 0.00, 4.07, 0.00, NULL, NULL, '900183934', 'MC181', 'Adm Cond. PÇA NUNO PINHEIRO TORRES 10', 'PÇA NUNO PINHEIRO TORRES 10', '1500-246', 'LISBOA', 'pt', 'geral@m-condominios.pt', 'Período Ago/2022\nEnvios Relativos ao mês de Agosto de 2022 (Conforme Documento em Anexo)', NULL, NULL, NULL, NULL, 0, 1, 0, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '154783ndap518140d42a35f2550eefd7d84ea55827', 13, '2022-08-07 11:29:32', '2023-06-25 18:35:24', NULL);

Hidden Content

You must register or login to view this content.

[secret0s]

"Sorry, File does not exist on this server"

[Addka72424]

Hello,

The link on this thread has been updated as of this post.

[secret0s]

Updated link works fine. Great!

[goromoro]

The link is working. looks goods

[Addka72424]

The link in this thread is dead. Please reply to the PM you were sent to get your thread moved back to the Databases section.