-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` int UNSIGNED NOT NULL,
  `location_description` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('ACTIVE','INACTIVE') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'ACTIVE',
  `created_by` int UNSIGNED DEFAULT NULL,
  `updated_by` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` (`id`, `location_description`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Metro Manila', 'ACTIVE', 1, 1, '2022-04-25 10:25:32', '2022-04-25 10:26:12', NULL),
(2, 'Outside Metro Manila', 'ACTIVE', 1, 1, '2022-04-25 10:25:39', '2022-04-25 10:26:02', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2016_08_07_145904_add_table_cms_apicustom', 1),
(2, '2016_08_07_150834_add_table_cms_dashboard', 1),
(3, '2016_08_07_151210_add_table_cms_logs', 1),
(4, '2016_08_07_151211_add_details_cms_logs', 1),
(5, '2016_08_07_152014_add_table_cms_privileges', 1),
(6, '2016_08_07_152214_add_table_cms_privileges_roles', 1),
(7, '2016_08_07_152320_add_table_cms_settings', 1),
(8, '2016_08_07_152421_add_table_cms_users', 1),
(9, '2016_08_07_154624_add_table_cms_menus_privileges', 1),
(10, '2016_08_07_154624_add_table_cms_moduls', 1),
(11, '2016_08_17_225409_add_status_cms_users', 1),
(12, '2016_08_20_125418_add_table_cms_notifications', 1),
(13, '2016_09_04_033706_add_table_cms_email_queues', 1),
(14, '2016_09_16_035347_add_group_setting', 1),
(15, '2016_09_16_045425_add_label_setting', 1),
(16, '2016_09_17_104728_create_nullable_cms_apicustom', 1),
(17, '2016_10_01_141740_add_method_type_apicustom', 1),
(18, '2016_10_01_141846_add_parameters_apicustom', 1),
(19, '2016_10_01_141934_add_responses_apicustom', 1),
(20, '2016_10_01_144826_add_table_apikey', 1),
(21, '2016_11_14_141657_create_cms_menus', 1),
(22, '2016_11_15_132350_create_cms_email_templates', 1),
(23, '2016_11_15_190410_create_cms_statistics', 1),
(24, '2016_11_17_102740_create_cms_statistic_components', 1),
(25, '2017_06_06_164501_add_deleted_at_cms_moduls', 1),
(26, '2019_08_22_164428_create_deliveries_table', 2),
(27, '2019_08_27_133108_create_stock_statuses_table', 2),
(28, '2019_09_04_161320_create_purchase_order_alls_table', 2),
(29, '2020_10_28_091532_create_ebs_pull_table', 3),
(30, '2020_10_29_124431_create_pos_pull_table', 4),
(31, '2020_11_03_115222_create_st_status_table', 4),
(32, '2020_11_11_132656_add_document_number_column_to_ebs_pull_table', 5),
(34, '2020_11_11_150339_add_st_document_number_column_to_ebs_pull_table', 6),
(35, '2020_11_11_150440_add_st_document_number_column_to_pos_pull_table', 6),
(36, '2020_11_13_102117_create_store_table', 7),
(37, '2020_12_03_162824_create_serials_table', 8),
(38, '2020_12_03_174028_add_locator_id_to_ebs_pull_table', 9),
(39, '2020_12_04_114359_add_has_serial_column_to_ebs_pull_table', 10),
(40, '2020_12_10_103737_create_item_table', 11),
(41, '2020_12_15_114953_add_item_id_to_ebs_pull_table', 12),
(42, '2020_12_15_132144_add_doo_subinventory_to_stores_table', 13),
(43, '2020_12_18_144842_add_store_column_to_cms_users_table', 14),
(44, '2020_12_18_155444_add_transit_warehouse_to_stores_table', 15),
(45, '2020_12_18_184920_add_price_column_to_items_table', 16),
(46, '2020_12_22_134220_add_status_column_to_pos_pull_table', 17),
(47, '2020_12_22_181841_add_has_serial_column_to_pos_pull_table', 18),
(48, '2020_12_22_200626_add_pos_warehouse_branch_column_to_stores_table', 19),
(49, '2020_12_23_160208_add_pos_warehouse_rma_to_stores_table', 20),
(50, '2020_12_28_184419_create_pullout_table', 21),
(51, '2020_12_28_184915_add_pullout_id_to_serials_table', 22),
(52, '2021_01_04_143958_add_transaction_type_to_pullout_table', 23),
(54, '2021_01_05_135603_create_reason_table', 24),
(56, '2021_01_05_135702_create_transaction_type_table', 25),
(58, '2021_01_05_135017_add_reason_id_to_pullout_table', 26),
(59, '2021_01_05_160229_create_channel_table', 27),
(60, '2021_01_05_160329_add_channel_id_to_cms_users_table', 27),
(61, '2021_01_05_161116_add_org_subinventory_to_stores_table', 28),
(62, '2021_01_12_165308_add_bea_so_reason_column_to_reason_table', 29),
(63, '2021_01_23_143525_add_reason_id_to_pos_pull_table', 30),
(64, '2021_02_01_173259_add_transport_type_id_column_to_ebs_pull_table', 31),
(65, '2021_02_01_173629_create_transport_types_table', 31),
(66, '2021_02_02_110946_add_hand_carrier_column_to_ebs_pull_table', 32),
(67, '2021_02_02_150650_add_transport_type_id_column_to_pos_pull_table', 33),
(68, '2021_02_02_150806_add_hand_carrier_column_to_pos_pull_table', 33),
(69, '2021_02_02_152012_add_schedule_date_column_to_pos_pull_table', 34),
(70, '2021_02_02_152029_add_schedule_date_column_to_ebs_pull_table', 34),
(74, '2021_02_02_175825_add_schedule_date_column_to_pullout_table', 35),
(75, '2021_02_02_175926_add_transport_type_id_column_to_pullout_table', 35),
(76, '2021_02_02_175951_add_hand_carrier_column_to_pullout_table', 36),
(77, '2021_02_04_103204_create_approval_matrix_table', 37),
(78, '2021_02_04_114724_add_channels_id_to_stores_table', 38),
(79, '2021_02_04_145511_add_stores_id_to_pullout_table', 39),
(80, '2021_02_04_145533_add_stores_id_to_pos_pull_table', 39),
(81, '2021_02_05_100903_add_review_column_to_pos_pull_table', 40),
(82, '2021_02_05_101007_add_review_column_to_pullout_table', 40),
(83, '2021_03_01_120622_add_received_by_at_column_in_pullout_table', 41),
(84, '2021_03_01_141834_create_code_counter_table', 42),
(85, '2020_11_11_133043_add_document_number_column_to_pos_pull_table', 43),
(86, '2021_03_05_170553_add_customer_po_column_to_ebs_pull_table', 44),
(87, '2021_03_10_170741_create_customer_type_table', 45),
(88, '2021_03_10_180042_add_transit_rma_branch_to_stores_table', 45),
(89, '2021_03_11_145445_add_sit_subinventory_to_stores_table', 46),
(90, '2021_03_11_163136_add_channel_id_column_to_pullout_table', 47),
(91, '2021_03_16_140051_add_customer_type_id_column_to_stores_table', 48),
(92, '2021_03_16_165243_add_sts_group_column_to_stores_table', 49),
(93, '2021_03_19_103412_add_stores_id_destination_to_pos_pull_table', 50),
(94, '2021_05_06_175900_add_stores_id_to_ebs_pull_table', 51),
(95, '2021_05_06_180025_add_stores_id_destination_to_pullout_table', 51),
(96, '2021_09_15_155252_create_status_workflows_table', 52),
(97, '2021_09_29_170438_add_step_column_to_pullout_table', 53),
(98, '2021_09_29_170523_add_step_column_to_pos_pull_table', 53),
(99, '2021_09_30_005928_add_reservation_qty_to_pullout_table', 54),
(100, '2021_09_30_010214_add_reservation_qty_to_items_table', 54),
(101, '2021_10_11_093052_create_problems_table', 55),
(102, '2021_10_11_103927_add_problem_columns_to_pullout_table', 56),
(103, '2021_12_02_113829_add_logistics_info_in_pullout_table', 57),
(104, '2021_12_02_133416_add_logistics_info_in_pos_pull_table', 58),
(105, '2022_02_18_152450_add_purchase_date_to_pullout_table', 59),
(106, '2022_03_23_170827_add_distri_reserve_qty_to_items_table', 60),
(107, '2022_03_31_020212_add_other_distri_reserve_qty_to_items_table', 61),
(108, '2022_03_31_085947_create_trip_tickets_table', 62),
(109, '2022_04_06_170018_add_trip_ref_to_code_counter_table', 62),
(110, '2022_04_07_090956_add_created_updated_by_trip_ticket_table', 63),
(111, '2022_04_07_093023_add_dr_qty_to_trip_ticket_table', 63),
(112, '2022_04_13_125834_add_additional_distri_subinventory_to_items_table', 64),
(113, '2022_04_13_160155_create_distri_subinventories_table', 65),
(114, '2022_04_18_092719_add_other_details_to_trip_ticket_table', 66),
(115, '2022_04_19_100327_add_is_released_to_trip_ticket_table', 67),
(116, '2022_04_19_104922_add_ref_type_to_trip_ticket_table', 67),
(117, '2022_04_19_172617_create_backload_reasons_table', 68),
(118, '2022_04_19_181250_add_backload_reason_to_trip_ticket_table', 69),
(119, '2022_04_25_152556_add_locations_id_to_stores_table', 70),
(120, '2022_04_25_152630_create_locations_table', 70),
(121, '2022_04_26_100215_add_store_logistics_details_to_trip_ticket_table', 71),
(122, '2022_04_27_114849_add_status_column_to_trip_ticket_table', 72),
(123, '2022_04_27_115118_create_trip_ticket_statuses_table', 72),
(124, '2022_04_28_184411_create_pullout_receivings_table', 73),
(125, '2022_04_29_103817_create_pullout_receiving_lines_table', 73),
(126, '2022_04_29_105333_create_pullout_receiving_serials_table', 73),
(127, '2022_04_29_111726_create_cancel_reasons_table', 74),
(128, '2023_01_25_141209_add_trip_ticket_lines_table', 75),
(129, '2023_01_25_142243_add_backload_reason_to_trip_ticket_lines_table', 76),
(130, '2023_02_03_105629_add_name_details_to_cms_users_table', 77),
(144, '2024_02_27_082051_create_gis_pulls_table', 78),
(145, '2024_02_27_124317_create_gis_pull_lines_table', 78),
(146, '2024_03_01_134443_add_columns_to_pos_pull', 79),
(154, '2024_03_12_112459_add_request_type_to_pullout', 80),
(155, '2024_04_25_094616_add_allow_multiple_items_flag_in_reason_table', 80),
(156, '2024_06_04_164459_create_pos_pull_headers_table', 80),
(157, '2024_06_06_112553_add_pos_pull_header_id_to_pos_pull', 80);

-- --------------------------------------------------------

--
-- Table structure for table `pos_pull`
--

CREATE TABLE `pos_pull` (
  `id` int UNSIGNED NOT NULL,
  `step` int UNSIGNED DEFAULT NULL,
  `pos_pull_header_id` int DEFAULT NULL,
  `received_st_date` date DEFAULT NULL,
  `received_st_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `st_document_number` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `memo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transfer_date` date DEFAULT NULL,
  `hand_carrier` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transport_types_id` int UNSIGNED DEFAULT NULL,
  `reason_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wh_from` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wh_to` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `channel_id` int UNSIGNED DEFAULT NULL,
  `stores_id` int UNSIGNED DEFAULT NULL,
  `location_id_from` int UNSIGNED DEFAULT NULL,
  `sub_location_id_from` int UNSIGNED DEFAULT NULL,
  `stores_id_destination` int UNSIGNED DEFAULT NULL,
  `location_id_to` int UNSIGNED DEFAULT NULL,
  `sub_location_id_to` int UNSIGNED DEFAULT NULL,
  `item_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `has_serial` int UNSIGNED NOT NULL DEFAULT '0',
  `serial` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `st_status_id` int DEFAULT NULL,
  `scheduled_by` int UNSIGNED DEFAULT NULL,
  `scheduled_at` date DEFAULT NULL,
  `received_by` int UNSIGNED DEFAULT NULL,
  `received_at` datetime DEFAULT NULL,
  `log_printed_at` datetime DEFAULT NULL,
  `log_printed_by` int UNSIGNED DEFAULT NULL,
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rejected_by` int UNSIGNED DEFAULT NULL,
  `rejected_at` datetime DEFAULT NULL,
  `approved_by` int UNSIGNED DEFAULT NULL,
  `approved_at` datetime DEFAULT NULL,
  `approver_comments` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pos_pull`
--

INSERT INTO `pos_pull` (`id`, `step`, `pos_pull_header_id`, `received_st_date`, `received_st_number`, `st_document_number`, `memo`, `transfer_date`, `hand_carrier`, `transport_types_id`, `reason_id`, `wh_from`, `wh_to`, `channel_id`, `stores_id`, `location_id_from`, `sub_location_id_from`, `stores_id_destination`, `location_id_to`, `sub_location_id_to`, `item_code`, `item_description`, `quantity`, `has_serial`, `serial`, `st_status_id`, `scheduled_by`, `scheduled_at`, `received_by`, `received_at`, `log_printed_at`, `log_printed_by`, `status`, `rejected_by`, `rejected_at`, `approved_by`, `approved_at`, `approver_comments`, `created_at`, `created_date`, `updated_at`) VALUES
(1, NULL, NULL, NULL, NULL, 'ST-0000001', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660971436', 'ANIMAL SAUNA 09', 10, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'VOID', NULL, NULL, NULL, NULL, NULL, '2024-03-01 06:29:29', '2024-03-01', '2024-03-01 06:48:21'),
(2, NULL, NULL, NULL, NULL, 'ST-0000001', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660972198', 'STILL WAITING FOR YOU 10', 10, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'VOID', NULL, NULL, NULL, NULL, NULL, '2024-03-01 06:29:29', '2024-03-01', '2024-03-01 06:48:21'),
(3, NULL, NULL, NULL, NULL, 'ST-0000003', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660971436', 'ANIMAL SAUNA 09', 10, 0, NULL, NULL, 8, '2024-03-07', 243, '2024-03-01 16:03:29', NULL, NULL, 'RECEIVED', NULL, NULL, 211, '2024-03-01 15:36:57', NULL, '2024-03-01 06:49:21', '2024-03-01', '2024-03-01 08:03:29'),
(4, NULL, NULL, NULL, NULL, 'ST-0000003', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660972198', 'STILL WAITING FOR YOU 10', 10, 0, NULL, NULL, 8, '2024-03-07', 243, '2024-03-01 16:03:29', NULL, NULL, 'RECEIVED', NULL, NULL, 211, '2024-03-01 15:36:57', NULL, '2024-03-01 06:49:22', '2024-03-01', '2024-03-01 08:03:29'),
(5, NULL, NULL, NULL, NULL, 'ST-0000005', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660971436', 'ANIMAL SAUNA 09', 10, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'VOID', NULL, NULL, NULL, NULL, NULL, '2024-03-01 07:23:26', '2024-03-01', '2024-03-01 07:32:58'),
(6, NULL, NULL, NULL, NULL, 'ST-0000005', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660972198', 'STILL WAITING FOR YOU 10', 10, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'VOID', NULL, NULL, NULL, NULL, NULL, '2024-03-01 07:23:28', '2024-03-01', '2024-03-01 07:32:58'),
(7, NULL, NULL, NULL, NULL, 'ST-0000007', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660971436', 'ANIMAL SAUNA 09', 10, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'VOID', 211, '2024-03-01 15:43:54', 211, '2024-03-01 15:41:01', NULL, '2024-03-01 07:29:18', '2024-03-01', '2024-03-01 07:43:54'),
(8, NULL, NULL, NULL, NULL, 'ST-0000007', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660972198', 'STILL WAITING FOR YOU 10', 10, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'VOID', 211, '2024-03-01 15:43:54', 211, '2024-03-01 15:41:01', NULL, '2024-03-01 07:29:21', '2024-03-01', '2024-03-01 07:43:54'),
(9, NULL, NULL, NULL, NULL, 'ST-0000009', 'test', '2024-03-28', 'Marvin Mosico', 2, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660971436', 'ANIMAL SAUNA 09', 10, 0, NULL, NULL, NULL, NULL, 243, '2024-03-01 16:07:48', NULL, NULL, 'RECEIVED', NULL, NULL, 211, '2024-03-01 16:07:03', NULL, '2024-03-01 08:06:19', '2024-03-01', '2024-03-01 08:07:48'),
(10, NULL, NULL, NULL, NULL, 'ST-0000009', 'test', '2024-03-28', 'Marvin Mosico', 2, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660972198', 'STILL WAITING FOR YOU 10', 10, 0, NULL, NULL, NULL, NULL, 243, '2024-03-01 16:07:48', NULL, NULL, 'RECEIVED', NULL, NULL, 211, '2024-03-01 16:07:03', NULL, '2024-03-01 08:06:21', '2024-03-01', '2024-03-01 08:07:48'),
(11, NULL, NULL, NULL, NULL, 'ST-0000011', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660971436', 'ANIMAL SAUNA 09', 10, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'VOID', 211, '2024-03-01 17:17:32', NULL, NULL, NULL, '2024-03-01 08:23:48', '2024-03-01', '2024-03-01 09:17:32'),
(12, NULL, NULL, NULL, NULL, 'ST-0000011', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660972198', 'STILL WAITING FOR YOU 10', 10, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'VOID', 211, '2024-03-01 17:17:32', NULL, NULL, NULL, '2024-03-01 08:23:50', '2024-03-01', '2024-03-01 09:17:32'),
(13, NULL, NULL, NULL, NULL, 'ST-0000013', 'TEST', NULL, NULL, 1, '43', 'GGBOMITSUKOSHI', 'GGBOGREENHILLS', NULL, 291, 2, 1, 300, 3, 2, '4549660971436', 'ANIMAL SAUNA 09', 5, 0, NULL, NULL, 8, '2024-03-08', 260, '2024-03-04 09:02:29', NULL, NULL, 'RECEIVED', NULL, NULL, 211, '2024-03-01 17:18:37', NULL, '2024-03-01 08:33:27', '2024-03-01', '2024-03-04 01:02:29'),
(14, NULL, NULL, NULL, NULL, 'ST-0000013', 'TEST', NULL, NULL, 1, '43', 'GGBOMITSUKOSHI', 'GGBOGREENHILLS', NULL, 291, 2, 1, 300, 3, 2, '4549660972198', 'STILL WAITING FOR YOU 10', 5, 0, NULL, NULL, 8, '2024-03-08', 260, '2024-03-04 09:02:29', NULL, NULL, 'RECEIVED', NULL, NULL, 211, '2024-03-01 17:18:37', NULL, '2024-03-01 08:33:29', '2024-03-01', '2024-03-04 01:02:29'),
(15, NULL, NULL, NULL, NULL, 'ST-0000015', NULL, NULL, NULL, 1, '43', 'GGBOMITSUKOSHI', 'GGBOGREENHILLS', NULL, 291, 2, 1, 300, 3, 2, '4549660971436', 'ANIMAL SAUNA 09', 2, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PENDING', NULL, NULL, NULL, NULL, NULL, '2024-03-01 08:57:40', '2024-03-01', NULL),
(16, NULL, NULL, NULL, NULL, 'ST-0000015', NULL, NULL, NULL, 1, '43', 'GGBOMITSUKOSHI', 'GGBOGREENHILLS', NULL, 291, 2, 1, 300, 3, 2, '4549660972198', 'STILL WAITING FOR YOU 10', 5, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PENDING', NULL, NULL, NULL, NULL, NULL, '2024-03-01 08:57:43', '2024-03-01', NULL),
(17, NULL, NULL, NULL, NULL, 'ST-0000017', NULL, NULL, NULL, 1, '43', 'GGBOMITSUKOSHI', 'GGBOGREENHILLS', NULL, 291, 2, 1, 300, 3, 2, '4549660971436', 'ANIMAL SAUNA 09', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PENDING', NULL, NULL, NULL, NULL, NULL, '2024-03-01 08:59:23', '2024-03-01', NULL),
(18, NULL, NULL, NULL, NULL, 'ST-0000017', NULL, NULL, NULL, 1, '43', 'GGBOMITSUKOSHI', 'GGBOGREENHILLS', NULL, 291, 2, 1, 300, 3, 2, '4549660972198', 'STILL WAITING FOR YOU 10', 2, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PENDING', NULL, NULL, NULL, NULL, NULL, '2024-03-01 08:59:26', '2024-03-01', NULL),
(19, NULL, NULL, NULL, NULL, 'ST-0000019', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660971436', 'ANIMAL SAUNA 09', 5, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'VOID', NULL, NULL, NULL, NULL, NULL, '2024-03-01 09:01:16', '2024-03-01', '2024-03-01 09:12:51'),
(20, NULL, NULL, NULL, NULL, 'ST-0000019', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660972198', 'STILL WAITING FOR YOU 10', 5, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'VOID', NULL, NULL, NULL, NULL, NULL, '2024-03-01 09:01:18', '2024-03-01', '2024-03-01 09:12:51'),
(21, NULL, NULL, NULL, NULL, 'ST-0000021', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660971436', 'ANIMAL SAUNA 09', 5, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'VOID', NULL, NULL, NULL, NULL, NULL, '2024-03-01 09:07:29', '2024-03-01', '2024-03-01 09:11:30'),
(22, NULL, NULL, NULL, NULL, 'ST-0000021', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660972198', 'STILL WAITING FOR YOU 10', 5, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'VOID', NULL, NULL, NULL, NULL, NULL, '2024-03-01 09:07:33', '2024-03-01', '2024-03-01 09:11:30'),
(23, NULL, NULL, NULL, NULL, 'ST-0000023', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660972198', 'STILL WAITING FOR YOU 10', 5, 0, NULL, NULL, 8, '2024-03-08', 188, '2024-03-04 11:40:44', NULL, NULL, 'RECEIVED', NULL, NULL, 211, '2024-03-04 11:26:24', NULL, '2024-03-04 03:25:11', '2024-03-04', '2024-03-04 03:40:44'),
(24, NULL, NULL, NULL, NULL, 'ST-0000023', NULL, NULL, NULL, 1, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660971436', 'ANIMAL SAUNA 09', 20, 0, NULL, NULL, 8, '2024-03-08', 188, '2024-03-04 11:40:44', NULL, NULL, 'RECEIVED', NULL, NULL, 211, '2024-03-04 11:26:24', NULL, '2024-03-04 03:25:15', '2024-03-04', '2024-03-04 03:40:44'),
(25, NULL, NULL, NULL, NULL, 'ST-0000025', NULL, '2024-03-06', 'Mosico Mosico', 2, '43', 'GGBOGREENHILLS', 'GGBOMITSUKOSHI', NULL, 300, 3, 2, 291, 2, 1, '4549660971436', 'ANIMAL SAUNA 09', 10, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FOR RECEIVING', NULL, NULL, 211, '2024-03-04 11:33:24', NULL, '2024-03-04 03:33:08', '2024-03-04', '2024-03-04 03:33:24'),
(26, NULL, NULL, NULL, NULL, 'ST-0000026', NULL, NULL, NULL, 1, '43', 'GGBOMITSUKOSHI', 'GGBOGREENHILLS', NULL, 291, 2, 1, 300, 3, 2, '4549660972198', 'STILL WAITING FOR YOU 10', 5, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PENDING', NULL, NULL, NULL, NULL, NULL, '2024-03-04 09:27:44', '2024-03-04', NULL),
(27, NULL, NULL, NULL, NULL, 'ST-0000026', NULL, NULL, NULL, 1, '43', 'GGBOMITSUKOSHI', 'GGBOGREENHILLS', NULL, 291, 2, 1, 300, 3, 2, '4549660971436', 'ANIMAL SAUNA 09', 5, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PENDING', NULL, NULL, NULL, NULL, NULL, '2024-03-04 09:27:47', '2024-03-04', NULL),
(28, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '80006574', 'LAU ACC QUINT -X2 5P CHRGR BLK', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-06 04:08:16', NULL, NULL),
(29, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '80006574', 'LAU ACC QUINT -X2 5P CHRGR BLK', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-07 03:33:15', NULL, NULL),
(30, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '80006574', 'LAU ACC QUINT -X2 5P CHRGR BLK', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-07 06:30:42', NULL, NULL),
(31, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '80006574', 'LAU ACC QUINT -X2 5P CHRGR BLK', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-07 06:31:35', NULL, NULL),
(32, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '80006574', 'LAU ACC QUINT -X2 5P CHRGR BLK', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-07 06:32:11', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `pos_pull_headers`
--

CREATE TABLE `pos_pull_headers` (
  `id` int UNSIGNED NOT NULL,
  `reference_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `received_st_date` datetime DEFAULT NULL,
  `received_st_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `st_document_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `memo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transfer_date` datetime DEFAULT NULL,
  `hand_carrier` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transport_types_id` int DEFAULT NULL,
  `reason_id` int DEFAULT NULL,
  `wh_from` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wh_to` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `channel_id` int DEFAULT NULL,
  `stores_id` int DEFAULT NULL,
  `location_id_from` int DEFAULT NULL,
  `sub_location_id_from` int DEFAULT NULL,
  `stores_id_destination` int DEFAULT NULL,
  `location_id_to` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_location_id_to` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `st_status_id` int DEFAULT NULL,
  `file_name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `scheduled_by` int DEFAULT NULL,
  `scheduled_at` datetime DEFAULT NULL,
  `received_by` int DEFAULT NULL,
  `received_at` datetime DEFAULT NULL,
  `confirmed_by` int DEFAULT NULL,
  `confirmed_at` datetime DEFAULT NULL,
  `approved_by` int DEFAULT NULL,
  `approved_at` datetime DEFAULT NULL,
  `log_printed_by` int DEFAULT NULL,
  `log_printed_at` datetime DEFAULT NULL,
  `rejected_by` int DEFAULT NULL,
  `rejected_at` datetime DEFAULT NULL,
  `approver_comments` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pos_pull_headers`
--

INSERT INTO `pos_pull_headers` (`id`, `reference_number`, `status`, `received_st_date`, `received_st_number`, `st_document_number`, `memo`, `transfer_date`, `hand_carrier`, `transport_types_id`, `reason_id`, `wh_from`, `wh_to`, `channel_id`, `stores_id`, `location_id_from`, `sub_location_id_from`, `stores_id_destination`, `location_id_to`, `sub_location_id_to`, `st_status_id`, `file_name`, `scheduled_by`, `scheduled_at`, `received_by`, `received_at`, `confirmed_by`, `confirmed_at`, `approved_by`, `approved_at`, `log_printed_by`, `log_printed_at`, `rejected_by`, `rejected_at`, `approver_comments`, `created_by`, `updated_by`, `created_date`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'MWSTS-0000001', 'FOR RECEIVING', NULL, NULL, '9928', 'test', NULL, NULL, 1, 26, 'GDWTRINOMA', 'GDWMOA', 1, 32, NULL, NULL, 52, NULL, NULL, 2, NULL, 8, '2024-06-21 00:00:00', NULL, NULL, 261, '2024-06-07 09:28:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2024-06-06', '2024-06-06 04:08:16', '2024-06-07 01:28:20', NULL),
(2, 'MWSTS-0000002', 'PENDING', NULL, NULL, '9936', NULL, NULL, 'John Doe', 2, 26, 'GDWTRINOMA', 'GDWMOA', 1, 32, NULL, NULL, 52, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 261, NULL, '2024-06-07', '2024-06-07 03:33:15', NULL, NULL),
(3, 'MWSTS-0000003', 'PENDING', NULL, NULL, '9940', 'memo ko', NULL, NULL, 1, 25, 'GDWTRINOMA', 'GDWMOA', 1, 32, NULL, NULL, 52, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 263, NULL, '2024-06-07', '2024-06-07 06:30:42', NULL, NULL),
(4, 'MWSTS-0000004', 'PENDING', NULL, NULL, '9941', 'memo mo', NULL, NULL, 1, 28, 'GDWTRINOMA', 'GDWMOA', 1, 32, NULL, NULL, 52, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 264, NULL, '2024-06-07', '2024-06-07 06:31:35', NULL, NULL),
(5, 'MWSTS-0000005', 'PENDING', NULL, NULL, '9942', 'memo ko', NULL, NULL, 1, 25, 'GDWTRINOMA', 'GDWMOA', 1, 32, NULL, NULL, 52, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 265, NULL, '2024-06-07', '2024-06-07 06:32:11', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `problems`
--

CREATE TABLE `problems` (
  `id` int UNSIGNED NOT NULL,
  `problem_details` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('ACTIVE','INACTIVE') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'ACTIVE',
  `created_by` int UNSIGNED DEFAULT NULL,
  `updated_by` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `problems`
--

INSERT INTO `problems` (`id`, `problem_details`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'AESTHETICS - DISCOLORATION', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(2, 'AESTHETICS - MISSING PARTS / COMPONENTS', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(3, 'AESTHETICS - SCRATCHES / DENTS', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(4, 'AESTHETICS - WEAK ADHESIVE', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(5, 'BATTERY - BLOATED', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(6, 'BATTERY - EASILY DRAINED', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(7, 'BATTERY - NOT CHARGING', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(8, 'BATTERY - OVERHEATING', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(9, 'CAMERA - FOCUS ISSUES', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(10, 'CONNECTIVITY - SIGNAL', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(11, 'CONNECTIVITY - SYNC', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(12, 'CONNECTIVITY - WIFI', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(13, 'DISPLAY - CRACKED SCREEN', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(14, 'DISPLAY - FLICKERING SCREEN', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(15, 'DISPLAY - TOUCH MALFUNCTIONING', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(16, 'INPUT - BUTTON MALFUNCTIONING', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(17, 'MICROPHONE - NO SOUND INPUT', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(18, 'OTHERS', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(19, 'POWER - INTERMITTENT CHARGING', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(20, 'POWER - NOT CHARGING', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(21, 'POWER - NOT OPENING', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(22, 'SCREEN - DEAD PIXELS', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(23, 'SOFTWARE - HANGING', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(24, 'SOFTWARE - VIRUS', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(25, 'SOUND - DISTORTED/STATIC', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL),
(26, 'SOUND - NO VOLUME', 'ACTIVE', 1, NULL, '2021-10-11 01:42:29', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `pullout`
--

CREATE TABLE `pullout` (
  `id` int UNSIGNED NOT NULL,
  `step` int UNSIGNED DEFAULT NULL,
  `received_st_date` date DEFAULT NULL,
  `received_st_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sor_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `st_document_number` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `si_document_number` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `memo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pullout_date` date DEFAULT NULL,
  `picklist_date` date DEFAULT NULL,
  `pickconfirm_date` date DEFAULT NULL,
  `hand_carrier` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transport_types_id` int UNSIGNED DEFAULT NULL,
  `schedule_date` date DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `schedule_by` int UNSIGNED DEFAULT NULL,
  `log_printed_at` datetime DEFAULT NULL,
  `log_printed_by` int UNSIGNED DEFAULT NULL,
  `transaction_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reason_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problems` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `problem_detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `wh_from` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wh_to` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stores_id` int UNSIGNED DEFAULT NULL,
  `stores_id_destination` int UNSIGNED DEFAULT NULL,
  `channel_id` int UNSIGNED DEFAULT NULL,
  `item_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `has_serial` int UNSIGNED DEFAULT NULL,
  `serial` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `st_status_id` int UNSIGNED DEFAULT NULL,
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `received_by` int UNSIGNED DEFAULT NULL,
  `received_at` datetime DEFAULT NULL,
  `rejected_by` int UNSIGNED DEFAULT NULL,
  `rejected_at` datetime DEFAULT NULL,
  `approved_by` int UNSIGNED DEFAULT NULL,
  `approved_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `request_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pullout_receivings`
--

CREATE TABLE `pullout_receivings` (
  `id` int UNSIGNED NOT NULL,
  `wrs_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sor_mor_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stores_id` int UNSIGNED DEFAULT NULL,
  `reason_id` int UNSIGNED DEFAULT NULL,
  `pullout_from` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int UNSIGNED DEFAULT NULL,
  `updated_by` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pullout_receiving_lines`
--

CREATE TABLE `pullout_receiving_lines` (
  `id` int UNSIGNED NOT NULL,
  `pullout_receivings_id` int UNSIGNED DEFAULT NULL,
  `item_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` int UNSIGNED DEFAULT NULL,
  `received_quantity` int UNSIGNED DEFAULT NULL,
  `serial` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `has_serial` int UNSIGNED DEFAULT NULL,
  `received_serial` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cancel_quantity` int UNSIGNED DEFAULT NULL,
  `cancel_reasons` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cancel_reason_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remarks` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pullout_receiving_serials`
--

CREATE TABLE `pullout_receiving_serials` (
  `id` int UNSIGNED NOT NULL,
  `pullout_receiving_lines_id` int UNSIGNED DEFAULT NULL,
  `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('MISMATCHED','RECEIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'RECEIVED',
  `created_by` int UNSIGNED DEFAULT NULL,
  `updated_by` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `reason`
--

CREATE TABLE `reason` (
  `id` int UNSIGNED NOT NULL,
  `transaction_type_id` int UNSIGNED DEFAULT NULL,
  `bea_mo_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bea_so_reason` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pullout_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('ACTIVE','INACTIVE') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'ACTIVE',
  `allow_multi_items` int UNSIGNED NOT NULL DEFAULT '0',
  `created_by` int UNSIGNED DEFAULT NULL,
  `updated_by` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reason`
--

INSERT INTO `reason` (`id`, `transaction_type_id`, `bea_mo_reason`, `bea_so_reason`, `pullout_reason`, `status`, `allow_multi_items`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 2, '166', 'R-05', 'DEFECTIVE RETURN', 'INACTIVE', 0, 1, 1, '2021-01-04 23:48:33', '2022-02-21 18:08:24', NULL),
(2, 2, '181', 'R-21', 'SUPPLIER PRODUCT RECALL', 'ACTIVE', 0, 1, 1, '2021-01-04 23:48:53', '2021-10-10 19:51:24', NULL),
(3, 2, '167', 'R-06', 'DEFECTIVE STORE STOCK', 'ACTIVE', 0, 1, 1, '2021-01-04 23:49:02', '2021-10-10 19:50:52', NULL),
(4, 2, '169', 'R-08', 'DIGITS PRODUCT RECALL', 'ACTIVE', 0, 1, 1, '2021-01-04 23:49:12', '2021-10-10 19:51:08', NULL),
(5, 1, '163', 'R-02', 'BACKLOAD/WRONG DELIVERY', 'ACTIVE', 0, 1, 1, '2021-01-04 23:50:07', '2021-10-10 19:45:30', NULL),
(6, 1, '162', 'R-01', 'ASSET REQUISITION', 'ACTIVE', 0, 1, 1, '2021-01-04 23:50:31', '2021-10-10 19:45:11', NULL),
(7, 1, '164', 'R-03', 'CUSTOMER REPLACEMENT', 'ACTIVE', 0, 1, 1, '2021-01-04 23:50:46', '2021-10-10 19:45:44', NULL),
(8, 1, '168', 'R-07', 'DEMO RECLASS', 'ACTIVE', 0, 1, 1, '2021-01-04 23:50:59', '2021-10-10 19:46:13', NULL),
(9, 1, '170', 'R-09', 'DIS-CON REPLACEMENT', 'ACTIVE', 0, 1, 1, '2021-01-04 23:51:11', '2021-10-10 19:46:28', NULL),
(10, 1, '171', 'R-10', 'DIS-CON RETURN', 'ACTIVE', 0, 1, 1, '2021-01-04 23:51:23', '2021-10-10 19:46:43', NULL),
(11, 1, '172', 'R-11', 'DIS-OUT REPLACEMENT', 'ACTIVE', 0, 1, 1, '2021-01-04 23:51:33', '2021-10-10 19:46:56', NULL),
(12, 1, '173', 'R-12', 'DISTRIBUTION REQUEST', 'ACTIVE', 0, 1, 1, '2021-01-04 23:51:42', '2021-10-10 19:47:10', NULL),
(13, 1, '174', 'R-14', 'FRANCHISE RETURN', 'ACTIVE', 0, 1, 1, '2021-01-04 23:51:53', '2021-10-10 19:47:47', NULL),
(14, 1, '175', 'R-15', 'HQ PULL-OUT', 'ACTIVE', 0, 1, 1, '2021-01-04 23:52:03', '2021-10-10 19:48:06', NULL),
(15, 1, '176', 'R-16', 'MARKETING', 'ACTIVE', 0, 1, 1, '2021-01-04 23:52:24', '2021-10-10 19:48:19', NULL),
(16, 1, '177', 'R-17', 'OPEN BOX SALE', 'ACTIVE', 0, 1, 1, '2021-01-04 23:52:55', '2021-10-10 19:48:34', NULL),
(17, 1, '178', 'R-18', 'REORDER', 'ACTIVE', 0, 1, 1, '2021-01-04 23:53:04', '2021-10-10 19:48:54', NULL),
(18, 1, '179', 'R-19', 'SALE EVENT REQUEST', 'ACTIVE', 0, 1, 1, '2021-01-04 23:53:18', '2021-10-10 19:49:12', NULL),
(19, 1, '180', 'R-20', 'SALE EVENT RETURN', 'ACTIVE', 0, 1, 1, '2021-01-04 23:53:29', '2021-10-10 19:49:38', NULL),
(20, 1, '182', 'R-22', 'TOTAL PULL-OUT', 'ACTIVE', 0, 1, 1, '2021-01-04 23:53:43', '2021-10-10 19:49:54', NULL),
(21, 1, '165', 'R-04', 'CUSTOMER REQUEST', 'ACTIVE', 0, 1, 1, '2021-01-22 03:07:15', '2021-10-10 19:45:57', NULL),
(22, 1, '142', 'R-13', 'FRANCHISE REQUEST', 'ACTIVE', 0, 1, 1, '2021-01-28 10:48:51', '2021-10-10 19:47:30', NULL),
(23, 3, '176', 'R-16', 'MARKETING', 'ACTIVE', 0, 1, 1, '2021-02-28 22:03:57', '2021-10-10 19:53:00', NULL),
(24, 4, NULL, NULL, 'BACKLOAD/WRONG DELIVERY', 'ACTIVE', 0, 1, NULL, '2021-10-05 19:06:45', NULL, NULL),
(25, 4, NULL, NULL, 'CUSTOMER REPLACEMENT', 'ACTIVE', 0, 1, NULL, '2021-10-05 19:07:16', NULL, NULL),
(26, 4, NULL, NULL, 'CUSTOMER REQUEST', 'ACTIVE', 0, 1, NULL, '2021-10-05 19:07:51', NULL, NULL),
(27, 4, NULL, NULL, 'ECOMM REQUEST', 'INACTIVE', 0, 1, 1, '2021-10-05 19:08:57', '2021-12-06 20:24:48', NULL),
(28, 4, NULL, NULL, 'FRANCHISE REQUEST', 'ACTIVE', 0, 1, NULL, '2021-10-05 19:09:26', NULL, NULL),
(29, 4, NULL, NULL, 'MARKETING', 'ACTIVE', 0, 1, NULL, '2021-10-05 19:09:50', NULL, NULL),
(30, 4, NULL, NULL, 'OPEN BOX SALE', 'ACTIVE', 0, 1, NULL, '2021-10-05 19:10:14', NULL, NULL),
(31, 4, NULL, NULL, 'REORDER', 'ACTIVE', 0, 1, NULL, '2021-10-05 19:10:33', NULL, NULL),
(32, 4, NULL, NULL, 'SALE EVENT REQUEST', 'ACTIVE', 0, 1, NULL, '2021-10-05 19:10:52', NULL, NULL),
(33, 4, NULL, NULL, 'DEFECTIVE STORE STOCK', 'ACTIVE', 0, 1, NULL, '2021-10-05 19:11:54', NULL, NULL),
(34, 4, NULL, NULL, 'DIGITS PRODUCT RECALL', 'ACTIVE', 0, 1, NULL, '2021-10-05 19:12:14', NULL, NULL),
(35, 4, NULL, NULL, 'SUPPLIER PRODUCT RECALL', 'ACTIVE', 0, 1, NULL, '2021-10-05 19:12:35', NULL, NULL),
(36, 1, '122', 'R-24', 'ECOMM REQUEST', 'INACTIVE', 0, 1, 1, '2021-10-10 19:43:40', '2021-12-06 20:29:26', NULL),
(37, 1, '123', 'R-25', 'ECOMM RETURN', 'ACTIVE', 0, 1, NULL, '2021-10-10 19:43:56', NULL, NULL),
(38, 1, '124', 'R-26', 'RETAIL REQUEST', 'ACTIVE', 0, 1, NULL, '2021-10-10 19:44:42', NULL, NULL),
(39, 4, NULL, NULL, 'ECOMM REQUEST FBV', 'ACTIVE', 0, 1, NULL, '2021-12-06 20:24:35', NULL, NULL),
(40, 4, NULL, NULL, 'ECOMM REQUEST FBD', 'ACTIVE', 0, 1, NULL, '2021-12-06 20:24:39', NULL, NULL),
(41, 1, '203', 'R-28', 'ECOMM REQUEST FBV', 'ACTIVE', 0, 1, NULL, '2021-12-06 20:29:18', NULL, NULL),
(42, 1, '202', 'R-27', 'ECOMM REQUEST FBD', 'ACTIVE', 0, 1, NULL, '2021-12-06 20:29:19', NULL, NULL),
(43, 4, NULL, NULL, 'STOCK REALLOCATION', 'ACTIVE', 0, 1, NULL, '2022-02-17 00:10:38', NULL, NULL),
(44, 1, '222', 'R-29', 'EMPLOYEE REQUEST', 'ACTIVE', 0, 1, NULL, '2022-02-17 00:45:40', NULL, NULL),
(45, 1, '282', 'R-30', 'DIS-OUT EXCHANGE', 'ACTIVE', 0, 1, NULL, '2022-10-05 18:34:29', NULL, NULL),
(46, 1, '322', 'R-31', 'MADNESS', 'ACTIVE', 0, 1, NULL, '2023-03-14 22:41:19', NULL, NULL),
(47, 1, '366', 'R-32', 'STOCK REALLOCATION', 'ACTIVE', 0, 1, NULL, '2023-05-25 18:49:03', NULL, NULL),
(48, 1, '369', 'R-33', 'DEMO - SALE', 'ACTIVE', 0, 1, NULL, '2023-05-29 18:57:15', NULL, NULL),
(49, 4, NULL, NULL, 'DEMO - SALE', 'ACTIVE', 0, 1, NULL, '2023-05-30 17:03:12', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `serials`
--

CREATE TABLE `serials` (
  `id` int UNSIGNED NOT NULL,
  `ebs_pull_id` int UNSIGNED DEFAULT NULL,
  `pos_pull_id` int UNSIGNED DEFAULT NULL,
  `pullout_id` int UNSIGNED DEFAULT NULL,
  `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `counter` int NOT NULL DEFAULT '0',
  `status` enum('PENDING','FAILED','RECEIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'PENDING',
  `created_by` int UNSIGNED DEFAULT NULL,
  `updated_by` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `status_workflows`
--

CREATE TABLE `status_workflows` (
  `id` int UNSIGNED NOT NULL,
  `transaction_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `channel_id` int UNSIGNED DEFAULT NULL,
  `customer_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transport_types_id` int UNSIGNED DEFAULT NULL,
  `workflow_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_step` int UNSIGNED DEFAULT NULL,
  `next_step` int UNSIGNED DEFAULT NULL,
  `status` enum('ACTIVE','INACTIVE') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'ACTIVE',
  `created_by` int UNSIGNED DEFAULT NULL,
  `updated_by` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `status_workflows`
--

INSERT INTO `status_workflows` (`id`, `transaction_type`, `channel_id`, `customer_type`, `transport_types_id`, `workflow_status`, `current_step`, `next_step`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'STW', 1, NULL, 1, 'PENDING', 1, 2, 'ACTIVE', NULL, NULL, '2021-08-16 02:15:34', NULL, NULL),
(2, 'STW', 1, NULL, 1, 'FOR PROCESSING', 2, 3, 'ACTIVE', NULL, NULL, '2021-08-16 02:16:01', NULL, NULL),
(3, 'STW', 1, NULL, 1, 'FOR SCHEDULE', 3, 4, 'ACTIVE', 1, NULL, '2021-08-16 02:18:02', NULL, NULL),
(4, 'STW', 1, NULL, 1, 'FOR RECEIVING', 4, 5, 'ACTIVE', 1, NULL, '2021-08-16 02:18:19', NULL, NULL),
(5, 'STW', 1, NULL, 1, 'RECEIVED', 5, 6, 'ACTIVE', 1, NULL, '2021-08-16 02:19:15', NULL, NULL),
(6, 'STW', 4, 'FBD', NULL, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2021-08-16 11:39:59', NULL, NULL),
(7, 'STW', 4, 'FBD', NULL, 'FOR PICKLIST', 2, 4, 'ACTIVE', 1, 1, '2021-08-16 11:40:25', '2021-09-07 11:01:32', NULL),
(9, 'STW', 4, 'FBD', NULL, 'FOR RECEIVING', 4, 5, 'ACTIVE', 1, 1, '2021-08-16 11:41:38', '2021-08-16 11:42:01', NULL),
(10, 'STW', 4, 'FBD', NULL, 'RECEIVED', 5, 6, 'ACTIVE', 1, NULL, '2021-08-16 11:42:18', NULL, NULL),
(16, 'STW', 4, 'FBV', 1, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2021-08-17 12:43:26', NULL, NULL),
(18, 'STW', 4, 'FBV', 1, 'FOR SCHEDULE', 3, 4, 'ACTIVE', 1, 1, '2021-08-17 12:44:27', '2021-09-07 15:07:24', NULL),
(19, 'STW', 4, 'FBV', 1, 'FOR RECEIVING', 4, 5, 'ACTIVE', 1, NULL, '2021-08-17 12:44:45', NULL, NULL),
(20, 'STW', 4, 'FBV', 1, 'RECEIVED', 5, 6, 'ACTIVE', 1, NULL, '2021-08-17 12:45:07', NULL, NULL),
(26, 'RMA', 4, 'FBV', 1, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2021-08-17 13:47:21', NULL, NULL),
(28, 'RMA', 4, 'FBV', 1, 'FOR SCHEDULE', 3, 4, 'ACTIVE', 1, 1, '2021-08-17 13:49:05', '2021-09-08 09:59:54', NULL),
(29, 'RMA', 4, 'FBV', 1, 'FOR RECEIVING', 4, 5, 'ACTIVE', 1, NULL, '2021-08-17 13:49:19', NULL, NULL),
(30, 'RMA', 4, 'FBV', 1, 'RECEIVED', 5, 6, 'ACTIVE', 1, NULL, '2021-08-17 13:49:33', NULL, NULL),
(31, 'STW', 4, 'FBV', 1, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2021-09-07 15:07:43', NULL, NULL),
(32, 'RMA', 4, 'FBV', 1, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2021-09-08 10:00:15', NULL, NULL),
(33, 'STW', 1, NULL, 2, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2021-09-13 09:59:56', NULL, NULL),
(34, 'STW', 1, NULL, 2, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2021-09-13 10:00:10', NULL, NULL),
(35, 'STW', 1, NULL, 2, 'FOR RECEIVING', 3, 4, 'ACTIVE', 1, NULL, '2021-09-13 10:00:31', NULL, NULL),
(36, 'STW', 1, NULL, 2, 'RECEIVED', 4, 5, 'ACTIVE', 1, NULL, '2021-09-13 10:00:51', NULL, NULL),
(37, 'RMA', 1, NULL, 1, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2021-09-13 14:02:50', NULL, NULL),
(38, 'RMA', 1, NULL, 1, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2021-09-13 14:03:06', NULL, NULL),
(39, 'RMA', 1, NULL, 1, 'FOR SCHEDULE', 3, 4, 'ACTIVE', 1, NULL, '2021-09-13 14:03:21', NULL, NULL),
(40, 'RMA', 1, NULL, 1, 'FOR RECEIVING', 4, 5, 'ACTIVE', 1, NULL, '2021-09-13 14:03:36', NULL, NULL),
(41, 'RMA', 1, NULL, 1, 'RECEIVED', 5, 6, 'ACTIVE', 1, NULL, '2021-09-13 14:03:50', NULL, NULL),
(42, 'RMA', 1, NULL, 2, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2021-09-13 14:04:24', NULL, NULL),
(43, 'RMA', 1, NULL, 2, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2021-09-13 14:04:38', NULL, NULL),
(44, 'RMA', 1, NULL, 2, 'FOR RECEIVING', 3, 4, 'ACTIVE', 1, NULL, '2021-09-13 14:04:53', NULL, NULL),
(45, 'RMA', 1, NULL, 2, 'RECEIVED', 4, 5, 'ACTIVE', 1, NULL, '2021-09-13 14:05:07', NULL, NULL),
(46, 'STW', 2, NULL, 1, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2021-09-14 05:05:47', NULL, NULL),
(47, 'STW', 2, NULL, 1, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2021-09-14 05:06:13', NULL, NULL),
(48, 'STW', 2, NULL, 1, 'FOR SCHEDULE', 3, 4, 'ACTIVE', 1, NULL, '2021-09-14 05:06:31', NULL, NULL),
(49, 'STW', 2, NULL, 1, 'FOR RECEIVING', 4, 5, 'ACTIVE', 1, NULL, '2021-09-14 05:07:01', NULL, NULL),
(50, 'STW', 2, NULL, 1, 'RECEIVED', 5, 6, 'ACTIVE', 1, NULL, '2021-09-14 05:07:17', NULL, NULL),
(51, 'STW', 2, NULL, 2, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2021-09-14 05:38:57', NULL, NULL),
(52, 'STW', 2, NULL, 2, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2021-09-14 05:39:19', NULL, NULL),
(53, 'STW', 2, NULL, 2, 'FOR RECEIVING', 3, 4, 'ACTIVE', 1, NULL, '2021-09-14 05:39:34', NULL, NULL),
(54, 'STW', 2, NULL, 2, 'RECEIVED', 4, 5, 'ACTIVE', 1, NULL, '2021-09-14 05:39:49', NULL, NULL),
(55, 'RMA', 2, NULL, 1, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2021-09-14 05:42:23', NULL, NULL),
(56, 'RMA', 2, NULL, 1, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2021-09-14 05:42:41', NULL, NULL),
(57, 'RMA', 2, NULL, 1, 'FOR SCHEDULE', 3, 4, 'ACTIVE', 1, NULL, '2021-09-14 05:42:54', NULL, NULL),
(58, 'RMA', 2, NULL, 1, 'FOR RECEIVING', 4, 5, 'ACTIVE', 1, NULL, '2021-09-14 05:43:06', NULL, NULL),
(59, 'RMA', 2, NULL, 1, 'RECEIVED', 5, 6, 'ACTIVE', 1, NULL, '2021-09-14 05:43:20', NULL, NULL),
(60, 'RMA', 2, NULL, 2, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2021-09-14 05:43:35', NULL, NULL),
(61, 'RMA', 2, NULL, 2, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2021-09-14 05:43:52', NULL, NULL),
(62, 'RMA', 2, NULL, 2, 'FOR RECEIVING', 3, 4, 'ACTIVE', 1, NULL, '2021-09-14 05:44:05', NULL, NULL),
(63, 'RMA', 2, NULL, 2, 'RECEIVED', 4, 5, 'ACTIVE', 1, NULL, '2021-09-14 05:44:17', NULL, NULL),
(64, 'RMA', 4, 'FBD', NULL, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2021-09-22 17:54:56', NULL, NULL),
(65, 'RMA', 4, 'FBD', NULL, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2021-09-22 17:55:15', NULL, NULL),
(66, 'RMA', 4, 'FBD', NULL, 'FOR RECEIVING', 3, 4, 'ACTIVE', 1, NULL, '2021-09-22 17:55:46', NULL, NULL),
(67, 'RMA', 4, 'FBD', NULL, 'RECEIVED', 4, 5, 'ACTIVE', 1, NULL, '2021-09-22 17:56:04', NULL, NULL),
(68, 'STW', 6, NULL, 1, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-03-01 17:20:49', NULL, NULL),
(69, 'STW', 6, NULL, 1, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-03-01 17:21:05', NULL, NULL),
(70, 'STW', 6, NULL, 1, 'FOR SCHEDULE', 3, 4, 'ACTIVE', 1, NULL, '2022-03-01 17:21:20', NULL, NULL),
(71, 'STW', 6, NULL, 1, 'FOR RECEIVING', 4, 5, 'ACTIVE', 1, NULL, '2022-03-01 17:21:34', NULL, NULL),
(72, 'STW', 6, NULL, 1, 'RECEIVED', 5, 6, 'ACTIVE', 1, NULL, '2022-03-01 17:21:46', NULL, NULL),
(73, 'STW', 6, NULL, 2, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-03-01 17:24:10', NULL, NULL),
(74, 'STW', 6, NULL, 2, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-03-01 17:24:21', NULL, NULL),
(75, 'STW', 6, NULL, 2, 'FOR RECEIVING', 3, 4, 'ACTIVE', 1, NULL, '2022-03-01 17:24:35', NULL, NULL),
(76, 'STW', 6, NULL, 2, 'RECEIVED', 4, 5, 'ACTIVE', 1, NULL, '2022-03-01 17:24:51', NULL, NULL),
(77, 'RMA', 6, NULL, 1, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-03-06 13:43:28', NULL, NULL),
(78, 'RMA', 6, NULL, 1, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-03-06 13:43:53', NULL, NULL),
(79, 'RMA', 6, NULL, 1, 'FOR SCHEDULE', 3, 4, 'ACTIVE', 1, NULL, '2022-03-06 13:44:14', NULL, NULL),
(80, 'RMA', 6, NULL, 1, 'FOR RECEIVING', 4, 5, 'ACTIVE', 1, NULL, '2022-03-06 13:44:40', NULL, NULL),
(81, 'RMA', 6, NULL, 1, 'RECEIVED', 5, 6, 'ACTIVE', 1, NULL, '2022-03-06 13:44:58', NULL, NULL),
(82, 'RMA', 6, NULL, 2, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-03-06 13:46:15', NULL, NULL),
(83, 'RMA', 6, NULL, 2, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-03-06 13:46:29', NULL, NULL),
(84, 'RMA', 6, NULL, 2, 'FOR RECEIVING', 3, 4, 'ACTIVE', 1, NULL, '2022-03-06 13:46:49', NULL, NULL),
(85, 'RMA', 6, NULL, 2, 'RECEIVED', 4, 5, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(86, 'STW', 10, NULL, 1, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(87, 'STW', 10, NULL, 1, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(88, 'STW', 10, NULL, 1, 'FOR SCHEDULE', 3, 4, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(89, 'STW', 10, NULL, 1, 'FOR RECEIVING', 4, 5, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(90, 'STW', 10, NULL, 1, 'RECEIVED', 5, 6, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(91, 'STW', 10, NULL, 2, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(92, 'STW', 10, NULL, 2, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(93, 'STW', 10, NULL, 2, 'FOR RECEIVING', 3, 4, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(94, 'STW', 10, NULL, 2, 'RECEIVED', 4, 5, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(95, 'RMA', 10, NULL, 1, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(96, 'RMA', 10, NULL, 1, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(97, 'RMA', 10, NULL, 1, 'FOR SCHEDULE', 3, 4, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(98, 'RMA', 10, NULL, 1, 'FOR RECEIVING', 4, 5, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(99, 'RMA', 10, NULL, 1, 'RECEIVED', 5, 6, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(100, 'RMA', 10, NULL, 2, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(101, 'RMA', 10, NULL, 2, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(102, 'RMA', 10, NULL, 2, 'FOR RECEIVING', 3, 4, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(103, 'RMA', 10, NULL, 2, 'RECEIVED', 4, 5, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(104, 'STW', 11, NULL, 1, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(105, 'STW', 11, NULL, 1, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(106, 'STW', 11, NULL, 1, 'FOR SCHEDULE', 3, 4, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(107, 'STW', 11, NULL, 1, 'FOR RECEIVING', 4, 5, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(108, 'STW', 11, NULL, 1, 'RECEIVED', 5, 6, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(109, 'STW', 11, NULL, 2, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(110, 'STW', 11, NULL, 2, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(111, 'STW', 11, NULL, 2, 'FOR RECEIVING', 3, 4, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(112, 'STW', 11, NULL, 2, 'RECEIVED', 4, 5, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(113, 'RMA', 11, NULL, 1, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(114, 'RMA', 11, NULL, 1, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(115, 'RMA', 11, NULL, 1, 'FOR SCHEDULE', 3, 4, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(116, 'RMA', 11, NULL, 1, 'FOR RECEIVING', 4, 5, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(117, 'RMA', 11, NULL, 1, 'RECEIVED', 5, 6, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(118, 'RMA', 11, NULL, 2, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(119, 'RMA', 11, NULL, 2, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(120, 'RMA', 11, NULL, 2, 'FOR RECEIVING', 3, 4, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(121, 'RMA', 11, NULL, 2, 'RECEIVED', 4, 5, 'ACTIVE', 1, NULL, '2022-03-06 13:47:05', NULL, NULL),
(122, 'RMA', 7, NULL, 1, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-05-15 19:08:59', NULL, NULL),
(123, 'RMA', 7, NULL, 1, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-05-15 19:10:57', NULL, NULL),
(124, 'RMA', 7, NULL, 1, 'FOR SCHEDULE', 3, 4, 'ACTIVE', 1, NULL, '2022-05-15 19:11:26', NULL, NULL),
(125, 'RMA', 7, NULL, 1, 'FOR RECEIVING', 4, 5, 'ACTIVE', 1, NULL, '2022-05-15 19:11:40', NULL, NULL),
(126, 'RMA', 7, NULL, 1, 'RECEIVED', 5, 6, 'ACTIVE', 1, NULL, '2022-05-15 19:11:55', NULL, NULL),
(127, 'RMA', 7, NULL, 2, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-05-15 19:26:35', NULL, NULL),
(128, 'RMA', 7, NULL, 2, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-05-15 19:26:51', NULL, NULL),
(129, 'RMA', 7, NULL, 2, 'FOR RECEIVING', 3, 4, 'ACTIVE', 1, NULL, '2022-05-15 19:27:05', NULL, NULL),
(130, 'RMA', 7, NULL, 2, 'RECEIVED', 4, 5, 'ACTIVE', 1, NULL, '2022-05-15 19:27:20', NULL, NULL),
(131, 'STW', 7, NULL, 1, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-05-15 19:29:02', NULL, NULL),
(132, 'STW', 7, NULL, 1, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-05-15 19:29:15', NULL, NULL),
(133, 'STW', 7, NULL, 1, 'FOR SCHEDULE', 3, 4, 'ACTIVE', 1, NULL, '2022-05-15 19:29:29', NULL, NULL),
(134, 'STW', 7, NULL, 1, 'FOR RECEIVING', 4, 5, 'ACTIVE', 1, NULL, '2022-05-15 19:29:44', NULL, NULL),
(135, 'STW', 7, NULL, 1, 'RECEIVED', 5, 6, 'ACTIVE', 1, NULL, '2022-05-15 19:30:00', NULL, NULL),
(136, 'STW', 7, NULL, 2, 'PENDING', 1, 2, 'ACTIVE', 1, NULL, '2022-05-15 19:30:42', NULL, NULL),
(137, 'STW', 7, NULL, 2, 'FOR PROCESSING', 2, 3, 'ACTIVE', 1, NULL, '2022-05-15 19:31:02', NULL, NULL),
(138, 'STW', 7, NULL, 2, 'FOR RECEIVING', 3, 4, 'ACTIVE', 1, NULL, '2022-05-15 19:33:05', NULL, NULL),
(139, 'STW', 7, NULL, 2, 'RECEIVED', 4, 5, 'ACTIVE', 1, NULL, '2022-05-15 19:33:23', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `stock_statuses`
--

CREATE TABLE `stock_statuses` (
  `id` int UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `stores`
--

CREATE TABLE `stores` (
  `id` int UNSIGNED NOT NULL,
  `bea_so_store_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bea_mo_store_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pos_warehouse` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pos_warehouse_branch` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pos_warehouse_transit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pos_warehouse_transit_branch` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pos_warehouse_rma` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pos_warehouse_rma_branch` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pos_warehouse_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doo_subinventory` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sit_subinventory` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `org_subinventory` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `channel_id` int UNSIGNED DEFAULT NULL,
  `customer_type_id` int UNSIGNED DEFAULT NULL,
  `locations_id` int UNSIGNED DEFAULT NULL,
  `sts_group` int UNSIGNED DEFAULT NULL,
  `allowed_bulk_receiving` tinyint NOT NULL DEFAULT '0',
  `status` enum('ACTIVE','INACTIVE') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'ACTIVE',
  `created_by` int UNSIGNED DEFAULT NULL,
  `updated_by` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stores`
--

INSERT INTO `stores` (`id`, `bea_so_store_name`, `bea_mo_store_name`, `pos_warehouse`, `pos_warehouse_branch`, `pos_warehouse_transit`, `pos_warehouse_transit_branch`, `pos_warehouse_rma`, `pos_warehouse_rma_branch`, `pos_warehouse_name`, `doo_subinventory`, `sit_subinventory`, `org_subinventory`, `channel_id`, `customer_type_id`, `locations_id`, `sts_group`, `allowed_bulk_receiving`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'BASEUS.AYALA.BONIFACIO HIGH STREET.FRA', 'BASEUS AYALA BONIFACIO HIGH STREET FRA', 'BASEUSBGC', 'BSBGC', 'TBASEUSBGC', 'TBASEUSBGC', 'BASEUSBGR', 'RBASEUSBGC', 'BASEUS BGC', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 2, 0, 'INACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-12-02 05:37:37', NULL),
(2, 'BASEUS.AYALA.TRINOMA.RTL', 'BASEUS AYALA TRINOMA RTL', 'GBASEUSTRINOMA', 'BASEUSTRINOMA', 'TBASEUSTRINOMA', NULL, 'BSTRINOMARM', NULL, 'BASEUS TRINOMA', 'RETAIL', NULL, 'RETAIL', 1, NULL, NULL, 1, 0, 'INACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-10-10 22:07:54', NULL),
(3, 'BASEUS.AYALA.UPTC.RTL', 'BASEUS AYALA UPTC RTL', 'BASEUSUPTOWN', 'BASEUSUPTC', 'TBASEUSUPTOWN', NULL, 'BASEUSUPTOWNRM', NULL, 'BASEUS UP TOWN', 'RETAIL', NULL, 'RETAIL', 1, NULL, NULL, 1, 0, 'INACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-12-02 06:04:25', NULL),
(4, 'BASEUS.SM.FAIRVIEW.RTL', 'BASEUS SM FAIRVIEW RTL', 'GBASEUSFAIRVIEW', 'BASEUSFVW', 'TBASEUSFAIRVIEW', NULL, 'BASEUSFAIRVIEWRM', NULL, 'BASEUS FAIRVIEW', 'RETAIL', NULL, 'RETAIL', 1, NULL, NULL, 1, 0, 'INACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-12-02 06:03:50', NULL),
(5, 'BASEUS.SM.NORTH EDSA.RTL', 'BASEUS SM NORTH EDSA RTL', 'GBASEUSSMNORTH', 'GBASEUSSMNORTH', NULL, NULL, NULL, NULL, 'BASEUS SM NORTH', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'INACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-12-02 06:03:50', NULL),
(6, 'BASEUS.SM.SOUTHMALL.RTL', 'BASEUS SM SOUTHMALL RTL', 'GBASEUSSOUTHMALL', 'BASEUSSOUTHMALL', 'TBASEUSSOUTHMALL', NULL, 'BASEUSSOUTHRM', NULL, 'BASEUS SOUTHMALL', 'RETAIL', NULL, 'RETAIL', 1, NULL, NULL, 1, 0, 'INACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-12-02 06:03:50', NULL),
(7, 'BEYOND THE BOX.AYALA.FAIRVIEW TERRACES.FRA', 'BEYOND THE BOX FAIRVIEW TERRACES FRA', 'GBTBFAIRVIEW', 'BTBFAIRVIEW', 'TBTBFAIRVIEW', 'TBTBFAIRVIEW', 'BTBFAIRVIEWRM', 'RBTBFAIRVIEW', 'BTB FAIRVIEW', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 4, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-12-02 04:16:02', NULL),
(8, 'BEYOND THE BOX.AYALA.MARKET MARKET.FRA', 'BEYOND THE BOX AYALA MARKET MARKET FRA', 'GBTBMARKETMARKET', 'BTBMARKETMARKET', 'TBTBMARKETMARKET', 'TBTBMARKETMARKET', 'BTBMARKETMARKTRM', 'RBTBMARKETMARKET', 'BTB MARKET MARKET', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 6, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-12-02 04:20:28', NULL),
(9, 'BEYOND THE BOX.CENTURY CITY.MAKATI.RTL', 'BEYOND THE BOX CENTURY CITY MAKATI RTL', 'GNBTBCENTURY', 'BTBCENTURY', 'TBTBCENTURY', 'TBTBCENTURY', 'BTBCENTURYRM', 'RBTBCENTURY', 'BTB CENTURY', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:58', '2022-03-11 05:13:30', NULL),
(10, 'BEYOND THE BOX.CITY OF DREAMS.MANILA.RTL', 'BEYOND THE BOX CITY OF DREAMS MANILA RTL', 'GBTBCOD', 'BTBCOD', 'TBTBCOD', 'TBTBCITYOFDREAMS', 'BTBCODRM', 'RBTBCITYOFDREAMS', 'BTB CITY OF DREAMS', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-06-05 17:09:08', NULL),
(11, 'BEYOND THE BOX.GREENHILLS.VMALL.RTL', 'BEYOND THE BOX GREENHILLS VMALL RTL', 'GBTBVMALL', 'BTBVMALL', 'TBTBVMALL', 'TBTBVMALL', 'BTBVMALLRM', 'RBTBVMALL', 'BTB VMALL', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-06-05 17:10:10', NULL),
(12, 'BEYOND THE BOX.KCC.VERANZA.RTL', 'BEYOND THE BOX KCC VERANZA RTL', 'GBTBVERANZA', 'BTBVERANZA', 'TBTBVERANZA', 'TBTBVERANZA', 'BTBVERANZARM', 'RBTBVERANZA', 'BTB VERANZA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-06-05 17:14:06', NULL),
(13, 'BEYOND THE BOX.LIMKETKAI MALL.CDO.FRA', 'BEYOND THE BOX LIMKETKAI CDO FRA', 'BTBCDOG', 'BTBCDO', 'TBTBCDO', 'TBTBCDO', 'BTBCDORM', 'RBTBCDO', 'BTB CDO', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 11, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-12-02 05:20:11', NULL),
(14, 'BEYOND THE BOX.MEGAWORLD.FORBESTOWN.FRA', 'BEYOND THE BOX MEGAWORLD FORBESTOWN FRA', 'GBTBFORBESTOWN', 'BTBFORBESTOWN', 'TBTBFORBESTOWN', 'TBTBFORBESTOWN', 'BTBFORBESTOWNRM', 'RBTBFORBESTOWN', 'BTB FORBESTOWN', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 4, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-12-02 04:16:15', NULL),
(15, 'BEYOND THE BOX.MEGAWORLD.LUCKY CHINATOWN.FRA', 'BEYOND THE BOX MEGAWORLD LUCKY CHINATOWN FRA', 'GBTBLUCKYCHINA', 'BTBLUCKYCHINA', 'TBTBLUCKYCHINA', 'TBTBLUCKY', 'BTBLUCKYCHINARM', 'RBTBLUCKY', 'BTB LUCKY', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 4, 0, 'ACTIVE', 1, 73, '2020-11-12 19:28:58', '2024-01-01 17:02:20', NULL),
(16, 'BEYOND THE BOX.MEGAWORLD.NEWPORT.RTL', 'BEYOND THE BOX MEGAWORLD NEWPORT RTL', 'GBTBRESORTSWORLD', 'BTBRESORTSWORLD', 'TBTBRESORTSWORLD', 'TBTBNEWPORT', 'BTBRSORTSWORLDRM', 'RBTBNEWPORT', 'BTB NEWPORT', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-06-05 17:15:13', NULL),
(17, 'BEYOND THE BOX.MEGAWORLD.SOUTHWOODS.RTL', 'BEYOND THE BOX MEGAWORLD SOUTHWOODS RTL', 'GBTBSOUTHWOODS', 'BTBSOUTHWOODS', 'TBTBSOUTHWOODS', 'TBTBSOUTHWOODS', 'BTBSOUTHWOODSRM', 'RBTBSOUTHWOODS', 'BTB SOUTHWOODS', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-06-05 17:25:22', NULL),
(18, 'BEYOND THE BOX.MEGAWORLD.UPTOWN MALL.RTL', 'BEYOND THE BOX MEGAWORLD UPTOWN RTL', 'GBTBUPTOWN', 'BTBUPTOWN', 'TBTBUPTOWN', 'TBTBUPTOWN', 'BTBUPTOWNRM', 'RBTBUPTOWN', 'BTB UPTOWN', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-06-05 17:25:22', NULL),
(19, 'BEYOND THE BOX.MEGAWORLD.VENICE GRAND CANAL.RTL', 'BEYOND THE BOX VENICE GRAND CANAL RTL', 'GBTBPIAZZA', 'BTBPIAZZA', 'TBTBPIAZZA', 'TBTBPIAZZA', 'BTBPIAZZARM', 'RBTBPIAZZA', 'BTB PIAZZA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:58', '2021-06-09 02:21:42', NULL),
(20, 'BEYOND THE BOX.ONE ROCKWELL.MAKATI.RTL', 'BEYOND THE BOX ONE ROCKWELL MAKATI RTL', 'GBTBROCKWELL', 'GBTBROCKWELL', NULL, NULL, NULL, NULL, 'BTB ROCKWELL', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'INACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-12-02 06:36:07', NULL),
(21, 'BEYOND THE BOX.ROBINSONS.ERMITA.RTL', 'BEYOND THE BOX ROBINSONS ERMITA RTL', 'GBTBERMITA', 'BTBERMITA', 'TBTBERMITA', 'TBTBERMITA', 'BTBERMITARM', 'RBTBERMITA', 'BTB ERMITA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-06-05 17:25:22', NULL),
(22, 'BEYOND THE BOX.ROBINSONS.GALLERIA.RTL', 'BEYOND THE BOX ROBINSONS GALLERIA RTL', 'GBTBGALLERIA', 'BTBGALLERIA', 'TBTBGALLERIA', 'TBTBGALLERIA', 'BTBGALLERIARM', 'RBTBGALLERIA', 'BTB GALLERIA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-06-05 17:25:22', NULL),
(23, 'BEYOND THE BOX.SM.BAGUIO.RTL', 'BEYOND THE BOX SM BAGUIO RTL', 'GBTBBAGUIO', 'BTBBAGUIO', 'TBTBBAGUIO', 'TBTBBAGUIO', 'BTBBAGUIORM', 'RBTBBAGUIO', 'BTB BAGUIO', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-06-05 17:25:22', NULL),
(24, 'BEYOND THE BOX.THE PLAZA.GUAM.FRA', NULL, 'BTBGUAMPLAZA', NULL, NULL, NULL, NULL, NULL, 'BTB GUAM', 'FRANCHISE', NULL, 'FRANCHISE', 2, NULL, NULL, 2, 0, 'INACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-12-02 05:40:43', NULL),
(25, 'DIGITAL WALKER.AYALA.ABREEZA.RTL', 'DIGITAL WALKER AYALA ABREEZA RTL', 'GDWABREEZA', 'DWABREEZA', 'TDWABREEZA', 'TDWABREEZA', 'DWABREEZARM', 'RDWABREEZA', 'DW ABREEZA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-06-05 17:25:22', NULL),
(26, 'DIGITAL WALKER.AYALA.BAY AREA.RTL', 'DIGITAL WALKER AYALA BAY AREA RTL', 'GDWTHEBAY', 'DWTHEBAY', 'TDWTHEBAY', 'TDWTHEBAY', 'DWTHEBAYRM', 'RDWTHEBAY', 'DW THE BAY', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-06-05 17:25:22', NULL),
(27, 'DIGITAL WALKER.AYALA.CEBU.RTL', 'DIGITAL WALKER AYALA CEBU RTL', 'DWAYALACEBUG', 'DWAYALACEBU', 'TDWAYALACEBU', 'TDWAYALACEBU', 'DWALAYACEBURM', 'RDWAYALACEBU', 'DW AYALA CEBU', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-06-05 17:25:22', NULL),
(28, 'DIGITAL WALKER.AYALA.GLORIETTA 2.RTL', 'DIGITAL WALKER AYALA GLORIETTA 2 RTL', 'GDWGLORIETTA', 'DWGLORIETTA2', 'TDWGLORIETTA5', 'TDWGLORIETTA', 'DWGLORIETTARM', 'RDWGLORIETTA', 'DW GLORIETTA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-06-05 17:25:22', NULL),
(29, 'DIGITAL WALKER.AYALA.GREENBELT 5.FRA', 'DIGITAL WALKER AYALA GREENBELT 5 FRA', 'GDWGREENBELT5FRA', 'DWGREENBELT5FRA', 'TDWGREENBELT', 'TDWGREENBELT', 'DWGREENBELT5RM', 'RDWGREENBELT', 'DW GREENBELT FRA', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 6, 0, 'INACTIVE', 1, 1, '2020-11-12 19:28:59', '2023-07-04 17:36:32', NULL),
(30, 'DIGITAL WALKER.AYALA.ONE BONIFACIO.RTL', 'DIGITAL WALKER AYALA ONE BONIFACIO RTL', 'DWONEBONIG', 'DWONEBONI', 'DWONEBONIR', 'TDWONEBONIFACIO', 'DWONEBONIRM', 'RDWONEBONIFACIO', 'DW ONE BONIFACIO', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 73, '2020-11-12 19:28:59', '2023-11-24 01:32:39', NULL),
(31, 'DIGITAL WALKER.AYALA.THE 30TH.RTL', 'DIGITAL WALKER AYALA THE 30TH RTL', 'GDWTHE30TH', 'DWTHE30TH', 'TDWTHE30TH', 'TDWTHE30TH', 'DWTHE30THRM', 'RDWTHE30TH', 'DW THE 30TH', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-06-05 17:25:22', NULL),
(32, 'DIGITAL WALKER.AYALA.TRINOMA.RTL', 'DIGITAL WALKER AYALA TRINOMA RTL', 'GDWTRINOMA', 'DWTRINOMA', 'TDWTRINOMA', 'TDWTRINOMA', 'DWTRINOMARM', 'RDWTRINOMA', 'DW TRINOMA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-06-05 17:25:22', NULL),
(33, 'DIGITAL WALKER.AYALA.UPTC.FRA', 'DIGITAL WALKER AYALA UPTC FRA', 'GDWUPTOWN', 'DWUPTC', 'TDWUPTOWNCENTER', 'TDWUPTC', 'DWUPTOWNRM', 'RDWUPTC', 'DW UPTC', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 5, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-12-02 04:19:37', NULL),
(34, 'DIGITAL WALKER.AYALA.VERTIS NORTH.FRA', 'DIGITAL WALKER AYALA VERTIS NORTH FRA', 'GDWVERTIS', 'DWVERTISNORTH', 'TDWVERTISNORTH', 'TDWVERTIS', 'DWVERTIS', 'RDWVERTIS', 'DW VERTIS', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 5, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-12-02 04:19:33', NULL),
(35, 'DIGITAL WALKER.CAPITOL COMMONS.ESTANCIA.FRA', 'DIGITAL WALKER CAPITOL COMMONS ESTANCIA FRA', 'GDWESTANCIA', 'DWESTANCIA', 'TDWESTANCIA', 'TDWESTANCIA', 'DWESTANCIARM', 'RDWESTANCIA', 'DW ESTANCIA', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 5, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-12-02 04:19:41', NULL),
(36, 'DIGITAL WALKER.CC.ESTANCIA EXPANSION.FRA', 'DIGITAL WALKER CC ESTANCIA EXPANSION FRA', 'DWESTANCIAEG', 'DWESTANCIAEXP', 'DWESTANCIAEXT', 'TDWESTANCIAEXP', 'DWESTANCIAEXPR', 'RDWESTANCIAEXP', 'DW ESTANCIA EXP', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 5, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:59', '2022-08-22 22:06:53', NULL),
(37, 'DIGITAL WALKER.CENTRIO.CDO.RTL', 'DIGITAL WALKER CENTRIO CDO RTL', 'GDWCAGAYAN', 'DWCAGAYAN', 'TDWCAGAYAN', 'TDWCDO', 'DWCAGAYANRM', 'RDWCDO', 'DW CDO', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-06-05 17:25:22', NULL),
(38, 'DIGITAL WALKER.CENTURY CITY.MAKATI.RTL', 'DIGITAL WALKER CENTURY CITY MAKATI RTL', 'GDWCENTURY', 'DWCENTURY', 'TDWCENTURY', 'TDWCENTURY', 'DWCENTURYRM', 'RDWCENTURY', 'DW CENTURY', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:28:59', '2021-06-05 17:25:22', NULL),
(39, 'DIGITAL WALKER.FESTIVAL MALL.ALABANG.FRA', 'DIGITAL WALKER FESTIVAL MALL ALABANG FRA', 'DWFESTIVAL', 'GDWFESTIVAL', NULL, NULL, NULL, NULL, 'DW FESTIVAL MALL', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 9, 0, 'INACTIVE', 1, 1, '2020-11-12 19:29:00', '2021-12-02 06:41:47', NULL),
(40, 'DIGITAL WALKER.GREENHILLS.VMALL.RTL', 'DIGITAL WALKER GREENHILLS VMALL RTL', 'GDWVMALL', 'DWVMALL', 'TDWVMALL', 'TDWVMALL', 'DWVMALL', 'RDWVMALL', 'DW VMALL', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:00', '2021-06-05 17:25:22', NULL),
(41, 'DIGITAL WALKER.MEGAWORLD.EASTWOOD.RTL', 'DIGITAL WALKER MEGAWORLD EASTWOOD RTL', 'GDWEASTWOOD', 'DWEASTWOOD', 'TDWEASTWOOD', 'TDWEASTWOOD', 'DWEASTWOODRM', 'RDWEASTWOOD', 'DW EASTWOOD', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:00', '2021-06-05 17:25:22', NULL),
(42, 'DIGITAL WALKER.MEGAWRLD.FESTIVE WALK.RTL', 'DIGITAL WALKER MEGAWRLD FESTIVEWALK RTL', '678001', 'DWFESTIVEWALK', '678002', 'TDWFESTIVEWALK', '678003', 'RDWFESTIVEWALK', 'DW FESTIVE WALK', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:00', '2021-06-23 03:16:04', NULL),
(43, 'DIGITAL WALKER.OKADA.MANILA.RTL', 'DIGITAL WALKER OKADA MANILA RTL', 'DWOKADAG', 'DWOKADA', 'TDWOKADA', 'TDWOKADA', 'DWOKADARM', 'RDWOKADA', 'DW OKADA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:00', '2021-06-05 17:25:22', NULL),
(44, 'DIGITAL WALKER.ROBINSONS.ERMITA.RTL', 'DIGITAL WALKER ROBINSONS ERMITA RTL', 'GDWERMITA', 'DWERMITA', 'TDWERMITA', 'TDWERMITA', 'DWERMITARM', 'RDWERMITA', 'DW ERMITA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:00', '2021-06-05 17:25:22', NULL),
(45, 'DIGITAL WALKER.ROBINSONS.MAGNOLIA.FRA', 'DIGITAL WALKER ROBINSONS MAGNOLIA FRA', 'GDWMAGNOLIA', 'DWMAGNOLIA', 'TWDMAGNOLIA', 'TDWMAGNOLIA', 'DWMAGNOLIARM', 'RDWMAGNOLIA', 'DW MAGNOLIA', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 8, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:00', '2021-12-02 05:18:52', NULL),
(46, 'DIGITAL WALKER.ROBINSONS.PIONEER.RTL', 'DIGITAL WALKER ROBINSONS PIONEER RTL', 'GDWPIONEER', 'DWPIONEER', 'TDWPIONEER', 'TDWPIONEER', 'DWPIONEERRM', 'RDWPIONEER', 'DW PIONEER', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:00', '2021-06-05 17:25:22', NULL),
(47, 'DIGITAL WALKER.ROCKWELL.POWERPLANT.RTL', 'DIGITAL WALKER ROCKWELL POWERPLANT RTL', 'GDWROCKWELL', 'DWROCKWELL', 'TDWROCKWELL', 'TDWROCKWELL', 'DWROCKWELLRM', 'RDWROCKWELL', 'DW ROCKWELL', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:00', '2023-10-10 02:23:31', NULL),
(48, 'DIGITAL WALKER.SHANGRI-LA.EDSA.RTL', 'DIGITAL WALKER SHANGRI-LA EDSA RTL', 'GDWSHANGRILA', 'DWSHANGRILA', 'TDWSHANGRILA', 'TDWSHANGRILA', 'DWSHANGRILARM', 'RDWSHANGRILA', 'DW SHANGRILA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:00', '2021-06-05 17:25:23', NULL),
(49, 'DIGITAL WALKER.SM.AURA.RTL', 'DIGITAL WALKER SM AURA RTL', 'GDWSMAURA', 'DWSMAURA', 'TDWSMAURA', 'TDWSMAURA', 'DWSMAURARM', 'RDWSMAURA', 'DW SM AURA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:00', '2021-06-05 17:25:23', NULL),
(50, 'DIGITAL WALKER.SM.BAGUIO.RTL', 'DIGITAL WALKER SM BAGUIO RTL', 'GDWBAGUIO', 'DWBAGUIO', 'TDWBAGUIO', 'TDWBAGUIO', 'DWBAGUIORM', 'RDWBAGUIO', 'DW BAGUIO', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:00', '2021-06-05 17:25:23', NULL),
(51, 'DIGITAL WALKER.SM.CEBU.RTL', 'DIGITAL WALKER SM CEBU RTL', 'DWSMCEBUG', 'DWSMCEBU', 'TDWSMCEBU', 'TDWSMCEBU', 'DWSMCEBURM', 'RDWSMCEBU', 'DW SM CEBU', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:00', '2021-06-05 17:25:23', NULL),
(52, 'DIGITAL WALKER.SM.MALL OF ASIA.RTL', 'DIGITAL WALKER SM MALL OF ASIA RTL', 'GDWMOA', 'DWMOA', 'TDWMOA', 'TDWMOA', 'DWMOARM', 'RDWMOA', 'DW MOA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:01', '2021-06-05 17:25:23', NULL),
(53, 'DIGITAL WALKER.SM.NORTH EDSA.RTL', 'DIGITAL WALKER SM NORTH EDSA RTL', 'DWSMNORTHG', 'DWSMNORTHEDSA', 'TDWSMNORTH', 'TDWNORTHEDSA', 'DWSMNORTHRM', 'RDWNORTHEDSA', 'DW NORTH EDSA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:01', '2021-06-05 17:25:23', NULL),
(54, 'DIGITAL WALKER.SM.SOUTHMALL.RTL', 'DIGITAL WALKER SM SOUTHMALL RTL', '687001', 'DWSOUTHMALL', '687002', 'TDWSOUTHMALL', '687003', 'RDWSOUTHMALL', 'DW SOUTHMALL', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:01', '2021-06-05 17:25:23', NULL),
(55, 'DIGITAL WALKER.SUPERMALLS.CONRAD HOTEL.RTL', 'DIGITAL WALKER CONRAD HOTEL RTL', 'GDWCONRAD', 'DWCONRAD', 'TDWCONRAD', 'TDWCONRAD', 'DWCONRADRM', 'RDWCONRAD', 'DW CONRAD', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:01', '2021-06-08 23:03:13', NULL),
(56, 'DIGITAL WALKER.SUPERMALLS.THE PODIUM.RTL', 'DIGITAL WALKER SUPERMALLS THE PODIUM RTL', 'GDWPODIUM', 'DWPODIUM', 'TDWPODIUM', 'TDWPODIUM', 'DWPODIUMRM', 'RDWPODIUM', 'DW PODIUM', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:01', '2021-06-05 17:25:23', NULL),
(57, 'OMG.GREENHILLS.VMALL.RTL', 'OMG GREENHILLS VMALL RTL', 'OMGVMALLG', 'OMGVMALLG', NULL, NULL, NULL, NULL, 'OMG VMALL', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'INACTIVE', 1, 1, '2020-11-12 19:29:01', '2021-12-02 06:12:29', NULL),
(58, 'OMG.MEGAWORLD.FESTIVE WALK.RTL', 'OMG MEGAWORLD FESTIVE WALK RTL', 'GOMGFESTIVE', 'OMGFESTIVE', 'OMGFESTIVER', NULL, 'OMGFESTIVERM', NULL, 'OMG FESTIVE WALK', 'RETAIL', NULL, 'RETAIL', 1, NULL, NULL, 1, 0, 'INACTIVE', 1, 1, '2020-11-12 19:29:01', '2021-12-02 06:12:29', NULL),
(59, 'OMG.ROBINSONS.ERMITA.RTL', 'OMG OMG ROBINSONS ERMITA RTL', 'GOMGERMITA', 'OMGERMITA', 'TOMGERMITA', 'TOMGERMITA', 'OMGERMITARM', 'ROMGERMITA', 'OMG ERMITA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:01', '2021-07-08 22:17:13', NULL),
(60, 'OMG.SM.CDO.RTL', 'OMG SM CDO RTL', 'OMGCDO', 'OMGCDO', 'TOMGCDO', NULL, 'OMGCDORM', NULL, 'OMG CDO', 'RETAIL', NULL, 'RETAIL', 1, NULL, NULL, 1, 0, 'INACTIVE', 1, 1, '2020-11-12 19:29:01', '2021-12-02 06:12:29', NULL),
(61, 'OUTERSPACE.NAIA.TERMINAL 3.RTL', 'OUTERSPACE NAIA TERMINAL 3 RTL', 'GOSNAIA', 'OUTERSPACENAIAT3', 'TOSNAIA', NULL, 'OSNAIARM', NULL, 'OUTERSPACE NAIA TERMINAL', 'RETAIL', NULL, 'RETAIL', 1, NULL, NULL, 1, 0, 'INACTIVE', 1, 1, '2020-11-12 19:29:01', '2021-12-02 06:35:57', NULL),
(62, 'SERVICE CENTER.AYALA.BONIFACIO HIGH STREET.RTL', 'SERVICE CENTER BONIFACIO HIGH STREET RTL', 'BTBSCBGCG', 'BTBSERVICEBGC', 'BTBSCBGCR', 'TSCBGC', 'RSCBGC', 'RSCBGC', 'SC BGC', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:01', '2021-06-09 02:25:14', NULL),
(63, 'SERVICE CENTER.GREENHILLS.VMALL.RTL', 'SERVICE CENTER GREENHILLS VMALL RTL', 'BTBSCVMALLG', 'BTBSCVMALL', 'BTBSCVMALLR', 'TSCVMALL', 'RSCVMALL', 'RSCVMALL', 'SC VMALL', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2020-11-12 19:29:01', '2021-06-05 17:25:23', NULL),
(64, 'DIGITS WAREHOUSE', 'DIGITS WAREHOUSE', 'DIGITSWAREHOUSE', 'DIGITSWAREHOUSE', 'DIGITSWAREHOUSE', NULL, 'DIGITSWAREHOUSE', NULL, 'DIGITS WAREHOUSE', 'DIGITS', NULL, 'DIGITS', NULL, NULL, NULL, NULL, 0, 'ACTIVE', NULL, NULL, '2020-12-28 03:32:43', NULL, NULL),
(65, 'DIGITS RMA', 'DIGITS RMA', 'DIGITSRMA', 'DIGITSRMA', 'DIGITSRMA', NULL, 'DIGITSRMA', NULL, 'DIGITS RMA', 'RMA', NULL, 'RMA', NULL, NULL, NULL, NULL, 0, 'ACTIVE', NULL, NULL, '2020-12-28 03:33:09', NULL, NULL),
(67, 'DIGITAL WALKER.VISTA MALL.TAGUIG.RTL', 'DIGITAL WALKER VISTA MALL TAGUIG RTL', '698001', 'DWVISTAMALLTAG', '698002', 'TDWVISTATAGUIG', '698003', 'RDWVISTATAGUIG', 'DW VISTA TAGUIG', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2021-03-09 17:38:20', '2021-06-05 17:25:23', NULL),
(68, 'DIGITAL WALKER.LAZADA.FBV.ONL', 'LAZADA DIGITAL WALKER FBV', 'GLAZADADWFBV', 'LAZADADWFBV', NULL, NULL, NULL, NULL, 'LAZADA DW FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2021-03-09 21:14:01', '2021-06-05 17:50:51', NULL),
(69, 'FITBIT.LAZADA.FBV.ONL', 'LAZADA FITBIT FBV', 'GLAZADAFITBITFBV', 'LAZADAFITBITFBV', NULL, NULL, NULL, NULL, 'LAZADA FITBIT FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2021-03-09 21:14:01', '2021-06-05 17:54:50', NULL),
(70, 'ONEPLUS.LAZADA.FBV.ONL', 'LAZADA ONEPLUS FBV', 'GLAZONEPLUSFBV', 'LAZADAONEPLUSFBV', NULL, NULL, NULL, NULL, 'LAZADA ONEPLUS FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2021-03-09 21:14:01', '2021-06-05 18:00:23', NULL),
(71, 'UAG.LAZADA.FBV.ONL', 'LAZADA UAG FBV', 'GLAZADAUAGFBV', 'LAZADAUAGFBV', NULL, NULL, NULL, NULL, 'LAZADA UAG FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2021-03-09 21:14:01', '2021-06-05 18:08:07', NULL),
(72, 'DIGITAL WALKER.SHOPEE.FBD.ONL', 'DIGITAL WALKER SHOPEE FBD', 'GSHOPEEDWFBD', 'DIGITS', 'TSHOPEEDWFBD', 'TSHOPEEDWFBD', 'RSHOPEEDWFBD', 'RSHOPEEDWFBD', 'SHOPEE DW FBD', 'SHOPEE', 'SHOPEE FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 1, '2021-03-09 21:14:01', '2021-10-19 18:44:18', NULL),
(73, 'ONEPLUS.SHOPEE.FBV.ONL', 'SHOPEE ONEPLUS FBV', 'SHOPEEFBV', 'SHOPEEFBV', NULL, NULL, NULL, NULL, 'SHOPEE ONEPLUS FBV', 'SHOPEE', NULL, 'ECOM', 4, NULL, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:01', '2021-10-19 08:48:47', NULL),
(74, 'BASEUS.LAZADA.FBV.ONL', 'LAZADA BASEUS FBV', 'LAZADAFBV', 'LAZADAFBV', NULL, NULL, NULL, NULL, 'LAZADA BASEUS FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 09:57:20', NULL),
(75, 'FITBIT.SHOPEE.FBV.ONL', 'SHOPEE FITBIT FBV', 'SHOPEEFBV', 'SHOPEEFBV', NULL, NULL, NULL, NULL, 'SHOPEE FITBIT FBV', 'SHOPEE', NULL, 'ECOM', 4, NULL, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 08:48:47', NULL),
(76, 'BASEUS.SHOPEE.FBV.ONL', 'SHOPEE BASEUS FBV', 'SHOPEEFBV', 'SHOPEEFBV', NULL, NULL, NULL, NULL, 'SHOPEE BASEUS FBV', 'SHOPEE', NULL, 'ECOM', 4, NULL, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 08:48:47', NULL),
(77, 'JOYROOM.LAZADA.FBV.ONL', 'LAZADA JOYROOM FBV', 'LAZADAFBV', 'LAZADAFBV', NULL, NULL, NULL, NULL, 'LAZADA JOYROOM FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 09:56:55', NULL),
(78, 'JOYROOM.SHOPEE.FBV.ONL', 'JOYROOM SHOPEE FBV', 'SHOPEEFBV', 'SHOPEEFBV', NULL, NULL, NULL, NULL, 'JOYROOM SHOPEE FBV', 'SHOPEE', NULL, 'ECOM', 4, NULL, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 08:48:47', NULL),
(79, 'FITBIT.LAZADA.FBD.ONL', 'FITBIT LAZADA FBD', 'GLAZADAFITBITFBD', 'DIGITS', 'TLAZADAFITBITFBD', 'TLAZADAFITBITFBD', 'RLAZADAFITBITFBD', 'RLAZADAFITBITFBD', 'LAZADA FITBIT FBD', 'LAZADA', 'LAZADA FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 18:38:10', NULL),
(80, 'ONEPLUS.LAZADA.FBD.ONL', 'ONEPLUS LAZADA FBD', 'GLAZONEPLUSFBD', 'DIGITS', 'TLAZONEPLUSFBD', 'TLAZONEPLUSFBD', 'RLAZONEPLUSFBD', 'RLAZONEPLUSFBD', 'LAZADA ONEPLUS FBD', 'LAZADA', 'LAZADA FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 18:40:34', NULL),
(81, 'BASEUS.LAZADA.FBD.ONL', 'BASEUS LAZADA FBD', 'LAZADAFBD', 'LAZADAFBD', NULL, NULL, NULL, NULL, 'BASEUS LAZADA FBD', 'LAZADA', 'LAZADA FBD', 'ECOM', 4, 7, NULL, 3, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-06-05 18:22:41', NULL),
(82, 'FITBIT.SHOPEE.FBD.ONL', 'FITBIT SHOPEE FBD', 'GSHOPEEFITBITFBD', 'DIGITS', 'TSHOPEEFITBITFBD', 'TSHOPEEFITBITFBD', 'RSHOPEEFITBITFBD', 'RSHOPEEFITBITFBD', 'SHOPEE FITBIT FBD', 'SHOPEE', 'SHOPEE FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 18:44:41', NULL),
(83, 'ONEPLUS.SHOPEE.FBD.ONL', 'ONEPLUS SHOPEE FBD', 'GSHPONEPLUSFBD', 'DIGITS', 'TSHPONEPLUSFBD', 'TSHPONEPLUSFBD', 'RSHPONEPLUSFBD', 'RSHPONEPLUSFBD', 'SHOPEE ONEPLUS FBD', 'SHOPEE', 'SHOPEE FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 18:45:32', NULL),
(84, 'BASEUS.SHOPEE.FBD.ONL', 'BASEUS SHOPEE FBD', 'SHOPEEFBD', 'SHOPEEFBD', NULL, NULL, NULL, NULL, 'BASEUS SHOPEE FBD', 'SHOPEE', 'SHOPEE FBD', 'ECOM', 4, 7, NULL, 3, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-06-05 18:22:41', NULL),
(85, 'JOYROOM.SHOPEE.FBD.ONL', 'JOYROOM SHOPEE FBD', 'SHOPEEFBD', 'SHOPEEFBD', NULL, NULL, NULL, NULL, 'JOYROOM SHOPEE FBD', 'SHOPEE', 'SHOPEE FBD', 'ECOM', 4, 7, NULL, 3, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-06-05 18:20:04', NULL),
(86, 'JOYROOM.LAZADA.FBD.ONL', 'JOYROOM LAZADA FBD', 'LAZADAFBD', 'LAZADAFBD', NULL, NULL, NULL, NULL, 'JOYROOM LAZADA FBD', 'LAZADA', 'LAZADA FBD', 'ECOM', 4, 7, NULL, 3, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-06-05 18:19:55', NULL),
(87, 'AFTERSHOKZ.LAZADA.CLL.ONL', 'CLOUD LOGIC NEW MANILA FBV', 'CLOUDLOGIC', 'CLOUDLOGIC', NULL, NULL, NULL, NULL, 'AFTERSHOKZ LAZADA CLL', 'LAZADA', NULL, 'ECOM', 4, NULL, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 08:48:47', NULL),
(88, 'DIGITAL WALKER.LAZADA.CLL.ONL', 'CLOUD LOGIC NEW MANILA FBV', 'CLOUDLOGIC', 'CLOUDLOGIC', NULL, NULL, NULL, NULL, 'DIGITAL WALKER LAZADA CLL', 'LAZADA', NULL, 'ECOM', 4, NULL, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 08:48:47', NULL),
(89, 'MOMAX.LAZADA.CLL.ONL', 'CLOUD LOGIC NEW MANILA FBV', 'CLOUDLOGIC', 'CLOUDLOGIC', NULL, NULL, NULL, NULL, 'MOMAX LAZADA CLL', 'LAZADA', NULL, 'ECOM', 4, NULL, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 08:48:47', NULL),
(90, 'AFTERSHOKZ.SHOPEE.CLL.ONL', 'CLOUD LOGIC NEW MANILA FBV', 'CLOUDLOGIC', 'CLOUDLOGIC', NULL, NULL, NULL, NULL, 'AFTERSHOKZ SHOPEE CLL', 'SHOPEE', NULL, 'ECOM', 4, NULL, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 08:48:47', NULL),
(91, 'DIGITAL WALKER.SHOPEE.CLL.ONL', 'CLOUD LOGIC NEW MANILA FBV', 'CLOUDLOGIC', 'CLOUDLOGIC', NULL, NULL, NULL, NULL, 'DIGITAL WALKER SHOPEE CLL', 'SHOPEE', NULL, 'ECOM', 4, NULL, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 08:48:47', NULL),
(92, 'MOMAX.SHOPEE.CLL.ONL', 'CLOUD LOGIC NEW MANILA FBV', 'CLOUDLOGIC', 'CLOUDLOGIC', NULL, NULL, NULL, NULL, 'MOMAX SHOPEE CLL', 'SHOPEE', NULL, 'ECOM', 4, NULL, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 08:48:47', NULL),
(93, '1MORE.LAZADA.FBV.ONL', 'LAZADA 1MORE FBV', 'LAZADAFBV', 'LAZADAFBV', NULL, NULL, NULL, NULL, 'LAZADA 1MORE FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:02', '2021-10-19 09:56:10', NULL),
(94, '1MORE.SHOPEE.FBV.ONL', '1MORE SHOPEE FBV', 'SHOPEEFBV', 'SHOPEEFBV', NULL, NULL, NULL, NULL, '1MORE SHOPEE FBV', 'SHOPEE', NULL, 'ECOM', 4, NULL, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:03', '2021-10-19 08:48:47', NULL),
(95, '1MORE.LAZADA.FBD.ONL', '1MORE LAZADA FBD', 'LAZADAFBD', 'LAZADAFBD', NULL, NULL, NULL, NULL, '1MORE LAZADA FBD', 'LAZADA', 'LAZADA FBD', 'ECOM', 4, 7, NULL, 3, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:03', '2021-06-05 18:19:27', NULL),
(96, '1MORE.SHOPEE.FBD.ONL', '1MORE SHOPEE FBD', 'SHOPEEFBD', 'SHOPEEFBD', NULL, NULL, NULL, NULL, '1MORE SHOPEE FBD', 'SHOPEE', 'SHOPEE FBD', 'ECOM', 4, 7, NULL, 3, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:03', '2021-06-05 18:19:27', NULL),
(97, 'ZENDURE.LAZADA.FBV.ONL', 'LAZADA ZENDURE FBV', 'LAZADAFBV', 'LAZADAFBV', NULL, NULL, NULL, NULL, 'LAZADA ZENDURE FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:03', '2021-10-19 09:55:53', NULL),
(98, 'ZENDURE.SHOPEE.FBV.ONL', 'ZENDURE SHOPEE FBV', 'SHOPEEFBV', 'SHOPEEFBV', NULL, NULL, NULL, NULL, 'ZENDURE SHOPEE FBV', 'SHOPEE', NULL, 'ECOM', 4, NULL, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:03', '2021-10-19 08:48:47', NULL),
(99, 'ZENDURE.LAZADA.FBD.ONL', 'ZENDURE LAZADA FBD', 'LAZADAFBD', 'LAZADAFBD', NULL, NULL, NULL, NULL, 'ZENDURE LAZADA FBD', 'LAZADA', 'LAZADA FBD', 'ECOM', 4, 7, NULL, 3, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:03', '2021-06-05 18:20:18', NULL),
(100, 'ZENDURE.SHOPEE.FBD.ONL', 'ZENDURE SHOPEE FBD', 'SHOPEEFBD', 'SHOPEEFBD', NULL, NULL, NULL, NULL, 'ZENDURE SHOPEE FBD', 'SHOPEE', 'SHOPEE FBD', 'ECOM', 4, 7, NULL, 3, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:03', '2021-06-05 18:20:18', NULL),
(101, 'HOME OFFICE.DIGITS.FBD.ONL', 'HOME OFFICE DIGITS FBD', 'GHOMEOFFICEFBD', 'ZERO INVENTORY', NULL, NULL, NULL, NULL, 'HOMEOFFICE FBD', NULL, 'HMEOFC FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 1, '2021-03-09 21:14:03', '2021-10-19 08:28:53', NULL),
(102, 'BEYOND THE BOX.LAZADA.FBV.ONL', 'LAZADA BTB FBV', 'GLAZADABTBFBV', 'LAZADABTBFBV', NULL, NULL, NULL, NULL, 'LAZADA BTB FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2021-03-09 21:14:03', '2021-10-19 09:49:21', NULL),
(103, 'ECQDIGITS.ONL', 'ECQ DIGITS', NULL, NULL, NULL, NULL, NULL, NULL, 'ECQ DIGITS', NULL, NULL, 'ECOM', 4, NULL, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:03', '2021-10-19 08:48:47', NULL),
(104, 'ECQRETAIL.ONL', 'ECQ RETAIL', NULL, NULL, NULL, NULL, NULL, NULL, 'ECQ RETAIL', NULL, NULL, 'ECOM', 4, NULL, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:03', '2021-10-19 08:48:47', NULL),
(105, 'MARSHALL.LAZADA.FBV.ONL', 'LAZADA MARSHALL FBV', 'GLAZMARSHALLFBV', 'LAZMARSHALLFBV', NULL, NULL, NULL, NULL, 'LAZADA MARSHALL FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2021-03-09 21:14:03', '2021-06-05 17:57:13', NULL),
(106, 'THE GROVE HOWARD.ONL', 'THE GROVE HOWARD', 'THEGROVEHOWARD', 'THEGROVEHOWARD', NULL, NULL, NULL, NULL, 'THE GROVE HOWARD', NULL, NULL, 'ECOM', 4, NULL, NULL, NULL, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:03', '2021-10-19 08:48:47', NULL),
(107, 'MARSHALL.LAZADA.FBD.ONL', 'MARSHALL LAZADA FBD', 'GLAZMARSHALLFBD', 'DIGITS', 'TLAZMARSHALLFBD', 'TLAZMARSHALLFBD', 'RLAZMARSHALLFBD', 'RLAZMARSHALLFBD', 'LAZADA MARSHALL FBD', 'LAZADA', 'LAZADA FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 1, '2021-03-09 21:14:03', '2021-10-19 18:40:09', NULL),
(108, 'UAG.LAZADA.FBD.ONL', 'UAG LAZADA FBD', 'GLAZADAUAGFBD', 'DIGITS', 'TLAZADAUAGFBD', 'TLAZADAUAGFBD', 'RLAZADAUAGFBD', 'RLAZADAUAGFBD', 'LAZADA UAG FBD', 'LAZADA', 'LAZADA FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 1, '2021-03-09 21:14:03', '2021-10-19 18:38:35', NULL),
(109, 'STORK PH.FBD.ONL', 'STORK PH FBD', 'STORKPHFBDONL', 'STORKPHFBDONL', NULL, NULL, NULL, NULL, 'STORK PH FBD', NULL, 'DIGITS FBD', 'ECOM', 4, 7, NULL, 3, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:03', '2021-03-16 22:47:34', NULL),
(110, 'MARSHALL.SHOPEE.FBD.ONL', 'MARSHALL SHOPEE FBD', 'GSHPMARSHALLFBD', 'DIGITS', 'TSHPMARSHALLFBD', 'TSHPMARSHALLFBD', 'RSHPMARSHALLFBD', 'RSHPMARSHALLFBD', 'SHOPEE MARSHALL FBD', 'SHOPEE', 'SHOPEE FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 1, '2021-03-09 21:14:04', '2021-10-19 18:45:01', NULL),
(111, 'BEYOND THE BOX.LAZADA.FBD.ONL', 'BEYOND THE BOX LAZADA FBD', 'GLAZADABTBFBD', 'DIGITS', 'TLAZADABTBFBD', 'TLAZADABTBFBD', 'RLAZADABTBFBD', 'RLAZADABTBFBD', 'LAZADA BTB FBD', 'LAZADA', 'LAZADA FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 1, '2021-03-09 21:14:04', '2021-10-19 18:37:22', NULL),
(112, 'BEYOND THE BOX.DIGITS.FBD.ONL', 'BEYOND THE BOX DIGITS FBD', 'GECOMBTBFBD', 'DIGITS', 'TECOMBTBFBD', 'TECOMBTBFBD', 'RECOMBTBFBD', 'RECOMBTBFBD', 'ECOM BTB FBD', NULL, 'WEBBTB FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 1, '2021-03-09 21:14:04', '2021-10-21 23:42:24', NULL),
(113, 'AFTERSHOKZ.SHOPEE.FBD.ONL', 'AFTERSHOKZ SHOPEE FBD', 'SHOPEEFBD', 'SHOPEEFBD', NULL, NULL, NULL, NULL, 'AFTERSHOKZ SHOPEE FBD', 'SHOPEE', 'SHOPEE FBD', 'ECOM', 4, 7, NULL, 3, 0, 'INACTIVE', 1, 1, '2021-03-09 21:14:04', '2021-06-05 18:21:48', NULL),
(114, 'CLEARANCE.ROCKWELL.SANTOLAN TOWN PLAZA.SLE', 'CLEARANCE SANTOLAN TOWN PLAZA SLE', 'DWSANTOLANESALE', 'DWSANTOLANESALE', NULL, NULL, NULL, NULL, 'DW SANTOLAN SALE', 'CLEARANCE', NULL, 'DIGITS', 5, 1, NULL, NULL, 0, 'ACTIVE', NULL, NULL, '2021-03-14 22:28:49', '2021-03-15 23:09:08', NULL),
(115, 'ABENSON.DEPOT.PASIG.DLR', 'ABENSON DEPOT PASIG', 'GABENSONDEPOTPASIG', 'ABENSONDEPOTPASIG', NULL, NULL, NULL, NULL, 'ABENSON DEPOT PASIG', 'DISTRI', NULL, 'DISTRI', 10, 8, NULL, NULL, 0, 'ACTIVE', NULL, 1, '2021-03-14 22:29:51', '2023-06-20 19:49:00', NULL),
(116, 'DW MACHINE.ROCKWELL.POWERPLANT.RTL', 'DW MACHINES ROCKWELL POWERPLANT RTL', 'GDWMACHINEROCK', 'DWMACHINEROCKWEL', 'TRNSTDWMACHINERO', 'TDWMACHROCKWELL', 'RMADWMACHINEROCK', 'RDWMACHROCKWELL', 'DW MACH ROCKWELL', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2021-06-05 17:25:12', '2021-06-10 02:16:39', NULL),
(117, 'DIGITAL WALKER MACHINE.TRINOMA.RTL', 'DW MACHINES TRINOMA RTL', 'DWMCHNETRINOMAGD', 'DWMCHNTRINOMA', 'DWMHNETRINOMATR', 'TDWMACHTRINOMA', 'RMADWMCHNTRINOMA', 'RDWMACHTRINOMA', 'DW MACH TRINOMA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2021-06-05 17:25:12', '2021-06-10 02:16:19', NULL),
(118, 'DIGITAL WALKER.SM.FAIRVIEW.FRA', 'DIGITAL WALKER SM FAIRVIEW FRA', 'DWSMFAIRVIEWG', 'DWSMFAIRVIEW', 'DWSMFAIRVIEWTR', 'TDWFAIRVIEW', 'DWSMFAIRVIEWRMA', 'RDWFAIRVIEW', 'DW FAIRVIEW', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 4, 0, 'ACTIVE', 1, NULL, '2021-06-05 17:27:43', '2021-12-02 04:16:11', NULL),
(119, 'DIGITAL WALKER.LAZADA.FBD.ONL', 'DIGITAL WALKER LAZADA FBD', 'GLAZADADWFBD', 'DIGITS', 'TLAZADADWFBD', 'TLAZADADWFBD', 'RLAZADADWFBD', 'RLAZADADWFBD', 'LAZADA DW FBD', 'LAZADA', 'LAZADA FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 1, '2021-06-05 18:13:19', '2021-10-19 18:37:46', NULL),
(120, 'DIGITAL WALKER.DIGITS.FBD.ONL', 'WEBSITE DW FBD', 'GECOMDWFBD', 'DIGITS', 'TECOMDWFBD', 'TECOMDWFBD', 'RECOMDWFBD', 'RECOMDWFBD', 'ECOM DW FBD', NULL, 'WEBDW FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 1, '2021-06-05 18:13:19', '2021-10-28 18:19:13', NULL),
(121, 'BEYOND THE BOX.SHOPEE.FBD.ONL', 'SHOPEE BTB FBD', 'GSHOPEEBTBFBD', 'DIGITS', 'TSHOPEEBTBFBD', 'TSHOPEEBTBFBD', 'RSHOPEEBTBFBD', 'RSHOPEEBTBFBD', 'SHOPEE BTB FBD', 'SHOPEE', 'SHOPEE FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 1, '2021-06-05 18:13:19', '2021-10-19 18:43:51', NULL),
(122, 'BEYOND THE BOX.SHOPEE.FBV.ONL', 'SHOPEE BTB FBV', 'GSHOPEEBTBFBV', 'SHOPEEBTBFBV', NULL, NULL, NULL, NULL, 'SHOPEE BTB FBV', 'SHOPEE', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'ACTIVE', 1, 1, '2021-06-05 18:13:19', '2021-10-19 09:27:47', NULL),
(123, 'AFTERSHOKZ.LAZADA.FBD.ONL', 'AFTERSHOKZ LAZADA FBD', 'GLAZAFTFBD', 'DIGITS', 'TLAZAFTFBD', 'TLAZAFTFBD', 'RLAZAFTFBD', 'RLAZAFTFBD', 'LAZADA AFTERSHOKZ FBD', 'LAZADA', 'LAZADA FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 1, '2021-06-05 18:13:19', '2022-02-10 22:34:35', NULL),
(124, 'AFTERSHOKZ.LAZADA.FBV.ONL', 'LAZADA AFTERSHOKZ FBV', 'GLAZAFTFBV', 'LAZAFTFBV', NULL, NULL, NULL, NULL, 'LAZADA AFTERSHOKZ FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'ACTIVE', 1, 1, '2021-06-05 18:13:19', '2021-06-05 18:14:48', NULL),
(125, 'DIGITAL WALKER.SM.MARILAO.RTL', 'DIGITAL WALKER SM MARILAO RTL', 'GDWSMMARILAO', 'DWSMMARILAO', 'TDWSMMARILAO', 'TDWSMMARILAO', 'RDWSMMARILAO', 'RDWSMMARILAO', 'DW SM MARILAO', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'INACTIVE', NULL, 1, '2021-07-07 01:03:55', '2023-03-28 06:00:42', NULL),
(126, 'DIGITAL WALKER.MEGAWORLD.UPTOWN MALL.RTL', 'DIGITAL WALKER MEGAWORLD UPTOWN MALL RTL', 'GDWUPTOWNMALL', 'DWUPTOWNMALL', 'TDWUPTOWNMALL', 'TDWUPTOWNMALL', 'RDWUPTOWNMALL', 'RDWUPTOWNMALL', 'DW UPTOWN MALL', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', NULL, NULL, '2021-09-23 21:17:10', '2021-09-23 21:41:33', NULL),
(127, 'DIGITAL WALKER.THE OUTLETS.LIPA.RTL', 'DIGITAL WALKER THE OUTLETS LIPA RTL', 'GDWLIPA', 'DWLIPA', 'TDWLIPA', 'TDWLIPA', 'RDWLIPA', 'RDWLIPA', 'DW LIPA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', NULL, NULL, '2021-09-23 21:18:45', '2021-09-23 21:41:13', NULL),
(128, 'DIGITAL WALKER.SM.SANTA MESA.RTL', 'DIGITAL WALKER SM SANTA MESA RTL', 'GDWSMSANTAMESA', 'DWSMSANTAMESA', 'TDWSMSANTAMESA', 'TDWSMSANTAMESA', 'RDWSMSANTAMESA', 'RDWSMSANTAMESA', 'DW SM SANTA MESA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', NULL, NULL, '2021-09-27 19:23:56', NULL, NULL),
(129, 'DIGITAL WALKER.SM.GRAND CENTRAL.RTL', 'DIGITAL WALKER SM GRAND CENTRAL RTL', 'GDWCENTRAL', 'DWCENTRAL', 'TDWCENTRAL', 'TDWCENTRAL', 'RDWCENTRAL', 'RDWCENTRAL', 'DW GRAND CENTRAL', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', NULL, NULL, '2021-10-03 18:17:25', '2021-11-25 00:22:04', NULL),
(130, 'DIGITAL WALKER.AYALA.HIGH STREET.FRA', 'DIGITAL WALKER AYALA HIGH STREET FRA', 'GDWHIGHSTREETFRA', 'DWHIGHSTREETFRA', 'TDWHIGHSTREET', 'TDWHIGHSTREET', 'RDWHIGHSTREET', 'RDWHIGHSTREET', 'DW HIGH STREET FRA', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 6, 0, 'INACTIVE', NULL, 1, '2021-10-12 17:26:30', '2023-07-04 17:37:22', NULL),
(131, 'DIGITAL WALKER.ROBINSONS.GALLERIA.RTL', 'DIGITAL WALKER ROBINSONS GALLERIA RTL', 'GDWORTIGAS', 'DWORTIGAS', 'TDWORTIGAS', 'TDWORTIGAS', 'RDWORTIGAS', 'RDWORTIGAS', 'DW GALLERIA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', NULL, NULL, '2021-10-17 19:48:56', '2022-01-09 23:15:41', NULL),
(132, 'BEYOND THE BOX.VISTA MALL.NOMO.RTL', 'BEYOND THE BOX VISTA MALL NOMO RTL', 'GBTBNOMO', 'BTBNOMO', 'TBTBNOMO', 'TBTBNOMO', 'RBTBNOMO', 'RBTBNOMO', 'BTB NOMO', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', NULL, NULL, '2021-10-18 18:20:38', '2021-10-18 19:11:47', NULL),
(133, 'DIGITAL WALKER.ROBINSONS.LA UNION.RTL', 'DIGITAL WALKER ROBINSONS LA UNION RTL', 'GDWLAUNION', 'DWLAUNION', 'TDWLAUNION', 'TDWLAUNION', 'RDWLAUNION', 'RDWLAUNION', 'DW LA UNION', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', NULL, NULL, '2021-10-18 18:21:33', NULL, NULL),
(134, 'MOMAX.LAZADA.FBD.ONL', 'MOMAX LAZADA FBD', 'GMOMAXLAZADAFBD', 'DIGITS', 'TMOMAXLAZADAFBD', 'TMOMAXLAZADAFBD', 'RMOMAXLAZADAFBD', 'RMOMAXLAZADAFBD', 'LAZADA MOMAX FBD', 'LAZADA', 'LAZADA FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', NULL, NULL, '2021-10-19 08:56:07', '2021-10-19 18:43:30', NULL),
(135, 'MOMAX.LAZADA.FBV.ONL', 'MOMAX LAZADA FBV', 'GLAZADAMOMAXFBV', 'LAZADAMOMAXFBV', NULL, NULL, NULL, NULL, 'LAZADA MOMAX FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'ACTIVE', NULL, NULL, '2021-10-19 09:04:28', NULL, NULL),
(136, 'SOUNDPEATS.SHOPEE.FRA', 'SOUNDPEATS SHOPEE FRA', 'GSHPESOUNDPEATS', 'SHPESOUNDPEATS', 'TSHPESOUNDPEATS', 'TSHPESOUNDPEATS', 'RSHPESOUNDPEATS', 'RSHPESOUNDPEATS', 'SHPE SOUNDPEATS', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 4, 0, 'ACTIVE', NULL, NULL, '2021-11-02 19:36:50', '2022-02-15 17:33:41', NULL),
(137, 'DIGITAL WALKER.SM.MEGAMALL.RTL', 'DIGITAL WALKER SM MEGAMALL RTL', 'GDWMANDALUYONG', 'DWMANDALUYONG', 'TDWMANDALUYONG', 'TDWMANDALUYONG', 'RDWMANDALUYONG', 'RDWMANDALUYONG', 'DW SM MEGAMALL', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', NULL, NULL, '2021-11-08 23:16:22', '2021-12-29 04:35:45', NULL),
(138, 'POP UP STORE.SOLAIRE.DIGITAL WALKER.RTL', 'POP UP STORE SOLAIRE DIGITAL WALKER RTL', 'GDWSOLAIRE', 'DWSOLAIRE', 'TDWSOLAIRE', 'TDWSOLAIRE', 'RDWSOLAIRE', 'RDWSOLAIRE', 'DW SOLAIRE', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', NULL, NULL, '2021-11-11 16:50:05', NULL, NULL),
(139, 'BLUESPACE HQ', 'BLUESPACE HQ', 'BLUESPACE', 'BLUESPACE', 'BLUESPACET', 'BLUESPACET', NULL, NULL, 'BLUESPACE HQ', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 4, 0, 'ACTIVE', NULL, NULL, '2021-12-03 17:55:15', '2021-12-15 18:45:15', NULL),
(140, 'DIGITAL WALKER.AYALA.ATC.FRA', 'DIGITAL WALKER AYALA ATC FRA', 'GDWAYALAALABANG', 'DWAYALAALABANG', 'TDWAYALAALABANG', 'TDWAYALAALABANG', 'RDWAYALAALABANG', 'RDWAYALAALABANG', 'DW AYALA ALABANG', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 4, 0, 'ACTIVE', NULL, NULL, '2022-01-05 22:07:58', '2022-01-06 00:05:05', NULL),
(141, 'DIGITAL WALKER.KCC MALL.ZAMBOANGA.RTL', 'DIGITAL WALKER KCC MALL ZAMBOANGA RTL', 'GDWKCCMALL', 'DWKCCMALL', 'TDWKCCMALL', 'TDWKCCMALL', 'RDWKCCMALL', 'RDWKCCMALL', 'DW KCC MALL', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', NULL, NULL, '2022-01-10 18:12:52', NULL, NULL),
(142, 'AUDIOENGINE.LAZADA.FBD.ONL', 'AUDIOENGINE LAZADA FBD', 'GLAZADAAUDIOENG', 'LAZADAAUDIOENG', 'TLAZADAAUDIOENG', 'TLAZADAAUDIOENG', 'RLAZADAAUDIOENG', 'RLAZADAAUDIOENG', 'LAZADA AUDIOENGINE FBD', 'LAZADA', 'LAZADA FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', NULL, NULL, '2022-01-10 23:49:34', '2022-01-12 22:38:40', NULL),
(143, 'AUDIOENGINE.LAZADA.FBV.ONL', 'AUDIOENGINE LAZADA FBV', 'GLAZAUDFBV', 'LAZAUDFBV', NULL, NULL, NULL, NULL, 'AUDIOENGINE LAZADA FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'ACTIVE', NULL, NULL, '2022-01-11 01:04:56', NULL, NULL),
(144, 'HIDRATESPARK.LAZADA.FBD.ONL', 'HIDRATESPARK LAZADA FBD', 'GLAZADAHDRTESPRK', 'LAZADAHDRTESPRK', 'TLAZADAHDRTESPRK', 'TLAZADAHDRTESPRK', 'RLAZADAHDRTESPRK', 'RLAZADAHDRTESPRK', 'LAZADA HIDRATESPARK FBD', 'LAZADA', 'LAZADA FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', NULL, NULL, '2022-01-12 22:26:21', NULL, NULL),
(145, 'HIDRATESPARK.SHOPEE.FBD.ONL', 'HIDRATESPARK SHOPEE FBD', 'GSHOPEEHDRTESPRK', 'SHOPEEHDRTESPRK', 'TSHOPEEHDRTESPRK', 'TSHOPEEHDRTESPRK', 'RSHOPEEHDRTESPRK', 'RSHOPEEHDRTESPRK', 'HIDRATESPARK SHOPEE FBD', 'SHOPEE', 'SHOPEE FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', NULL, NULL, '2022-01-12 22:29:25', NULL, NULL),
(146, 'HIDRATESPARK.LAZADA.FBV.ONL', 'HIDRATESPARK LAZADA FBV', 'GLAZHIDFBV', 'LAZHIDFBV', NULL, NULL, NULL, NULL, 'HIDRATESPARK LAZADA FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'ACTIVE', NULL, NULL, '2022-01-12 22:31:58', NULL, NULL),
(147, 'ASUS PHILIPPINES CORPORATION.CRP', 'ASUS PHILIPPINES CORPORATION', 'GASUSPHILIPPINESCORPORATION', 'GASUSPHILIPPINESCORPORATION', NULL, NULL, NULL, NULL, 'ASUS PHILIPPINES CORPORATION', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(148, 'AUTOMOBILE CENTRAL ENTERPRISE INC.CRP', 'AUTOMOBILE CENTRAL ENTERPRISE INC', 'GAUTOMOBILECENTRALENTERPRISEINC', 'GAUTOMOBILECENTRALENTERPRISEINC', NULL, NULL, NULL, NULL, 'AUTOMOBILE CENTRAL ENTERPRISE INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(149, 'AZEUS SYSTEMS PHILIPPINES LIMITED.OUT', 'AZEUS SYSTEMS PHILIPPINES LIMITED', 'GAZEUSSYSTEMSPHILIPPINESLIMITED', 'GAZEUSSYSTEMSPHILIPPINESLIMITED', NULL, NULL, NULL, NULL, 'AZEUS SYSTEMS PHILIPPINES LIMITED', 'DISTRI', NULL, 'DISTRI', 7, NULL, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(150, 'BANK OF CHINA (HONGKONG) LIMITED.CRP', 'BANK OF CHINA (HONGKONG) LIMITED', 'GBANKOFCHINAHONGKONGLIMITED', 'GBANKOFCHINAHONGKONGLIMITED', NULL, NULL, NULL, NULL, 'BANK OF CHINA (HONGKONG) LIMITED', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(151, 'BANK OF SINGAPORE LIMITED.CRP', 'BANK OF SINGAPORE LIMITED', 'GBANKOFSINGAPORELIMITED', 'GBANKOFSINGAPORELIMITED', NULL, NULL, NULL, NULL, 'BANK OF SINGAPORE LIMITED', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(152, 'BANK OF THE PHIL.ISLANDS.CRP', 'BANK OF THE PHIL.ISLANDS', 'GBANKOFTHEPHILISLANDS', 'GBANKOFTHEPHILISLANDS', NULL, NULL, NULL, NULL, 'BANK OF THE PHIL.ISLANDS', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(153, 'BERMOR TECHZONE COMPUTER PARTS & AAC.CRP', 'BERMOR TECHZONE COMPUTER PARTS & AAC', 'GBERMORTECHZONECOMPUTERPARTSAAC', 'GBERMORTECHZONECOMPUTERPARTSAAC', NULL, NULL, NULL, NULL, 'BERMOR TECHZONE COMPUTER PARTS & AAC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(154, 'BETTZEIT SOUTHEAST ASIA INC.CRP', 'BETTZEIT SOUTHEAST ASIA INC', 'GBETTZEITSOUTHEASTASIAINC', 'GBETTZEITSOUTHEASTASIAINC', NULL, NULL, NULL, NULL, 'BETTZEIT SOUTHEAST ASIA INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(155, 'CREDIT ACCESS PH FINANCING CO.INC.CRP', 'CREDIT ACCESS PH FINANCING CO.INC', 'GCREDITACCESSPHFINANCINGCOINC', 'GCREDITACCESSPHFINANCINGCOINC', NULL, NULL, NULL, NULL, 'CREDIT ACCESS PH FINANCING CO.INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(156, 'ELECTROCOMPUTER DATA SYSTEM.CRP', 'ELECTROCOMPUTER DATA SYSTEM', 'GELECTROCOMPUTERDATASYSTEM', 'GELECTROCOMPUTERDATASYSTEM', NULL, NULL, NULL, NULL, 'ELECTROCOMPUTER DATA SYSTEM', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(157, 'ENJOYLIFE MARKETING CORP.CRP', 'ENJOYLIFE MARKETING CORP', 'GENJOYLIFEMARKETINGCORP', 'GENJOYLIFEMARKETINGCORP', NULL, NULL, NULL, NULL, 'ENJOYLIFE MARKETING CORP', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(158, 'EUROFRAGANCE PHILIPPINES INC.CRP', 'EUROFRAGANCE PHILIPPINES INC', 'GEUROFRAGANCEPHILIPPINESINC', 'GEUROFRAGANCEPHILIPPINESINC', NULL, NULL, NULL, NULL, 'EUROFRAGANCE PHILIPPINES INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(159, 'F MUSIQUE BANC ENTERPRISES.CRP', 'F MUSIQUE BANC ENTERPRISES', 'GFMUSIQUEBANCENTERPRISES', 'GFMUSIQUEBANCENTERPRISES', NULL, NULL, NULL, NULL, 'F MUSIQUE BANC ENTERPRISES', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(160, 'FASTJOBS PHILIPPINES INC.CRP', 'FASTJOBS PHILIPPINES INC', 'GFASTJOBSPHILIPPINESINC', 'GFASTJOBSPHILIPPINESINC', NULL, NULL, NULL, NULL, 'FASTJOBS PHILIPPINES INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(161, 'FELCRIS DAVAO.FELCRIS CENTRALE.DAVAO.DLR', 'FELCRIS DAVAO.FELCRIS CENTRALE.DAVAO', 'GFELCRISDAVAOFELCRISCENTRALEDAVAO', 'GFELCRISDAVAOFELCRISCENTRALEDAVAO', NULL, NULL, NULL, NULL, 'FELCRIS DAVAO.FELCRIS CENTRALE.DAVAO', 'DISTRI', NULL, 'DISTRI', 10, NULL, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(162, 'FELIPE ROY RUFINO.CRP', 'FELIPE ROY RUFINO', 'GFELIPEROYRUFINO', 'GFELIPEROYRUFINO', NULL, NULL, NULL, NULL, 'FELIPE ROY RUFINO', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(163, 'GADGET HEADZ GADGETS AND ACCESSORIES.DLR', 'GADGET HEADZ GADGETS AND ACCESSORIES', 'GGADGETHEADZGADGETSANDACCESSORIES', 'GGADGETHEADZGADGETSANDACCESSORIES', NULL, NULL, NULL, NULL, 'GADGET HEADZ GADGETS AND ACCESSORIES', 'DISTRI', NULL, 'DISTRI', 10, NULL, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(164, 'GLOBE.HEAD OFFICE.DLR', 'GLOBE.HEAD OFFICE', 'GGLOBEHEADOFFICE', 'GGLOBEHEADOFFICE', NULL, NULL, NULL, NULL, 'GLOBE.HEAD OFFICE', 'DISTRI', NULL, 'DISTRI', 10, 8, NULL, NULL, 0, 'ACTIVE', 1, 1, '2022-03-25 02:56:21', '2023-03-22 18:52:06', NULL),
(165, 'GRUNDFOS PUMPS (PHILS.), INC.CRP', 'GRUNDFOS PUMPS (PHILS.), INC', 'GGRUNDFOSPUMPSPHILSINC', 'GGRUNDFOSPUMPSPHILSINC', NULL, NULL, NULL, NULL, 'GRUNDFOS PUMPS (PHILS.), INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(166, 'JMB ALBAY GADGETS.DLR', 'JMB ALBAY GADGETS', 'GJMBALBAYGADGETS', 'GJMBALBAYGADGETS', NULL, NULL, NULL, NULL, 'JMB ALBAY GADGETS', 'DISTRI', NULL, 'DISTRI', 10, NULL, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(167, 'JP SAN PEDRO MUSICAL INSTRUMENT TRD.CRP', 'JP SAN PEDRO MUSICAL INSTRUMENT TRD', 'GJPSANPEDROMUSICALINSTRUMENTTRD', 'GJPSANPEDROMUSICALINSTRUMENTTRD', NULL, NULL, NULL, NULL, 'JP SAN PEDRO MUSICAL INSTRUMENT TRD', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(168, 'KEYSYS INC.CRP', 'KEYSYS INC', 'GKEYSYSINC', 'GKEYSYSINC', NULL, NULL, NULL, NULL, 'KEYSYS INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(169, 'KIMSTORE ENTERPRISE CORP.DLR', 'KIMSTORE ENTERPRISE CORP', 'GKIMSTOREENTERPRISECORP', 'GKIMSTOREENTERPRISECORP', NULL, NULL, NULL, NULL, 'KIMSTORE ENTERPRISE CORP', 'DISTRI', NULL, 'DISTRI', 10, NULL, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(170, 'KUMU INC.CRP', 'KUMU INC', 'GKUMUINC', 'GKUMUINC', NULL, NULL, NULL, NULL, 'KUMU INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(171, 'LIKE ME TRADING.CRP', 'LIKE ME TRADING', 'GLIKEMETRADING', 'GLIKEMETRADING', NULL, NULL, NULL, NULL, 'LIKE ME TRADING', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(172, 'METRO PACIFIC HEALTH TECH CORP.CRP', 'METRO PACIFIC HEALTH TECH CORP', 'GMETROPACIFICHEALTHTECHCORP', 'GMETROPACIFICHEALTHTECHCORP', NULL, NULL, NULL, NULL, 'METRO PACIFIC HEALTH TECH CORP', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:21', NULL, NULL),
(173, 'NEST MANILA HOME APPLIANCES TRADING.DLR', 'NEST MANILA HOME APPLIANCES TRADING', 'GNESTMANILAHOMEAPPLIANCESTRADING', 'GNESTMANILAHOMEAPPLIANCESTRADING', NULL, NULL, NULL, NULL, 'NEST MANILA HOME APPLIANCES TRADING', 'DISTRI', NULL, 'DISTRI', 10, 8, NULL, NULL, 0, 'ACTIVE', 1, 73, '2022-03-25 02:56:22', '2022-12-19 17:56:05', NULL),
(174, 'NEXUS TECHNOLOGIES INC.CRP', 'NEXUS TECHNOLOGIES INC', 'GNEXUSTECHNOLOGIESINC', 'GNEXUSTECHNOLOGIESINC', NULL, NULL, NULL, NULL, 'NEXUS TECHNOLOGIES INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(175, 'NURTUREMED PHARMA, INC.CRP', 'NURTUREMED PHARMA, INC', 'GNURTUREMEDPHARMAINC', 'GNURTUREMEDPHARMAINC', NULL, NULL, NULL, NULL, 'NURTUREMED PHARMA, INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(176, 'OR1 MARKETING MANAGEMENT.CRP', 'OR1 MARKETING MANAGEMENT', 'GOR1MARKETINGMANAGEMENT', 'GOR1MARKETINGMANAGEMENT', NULL, NULL, NULL, NULL, 'OR1 MARKETING MANAGEMENT', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(177, 'PC HUB COMPUTER TECHNOLOGY, INC.DLR', 'PC HUB COMPUTER TECHNOLOGY, INC', 'GPCHUBCOMPUTERTECHNOLOGYINC', 'GPCHUBCOMPUTERTECHNOLOGYINC', NULL, NULL, NULL, NULL, 'PC HUB COMPUTER TECHNOLOGY, INC', 'DISTRI', NULL, 'DISTRI', 10, NULL, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(178, 'PROFESSIONAL CREATIVES AND TRADE MARKETERS INC.CRP', 'PROFESSIONAL CREATIVES AND TRADE MARKETERS INC', 'GPROFESSIONALCREATIVESANDTRADEMARKETERSINC', 'GPROFESSIONALCREATIVESANDTRADEMARKETERSINC', NULL, NULL, NULL, NULL, 'PROFESSIONAL CREATIVES AND TRADE MARKETERS INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL);
INSERT INTO `stores` (`id`, `bea_so_store_name`, `bea_mo_store_name`, `pos_warehouse`, `pos_warehouse_branch`, `pos_warehouse_transit`, `pos_warehouse_transit_branch`, `pos_warehouse_rma`, `pos_warehouse_rma_branch`, `pos_warehouse_name`, `doo_subinventory`, `sit_subinventory`, `org_subinventory`, `channel_id`, `customer_type_id`, `locations_id`, `sts_group`, `allowed_bulk_receiving`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(179, 'RUSTANS.MAKATI.DLR', 'RUSTANS.MAKATI', 'GRUSTANSMAKATI', 'GRUSTANSMAKATI', NULL, NULL, NULL, NULL, 'RUSTANS.MAKATI', 'DISTRI', NULL, 'DISTRI', 10, NULL, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(180, 'RUSTANS.SHANGRI-LA.EDSA.DLR', 'RUSTANS.SHANGRI-LA.EDSA', 'GRUSTANSSHANGRILAEDSA', 'GRUSTANSSHANGRILAEDSA', NULL, NULL, NULL, NULL, 'RUSTANS.SHANGRI-LA.EDSA', 'DISTRI', NULL, 'DISTRI', 10, NULL, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(181, 'SCHENKER MNL ADMIN COMP CENTER INC.CRP', 'SCHENKER MNL ADMIN COMP CENTER INC', 'GSCHENKERMNLADMINCOMPCENTERINC', 'GSCHENKERMNLADMINCOMPCENTERINC', NULL, NULL, NULL, NULL, 'SCHENKER MNL ADMIN COMP CENTER INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(182, 'SEAOIL PHILIPPINES INC.CRP', 'SEAOIL PHILIPPINES INC', 'GSEAOILPHILIPPINESINC', 'GSEAOILPHILIPPINESINC', NULL, NULL, NULL, NULL, 'SEAOIL PHILIPPINES INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(183, 'SHOPHERO TV INC.DLR', 'SHOPHERO TV INC', 'GSHOPHEROTVINC', 'GSHOPHEROTVINC', NULL, NULL, NULL, NULL, 'SHOPHERO TV INC', 'DISTRI', NULL, 'DISTRI', 10, 2, NULL, NULL, 0, 'ACTIVE', 1, 1, '2022-03-25 02:56:22', '2023-03-02 23:11:41', NULL),
(184, 'START UP ENTERPRISES.CRP', 'START UP ENTERPRISES', 'GSTARTUPENTERPRISES', 'GSTARTUPENTERPRISES', NULL, NULL, NULL, NULL, 'START UP ENTERPRISES', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(185, 'TATRONIC GROUP, INC.DLR', 'TATRONIC GROUP, INC', 'GTATRONICGROUPINC', 'GTATRONICGROUPINC', NULL, NULL, NULL, NULL, 'TATRONIC GROUP, INC', 'DISTRI', NULL, 'DISTRI', 10, NULL, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(186, 'TECHBYTRX COMPUTER PARTS AND ACCESSORIES TRADING.DLR', 'TECHBYTRX COMPUTER PARTS AND ACCESSORIES TRADING', 'GTECHBYTRXCOMPUTERPARTSANDACCESSORIESTRADING', 'GTECHBYTRXCOMPUTERPARTSANDACCESSORIESTRADING', NULL, NULL, NULL, NULL, 'TECHBYTRX COMPUTER PARTS AND ACCESSORIES TRADING', 'DISTRI', NULL, 'DISTRI', 10, NULL, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(187, 'THE INBOX STORE.SM.CLARK PAMPANGA.DLR', 'THE INBOX STORE.SM.CLARK PAMPANGA', 'GTHEINBOXSTORESMCLARKPAMPANGA', 'GTHEINBOXSTORESMCLARKPAMPANGA', NULL, NULL, NULL, NULL, 'THE INBOX STORE.SM.CLARK PAMPANGA', 'DISTRI', NULL, 'DISTRI', 10, NULL, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(188, 'THE PHILIPPINE AMERICAN LIFE AND GENERAL INSURANCE COMPANY.CRP', 'THE PHILIPPINE AMERICAN LIFE AND GENERAL INSURANCE COMPANY', 'GTHEPHILIPPINEAMERICANLIFEANDGENERALINSURANCECOMPANY', 'GTHEPHILIPPINEAMERICANLIFEANDGENERALINSURANCECOMPANY', NULL, NULL, NULL, NULL, 'THE PHILIPPINE AMERICAN LIFE AND GENERAL INSURANCE COMPANY', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(189, 'TL SALES AND MANAGEMENT SERVICES, INC.DLR', 'TL SALES AND MANAGEMENT SERVICES INC DLR', 'GTLSALESANDMANAGEMENTSERVICES', 'GTLSALESANDMANAGEMENTSERVICES', NULL, NULL, NULL, NULL, 'TL SALES AND MANAGEMENT SERVICES INC DLR', 'DISTRI', NULL, 'DISTRI', 10, 8, NULL, NULL, 0, 'ACTIVE', 1, 1, '2022-03-25 02:56:22', '2022-08-16 01:27:42', NULL),
(190, 'TOTAL BUSINESS AGENCY.CRP', 'TOTAL BUSINESS AGENCY', 'GTOTALBUSINESSAGENCY', 'GTOTALBUSINESSAGENCY', NULL, NULL, NULL, NULL, 'TOTAL BUSINESS AGENCY', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(191, 'VICTORIA COURT.HILLCREST.CRP', 'VICTORIA COURT.HILLCREST', 'GVICTORIACOURTHILLCREST', 'GVICTORIACOURTHILLCREST', NULL, NULL, NULL, NULL, 'VICTORIA COURT.HILLCREST', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(192, 'WARNER MUSIC PHILIPPINES INC.CRP', 'WARNER MUSIC PHILIPPINES INC', 'GWARNERMUSICPHILIPPINESINC', 'GWARNERMUSICPHILIPPINESINC', NULL, NULL, NULL, NULL, 'WARNER MUSIC PHILIPPINES INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(193, 'WESTCON SOLUTIONS PHILIPPINES INC.CRP', 'WESTCON SOLUTIONS PHILIPPINES INC', 'GWESTCONSOLUTIONSPHILIPPINESINC', 'GWESTCONSOLUTIONSPHILIPPINESINC', NULL, NULL, NULL, NULL, 'WESTCON SOLUTIONS PHILIPPINES INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(194, 'WORLD SOLUTION TECHNOLOGY INC.CRP', 'WORLD SOLUTION TECHNOLOGY INC', 'GWORLDSOLUTIONTECHNOLOGYINC', 'GWORLDSOLUTIONTECHNOLOGYINC', NULL, NULL, NULL, NULL, 'WORLD SOLUTION TECHNOLOGY INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(195, 'XUNDD TRADING CORPORATION.DLR', 'XUNDD TRADING CORPORATION', 'GXUNDDTRADINGCORPORATION', 'GXUNDDTRADINGCORPORATION', NULL, NULL, NULL, NULL, 'XUNDD TRADING CORPORATION', 'DISTRI', NULL, 'DISTRI', 10, NULL, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-03-25 02:56:22', NULL, NULL),
(196, 'ABENSON.HEAD OFFICE.CON', 'ABENSON HEAD OFFICE CON', 'GABENSONHOFCCON', 'GABENSONHOFCCON', NULL, NULL, NULL, NULL, 'ABENSON HEAD OFFICE CON', 'ABENSON', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', NULL, NULL, '2022-03-30 09:52:23', '2022-03-30 10:16:21', NULL),
(197, 'R.O.X.AYALA.BONIFACIO HIGH STREET.CON', 'R.O.X. AYALA BONIFACIO HIGH STREET CON', 'GROXAYALABHSCON', 'GROXAYALABHSCON', NULL, NULL, NULL, NULL, 'R.O.X. AYALA BONIFACIO HIGH STREET CON', 'ROX', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', NULL, NULL, '2022-03-30 09:54:56', '2022-03-30 10:16:45', NULL),
(198, 'MONEYGURU PHILIPPINES CORP.CRP', 'MONEYGURU PHILIPPINES CORP', 'MONEYGURUPHILIPPINESCORP', 'MONEYGURUPHILIPPINESCORP', NULL, NULL, NULL, NULL, 'MONEYGURU PHILIPPINES CORP', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', NULL, NULL, '2022-04-12 18:50:38', NULL, NULL),
(199, 'PURE MOVEMENT LAB.CON', 'PURE MOVEMENT LAB CON', 'PUREMOVEMENTLABCON', 'PUREMOVEMENTLABCON', NULL, NULL, NULL, NULL, 'PURE MOVEMENT LAB CON', 'PURE MOVE', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', NULL, 1, '2022-04-12 23:35:46', '2022-07-21 16:48:48', NULL),
(200, 'SM DEPARTMENT STORE.SM.MEGAMALL.CON', 'SM DEPARTMENT STORE SM MEGAMALL CON', 'SMDEPTSMMEGAMALLCON', 'SMDEPTSMMEGAMALLCON', NULL, NULL, NULL, NULL, 'SM DEPT STORE SM MEGAMALL CON', 'SM DEPT', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', NULL, 1, '2022-04-12 23:39:59', '2022-06-21 16:40:59', NULL),
(201, 'LISTENING ROOM.SM.MEGAMALL.DLR', 'LISTENING ROOM SM MEGAMALL', 'LISTENINGROOMSMMEGAMALL', 'LISTENINGROOMSMMEGAMALL', NULL, NULL, NULL, NULL, 'LISTENING ROOM SM MEGAMALL', 'DISTRI', NULL, 'DISTRI', 10, 8, NULL, NULL, 0, 'ACTIVE', NULL, 1, '2022-04-17 18:37:27', '2023-03-19 18:33:39', NULL),
(202, 'XIAOMI.AYALA.CIRCUIT MAKATI.RTL', 'XIAOMI AYALA CIRCUIT MAKATI RTL', 'GXMICIRCUITMKTI', 'XMICIRCUITMKTI', 'TXMICIRCUITMKTI', 'TXMICIRCUITMKTI', 'RXMICIRCUITMKTI', 'RXMICIRCUITMKTI', 'XIAOMI CIRCUIT MAKATI', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', NULL, NULL, '2022-04-20 23:27:17', NULL, NULL),
(203, 'NOTHING.LAZADA.FBD.ONL', 'NOTHING LAZADA FBD', 'GNOTHINGLAZADA', 'NOTHINGLAZADA', 'TNOTHINGLAZADA', 'TNOTHINGLAZADA', 'RNOTHINGLAZADA', 'RNOTHINGLAZADA', 'NOTHING LAZADA', 'LAZADA', 'LAZADA FBD', 'ECOM', 4, 7, 1, 3, 0, 'ACTIVE', 1, 1, '2022-04-27 18:31:36', '2022-06-30 18:00:44', NULL),
(204, 'NOTHING.SHOPEE.FBD.ONL', 'NOTHING SHOPEE FBD', 'GNOTHINGSHOPEE', 'NOTHINGSHOPEE', 'TNOTHINGSHOPEE', 'TNOTHINGSHOPEE', 'RNOTHINGSHOPEE', 'RNOTHINGSHOPEE', 'NOTHING SHOPEE', 'SHOPEE', 'SHOPEE FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, 73, '2022-04-27 18:33:52', '2022-06-29 17:22:23', NULL),
(205, 'NOTHING.LAZADA.FBV.ONL', 'NOTHING LAZADA FBV', 'GNOTHINGLAZADAFBV', 'NOTHINGLAZADAFBV', NULL, NULL, NULL, NULL, 'NOTHING LAZADA FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-04-27 18:41:51', NULL, NULL),
(206, 'SPECK.LAZADA.FBV.ONL', 'SPECK LAZADA FBV', 'GLAZSPECKFBV', 'LAZSPECKFBV', NULL, NULL, NULL, NULL, 'SPECK LAZADA FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-05-11 19:50:39', NULL, NULL),
(207, 'CLEARANCE.DW ROB ANTIPOLO 2022.RTL', 'CLEARANCE DW ROB ANTIPOLO 2022 RTL', 'GDWROBANTIPOLO', 'DWROBANTIPOLO', 'TDWROBANTIPOLO', 'TDWROBANTIPOLO', 'RDWROBANTIPOLO', 'RDWROBANTIPOLO', 'DW ROB ANTIPOLO', 'RETAIL', NULL, 'RETAIL', 1, 9, 1, 1, 0, 'INACTIVE', 1, 188, '2022-05-19 02:45:57', '2023-09-06 01:26:37', NULL),
(208, 'EL OBSERVATORIO DE MANILA, INC.CRP', 'EL OBSERVATORIO DE MANILA, INC', 'ELOBSERVATORIODEMANILA', 'ELOBSERVATORIODEMANILA', NULL, NULL, NULL, NULL, 'EL OBSERVATORIO DE MANILA, INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-05 22:03:30', NULL, NULL),
(209, 'SM APPLIANCE.SM.MEGAMALL.CON', 'SM APPLIANCE SM MEGAMALL CON', 'GSMAPPMEGAMALL', 'SMAPPMEGAMALL', NULL, NULL, NULL, NULL, 'SM APP MEGAMALL CON', 'SM APP', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-08 19:09:23', NULL, NULL),
(210, 'DIGITAL WALKER.AYALA TRIANGLE.SERENE.RTL', 'DIGITAL WALKER AYALA TRIANGLE SERENE RTL', 'GDWAYALASERENE', 'DWAYALASERENE', 'TDWAYALASERENE', 'TDWAYALASERENE', 'RDWAYALASERENE', 'RDWAYALASERENE', 'DW AYALA SERENE', 'RETAIL', NULL, 'RETAIL', 1, 9, 1, 1, 0, 'ACTIVE', 1, NULL, '2022-06-10 01:34:55', NULL, NULL),
(211, 'UNIGLOBE TRAVELWARE CO. INC.CON', 'UNIGLOBE TRAVELWARE CO INC CON', 'GUNIGLOBE', 'UNIGLOBE', NULL, NULL, NULL, NULL, 'UNIGLOBE TRAVELWARE CO INC CON', 'TRAVELCLUB', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, 1, '2022-06-21 16:08:32', '2022-06-21 16:09:20', NULL),
(212, 'SM DEPARTMENT STORE.SM.MAKATI.CON', 'SM DEPARTMENT STORE SM MAKATI CON', 'GSMMAKATICON', 'GSMMAKATICON', NULL, NULL, NULL, NULL, 'SM DEPARTMENT STORE SM MAKATI CON', 'SM DEPT', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-21 16:30:52', NULL, NULL),
(213, 'SM DEPARTMENT STORE.SM.MANILA.CON', 'SM DEPARTMENT STORE SM MANILA CON', 'GSMMANILACON', 'GSMMANILACON', NULL, NULL, NULL, NULL, 'SM DEPARTMENT STORE SM MANILA CON', 'SM DEPT', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-21 16:30:52', NULL, NULL),
(214, 'SM DEPARTMENT STORE.SM.MARIKINA.CON', 'SM DEPARTMENT STORE SM MARIKINA CON', 'GSMMARIKINACON', 'GSMMARIKINACON', NULL, NULL, NULL, NULL, 'SM DEPARTMENT STORE SM MARIKINA CON', 'SM DEPT', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-21 16:30:52', NULL, NULL),
(215, 'SM DEPARTMENT STORE.SM.MALL OF ASIA.CON', 'SM DEPARTMENT STORE SM MALL OF ASIA CON', 'GSMMOACON', 'GSMMOACON', NULL, NULL, NULL, NULL, 'SM DEPARTMENT STORE SM MALL OF ASIA CON', 'SM DEPT', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-21 16:30:52', NULL, NULL),
(216, 'SM DEPARTMENT STORE.SM.NORTH EDSA.CON', 'SM DEPARTMENT STORE SM NORTH EDSA CON', 'GSMNORTHEDSACON', 'GSMNORTHEDSACON', NULL, NULL, NULL, NULL, 'SM DEPARTMENT STORE SM NORTH EDSA CON', 'SM DEPT', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-21 16:30:52', NULL, NULL),
(217, 'SM DEPARTMENT STORE.SM.SOUTHMALL.CON', 'SM DEPARTMENT STORE SM SOUTHMALL CON', 'GSMSOUTHMALLCON', 'GSMSOUTHMALLCON', NULL, NULL, NULL, NULL, 'SM DEPARTMENT STORE SM SOUTHMALL CON', 'SM DEPT', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-21 16:30:53', NULL, NULL),
(218, 'TOBY\'S.AYALA.GLORIETTA 4.CON', 'TOBY\'S AYALA GLORIETTA 4 CON', 'GAYALAGLORIETTA4', 'GAYALAGLORIETTA4', NULL, NULL, NULL, NULL, 'TOBY\'S AYALA GLORIETTA 4 CON', 'TOBYS', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-21 17:49:21', NULL, NULL),
(219, 'TOBY\'S.SM.MALL OF ASIA.CON', 'TOBY\'S SM MALL OF ASIA CON', 'GSMMALLOFASIA', 'GSMMALLOFASIA', NULL, NULL, NULL, NULL, 'TOBY\'S SM MALL OF ASIA CON', 'TOBYS', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-21 17:49:21', NULL, NULL),
(220, 'TOBY\'S.SM.THE BLOCK.CON', 'TOBY\'S SM THE BLOCK CON', 'GSMTHEBLOCK', 'GSMTHEBLOCK', NULL, NULL, NULL, NULL, 'TOBY\'S SM THE BLOCK CON', 'TOBYS', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-21 17:49:21', NULL, NULL),
(221, 'TOBY\'S.AYALA.TRINOMA.CON', 'TOBY\'S AYALA TRINOMA CON', 'GAYALATRINOMA', 'GAYALATRINOMA', NULL, NULL, NULL, NULL, 'TOBY\'S AYALA TRINOMA CON', 'TOBYS', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-21 17:49:21', NULL, NULL),
(222, 'TOBY\'S.AYALA.GLORIETTA 2.CON', 'TOBY\'S AYALA GLORIETTA 2 CON', 'GAYALAGLORIETTA2', 'GAYALAGLORIETTA2', NULL, NULL, NULL, NULL, 'TOBY\'S AYALA GLORIETTA 2 CON', 'TOBYS', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-21 17:49:21', NULL, NULL),
(223, 'TOBY\'S.SM.SAN LAZARO.CON', 'TOBY\'S SM SAN LAZARO CON', 'GSMSANLAZARO', 'GSMSANLAZARO', NULL, NULL, NULL, NULL, 'TOBY\'S SM SAN LAZARO CON', 'TOBYS', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-21 17:49:22', NULL, NULL),
(224, 'TOBY\'S.SM.AURA.CON', 'TOBY\'S SM AURA CON', 'GSMAURA', 'GSMAURA', NULL, NULL, NULL, NULL, 'TOBY\'S SM AURA CON', 'TOBYS', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-21 17:49:22', NULL, NULL),
(225, 'TOBY\'S.SM.MEGAMALL.CON', 'TOBY\'S SM MEGAMALL CON', 'GSMMEGAMALL', 'GSMMEGAMALL', NULL, NULL, NULL, NULL, 'TOBY\'S SM MEGAMALL CON', 'TOBYS', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-21 17:49:22', NULL, NULL),
(226, 'TOBY\'S.SHANGRI-LA.EDSA.CON', 'TOBY\'S SHANGRI-LA EDSA CON', 'GSHANGRILAEDSA', 'GSHANGRILAEDSA', NULL, NULL, NULL, NULL, 'TOBY\'S SHANGRI-LA EDSA CON', 'TOBYS', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-21 17:49:22', NULL, NULL),
(227, 'ECOM.DIGITS.FBD.ONL', 'ECOM DIGITS FBD', 'GECOMFBD', 'ECOMFBD', 'TECOMFBD', 'TECOMFBD', 'RECOMFBD', 'RECOMFBD', 'ECOM FBD', NULL, 'ECOM FBD', 'ECOM', 4, 7, NULL, 3, 0, 'ACTIVE', 1, NULL, '2022-06-21 23:32:38', NULL, NULL),
(228, 'ESP COMMERCIAL.CRP', 'ESP COMMERCIAL', 'GESPCOMMERCIAL', 'GESPCOMMERCIAL', NULL, NULL, NULL, NULL, 'ESP COMMERCIAL', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-06-22 00:05:10', NULL, NULL),
(229, 'ASTRAL DATA SYSTEMS INC.CRP', 'ASTRAL DATA SYSTEMS INC', 'GASTRALDATASYSTEMSINC', 'GASTRALDATASYSTEMSINC', NULL, NULL, NULL, NULL, 'ASTRAL DATA SYSTEMS INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-07-07 23:05:23', NULL, NULL),
(230, 'IONTECH INC.CRP', 'IONTECH INC', 'GIONTECHINC', 'GIONTECHINC', NULL, NULL, NULL, NULL, 'IONTECH INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-07-12 23:41:54', NULL, NULL),
(231, 'PHILIPPINE RED CROSS.CRP', 'PHILIPPINE RED CROSS', 'GPHILIPPINE RED CROSS', 'GPHILIPPINE RED CROSS', NULL, NULL, NULL, NULL, 'PHILIPPINE RED CROSS', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-07-18 21:55:38', NULL, NULL),
(232, 'I STUDIO.SM.MANILA.CON', 'I STUDIO SM MANILA CON', 'GISTUDIOSMMANILACON', 'GISTUDIOSMMANILACON', NULL, NULL, NULL, NULL, 'I STUDIO SM MANILA CON', 'I STUDIO', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-07-21 16:51:00', NULL, NULL),
(233, 'COMMONWEALTH.HEAD OFFICE.CON', 'COMMONWEALTH HEAD OFFICE CON', 'GCOMMONWEALTHHEADOFFICECON', 'GCOMMONWEALTHHEADOFFICECON', NULL, NULL, NULL, NULL, 'COMMONWEALTH HEAD OFFICE CON', 'COMMONWLTH', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 1, 1, '2022-07-28 00:07:03', '2022-11-09 19:09:56', NULL),
(234, 'TRAVELLERS.MEGAWORLD.NEWPORT.CRP', 'TRAVELLERS MEGAWORLD NEWPORT CRP', 'GTRAVELLERSMEGAWORLDNEWPORTCRP', 'GTRAVELLERSMEGAWORLDNEWPORTCRP', NULL, NULL, NULL, NULL, 'TRAVELLERS MEGAWORLD NEWPORT CRP', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-07-31 23:24:18', NULL, NULL),
(235, 'SMART COMMUNICATIONS, INC.CRP', 'SMART COMMUNICATIONS INC', 'GSMARTCOMMS', 'GSMARTCOMMS', NULL, NULL, NULL, NULL, 'SMART COMMUNICATIONS INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-09-06 23:35:07', NULL, NULL),
(236, 'SHOPEE.CRP', 'SHOPEE CRP', 'GSHOPEECRP', 'GSHOPEECRP', NULL, NULL, NULL, NULL, 'SHOPEE CRP', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-09-11 19:29:03', NULL, NULL),
(237, 'DIGITAL WALKER.SM.TANZA CAVITE.RTL', 'DIGITAL WALKER SM TANZA CAVITE RTL', 'GDWSMTANZA', 'DWSMTANZA', 'TDWSMTANZA', 'TDWSMTANZA', 'RDWSMTANZA', 'RDWSMTANZA', 'DW SM TANZA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, NULL, '2022-09-21 21:46:46', NULL, NULL),
(238, 'ACEFAST.LAZADA.FBV.ONL', 'ACEFAST LAZADA FBV', 'LAZACEFBV', 'LAZACEFBV', NULL, NULL, NULL, NULL, 'ACEFAST LAZADA FBV', 'LAZADA', NULL, 'ECOM', 4, 7, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-09-28 16:27:53', NULL, NULL),
(239, 'INDIEVENTS, INC.CRP', 'INDIEVENTS INC CRP', 'GINDIEVENTSINCCRP', 'GINDIEVENTSINCCRP', NULL, NULL, NULL, NULL, 'INDIEVENTS INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-10-10 02:28:26', NULL, NULL),
(240, 'ATENEO DE DAVAO UNIVERSITY.CRP', 'ATENEO DE DAVAO UNIVERSITY', 'GATENEO', 'GATENEO', NULL, NULL, NULL, NULL, 'ATENEO DE DAVAO UNIVERSITY', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 73, NULL, '2022-10-17 01:16:31', NULL, NULL),
(241, 'DIGITAL WALKER.EVIA MALL.LAS PINAS.RTL', 'DIGITAL WALKER EVIA MALL LAS PINAS RTL', 'GDWEVIAMALL', 'DWEVIAMALL', 'TDWEVIAMALL', 'TDWEVIAMALL', 'RDWEVIAMALL', 'RDWEVIAMALL', 'DW EVIA MALL', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, NULL, '2022-10-20 22:30:19', NULL, NULL),
(242, 'DIGITAL WALKER.ROBINSONS.ANTIPOLO.RTL', 'DIGITAL WALKER ROBINSONS ANTIPOLO RTL', 'GDWRANTIPOLO', 'DWRANTIPOLO', 'TDWRANTIPOLO', 'TDWRANTIPOLO', 'RDWRANTIPOLO', 'RDWRANTIPOLO', 'DW ROBINSON ANTIPOLO', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 1, '2022-10-20 22:40:14', '2022-10-20 22:43:40', NULL),
(243, 'G-MAGMASTER CORPORATION.DLR', 'G-MAGMASTER CORPORATION', 'GMAGMASTERCORPORATION', 'GMAGMASTERCORPORATION', NULL, NULL, NULL, NULL, 'G-MAGMASTER CORPORATION', 'DISTRI', NULL, 'DISTRI', 10, 3, NULL, NULL, 0, 'ACTIVE', 1, 1, '2022-10-27 01:14:00', '2023-06-20 19:41:13', NULL),
(244, 'CLEARANCE.SMX.MOA.RTL', 'CLEARANCE SMX MOA RTL', 'GSMXMOA', 'SMXMOA', 'TSMXMOA', 'TSMXMOA', 'RSMXMOA', 'RSMXMOA', 'SMX MOA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, NULL, '2022-11-03 23:02:13', NULL, NULL),
(245, 'XIAOMI.MITSUKOSHI.BGC.RTL', 'XIAOMI MITSUKOSHI BGC RTL', 'GXMIMITSUKOSHI', 'XMIMITSUKOSHI', 'TXMIMITSUKOSHI', 'TXMIMITSUKOSHI', 'RXMIMITSUKOSHI', 'RXMIMITSUKOSHI', 'XIOAMI MITSUKOSHI', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, NULL, '2022-11-03 23:45:12', NULL, NULL),
(246, 'OPEN SOURCE.MITSUKOSHI.BGC.RTL', 'OPEN SOURCE MITSUKOSHI BGC RTL', 'GBTBMITSUKOSHI', 'BTBMITSUKOSHI', 'TBTBMITSUKOSHI', 'TBTBMITSUKOSHI', 'RBTBMITSUKOSHI', 'RBTBMITSUKOSHI', 'BTB MITSUKOSHI', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 73, '2022-11-03 23:46:11', '2024-02-22 19:31:39', NULL),
(247, 'XIAOMI.AYALA.VERTIS NORTH.RTL', 'XIAOMI AYALA VERTIS NORTH RTL', 'GXMIAYALAVERTIS', 'XMIAYALAVERTIS', 'TXMIAYALAVERTIS', 'TXMIAYALAVERTIS', 'RXMIAYALAVERTIS', 'RXMIAYALAVERTIS', 'XIOAMI AYALA VERTIS', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, NULL, '2022-11-03 23:47:17', NULL, NULL),
(248, 'BEYOND THE BOX.CITYFRONT.CLARK.RTL', 'BEYOND THE BOX CITYFRONT CLARK RTL', 'GBTBCITYFRONT', 'BTBCITYFRONT', 'TBTBCITYFRONT', 'TBTBCITYFRONT', 'RBTBCITYFRONT', 'RBTBCITYFRONT', 'BTB CITYFRONT CLARK', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, NULL, '2022-11-04 00:03:23', NULL, NULL),
(249, 'BEYOND THE BOX.ROBINSONS.MALOLOS.RTL', 'BEYOND THE BOX ROBINSONS MALOLOS RTL', 'GBTBROBMALOLOS', 'BTBROBMALOLOS', 'TBTBROBMALOLOS', 'TBTBROBMALOLOS', 'RBTBROBMALOLOS', 'RBTBROBMALOLOS', 'BTB ROBINSON MALOLOS', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, NULL, '2022-11-04 00:04:25', NULL, NULL),
(250, 'DIGITAL WALKER.POP UP MITSUKOSHI.BGC.RTL', 'DIGITAL WALKER POP UP MITSUKOSHI BGC RTL', 'GDWPOPMITSUKOSHI', 'DWPOPMITSUKOSHI', 'TDWPOPMITSUKOSHI', 'TDWPOPMITSUKOSHI', 'RDWPOPMITSUKOSHI', 'RDWPOPMITSUKOSHI', 'DW POP MITSUKOSHI', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, NULL, '2022-11-13 21:47:28', NULL, NULL),
(251, 'TIGER RESORT, LEISURE AND ENT., INC.CRP', 'TIGER RESORT, LEISURE AND ENT., INC', 'GTIGERRESORTLEISUREENTINC', 'GTIGERRESORTLEISUREENTINC', NULL, NULL, NULL, NULL, 'TIGER RESORT, LEISURE AND ENT., INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-12-06 16:36:23', NULL, NULL),
(252, 'GOLDEN PRESTIGE MRKTG, INC.CRP', 'GOLDEN PRESTIGE MRKTG INC', 'GGOLDENPRESTIGEMRKTGINC', 'GGOLDENPRESTIGEMRKTGINC', NULL, NULL, NULL, NULL, 'GOLDEN PRESTIGE MRKTG INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-12-14 01:20:43', NULL, NULL),
(253, 'MC KINSEY & CO. (PHILS.).CRP', 'MC KINSEY & CO. (PHILS.)', 'GMCKINSEYCOPHILS', 'GMCKINSEYCOPHILS', NULL, NULL, NULL, NULL, 'MC KINSEY & CO. (PHILS.)', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2022-12-19 19:47:39', NULL, NULL),
(254, 'MISTER GREY MARKETING INC.DLR', 'MISTER GREY MARKETING INC', 'GMISTERGREYMARKETINGINC', 'GMISTERGREYMARKETINGINC', NULL, NULL, NULL, NULL, 'MISTER GREY MARKETING INC', 'DISTRI', NULL, 'DISTRI', 10, 3, NULL, NULL, 0, 'ACTIVE', 1, 73, '2023-01-12 19:37:43', '2023-01-26 22:04:41', NULL),
(255, 'DIGITAL WALKER.SM.MAKATI.FRA', 'DIGITAL WALKER SM MAKATI FRA', 'GDWSMMAKATI', 'DWSMMAKATI', 'TDWSMMAKATI', 'TDWSMMAKATI', 'RDWSMMAKATI', 'RDWSMMAKATI', 'DW SM MAKATI', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 4, 0, 'ACTIVE', 1, NULL, '2023-01-30 00:50:27', NULL, NULL),
(256, 'UNIGLOBE TRAVELWARE CO. INC.CRP', 'UNIGLOBE TRAVELWARE CO. INC', 'GUNIGLOBETRAVELWARECOINC', 'GUNIGLOBETRAVELWARECOINC', NULL, NULL, NULL, NULL, 'UNIGLOBE TRAVELWARE CO. INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2023-02-02 19:02:37', NULL, NULL),
(257, 'STYLERIGHT GLOBAL CORPORATION.DLR', 'STYLERIGHT GLOBAL CORPORATION', 'GSTYLERIGHTGLOBALCORP', 'GSTYLERIGHTGLOBALCORP', NULL, NULL, NULL, NULL, 'STYLERIGHT GLOBAL CORPORATION', 'DISTRI', NULL, 'DISTRI', 10, 8, NULL, NULL, 0, 'ACTIVE', 1, 1, '2023-03-10 01:22:19', '2023-03-19 18:32:35', NULL),
(258, 'STEAG STATE POWER INC.CRP', 'STEAG STATE POWER INC', 'GSTEAGSTATEPOWER', 'GSTEAGSTATEPOWER', NULL, NULL, NULL, NULL, 'STEAG STATE POWER INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2023-03-14 22:25:44', NULL, NULL),
(259, 'SERVIER PHILIPPINES, INC.CRP', 'SERVIER PHILIPPINES INC', 'GSERVIERPHILIPPINES', 'GSERVIERPHILIPPINES', NULL, NULL, NULL, NULL, 'SERVIER PHILIPPINES INC', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, 73, '2023-03-14 22:26:37', '2023-03-23 22:37:49', NULL),
(260, 'DIGITAL WALKER.AYALA.GREENBELT 5.RTL', 'DIGITAL WALKER AYALA GREENBELT 5 RTL', 'GDWGREENBELT5', 'DWGREENBELT5', 'TDWGREENBELT', 'TDWGREENBELT', 'DWGREENBELT5RM', 'RDWGREENBELT', 'DW GREENBELT', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, NULL, '2023-03-20 03:02:06', NULL, NULL),
(261, 'DIGITAL WALKER.AYALA.HIGH STREET.RTL', 'DIGITAL WALKER AYALA HIGH STREET RTL', 'GDWHIGHSTREET', 'DWHIGHSTREET', 'TDWHIGHSTREET', 'TDWHIGHSTREET', 'RDWHIGHSTREET', 'RDWHIGHSTREET', 'DW HIGH STREET', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, NULL, '2023-03-20 03:03:41', NULL, NULL),
(262, 'DIGITAL WALKER.ROBINSONS.TACLOBAN.FRA', 'DIGITAL WALKER ROBINSONS TACLOBAN FRA', 'GDWTACLOBAN', 'DWTACLOBAN', 'TDWTACLOBAN', 'TDWTACLOBAN', 'RDWTACLOBAN', 'RDWTACLOBAN', 'DW TACLOBAN', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 20, 0, 'ACTIVE', 1, 1, '2023-03-29 21:57:20', '2023-11-23 19:58:20', NULL),
(263, 'NEWTRENDS INTERNATIONAL CORPORATION.DLR', 'NEWTRENDS INTERNATIONAL CORPORATION', 'GNEWTRENDSINTERNATIONALCORPORATION', 'GNEWTRENDSINTERNATIONALCORPORATION', NULL, NULL, NULL, NULL, 'NEWTRENDS INTERNATIONAL CORPORATION', 'NEWTRENDS', NULL, 'DISTRI', 10, 8, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2023-04-17 19:20:13', NULL, NULL),
(264, 'O&J GLOBAL TRADING.DLR', 'O&J GLOBAL TRADING', 'GO&JGLOBALTRADING', 'GO&JGLOBALTRADING', NULL, NULL, NULL, NULL, 'O&J GLOBAL TRADING', 'GLOBAL TRADING', NULL, 'DISTRI', 10, 8, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2023-04-17 19:21:58', NULL, NULL),
(265, 'IWH COMP., ELEC. GADGETS AND ACC.DLR', 'IWH COMP., ELEC. GADGETS AND ACC', 'GIWHCOMPELECGADGETSANDACC', 'GIWHCOMPELECGADGETSANDACC', NULL, NULL, NULL, NULL, 'IWH COMP., ELEC. GADGETS AND ACC', 'DISTRI', NULL, 'DISTRI', 10, 8, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2023-04-19 20:03:08', NULL, NULL),
(266, 'BEYOND THE BOX.GREENHILLS.ORTIGAS.RTL', 'BEYOND THE BOX GREENHILLS ORTIGAS RTL', 'GBTBGREENHILLS', 'BTBGREENHILLS', 'TBTBGREENHILLS', 'TBTBGREENHILLS', 'RBTBGREENHILLS', 'RBTBGREENHILLS', 'BTB GREENHILLS', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'INACTIVE', 1, 188, '2023-05-11 00:26:50', '2023-09-06 01:27:21', NULL),
(267, 'DIGITAL WALKER.GREENHILLS.ORTIGAS.RTL', 'DIGITAL WALKER GREENHILLS ORTIGAS RTL', 'GDWGREENHILLS', 'DWGREENHILLS', 'TDWGREENHILLS', 'TDWGREENHILLS', 'RDWGREENHILLS', 'RDWGREENHILLS', 'DW GREENHILLS', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, 73, '2023-05-11 00:28:09', '2023-12-14 19:11:29', NULL),
(268, 'DIGITAL WALKER.ONE.AYALA.FRA', 'DIGITAL WALKER ONE AYALA FRA', 'GDWONEAYALA', 'DWONEAYALA', 'TDWONEAYALA', 'TDWONEAYALA', 'RDWONEAYALA', 'RDWONEAYALA', 'DW ONE AYALA', 'FRANCHISE', NULL, 'FRANCHISE', 2, 6, NULL, 4, 0, 'ACTIVE', 1, 73, '2023-05-11 00:29:07', '2023-11-23 23:56:03', NULL),
(269, 'DIGITAL WALKER.SM.TELABASTAGAN.RTL', 'DIGITAL WALKER SM TELABASTAGAN RTL', 'GDWTELABASTAGAN', 'DWTELABASTAGAN', 'TDWTELABASTAGAN', 'TDWTELABASTAGAN', 'RDWTELABASTAGAN', 'RDWTELABASTAGAN', 'DW TELABASTAGAN', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, NULL, '2023-05-11 00:41:20', NULL, NULL),
(270, 'POLKADOT VENTURES CORPORATION.DLR', 'POLKADOT VENTURES CORPORATION', 'GPOLKADOTVENTURESCORPORATION', 'POLKADOTVENTURESCORPORATION', NULL, NULL, NULL, NULL, 'POLKADOT VENTURES CORPORATION', 'DISTRI', NULL, 'DISTRI', 10, 8, NULL, NULL, 0, 'ACTIVE', 1, 1, '2023-06-05 22:37:07', '2023-06-05 23:07:02', NULL),
(271, 'BEYOND INNOVATION INC.DLR', 'BEYOND INNOVATION INC', 'GBEYONDINNOVATIONINC', 'BEYONDINNOVATIONINC', NULL, NULL, NULL, NULL, 'BEYOND INNOVATION INC', 'DISTRI', NULL, 'DISTRI', 10, 8, NULL, NULL, 0, 'ACTIVE', 1, 1, '2023-06-05 22:38:06', '2023-08-07 23:24:57', NULL),
(272, 'CARL ZEISS PHILIPPINES PTE. LTD.CRP', 'CARL ZEISS PHILIPPINES PTE. LTD.CRP', 'GCARLZEISSPHILIPPINESPTELTD', 'GCARLZEISSPHILIPPINESPTELTD', NULL, NULL, NULL, NULL, 'CARL ZEISS PHILIPPINES PTE.LTD', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, 1, '2023-06-16 03:08:48', '2023-06-22 02:27:10', NULL),
(273, 'ALLHOME CORP.STARMALL.LAS PINAS.DLR', 'ALLHOME CORP STARMALL LAS PINAS', 'ALLHOME CORP.STARMALL.LAS PINAS.', 'GALLHOMECORPSTARMALLLASPINAS', NULL, NULL, NULL, NULL, 'ALLHOME CORP STARMALL LAS PINAS', 'DISTRI', NULL, 'DISTRI', 10, 3, NULL, NULL, 0, 'ACTIVE', 1, 1, '2023-06-20 19:47:10', '2023-06-20 19:48:57', NULL),
(274, 'BEYOND THE BOX.AIRPORT.CLARK.RTL', 'BEYOND THE BOX AIRPORT CLARK RTL', 'GBTBAIRPORTCLARK', 'BTBAIRPORTCLARK', 'TBTBAIRPORTCLARK', 'TBTBAIRPORTCLARK', 'RBTBAIRPORTCLARK', 'RBTBAIRPORTCLARK', 'BTB AIRPORT CLARK', 'RETAIL', NULL, 'RETAIL', 1, 9, 2, 1, 1, 'ACTIVE', 188, 73, '2023-07-12 19:31:42', '2023-12-19 23:52:13', NULL),
(275, 'DIGITAL WALKER.SM.STO.TOMAS.RTL', 'DIGITAL WALKER SM STO TOMAS RTL', 'GDWSMSTOTOMAS', 'DWSMSTOTOMAS', 'TDWSMSTOTOMAS', 'TDWSMSTOTOMAS', 'RDWSMSTOTOMAS', 'RDWSMSTOTOMAS', 'DW SM STO TOMAS', 'RETAIL', NULL, 'RETAIL', 1, 9, 2, 1, 0, 'ACTIVE', 188, 73, '2023-07-12 19:35:25', '2023-10-26 07:41:55', NULL),
(276, 'OPEN SOURCE.ROBINSONS.OPUS.RTL', 'OPEN SOURCE ROBINSONS OPUS RTL', 'GOSOPUS', 'OSOPUS', 'TOSOPUS', 'TOSOPUS', 'ROSOPUS', 'ROSOPUS', 'OS OPUS', 'RETAIL', NULL, 'RETAIL', 1, 9, 1, 1, 0, 'ACTIVE', 188, NULL, '2023-07-31 01:24:46', NULL, NULL),
(277, 'OPEN SOURCE.ROBINSONS.CEBU.RTL', 'OPEN SOURCE ROBINSONS CEBU RTL', 'GOSCEBU', 'OSCEBU', 'TOSCEBU', 'TOSCEBU', 'ROSCEBU', 'ROSCEBU', 'OS CEBU', 'RETAIL', NULL, 'RETAIL', 1, 9, 2, 1, 0, 'ACTIVE', 188, NULL, '2023-07-31 01:27:10', NULL, NULL),
(278, 'OPEN SOURCE.ROBINSONS.GAPAN.RTL', 'OPEN SOURCE ROBINSONS GAPAN RTL', 'GOSGAPAN', 'OSGAPAN', 'TOSGAPAN', 'TOSGAPAN', 'ROSGAPAN', 'ROSGAPAN', 'OS GAPAN', 'RETAIL', NULL, 'RETAIL', 1, 9, 2, 1, 0, 'ACTIVE', 188, NULL, '2023-07-31 01:28:44', NULL, NULL),
(279, 'DIGITAL WALKER.SM.BACOOR.RTL', 'DIGITAL WALKER SM BACOOR RTL', 'GDWSMBACOOR', 'DWSMBACOOR', 'TDWSMBACOOR', 'TDWSMBACOOR', 'RDWSMBACOOR', 'RDWSMBACOOR', 'DW SM BACOOR', 'RETAIL', NULL, 'RETAIL', 1, 9, 2, 1, 0, 'ACTIVE', 188, NULL, '2023-07-31 01:30:38', NULL, NULL),
(280, 'DIGITAL WALKER.SM.VALENZUELA.RTL', 'DIGITAL WALKER SM VALENZUELA RTL', 'GDWSMVALENZUELA', 'DWSMVALENZUELA', 'TDWSMVALENZUELA', 'TDWSMVALENZUELA', 'RDWSMVALENZUELA', 'RDWSMVALENZUELA', 'DW SM VALENZUELA', 'RETAIL', NULL, 'RETAIL', 1, 9, 1, 1, 0, 'ACTIVE', 188, 73, '2023-07-31 01:32:07', '2023-12-14 19:10:53', NULL),
(281, 'DIGITAL WALKER.AYALA.SOLENAD.RTL', 'DIGITAL WALKER AYALA SOLENAD RTL', 'GDWSOLENAD', 'DWSOLENAD', 'TDWSOLENAD', 'TDWSOLENAD', 'RDWSOLENAD', 'RDWSOLENAD', 'DW SOLENAD', 'RETAIL', NULL, 'RETAIL', 1, 9, 2, 1, 0, 'ACTIVE', 188, 1, '2023-07-31 01:33:35', '2023-11-30 19:18:47', NULL),
(282, 'INFINITY LOOP RETAIL INC.DLR', 'INFINITY LOOP RETAIL INC', 'GINFINITYLOOPRETAILINC', 'GINFINITYLOOPRETAILINC', NULL, NULL, NULL, NULL, 'INFINITY LOOP RETAIL INC', 'DISTRI', NULL, 'DISTRI', 10, 8, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2023-08-01 19:01:55', NULL, NULL),
(283, 'DIGITAL WALKER.SM.ROSARIO.RTL', 'DIGITAL WALKER SM ROSARIO RTL', 'GDWSMROSARIO', 'DWSMROSARIO', 'TDWSMROSARIO', 'TDWSMROSARIO', 'RDWSMROSARIO', 'RDWSMROSARIO', 'DW SM ROSARIO', 'RETAIL', NULL, 'RETAIL', 1, 9, 2, 1, 0, 'ACTIVE', 188, 1, '2023-08-07 17:32:38', '2023-10-07 22:34:03', NULL),
(284, 'DIGITAL WALKER.AYALA.CIRCUIT.RTL', 'DIGITAL WALKER AYALA CIRCUIT RTL', 'GDWAYALACIRCUIT', 'DWAYALACIRCUIT', 'TDWAYALACIRCUIT', 'TDWAYALACIRCUIT', 'RDWAYALACIRCUIT', 'RDWAYALACIRCUIT', 'DW AYALA CIRCUIT', 'RETAIL', NULL, 'RETAIL', 1, 9, 1, 1, 0, 'ACTIVE', 188, NULL, '2023-08-07 17:34:39', NULL, NULL),
(285, 'DIGITAL WALKER.SM.SAN PEDRO.RTL', 'DIGITAL WALKER SM SAN PEDRO RTL', 'GDWSMSANPEDRO', 'DWSMSANPEDRO', 'TDWSMSANPEDRO', 'TDWSMSANPEDRO', 'RDWSMSANPEDRO', 'RDWSMSANPEDRO', 'DW SM SAN PEDRO', 'RETAIL', NULL, 'RETAIL', 1, 9, 2, 1, 0, 'ACTIVE', 188, 1, '2023-08-07 18:19:47', '2023-11-23 19:58:35', NULL),
(286, 'DOCTOR TEXTUS GADGETS AND ACC. SHOP.DLR', 'DOCTOR TEXTUS GADGET AND ACC', 'DOCTORTEXTUSGADGETANDACC', 'DOCTORTEXTUSGADGETANDACC', NULL, NULL, NULL, NULL, 'DOCTOR TEXTUS GADGET AND ACC', NULL, NULL, 'DOCTORTEXTUSGADGETANDACC', 10, 3, NULL, NULL, 0, 'ACTIVE', 188, 1, '2023-09-06 23:00:54', '2023-09-13 20:07:50', NULL),
(287, 'DIGITAL WALKER.ROBINSONS.ERMITA 2F.RTL', 'DIGITAL WALKER ROBINSONS ERMITA 2F RTL', 'GDWERMITA2F', 'DWERMITA2F', 'TDWERMITA2F', 'TDWERMITA2F', 'RDWERMITA2F', 'RDWERMITA2F', 'DW ERMITA 2F', 'RETAIL', NULL, 'RETAIL', 1, 9, 1, 1, 0, 'ACTIVE', 188, NULL, '2023-09-12 18:17:01', NULL, NULL),
(288, 'OPEN SOURCE.PARQAL.ASEANA.RTL', 'OPEN SOURCE PARQAL ASEANA RTL', 'GOSASEANA', 'OSASEANA', 'TOSASEANA', 'TOSASEANA', 'ROSASEANA', 'ROSASEANA', 'OS ASEANA', 'RETAIL', NULL, 'RETAIL', 1, 9, 1, 1, 0, 'ACTIVE', 188, 1, '2023-09-12 18:18:51', '2023-10-07 22:32:43', NULL),
(289, 'DIGITAL WALKER.LIPAD.CLARK.RTL', 'DIGITAL WALKER LIPAD CLARK RTL', 'GDWLIPADCLARK', 'DWLIPADCLARK', 'TDWLIPADCLARK', 'TDWLIPADCLARK', 'RDWLIPADCLARK', 'RDWLIPADCLARK', 'DW LIPAD CLARK', 'RETAIL', NULL, 'RETAIL', 1, 9, 2, 1, 0, 'ACTIVE', 188, NULL, '2023-09-12 19:25:31', NULL, NULL),
(290, 'DIGITAL WALKER.SM.ARANETA CITY.RTL', 'DIGITAL WALKER SM ARANETA CITY RTL', 'GDWSMARANETA', 'DWSMARANETA', 'TDWSMARANETA', 'TDWSMARANETA', 'RDWSMARANETA', 'RDWSMARANETA', 'DW SM ARANETA', 'RETAIL', NULL, 'RETAIL', 1, 9, 1, 1, 0, 'ACTIVE', 188, 73, '2023-09-27 18:16:00', '2023-12-14 19:11:06', NULL),
(291, 'GASHAPON.MITSUKOSHI.BGC.RTL', 'GASHAPON MITSUKOSHI BGC RTL', 'GGBOMITSUKOSHI', 'GBOMITSUKOSHI', 'TGBOMITSUKOSHI', 'TGBOMITSUKOSHI', 'RGBOMITSUKOSHI', 'RGBOMITSUKOSHI', 'GBO MITSUKOSHI', 'RETAIL', NULL, 'RETAIL', 1, 9, 1, 1, 0, 'ACTIVE', 188, 73, '2023-10-25 22:28:59', '2023-11-07 14:52:00', NULL),
(292, 'ACEFAST.SM.MALL OF ASIA.RTL', 'ACEFAST SM MALL OF ASIA RTL', 'GACEFASTSMMOA', 'ACEFASTSMMOA', 'TACEFASTSMMOA', 'TACEFASTSMMOA', 'RACEFASTSMMOA', 'RACEFASTSMMOA', 'ACEFAST SM MOA', 'RETAIL', NULL, 'RETAIL', 1, 9, NULL, 1, 0, 'ACTIVE', 1, NULL, '2023-11-23 03:04:17', NULL, NULL),
(293, 'DIGITAL WALKER.AYALA.BACOLOD.RTL', 'DIGITAL WALKER AYALA BACOLOD RTL', 'GDWAYALABACOLOD', 'DWAYALABACOLOD', 'TDWAYALABACOLOD', 'TDWAYALABACOLOD', 'RDWAYALABACOLOD', 'RDWAYALABACOLOD', 'DW AYALA BACOLOD', 'RETAIL', NULL, 'RETAIL', 1, 9, 2, 1, 0, 'ACTIVE', 188, NULL, '2023-11-27 23:28:37', NULL, NULL),
(294, 'DIGITAL WALKER.VISTAMALL.STA. ROSA.RTL', 'DIGITAL WALKER VISTAMALL STA ROSA RTL', 'GDWSTAROSA', 'DWSTAROSA', 'TDWSTAROSA', 'TDWSTAROSA', 'RDWSTAROSA', 'RDWSTAROSA', 'DW STA ROSA', 'RETAIL', NULL, 'RETAIL', 1, 9, 2, 1, 1, 'ACTIVE', 188, 73, '2023-12-03 17:31:24', '2024-02-06 18:53:30', NULL),
(295, 'RUSTANS.AYALA.ALABANG TOWN CENTER.DLR', 'RUSTANS AYALA ALABANG TOWN CENTER', 'GRUSTANSAYALAATC', 'RUSTANSAYALAATC', NULL, NULL, NULL, NULL, 'RUSTANS AYALA ALABANG TOWN CENTER', 'DISTRI', NULL, 'DISTRI', 10, 8, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2023-12-11 22:44:43', NULL, NULL),
(296, 'DIGIMAP.ORTIGAS MALLS.GREENHILLS.CON', 'DIGIMAP ORTIGAS MALLS GREENHILLS CON', 'N/A', 'N/A', NULL, NULL, NULL, NULL, 'DIGIMAP ORTIGAS MALLS GREENHILLS', 'DIGIMAP', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 73, 1, '2024-01-15 17:39:52', '2024-01-29 22:47:14', NULL),
(297, 'DIGIMAP.ASEANA.PARQAL.CON', 'DIGIMAP ASEANA PARQAL CON', 'N/A', 'N/A', NULL, NULL, NULL, NULL, 'DIGIMAP ASEANA PARQAL', 'DIGIMAP', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 73, 1, '2024-01-15 17:40:25', '2024-01-29 22:46:30', NULL),
(298, 'DIGIMAP.AYALA.ONE.CON', 'DIGIMAP AYALA ONE CON', 'N/A', 'N/A', NULL, NULL, NULL, NULL, 'DIGIMAP AYALA ONE', 'DIGIMAP', NULL, 'DISTRI', 6, 2, NULL, NULL, 0, 'ACTIVE', 73, 1, '2024-01-15 17:41:52', '2024-01-29 22:46:37', NULL),
(299, 'PRIMER DIGIWORX CORPORATION.CRP', 'PRIMER DIGIWORX CORPORATION', 'GPRIMERDIGIWORXCORPORATION', 'GPRIMERDIGIWORXCORPORATION', NULL, NULL, NULL, NULL, 'PRIMER DIGIWORX CORPORATION', 'DISTRI', NULL, 'DISTRI', 11, 3, NULL, NULL, 0, 'ACTIVE', 1, NULL, '2024-01-29 22:07:18', NULL, NULL),
(300, 'GASHAPON.ORTIGAS MALLS.GREENHILLS.RTL', 'GASHAPON GREENHILLS VMALL RTL', 'GGBOGREENHILLS', 'GBOGREENHILLS', 'TGBOGREENHILLS', 'TGBOGREENHILLS', 'RGBOGREENHILLS', 'RGBOGREENHILLS', 'GBO GREENHILLS', 'RETAIL', NULL, 'RETAIL', 1, 9, 1, 1, 0, 'ACTIVE', 188, 188, '2024-02-20 19:50:55', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `st_status`
--

CREATE TABLE `st_status` (
  `id` int UNSIGNED NOT NULL,
  `status_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('ACTIVE','INACTIVE') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'ACTIVE',
  `created_by` int UNSIGNED DEFAULT NULL,
  `updated_by` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `st_status`
--

INSERT INTO `st_status` (`id`, `status_description`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'PENDING', 'ACTIVE', 1, NULL, '2020-11-12 20:32:01', NULL, NULL),
(2, 'FOR RECEIVING', 'ACTIVE', NULL, NULL, '2024-02-28 02:33:55', NULL, NULL),
(3, 'REJECTED', 'ACTIVE', NULL, NULL, '2024-02-28 02:41:41', NULL, NULL),
(4, 'RECEIVED', 'ACTIVE', NULL, NULL, '2024-02-28 03:16:49', '2024-02-28 04:16:27', NULL),
(5, 'VOID', 'ACTIVE', NULL, NULL, '2024-02-29 08:32:45', NULL, NULL),
(6, 'FOR SCHEDULE', 'ACTIVE', NULL, NULL, '2024-02-29 09:01:28', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `transaction_type`
--

CREATE TABLE `transaction_type` (
  `id` int UNSIGNED NOT NULL,
  `transaction_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('ACTIVE','INACTIVE') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'ACTIVE',
  `created_by` int UNSIGNED DEFAULT NULL,
  `updated_by` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transaction_type`
--

INSERT INTO `transaction_type` (`id`, `transaction_type`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'STW', 'ACTIVE', 1, NULL, '2021-01-04 22:41:56', NULL, NULL),
(2, 'RMA', 'ACTIVE', 1, NULL, '2021-01-04 22:42:03', NULL, NULL),
(3, 'STW Marketing', 'ACTIVE', 1, NULL, '2021-02-28 21:58:26', NULL, NULL),
(4, 'STS', 'ACTIVE', 1, NULL, '2021-10-03 18:09:57', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `transport_types`
--

CREATE TABLE `transport_types` (
  `id` int UNSIGNED NOT NULL,
  `transport_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('ACTIVE','INACTIVE') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'ACTIVE',
  `created_by` int UNSIGNED DEFAULT NULL,
  `updated_by` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transport_types`
--

INSERT INTO `transport_types` (`id`, `transport_type`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Logistics', 'ACTIVE', 1, NULL, '2021-02-01 19:52:54', NULL, NULL),
(2, 'Hand Carry', 'ACTIVE', 1, NULL, '2021-02-01 19:53:03', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `trip_tickets`
--

CREATE TABLE `trip_tickets` (
  `id` int UNSIGNED NOT NULL,
  `trip_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trip_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stores_id` int UNSIGNED DEFAULT NULL,
  `ref_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trip_qty` int UNSIGNED DEFAULT NULL,
  `plastic_qty` int UNSIGNED DEFAULT NULL,
  `box_qty` int UNSIGNED DEFAULT NULL,
  `is_backload` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `backload_reasons_id` int UNSIGNED DEFAULT NULL,
  `backload_at` datetime DEFAULT NULL,
  `is_received` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `received_at` datetime DEFAULT NULL,
  `is_released` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `released_at` datetime DEFAULT NULL,
  `logistics_personnel` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_personnel` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trip_ticket_statuses_id` int UNSIGNED DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` int UNSIGNED DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trip_tickets`
--

INSERT INTO `trip_tickets` (`id`, `trip_number`, `ref_type`, `trip_type`, `stores_id`, `ref_number`, `trip_qty`, `plastic_qty`, `box_qty`, `is_backload`, `backload_reasons_id`, `backload_at`, `is_received`, `received_at`, `is_released`, `released_at`, `logistics_personnel`, `store_personnel`, `trip_ticket_statuses_id`, `created_date`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_at`) VALUES
(1, 'TRPTCKT16071', 'STS', 'OUT', 291, 'ST-0000023', 25, 1, 1, 0, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, 6, '2024-03-04', '2024-03-04 03:27:55', 8, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `trip_tickets_temp`
--

CREATE TABLE `trip_tickets_temp` (
  `id` int UNSIGNED NOT NULL,
  `trip_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trip_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stores_id` int UNSIGNED DEFAULT NULL,
  `ref_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trip_qty` int UNSIGNED DEFAULT NULL,
  `plastic_qty` int UNSIGNED DEFAULT NULL,
  `box_qty` int UNSIGNED DEFAULT NULL,
  `is_backload` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `backload_reasons_id` int UNSIGNED DEFAULT NULL,
  `backload_at` datetime DEFAULT NULL,
  `is_received` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `received_at` datetime DEFAULT NULL,
  `is_released` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `released_at` datetime DEFAULT NULL,
  `logistics_personnel` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_personnel` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trip_ticket_statuses_id` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` int UNSIGNED DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `trip_ticket_lines`
--

CREATE TABLE `trip_ticket_lines` (
  `id` int UNSIGNED NOT NULL,
  `trip_tickets_id` int UNSIGNED DEFAULT NULL,
  `ref_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trip_qty` int UNSIGNED DEFAULT NULL,
  `plastic_qty` int UNSIGNED DEFAULT NULL,
  `box_qty` int UNSIGNED DEFAULT NULL,
  `is_backload` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `backload_reasons_id` int UNSIGNED DEFAULT NULL,
  `backload_at` datetime DEFAULT NULL,
  `is_received` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `received_at` datetime DEFAULT NULL,
  `is_released` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `released_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `trip_ticket_statuses`
--

CREATE TABLE `trip_ticket_statuses` (
  `id` int UNSIGNED NOT NULL,
  `trip_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trip_type` enum('IN','OUT') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('ACTIVE','INACTIVE') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'ACTIVE',
  `created_by` int UNSIGNED DEFAULT NULL,
  `updated_by` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trip_ticket_statuses`
--

INSERT INTO `trip_ticket_statuses` (`id`, `trip_status`, `trip_type`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Partially Released', 'IN', 'ACTIVE', 1, 1, '2022-04-26 20:01:39', '2022-04-26 20:02:01', NULL),
(2, 'Partially Received', 'OUT', 'ACTIVE', 1, NULL, '2022-04-26 20:01:44', NULL, NULL),
(3, 'Fully Received', 'OUT', 'ACTIVE', 1, NULL, '2022-04-26 20:02:14', NULL, NULL),
(4, 'Fully Released', 'IN', 'ACTIVE', 1, NULL, '2022-04-26 20:02:23', NULL, NULL),
(5, 'Pending', 'IN', 'ACTIVE', 1, NULL, '2022-04-26 20:02:29', NULL, NULL),
(6, 'Pending', 'OUT', 'ACTIVE', 1, NULL, '2022-04-26 20:02:48', NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `approval_matrix`
--
ALTER TABLE `approval_matrix`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `backload_reasons`
--
ALTER TABLE `backload_reasons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cancel_reasons`
--
ALTER TABLE `cancel_reasons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `channel`
--
ALTER TABLE `channel`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_apicustom`
--
ALTER TABLE `cms_apicustom`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_apikey`
--
ALTER TABLE `cms_apikey`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_dashboard`
--
ALTER TABLE `cms_dashboard`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_email_queues`
--
ALTER TABLE `cms_email_queues`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_email_templates`
--
ALTER TABLE `cms_email_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_logs`
--
ALTER TABLE `cms_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_menus`
--
ALTER TABLE `cms_menus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_menus_privileges`
--
ALTER TABLE `cms_menus_privileges`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_moduls`
--
ALTER TABLE `cms_moduls`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_notifications`
--
ALTER TABLE `cms_notifications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_privileges`
--
ALTER TABLE `cms_privileges`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_privileges_roles`
--
ALTER TABLE `cms_privileges_roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_settings`
--
ALTER TABLE `cms_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_statistics`
--
ALTER TABLE `cms_statistics`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms_statistic_components`
--
ALTER TABLE `cms_statistic_components`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `code_counter`
--
ALTER TABLE `code_counter`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customer_type`
--
ALTER TABLE `customer_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `distri_subinventories`
--
ALTER TABLE `distri_subinventories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ebs_pull`
--
ALTER TABLE `ebs_pull`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `order_items_unique` (`line_number`,`ordered_item`,`dr_number`),
  ADD KEY `stores_id` (`stores_id`),
  ADD KEY `locator_id` (`locator_id`),
  ADD KEY `transport_types_id` (`transport_types_id`),
  ADD KEY `ordered_item` (`ordered_item`);

--
-- Indexes for table `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `digits_code` (`digits_code`);

--
-- Indexes for table `locations`
--
ALTER TABLE `locations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pos_pull`
--
ALTER TABLE `pos_pull`
  ADD PRIMARY KEY (`id`),
  ADD KEY `st_document_number` (`st_document_number`),
  ADD KEY `item_code` (`item_code`),
  ADD KEY `transport_types_id` (`transport_types_id`),
  ADD KEY `reason_id` (`reason_id`),
  ADD KEY `channel_id` (`channel_id`),
  ADD KEY `stores_id` (`stores_id`),
  ADD KEY `stores_id_destination` (`stores_id_destination`);

--
-- Indexes for table `pos_pull_headers`
--
ALTER TABLE `pos_pull_headers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `problems`
--
ALTER TABLE `problems`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pullout`
--
ALTER TABLE `pullout`
  ADD PRIMARY KEY (`id`),
  ADD KEY `st_document_number` (`st_document_number`),
  ADD KEY `item_code` (`item_code`),
  ADD KEY `transport_types_id` (`transport_types_id`),
  ADD KEY `reason_id` (`reason_id`),
  ADD KEY `stores_id` (`stores_id`),
  ADD KEY `stores_id_destination` (`stores_id_destination`),
  ADD KEY `channel_id` (`channel_id`);

--
-- Indexes for table `pullout_receivings`
--
ALTER TABLE `pullout_receivings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pullout_receiving_lines`
--
ALTER TABLE `pullout_receiving_lines`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pullout_receiving_serials`
--
ALTER TABLE `pullout_receiving_serials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `reason`
--
ALTER TABLE `reason`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `serials`
--
ALTER TABLE `serials`
  ADD PRIMARY KEY (`id`),
  ADD KEY `serial_number` (`serial_number`),
  ADD KEY `ebs_pull_id` (`ebs_pull_id`),
  ADD KEY `pos_pull_id` (`pos_pull_id`),
  ADD KEY `pullout_id` (`pullout_id`);

--
-- Indexes for table `status_workflows`
--
ALTER TABLE `status_workflows`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `stock_statuses`
--
ALTER TABLE `stock_statuses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `stores`
--
ALTER TABLE `stores`
  ADD PRIMARY KEY (`id`),
  ADD KEY `channel_id` (`channel_id`),
  ADD KEY `customer_type_id` (`customer_type_id`);

--
-- Indexes for table `st_status`
--
ALTER TABLE `st_status`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `transaction_type`
--
ALTER TABLE `transaction_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `transport_types`
--
ALTER TABLE `transport_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `trip_tickets`
--
ALTER TABLE `trip_tickets`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `trip_tickets_temp`
--
ALTER TABLE `trip_tickets_temp`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `trip_ticket_lines`
--
ALTER TABLE `trip_ticket_lines`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `trip_ticket_statuses`
--
ALTER TABLE `trip_ticket_statuses`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `approval_matrix`
--
ALTER TABLE `approval_matrix`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `backload_reasons`
--
ALTER TABLE `backload_reasons`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `cancel_reasons`
--
ALTER TABLE `cancel_reasons`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `channel`
--
ALTER TABLE `channel`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `cms_apicustom`
--
ALTER TABLE `cms_apicustom`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cms_apikey`
--
ALTER TABLE `cms_apikey`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cms_dashboard`
--
ALTER TABLE `cms_dashboard`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_email_queues`
--
ALTER TABLE `cms_email_queues`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_email_templates`
--
ALTER TABLE `cms_email_templates`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cms_logs`
--
ALTER TABLE `cms_logs`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=316;

--
-- AUTO_INCREMENT for table `cms_menus`
--
ALTER TABLE `cms_menus`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;

--
-- AUTO_INCREMENT for table `cms_menus_privileges`
--
ALTER TABLE `cms_menus_privileges`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1321;

--
-- AUTO_INCREMENT for table `cms_moduls`
--
ALTER TABLE `cms_moduls`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

--
-- AUTO_INCREMENT for table `cms_notifications`
--
ALTER TABLE `cms_notifications`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_privileges`
--
ALTER TABLE `cms_privileges`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `cms_privileges_roles`
--
ALTER TABLE `cms_privileges_roles`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=211;

--
-- AUTO_INCREMENT for table `cms_settings`
--
ALTER TABLE `cms_settings`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `cms_statistics`
--
ALTER TABLE `cms_statistics`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `cms_statistic_components`
--
ALTER TABLE `cms_statistic_components`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

--
-- AUTO_INCREMENT for table `code_counter`
--
ALTER TABLE `code_counter`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `customer_type`
--
ALTER TABLE `customer_type`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `distri_subinventories`
--
ALTER TABLE `distri_subinventories`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `ebs_pull`
--
ALTER TABLE `ebs_pull`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `items`
--
ALTER TABLE `items`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35681;

--
-- AUTO_INCREMENT for table `locations`
--
ALTER TABLE `locations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=158;

--
-- AUTO_INCREMENT for table `pos_pull`
--
ALTER TABLE `pos_pull`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `pos_pull_headers`
--
ALTER TABLE `pos_pull_headers`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `problems`
--
ALTER TABLE `problems`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `pullout`
--
ALTER TABLE `pullout`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pullout_receivings`
--
ALTER TABLE `pullout_receivings`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pullout_receiving_lines`
--
ALTER TABLE `pullout_receiving_lines`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pullout_receiving_serials`
--
ALTER TABLE `pullout_receiving_serials`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reason`
--
ALTER TABLE `reason`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

--
-- AUTO_INCREMENT for table `serials`
--
ALTER TABLE `serials`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `status_workflows`
--
ALTER TABLE `status_workflows`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=140;

--
-- AUTO_INCREMENT for table `stock_statuses`
--
ALTER TABLE `stock_statuses`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stores`
--
ALTER TABLE `stores`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=301;

--
-- AUTO_INCREMENT for table `st_status`
--
ALTER TABLE `st_status`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `transaction_type`
--
ALTER TABLE `transaction_type`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `transport_types`
--
ALTER TABLE `transport_types`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `trip_tickets`
--
ALTER TABLE `trip_tickets`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `trip_tickets_temp`
--
ALTER TABLE `trip_tickets_temp`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `trip_ticket_lines`
--
ALTER TABLE `trip_ticket_lines`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `trip_ticket_statuses`
--
ALTER TABLE `trip_ticket_statuses`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

