-- Respaldo Nativo generado por Sistema CRM TS --
-- Base de datos: trydvnte_bameredith.com_core_customers --
-- Conexión: mysql_customers --
-- Fecha: 2026-08-24 01:01:08 --

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS `portfolio_customers`;
CREATE TABLE `portfolio_customers` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch office on core',
  `customer_type_id` int(11) NOT NULL COMMENT 'Related to catalogs item',
  `code` varchar(100) DEFAULT NULL,
  `first_name` varchar(75) NOT NULL,
  `middle_name` varchar(50) DEFAULT NULL COMMENT 'Could be null',
  `last_name` varchar(50) DEFAULT NULL COMMENT 'Could be null',
  `country_id` int(11) NOT NULL COMMENT 'Related to country table',
  `document_type` int(11) NOT NULL COMMENT 'Related to catalogs table = DOCTYPE',
  `document_number` varchar(50) NOT NULL DEFAULT '0',
  `customer_complemento` varchar(5) DEFAULT NULL COMMENT 'The complement',
  `gender_id` int(11) DEFAULT NULL COMMENT 'Related to catalogs items = GENDER',
  `birthday` date DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `social_media` text DEFAULT NULL,
  `phones` varchar(150) DEFAULT NULL,
  `address` varchar(512) DEFAULT NULL,
  `references` mediumtext DEFAULT NULL,
  `photo` text DEFAULT NULL,
  `siat_verified` char(1) NOT NULL DEFAULT '0' COMMENT '0=not verified\r\n1=verified',
  `status` varchar(2) NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `relative` (`relative`),
  KEY `code` (`code`),
  KEY `code_2` (`code`),
  KEY `document_number` (`document_number`),
  KEY `code_3` (`code`),
  KEY `code_4` (`code`),
  KEY `document_number_2` (`document_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('06c2e6fd-3f44-429d-8cb7-65fed151df63', '3fb0946f-25c5-4422-a7b6-fa1c4d27eae5', '641908b9-05a8-11f0-986e-bc2411f8cfbc', '1', '0', 'MACHACA', NULL, NULL, '27', '1', '6037994', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-03-27 19:36:18', '2025-03-27 19:36:18');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('07c3264b-1f9b-4ca0-8339-5e8815a7c00c', '0bb27e19-55d0-4d10-b5d4-f12fa68d84a4', '9ff38bd1-05b5-11f0-918f-0200fd828666', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '7', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-04-01 10:41:35', '2025-10-13 07:19:39');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('12ecde9d-9e27-4fd6-a3c7-a0d4566d8296', 'be3fbf82-b332-4e40-baab-95468240562c', '9ff38bd1-05b5-11f0-918f-0200fd828666', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '333', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'X', '2025-03-27 18:39:55', '2025-03-29 14:38:19');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('163e1300-6165-4f06-bd3e-d198cad19b51', '9bc1938f-3617-4675-8bf8-2794c19ef91a', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'MINERA KORIMAYA SRL', NULL, NULL, '27', '1', '485002023', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-12-24 19:43:43', '2025-12-24 19:43:43');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('181eacdd-6bb2-4c44-b126-d0f341e8d52a', '9bc1938f-3617-4675-8bf8-2794c19ef91a', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'GRUPO ESTABILIZA INGENIERIA SRL', NULL, NULL, '27', '1', '315922029', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2026-01-30 15:37:14', '2026-01-30 15:37:14');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('192462de-1a66-4a9c-aad7-9fbb9a032336', 'be3fbf82-b332-4e40-baab-95468240562c', '3883289f-05b9-11f0-918f-0200fd828666', '1', '0', 'COLQUE', NULL, NULL, '27', '1', '77745855', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-03-20 21:31:53', '2025-03-20 21:31:53');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('1d3ef72d-1525-42cd-8038-ed87c8d30331', '3fb0946f-25c5-4422-a7b6-fa1c4d27eae5', '641908b9-05a8-11f0-986e-bc2411f8cfbc', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'X', '2025-03-27 20:11:55', '2025-03-29 14:38:49');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('1dd15d16-874c-4403-992a-4b067ff02453', 'a5a6f349-32de-4e75-afa4-3731562a0540', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '7', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-03-28 13:49:32', '2025-03-28 13:49:32');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('1e70f069-2d52-43b0-83ab-6dc972d6eab7', '9bc1938f-3617-4675-8bf8-2794c19ef91a', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'HUANCA', NULL, NULL, '27', '4', '7033706', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-09-02 14:59:50', '2025-09-02 14:59:50');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('204691aa-35bc-4be4-8ac8-1d2d7c4fcd9f', 'be3fbf82-b332-4e40-baab-95468240562c', '9ff38bd1-05b5-11f0-918f-0200fd828666', '1', '0', 'AGUILAR', NULL, NULL, '27', '1', '8311138', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-03-27 18:35:47', '2025-03-27 18:35:47');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('2738bfb0-cb95-432a-8cfa-353aaf6303c3', 'e2997ba3-74f5-49ab-8d74-a83f61cf7761', '3b1e0b8f-05ba-11f0-918f-0200fd828666', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2026-03-27 21:09:02', '2026-03-27 21:09:02');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('289e7a79-af85-4978-9e3c-2c55ec1cf72a', 'be3fbf82-b332-4e40-baab-95468240562c', '3883289f-05b9-11f0-918f-0200fd828666', '1', '0', 'COLQUE', NULL, NULL, '27', '4', '11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-03-20 21:38:03', '2025-03-20 21:38:03');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('2a5025eb-d8a3-4bb1-88f1-3a3c91b9bace', '52fea30c-98dc-4c90-94e9-0e6d3f33ffa5', '641908b9-05a8-11f0-986e-bc2411f8cfbc', '1', '0', 'SN', NULL, NULL, '27', '4', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'X', '2025-03-25 21:20:03', '2025-03-29 14:38:59');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('2b4d478b-0e0e-4736-83f9-586e7e38f4fc', 'a5a6f349-32de-4e75-afa4-3731562a0540', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'CALAMANI', NULL, NULL, '27', '1', '13299229', NULL, NULL, NULL, NULL, NULL, '73565957', NULL, NULL, NULL, '0', 'A', '2025-03-30 15:39:12', '2025-03-30 15:39:12');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('3054a840-11d1-4afb-b496-6a0570912b42', 'a5a6f349-32de-4e75-afa4-3731562a0540', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'X', '2025-03-28 12:09:08', '2025-03-29 14:39:30');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('309eaf5b-1fb4-46bd-8a3d-6eb9c96f9255', '9bc1938f-3617-4675-8bf8-2794c19ef91a', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'TICONA', NULL, NULL, '27', '1', '5479535', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-12-04 15:19:53', '2025-12-04 15:19:53');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('30ede709-7eb6-4a22-aee6-bea95d60afe2', '9d57cdce-d76a-49f6-850a-5e251802274f', '3b1e0b8f-05ba-11f0-918f-0200fd828666', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'X', '2025-03-29 13:57:25', '2025-03-29 14:40:21');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('34c6da2f-9e17-4ee9-abb2-7473e712faf3', 'be3fbf82-b332-4e40-baab-95468240562c', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'SN', NULL, NULL, '27', '4', '11', NULL, NULL, NULL, NULL, NULL, '77592403', NULL, 'tomar cada 8 horas', NULL, '0', 'X', '2025-03-23 19:29:21', '2025-03-24 17:10:22');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('3c17b171-4c76-44dd-99c0-9bca21cdcc40', '3f3f5180-2d03-4125-b5e3-da92971659be', '3883289f-05b9-11f0-918f-0200fd828666', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'X', '2025-03-27 20:43:50', '2025-03-29 14:37:42');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('40aa571c-4305-477b-bc92-101222afa3ef', 'a5a6f349-32de-4e75-afa4-3731562a0540', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'MACHACA', NULL, NULL, '27', '1', '4959030', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-03-28 12:00:03', '2025-03-28 12:00:03');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('61b3ab39-d1ea-4d6e-808a-2d271b01b0e1', 'be3fbf82-b332-4e40-baab-95468240562c', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'SN', NULL, NULL, '27', '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'X', '2025-03-23 19:45:13', '2025-03-25 22:21:03');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('78609b75-3244-4b2f-9644-120855f8c21d', 'e2997ba3-74f5-49ab-8d74-a83f61cf7761', '3b1e0b8f-05ba-11f0-918f-0200fd828666', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '7', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-03-28 14:00:56', '2025-03-28 14:00:56');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('7979dea1-d4b5-4093-b4c4-08480bd7beb6', 'be3fbf82-b332-4e40-baab-95468240562c', '3883289f-05b9-11f0-918f-0200fd828666', '1', '0', 'SN', NULL, NULL, '27', '4', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'X', '2025-03-20 21:41:40', '2025-03-29 14:37:52');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('7e631dfa-b17d-4912-ae71-2fe22a506f35', 'be3fbf82-b332-4e40-baab-95468240562c', '57626706-7591-4d5e-9f8a-a5e1a36c1cd6', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '7', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-04-10 13:51:02', '2025-04-10 13:51:02');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('7fd7a476-ad1a-49b7-be87-cafe2db6949d', '9bc1938f-3617-4675-8bf8-2794c19ef91a', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', '7094148', NULL, NULL, '27', '1', '7094148', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PACHANI MAMANI', NULL, '0', 'A', '2025-09-16 18:34:37', '2025-09-16 18:34:37');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('8e681b1c-67b3-4199-b25b-d45f965214af', '9d57cdce-d76a-49f6-850a-5e251802274f', '3b1e0b8f-05ba-11f0-918f-0200fd828666', '1', '0', 'QUISPE', NULL, NULL, '27', '4', '7048808', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2026-01-05 08:14:34', '2026-01-05 08:14:34');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('9195f980-d6c7-4c2d-b900-8db6d30551ec', '9bc1938f-3617-4675-8bf8-2794c19ef91a', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'BAUTISTA', NULL, NULL, '27', '1', '6047481', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-11-27 17:06:09', '2025-11-27 17:06:09');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('924b5820-c7b3-40de-9bbe-582b9fe9628d', '3f3f5180-2d03-4125-b5e3-da92971659be', '3883289f-05b9-11f0-918f-0200fd828666', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '7', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-03-29 15:58:29', '2025-03-29 15:58:29');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('954fbd1e-d754-4c20-a0d4-40cca11216a9', 'be3fbf82-b332-4e40-baab-95468240562c', '3883289f-05b9-11f0-918f-0200fd828666', '1', '0', 'APARICIO', NULL, NULL, '27', '5', '4807414019', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-03-24 19:07:15', '2025-03-24 19:07:15');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('9b8cd21b-fb7e-479e-afe9-6316fa99a934', 'a5a6f349-32de-4e75-afa4-3731562a0540', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'TOS SECA........ DIEGO KALED QUELALI TOLA', NULL, NULL, '27', '1', '13922805', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-05-24 13:20:49', '2025-05-24 13:20:49');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('a07d9319-0627-4c82-99b6-9e3996d30716', 'be3fbf82-b332-4e40-baab-95468240562c', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'CHURA', NULL, NULL, '27', '5', '7074442014', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'X', '2025-03-23 19:47:30', '2025-03-24 17:10:32');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('a5d2ad82-d28d-4a05-873e-6b59ffa06078', 'a5a6f349-32de-4e75-afa4-3731562a0540', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '333', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'X', '2025-03-26 19:14:14', '2025-03-29 14:39:36');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('a9a4b216-5941-4808-87e2-2de5a71eb8b6', '9bc1938f-3617-4675-8bf8-2794c19ef91a', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'PACHANI MAMANI', NULL, NULL, '27', '1', '7094149', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-09-16 18:38:04', '2025-09-16 18:38:04');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('b66c546a-35eb-49f1-b26d-f739c8d58060', '71dee8df-35fe-4bfb-aa98-c83d86cc6854', '9ff38bd1-05b5-11f0-918f-0200fd828666', '1', '0', 'QUISPE', NULL, NULL, '27', '4', '6051746010', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-04-17 15:23:20', '2025-04-17 15:23:20');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('b757221c-e3f9-47f9-889a-7f5cf06c763d', '71dee8df-35fe-4bfb-aa98-c83d86cc6854', '9ff38bd1-05b5-11f0-918f-0200fd828666', '1', '0', 'MACUCHAPI', NULL, NULL, '27', '1', '6934193', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-09-20 14:02:01', '2025-09-20 14:02:01');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('bcb15d27-1444-4099-8162-042ae28d00d4', 'be3fbf82-b332-4e40-baab-95468240562c', '57626706-7591-4d5e-9f8a-a5e1a36c1cd6', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-04-16 14:55:18', '2025-04-16 14:55:18');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('be872e15-a991-4427-98b4-deed470dd48c', 'e2997ba3-74f5-49ab-8d74-a83f61cf7761', '3b1e0b8f-05ba-11f0-918f-0200fd828666', '1', '0', 'ESPEJO', NULL, NULL, '27', '1', '7078632', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-03-28 13:40:38', '2025-03-28 13:40:38');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('c84b75c1-80d7-4dad-aff3-c85bf67c9be8', 'be3fbf82-b332-4e40-baab-95468240562c', '3b1e0b8f-05ba-11f0-918f-0200fd828666', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '333', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'X', '2025-03-27 11:24:25', '2025-03-29 14:40:27');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('d2e6a1ce-3f08-4fa8-8077-6b419d59b604', 'a5a6f349-32de-4e75-afa4-3731562a0540', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'MAMANI.', NULL, NULL, '27', '1', '65456545', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-03-26 19:10:42', '2025-03-26 19:10:42');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('d3c454f4-158d-4623-8854-25b19aedd2e9', '3f3f5180-2d03-4125-b5e3-da92971659be', '3883289f-05b9-11f0-918f-0200fd828666', '1', '0', 'HUANCA', NULL, NULL, '27', '1', '9203272', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-03-27 20:41:32', '2025-03-27 20:41:32');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('db1838c3-3cbb-403d-91bf-704193689842', '52fea30c-98dc-4c90-94e9-0e6d3f33ffa5', '641908b9-05a8-11f0-986e-bc2411f8cfbc', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '333', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'X', '2025-03-26 20:34:39', '2025-03-29 14:38:54');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('f13b3dac-5bc5-42dc-ad1e-fa82b25e365c', 'be3fbf82-b332-4e40-baab-95468240562c', '641908b9-05a8-11f0-986e-bc2411f8cfbc', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '7', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-03-29 18:27:00', '2025-03-29 18:27:00');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('fa7341fc-27e1-4b09-98d8-182460f163c9', '71dee8df-35fe-4bfb-aa98-c83d86cc6854', '9ff38bd1-05b5-11f0-918f-0200fd828666', '1', '0', 'SIN NOMBRE', NULL, NULL, '27', '4', '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-03-29 15:58:54', '2025-03-29 15:58:54');
INSERT INTO `portfolio_customers` (`relative`, `users_sid`, `global_branch_office_id`, `customer_type_id`, `code`, `first_name`, `middle_name`, `last_name`, `country_id`, `document_type`, `document_number`, `customer_complemento`, `gender_id`, `birthday`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `siat_verified`, `status`, `created_at`, `updated_at`) VALUES ('ffae2f6e-e224-4053-97bf-b7561c62c0c8', 'a5a6f349-32de-4e75-afa4-3731562a0540', 'c5bd1883-05ba-11f0-918f-0200fd828666', '1', '0', 'ARIEL QUISPE RODRIGUEZ', NULL, NULL, '27', '1', '15917324', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'A', '2025-06-03 16:04:28', '2025-06-03 16:04:28');