INSERT INTO `member_main_data_image` (`id`, `md_id`, `image_url`, `created_at`) VALUES
(6, 15, '[encoded data, 49116 characters]', '2024-03-27 09:07:51');
INSERT INTO `member_main_data_image` (`id`, `md_id`, `image_url`, `created_at`) VALUES
(7, 19, '[encoded data, 80912 characters]', '2024-04-16 12:14:18');
INSERT INTO `member_main_data_image` (`id`, `md_id`, `image_url`, `created_at`) VALUES
(8, 20, '[encoded data, 94872 characters]', '2024-05-17 10:12:00');

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

--
-- Table structure for table `member_note`
--

CREATE TABLE `member_note` (
  `n_id` int(11) NOT NULL,
  `md_id` int(11) NOT NULL,
  `typeOfNote` int(11) NOT NULL,
  `priority` varchar(255) NOT NULL,
  `subject` varchar(500) NOT NULL,
  `note` varchar(500) NOT NULL,
  `document` text DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_note`
--

INSERT INTO `member_note` (`n_id`, `md_id`, `typeOfNote`, `priority`, `subject`, `note`, `document`, `created_at`, `updated_at`) VALUES
(3, 12, 1, 'Normal', 'any', 'note', 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/March/Images/images%20%2816%29.jpeg', '2024-03-20 10:32:11', '2024-10-08 17:29:21'),
(4, 41, 3, 'Normal', 'Note on membership application', 'Additional member details and preferences', NULL, '2024-05-28 19:00:31', '2024-10-08 17:29:25'),
(8, 45, 2, 'Normal', 'Note on membership application', 'description', NULL, '2024-05-30 14:08:31', '2024-10-08 17:29:27'),
(10, 47, 1, 'Normal', 'Note on membership application', 'description', NULL, '2024-06-04 11:59:42', '2024-10-08 17:29:32'),
(12, 49, 1, 'Normal', 'Note on membership application', 'test', NULL, '2024-06-20 18:30:17', '2024-10-08 17:29:34'),
(13, 50, 2, 'Normal', 'Note on membership application', 'became the first recorded victim of an automobile accident; the car involved was steam-powered', NULL, '2024-06-21 17:47:01', '2024-10-08 17:29:37'),
(15, 63, 3, 'Normal', 'Note on membership application', 'test2@yopmail.com', NULL, '2024-06-27 18:18:46', '2024-10-08 17:29:40'),
(16, 64, 1, 'Normal', 'Note on membership application', 'test@yopmail.com', NULL, '2024-06-27 18:21:28', '2024-10-08 17:29:42'),
(17, 65, 1, 'Normal', 'Note on membership application', 'testUser27@mailinator.com', NULL, '2024-07-05 10:36:53', '2024-10-08 17:29:45'),
(18, 72, 1, 'Normal', 'Note on membership application', 'crm.aug1401@yopmail.com', NULL, '2024-08-14 13:15:42', '2024-10-08 17:29:48'),
(19, 63, 3, 'Normal', 'Test ', 'note test', 'null', '2024-10-08 12:27:38', NULL),
(20, 127, 0, 'Normal', 'Note on membership application', 'check123@yopmail.com', NULL, '2024-10-18 15:52:36', NULL),
(21, 128, 0, 'Normal', 'Note on membership application', 'check18@yopmail.com', NULL, '2024-10-18 15:55:39', NULL),
(22, 129, 13, 'Normal', 'Note on membership application', 'tet1801@yopmail.com', NULL, '2024-10-18 15:59:48', NULL);

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

--
-- Table structure for table `member_payment_mandateReference`
--

CREATE TABLE `member_payment_mandateReference` (
  `id` int(11) NOT NULL,
  `payment_id` int(11) NOT NULL,
  `md_id` int(11) NOT NULL,
  `debit_mandate_available` int(11) NOT NULL DEFAULT 0 COMMENT '0 - unchecked,\r\n1 - checked',
  `mandate_document` text DEFAULT NULL,
  `signature_date` date NOT NULL,
  `effective_date` date NOT NULL,
  `characteristic` int(11) NOT NULL,
  `Notification` date DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_payment_mandateReference`
--

INSERT INTO `member_payment_mandateReference` (`id`, `payment_id`, `md_id`, `debit_mandate_available`, `mandate_document`, `signature_date`, `effective_date`, `characteristic`, `Notification`, `created_at`, `updated_at`) VALUES
(3, 1, 19, 0, 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/April/Documents/Free_Test_Data_500KB_PDF.pdf', '2024-02-03', '2027-02-02', 1, '2024-03-03', '2024-04-29 05:26:17', '2024-05-15 15:11:19'),
(4, 1, 19, 0, 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/April/Images/Tennisspielerin.jpeg', '2024-02-03', '2027-02-02', 1, '2024-03-03', '2024-04-29 05:28:05', '2024-05-15 15:11:21'),
(9, 6, 25, 1, NULL, '2024-04-04', '2024-05-16', 0, '2024-05-14', '2024-05-14 12:38:41', '2024-05-15 15:11:26'),
(10, 7, 24, 0, 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/May/Documents/SamplePPTFile.ppt', '2021-05-15', '2027-05-14', 1, '2024-05-15', '2024-05-15 09:08:35', '2024-05-15 10:09:00');

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

--
-- Table structure for table `member_periods`
--

CREATE TABLE `member_periods` (
  `p_id` int(11) NOT NULL,
  `md_id` int(11) NOT NULL,
  `startDate` date NOT NULL,
  `endDate` date NOT NULL,
  `description` varchar(500) NOT NULL,
  `period` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_periods`
--

INSERT INTO `member_periods` (`p_id`, `md_id`, `startDate`, `endDate`, `description`, `period`, `created_at`, `updated_at`) VALUES
(1, 25, '2023-01-23', '2023-01-23', 'description update', 'Period', '2024-02-08 13:34:30', NULL),
(2, 25, '2023-01-24', '2023-01-25', 'description up', 'Period', '2024-02-09 04:11:10', NULL),
(4, 12, '2024-03-20', '2024-03-23', 'Description', 'Absen for 1 week', '2024-03-20 08:24:09', '2024-03-20 08:26:12');

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

--
-- Table structure for table `member_Post_data`
--

CREATE TABLE `member_Post_data` (
  `post_id` int(11) NOT NULL,
  `md_id` int(11) NOT NULL,
  `contribution_id` bigint(20) NOT NULL,
  `post_startDate` date NOT NULL,
  `post_endDate` date NOT NULL,
  `variable_contribution` int(11) NOT NULL COMMENT '0- unchecked,\r\n1 - checked\r\n',
  `basic_amount` decimal(10,2) DEFAULT NULL,
  `Formula` varchar(500) DEFAULT NULL COMMENT '(Basic amount) * 1 ',
  `finalAmount` decimal(10,2) DEFAULT NULL,
  `paymentMethod` varchar(500) DEFAULT NULL,
  `blockBasicAmount` bigint(20) DEFAULT NULL COMMENT '0- unchecked,\r\n1 -checked',
  `blockPayment` bigint(20) DEFAULT NULL COMMENT '0- unchecked,\r\n1 -checked',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `member_prefix`
--

CREATE TABLE `member_prefix` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `memberPrefix` varchar(20) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_prefix`
--

INSERT INTO `member_prefix` (`id`, `user_id`, `memberPrefix`, `created_at`, `updated_at`) VALUES
(5, 41585, '2024', '2024-06-27 15:10:01', NULL),
(6, 41591, 'u2024', '2024-06-27 16:23:22', '2024-06-27 17:40:47'),
(7, 41496, '232ewdfsf', '2024-06-28 10:24:10', '2024-06-28 10:30:33');

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

--
-- Table structure for table `member_selected_departments`
--

CREATE TABLE `member_selected_departments` (
  `id` int(11) NOT NULL,
  `md_id` int(11) NOT NULL,
  `department_id` int(11) NOT NULL,
  `department_entry_on` date DEFAULT NULL,
  `leaving_department_on` date DEFAULT NULL,
  `reason_for_leaving` varchar(500) DEFAULT NULL,
  `status` int(11) DEFAULT NULL COMMENT '1- active,\r\n0- Passive\r\n',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_selected_departments`
--

INSERT INTO `member_selected_departments` (`id`, `md_id`, `department_id`, `department_entry_on`, `leaving_department_on`, `reason_for_leaving`, `status`, `created_at`, `updated_at`) VALUES
(2, 12, 1, '2024-03-18', '2024-03-28', 'reason', 0, '2024-03-18 11:51:26', '2024-03-18 12:04:05'),
(9, 66, 43, NULL, NULL, NULL, NULL, '2024-07-05 06:43:07', NULL),
(10, 66, 42, '2024-07-05', '2024-07-05', '', 1, '2024-07-05 06:45:12', NULL),
(16, 72, 42, '2024-08-14', NULL, NULL, 1, '2024-08-14 07:45:42', NULL),
(17, 125, 35, '2024-10-18', NULL, NULL, 1, '2024-10-18 08:00:02', NULL),
(18, 126, 35, '2024-10-18', NULL, NULL, 1, '2024-10-18 08:06:25', NULL),
(19, 127, 35, '2024-10-18', NULL, NULL, 1, '2024-10-18 10:22:36', NULL),
(20, 128, 35, '2024-10-18', NULL, NULL, 1, '2024-10-18 10:25:39', NULL),
(21, 129, 35, '2024-10-18', NULL, NULL, 1, '2024-10-18 10:29:48', NULL),
(22, 129, 42, '2024-10-18', NULL, NULL, 1, '2024-10-18 10:29:48', NULL);

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

--
-- Table structure for table `order_billwerk`
--

CREATE TABLE `order_billwerk` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` varchar(64) NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `planId` varchar(255) DEFAULT NULL,
  `planVariantId` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `data` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `order_billwerk`
--

INSERT INTO `order_billwerk` (`id`, `order_id`, `quantity`, `planId`, `planVariantId`, `created_at`, `data`) VALUES
(136, '6488201200de15f33402ea4a', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-13 07:51:48', '{\"Id\":\"6488201200de15f33402ea4a\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648820126e38c82b1af07c18\",\"LastBillingDate\":\"2023-06-13T07:51:46.1260000Z\",\"NextBillingDate\":\"2023-07-13T07:51:46.1260000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648820126e38c82b1af07c17\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"Mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T07:51:46.1260000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-13T07:51:46.1260000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T07:51:46.1260000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-13T07:51:46.1260000Z\",\"EndDate\":\"2023-07-13T07:51:46.1260000Z\",\"BilledUntil\":\"2023-07-13T07:51:46.1260000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-13T07:51:46.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648820126e38c82b1af07c17\",\"ContractId\":\"648820126e38c82b1af07c18\",\"Customer\":{\"CompanyName\":\"Mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"Herr@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(137, '648822e200e540a049b25d29', NULL, '624d58bced3240ead946eac4', '624d591bc926ef3dec5f5722', '2023-06-13 08:03:47', '{\"Id\":\"648822e200e540a049b25d29\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648822e26e38c82b1af0d4c7\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":6.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-13T08:03:45.6200000Z\",\"PeriodEnd\":\"2024-06-13T08:03:45.6200000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"624d591bc926ef3dec5f5722\",\"TotalNet\":69.6,\"TotalVat\":13.2,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":82.8,\"ProductDescription\":\"Online-Vereinsverwaltung für Vereine mit max. 99 Mitgliedern: \\n6,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648820126e38c82b1af07c18\",\"LastBillingDate\":\"2023-06-13T08:03:45.6200000Z\",\"NextBillingDate\":\"2024-06-13T08:03:45.6200000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648820126e38c82b1af07c17\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"Mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T07:51:46.1260000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-13T08:02:44.9430000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T08:03:45.6200000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T08:03:45.6200000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-13T07:51:46.1260000Z\",\"BilledUntil\":\"2024-06-13T08:03:45.6200000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":69.6,\"TotalVat\":13.2,\"TotalGross\":82.8,\"NextTotalGross\":82.8,\"NextTotalGrossDate\":\"2024-06-13T08:03:45.6200000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-13T08:03:46.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung SMALL\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-13T08:03:45.6200000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648820126e38c82b1af07c17\",\"ContractId\":\"648820126e38c82b1af07c18\",\"Customer\":{\"CompanyName\":\"Mangoit\",\"FirstName\":\"Herr\",\"LastName\":\"Eckehard\",\"EmailAddress\":\"Herr@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Kennedystrasse 62\",\"PostalCode\":\"63477\",\"City\":\"germany\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Kennedystrasse 62\",\"FormattedCityAddressLine\":\"63477 germany\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(138, '64883cb9fbc64bf83b3b347c', NULL, '624d58bced3240ead946eac4', '624d5901c926ef3dec5f56d2', '2023-06-13 09:54:03', '{\"Id\":\"64883cb9fbc64bf83b3b347c\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"64883cb9bc0df2b56fb0e24f\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":13.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-13T09:54:01.5540000Z\",\"PeriodEnd\":\"2024-06-13T09:54:01.5540000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"624d5901c926ef3dec5f56d2\",\"TotalNet\":140.16,\"TotalVat\":26.64,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":166.8,\"ProductDescription\":\"Online-Vereinsverwaltung für Vereine, inkl. DATEV-Schnittstelle:  \\n13,90€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648820126e38c82b1af07c18\",\"LastBillingDate\":\"2023-06-13T09:54:01.5540000Z\",\"NextBillingDate\":\"2024-06-13T09:54:01.5540000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648820126e38c82b1af07c17\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T07:51:46.1260000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-13T08:02:44.9430000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T08:03:45.6200000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-13T08:26:20.3350000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T09:54:01.5540000Z\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"Mangoit\",\"IBAN\":\"DE91100000000123456789\",\"MandateReference\":\"648822-e4891d-3da325-c3dcf8\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman =   MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-13T08:03:48.3890000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T09:54:01.5540000Z\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-13T07:51:46.1260000Z\",\"BilledUntil\":\"2024-06-13T09:54:01.5540000Z\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":140.16,\"TotalVat\":26.64,\"TotalGross\":166.8,\"NextTotalGross\":166.8,\"NextTotalGrossDate\":\"2024-06-13T09:54:01.5540000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-13T09:54:01.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-13T09:54:01.5540000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648820126e38c82b1af07c17\",\"ContractId\":\"648820126e38c82b1af07c18\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Herr\",\"LastName\":\"Eckehard\",\"EmailAddress\":\"Herr@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Kennedystrasse 62\",\"PostalCode\":\"63477\",\"City\":\"germany\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Kennedystrasse 62\",\"FormattedCityAddressLine\":\"63477 germany\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(139, '648847201e1ce920baf3ec0f', NULL, '624d58bced3240ead946eac4', '648040036051424d14298576', '2023-06-13 10:38:26', '{\"Id\":\"648847201e1ce920baf3ec0f\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"64884720891d3da325c4ef6f\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":19.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-13T10:38:24.3180000Z\",\"PeriodEnd\":\"2024-06-13T10:38:24.3180000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"648040036051424d14298576\",\"TotalNet\":200.64,\"TotalVat\":38.16,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":238.8,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud® | Start\\n19,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648820126e38c82b1af07c18\",\"LastBillingDate\":\"2023-06-13T10:38:24.3180000Z\",\"NextBillingDate\":\"2024-06-13T10:38:24.3180000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648820126e38c82b1af07c17\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T07:51:46.1260000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-13T08:02:44.9430000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T08:03:45.6200000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-13T08:26:20.3350000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T10:38:24.3180000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"Mangoit\",\"IBAN\":\"DE91100000000123456789\",\"MandateReference\":\"648822-e4891d-3da325-c3dcf8\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman =   MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-13T08:03:48.3890000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T10:38:24.3180000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-13T07:51:46.1260000Z\",\"BilledUntil\":\"2024-06-13T10:38:24.3180000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":200.64,\"TotalVat\":38.16,\"TotalGross\":238.8,\"NextTotalGross\":238.8,\"NextTotalGrossDate\":\"2024-06-13T10:38:24.3180000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-13T10:38:24.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung + App Light\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-13T10:38:24.3180000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648820126e38c82b1af07c17\",\"ContractId\":\"648820126e38c82b1af07c18\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Herr\",\"LastName\":\"Eckehard\",\"EmailAddress\":\"Herr@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Kennedystrasse 62\",\"PostalCode\":\"63477\",\"City\":\"germany\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Kennedystrasse 62\",\"FormattedCityAddressLine\":\"63477 germany\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(140, '6488476e4c5c3e16d87b1a1b', NULL, '624d58bced3240ead946eac4', '648040316051424d142986bc', '2023-06-13 10:39:44', '{\"Id\":\"6488476e4c5c3e16d87b1a1b\",\"PlanVariantId\":\"648040316051424d142986bc\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"6488476e891d3da325c4f19f\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":39.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-13T10:39:41.7910000Z\",\"PeriodEnd\":\"2024-06-13T10:39:41.7910000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"648040316051424d142986bc\",\"TotalNet\":402.36,\"TotalVat\":76.44,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":478.8,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud®\\n39,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648820126e38c82b1af07c18\",\"LastBillingDate\":\"2023-06-13T10:39:41.7910000Z\",\"NextBillingDate\":\"2024-06-13T10:39:41.7910000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648820126e38c82b1af07c17\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T07:51:46.1260000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-13T08:02:44.9430000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T08:03:45.6200000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-13T08:26:20.3350000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T10:39:41.7910000Z\",\"PlanVariantId\":\"648040316051424d142986bc\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"Mangoit\",\"IBAN\":\"DE91100000000123456789\",\"MandateReference\":\"648822-e4891d-3da325-c3dcf8\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman =   MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-13T08:03:48.3890000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T10:39:41.7910000Z\",\"PlanVariantId\":\"648040316051424d142986bc\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-13T07:51:46.1260000Z\",\"BilledUntil\":\"2024-06-13T10:39:41.7910000Z\",\"PlanVariantId\":\"648040316051424d142986bc\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":402.36,\"TotalVat\":76.44,\"TotalGross\":478.8,\"NextTotalGross\":478.8,\"NextTotalGrossDate\":\"2024-06-13T10:39:41.7910000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-13T10:39:42.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung + verein.cloud®\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-13T10:39:41.7910000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648820126e38c82b1af07c17\",\"ContractId\":\"648820126e38c82b1af07c18\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Herr\",\"LastName\":\"Eckehard\",\"EmailAddress\":\"Herr@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Kennedystrasse 62\",\"PostalCode\":\"63477\",\"City\":\"germany\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Kennedystrasse 62\",\"FormattedCityAddressLine\":\"63477 germany\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(141, '648848322bca2d20922aea71', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-13 10:43:00', '{\"Id\":\"648848322bca2d20922aea71\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"64884832891d3da325c4f46c\",\"LastBillingDate\":\"2023-06-13T10:42:58.1660000Z\",\"NextBillingDate\":\"2023-07-13T10:42:58.1660000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"64884832891d3da325c4f46b\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T10:42:58.1660000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-13T10:42:58.1660000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T10:42:58.1660000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-13T10:42:58.1660000Z\",\"EndDate\":\"2023-07-13T10:42:58.1660000Z\",\"BilledUntil\":\"2023-07-13T10:42:58.1660000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-13T10:42:58.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"64884832891d3da325c4f46b\",\"ContractId\":\"64884832891d3da325c4f46c\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"Sonya@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(142, '6488492cdfb6190ceccb0dbc', NULL, '624d58bced3240ead946eac4', '624d591bc926ef3dec5f5722', '2023-06-13 10:47:11', '{\"Id\":\"6488492cdfb6190ceccb0dbc\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"6488492cbc0df2b56fb187bc\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":6.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-13T10:47:08.5310000Z\",\"PeriodEnd\":\"2024-06-13T10:47:08.5310000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"624d591bc926ef3dec5f5722\",\"TotalNet\":69.6,\"TotalVat\":13.2,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":82.8,\"ProductDescription\":\"Online-Vereinsverwaltung für Vereine mit max. 99 Mitgliedern: \\n6,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"64884832891d3da325c4f46c\",\"LastBillingDate\":\"2023-06-13T10:47:08.5310000Z\",\"NextBillingDate\":\"2024-06-13T10:47:08.5310000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"64884832891d3da325c4f46b\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T10:42:58.1660000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-13T10:46:05.0180000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T10:47:08.5310000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T10:47:08.5310000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-13T10:42:58.1660000Z\",\"BilledUntil\":\"2024-06-13T10:47:08.5310000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":69.6,\"TotalVat\":13.2,\"TotalGross\":82.8,\"NextTotalGross\":82.8,\"NextTotalGrossDate\":\"2024-06-13T10:47:08.5310000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-13T10:47:08.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung SMALL\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-13T10:47:08.5310000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"64884832891d3da325c4f46b\",\"ContractId\":\"64884832891d3da325c4f46c\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Sonya\",\"LastName\":\"Nienow\",\"EmailAddress\":\"Sonya@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"4411 Hwy 7 W\",\"PostalCode\":\"50021\",\"City\":\"test\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"4411 Hwy 7 W\",\"FormattedCityAddressLine\":\"50021 test\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(143, '64886f0ede8d67e34a7f0708', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-13 13:28:47', '{\"Id\":\"64886f0ede8d67e34a7f0708\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"64886f0e891d3da325c5ab22\",\"LastBillingDate\":\"2023-06-13T13:28:46.1600000Z\",\"NextBillingDate\":\"2023-07-13T13:28:46.1600000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"64886f0e891d3da325c5ab21\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T13:28:46.1600000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-13T13:28:46.1600000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T13:28:46.1600000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-13T13:28:46.1600000Z\",\"EndDate\":\"2023-07-13T13:28:46.1600000Z\",\"BilledUntil\":\"2023-07-13T13:28:46.1600000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-13T13:28:46.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"64886f0e891d3da325c5ab21\",\"ContractId\":\"64886f0e891d3da325c5ab22\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"Lechner@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(144, '6488700853bd3abf7cca8636', NULL, '624d58bced3240ead946eac4', '624d591bc926ef3dec5f5722', '2023-06-13 13:32:58', '{\"Id\":\"6488700853bd3abf7cca8636\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"64887008891d3da325c5aedd\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":6.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-13T13:32:55.9560000Z\",\"PeriodEnd\":\"2024-06-13T13:32:55.9560000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"624d591bc926ef3dec5f5722\",\"TotalNet\":69.6,\"TotalVat\":13.2,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":82.8,\"ProductDescription\":\"Online-Vereinsverwaltung für Vereine mit max. 99 Mitgliedern: \\n6,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"64886f0e891d3da325c5ab22\",\"LastBillingDate\":\"2023-06-13T13:32:55.9560000Z\",\"NextBillingDate\":\"2024-06-13T13:32:55.9560000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"64886f0e891d3da325c5ab21\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T13:28:46.1600000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-13T13:31:45.8220000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T13:32:55.9560000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-13T13:32:55.9560000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-13T13:28:46.1600000Z\",\"BilledUntil\":\"2024-06-13T13:32:55.9560000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":69.6,\"TotalVat\":13.2,\"TotalGross\":82.8,\"NextTotalGross\":82.8,\"NextTotalGrossDate\":\"2024-06-13T13:32:55.9560000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-13T13:32:56.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung SMALL\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-13T13:32:55.9560000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"64886f0e891d3da325c5ab21\",\"ContractId\":\"64886f0e891d3da325c5ab22\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Ulrich\",\"LastName\":\"Lechner\",\"EmailAddress\":\"Lechner@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Hainallee 2\",\"PostalCode\":\"35781\",\"City\":\"germany\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Hainallee 2\",\"FormattedCityAddressLine\":\"35781 germany\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(145, '6489838591c8fde51a42b14d', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-14 09:08:24', '{\"Id\":\"6489838591c8fde51a42b14d\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648983850740d3bf59392288\",\"LastBillingDate\":\"2023-06-14T09:08:21.8430000Z\",\"NextBillingDate\":\"2023-07-14T09:08:21.8430000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648983850740d3bf59392287\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-14T09:08:21.8430000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-14T09:08:21.8430000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-14T09:08:21.8430000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-14T09:08:21.8430000Z\",\"EndDate\":\"2023-07-14T09:08:21.8430000Z\",\"BilledUntil\":\"2023-07-14T09:08:21.8430000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-14T09:08:21.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648983850740d3bf59392287\",\"ContractId\":\"648983850740d3bf59392288\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"Ellen@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(146, '648984b88f0ea49b31146cc3', NULL, '624d58bced3240ead946eac4', '624d591bc926ef3dec5f5722', '2023-06-14 09:13:29', '{\"Id\":\"648984b88f0ea49b31146cc3\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648984b80740d3bf59392c31\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":6.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-14T09:13:27.7190000Z\",\"PeriodEnd\":\"2024-06-14T09:13:27.7190000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"624d591bc926ef3dec5f5722\",\"TotalNet\":69.6,\"TotalVat\":13.2,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":82.8,\"ProductDescription\":\"Online-Vereinsverwaltung für Vereine mit max. 99 Mitgliedern: \\n6,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648983850740d3bf59392288\",\"LastBillingDate\":\"2023-06-14T09:13:27.7190000Z\",\"NextBillingDate\":\"2024-06-14T09:13:27.7190000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648983850740d3bf59392287\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-14T09:08:21.8430000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-14T09:12:34.6190000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-14T09:13:27.7190000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-14T09:13:27.7190000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-14T09:08:21.8430000Z\",\"BilledUntil\":\"2024-06-14T09:13:27.7190000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":69.6,\"TotalVat\":13.2,\"TotalGross\":82.8,\"NextTotalGross\":82.8,\"NextTotalGrossDate\":\"2024-06-14T09:13:27.7190000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-14T09:13:28.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung SMALL\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-14T09:13:27.7190000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648983850740d3bf59392287\",\"ContractId\":\"648983850740d3bf59392288\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"ellen\",\"LastName\":\"Jürgens\",\"EmailAddress\":\"Ellen@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Frankenallee 28\",\"PostalCode\":\"65779\",\"City\":\"Hesse\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Frankenallee 28\",\"FormattedCityAddressLine\":\"65779 Hesse\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(147, '648985d6d548ae85b683d887', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-14 09:18:16', '{\"Id\":\"648985d6d548ae85b683d887\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648985d62362e072ce1a3380\",\"LastBillingDate\":\"2023-06-14T09:18:14.7420000Z\",\"NextBillingDate\":\"2023-07-14T09:18:14.7420000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648985d62362e072ce1a337f\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-14T09:18:14.7420000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-14T09:18:14.7420000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-14T09:18:14.7420000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-14T09:18:14.7420000Z\",\"EndDate\":\"2023-07-14T09:18:14.7420000Z\",\"BilledUntil\":\"2023-07-14T09:18:14.7420000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-14T09:18:14.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648985d62362e072ce1a337f\",\"ContractId\":\"648985d62362e072ce1a3380\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"Lilly@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(148, '648986de357bbbafdaeddc6b', NULL, '624d58bced3240ead946eac4', '648040036051424d14298576', '2023-06-14 09:22:41', '{\"Id\":\"648986de357bbbafdaeddc6b\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648986de2362e072ce1a3d11\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":19.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-14T09:22:37.6850000Z\",\"PeriodEnd\":\"2024-06-14T09:22:37.6850000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"648040036051424d14298576\",\"TotalNet\":200.64,\"TotalVat\":38.16,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":238.8,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud® | Start\\n19,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648985d62362e072ce1a3380\",\"LastBillingDate\":\"2023-06-14T09:22:37.6850000Z\",\"NextBillingDate\":\"2024-06-14T09:22:37.6850000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648985d62362e072ce1a337f\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-14T09:18:14.7420000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-14T09:21:30.4360000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-14T09:22:37.6850000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-14T09:22:37.6850000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-14T09:18:14.7420000Z\",\"BilledUntil\":\"2024-06-14T09:22:37.6850000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":200.64,\"TotalVat\":38.16,\"TotalGross\":238.8,\"NextTotalGross\":238.8,\"NextTotalGrossDate\":\"2024-06-14T09:22:37.6850000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-14T09:22:38.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung + App Light\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-14T09:22:37.6850000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648985d62362e072ce1a337f\",\"ContractId\":\"648985d62362e072ce1a3380\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Lilly\",\"LastName\":\"Hauser-Pape\",\"EmailAddress\":\"Lilly@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Boelckestrasse 70\",\"PostalCode\":\"55252\",\"City\":\"Wiesbaden\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Boelckestrasse 70\",\"FormattedCityAddressLine\":\"55252 Wiesbaden\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}');
INSERT INTO `order_billwerk` (`id`, `order_id`, `quantity`, `planId`, `planVariantId`, `created_at`, `data`) VALUES
(149, '6489871dd1e3d55d29e4ee25', NULL, '624d58bced3240ead946eac4', '624d591bc926ef3dec5f5722', '2023-06-14 09:23:43', '{\"Id\":\"6489871dd1e3d55d29e4ee25\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"6489871d2362e072ce1a3f97\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":6.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-14T09:23:41.1380000Z\",\"PeriodEnd\":\"2024-06-14T09:23:41.1380000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"624d591bc926ef3dec5f5722\",\"TotalNet\":69.6,\"TotalVat\":13.2,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":82.8,\"ProductDescription\":\"Online-Vereinsverwaltung für Vereine mit max. 99 Mitgliedern: \\n6,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"},{\"Id\":\"000000000000000000000000\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":-11.999976,\"PricePerUnit\":19.9,\"VatPercentage\":19,\"PeriodStart\":\"2024-06-14T09:22:37.6850000Z\",\"PeriodEnd\":\"2023-06-14T09:23:41.1380000Z\",\"PeriodMultiplier\":-11.999976,\"ScaleAmount\":1,\"ProductId\":\"648040036051424d14298576\",\"TotalNet\":-200.64,\"TotalVat\":-38.16,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":-238.8,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud® | Start\\n19,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648985d62362e072ce1a3380\",\"LastBillingDate\":\"2023-06-14T09:23:41.1380000Z\",\"NextBillingDate\":\"2024-06-14T09:23:41.1380000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648985d62362e072ce1a337f\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-14T09:18:14.7420000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-14T09:21:30.4360000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-14T09:22:37.6850000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-14T09:23:41.1380000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"mangoit\",\"IBAN\":\"AD1400080001001234567890\",\"MandateReference\":\"648986-e12362-e072ce-1a3d24\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman =    MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-14T09:22:41.6370000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-14T09:23:41.1380000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-14T09:18:14.7420000Z\",\"BilledUntil\":\"2024-06-14T09:23:41.1380000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":-131.04,\"TotalVat\":-24.96,\"TotalGross\":-156,\"NextTotalGross\":82.8,\"NextTotalGrossDate\":\"2024-06-14T09:23:41.1380000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-14T09:23:41.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung SMALL\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-14T09:23:41.1380000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648985d62362e072ce1a337f\",\"ContractId\":\"648985d62362e072ce1a3380\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Lilly\",\"LastName\":\"Hauser-Pape\",\"EmailAddress\":\"Lilly@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Boelckestrasse 70\",\"PostalCode\":\"55252\",\"City\":\"Wiesbaden\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Boelckestrasse 70\",\"FormattedCityAddressLine\":\"55252 Wiesbaden\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(150, '648aa570932907430fc36096', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-15 05:45:23', '{\"Id\":\"648aa570932907430fc36096\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648aa570bb5c66bc3928a744\",\"LastBillingDate\":\"2023-06-15T05:45:20.3980000Z\",\"NextBillingDate\":\"2023-07-15T05:45:20.3980000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648aa570bb5c66bc3928a743\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T05:45:20.3980000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-15T05:45:20.3980000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T05:45:20.3980000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T05:45:20.3980000Z\",\"EndDate\":\"2023-07-15T05:45:20.3980000Z\",\"BilledUntil\":\"2023-07-15T05:45:20.3980000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T05:45:20.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648aa570bb5c66bc3928a743\",\"ContractId\":\"648aa570bb5c66bc3928a744\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"Isabella@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(151, '648aa6b358bf26bc9ec7e4ee', NULL, '624d58bced3240ead946eac4', '648040036051424d14298576', '2023-06-15 05:50:45', '{\"Id\":\"648aa6b358bf26bc9ec7e4ee\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648aa6b3825aa184b3ddd69a\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":19.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T05:50:43.3840000Z\",\"PeriodEnd\":\"2024-06-15T05:50:43.3840000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"648040036051424d14298576\",\"TotalNet\":200.64,\"TotalVat\":38.16,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":238.8,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud® | Start\\n19,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648aa570bb5c66bc3928a744\",\"LastBillingDate\":\"2023-06-15T05:50:43.3840000Z\",\"NextBillingDate\":\"2024-06-15T05:50:43.3840000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648aa570bb5c66bc3928a743\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T05:45:20.3980000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T05:49:23.1340000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T05:50:43.3840000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T05:50:43.3840000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T05:45:20.3980000Z\",\"BilledUntil\":\"2024-06-15T05:50:43.3840000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":200.64,\"TotalVat\":38.16,\"TotalGross\":238.8,\"NextTotalGross\":238.8,\"NextTotalGrossDate\":\"2024-06-15T05:50:43.3840000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T05:50:43.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung + App Light\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T05:50:43.3840000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648aa570bb5c66bc3928a743\",\"ContractId\":\"648aa570bb5c66bc3928a744\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Isabella\",\"LastName\":\"Schulte\",\"EmailAddress\":\"Isabella@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Hopfengarten 1\",\"PostalCode\":\"65795\",\"City\":\"Hesse\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Hopfengarten 1\",\"FormattedCityAddressLine\":\"65795 Hesse\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(152, '648aa910ea3465d577a2cfc7', 1, NULL, NULL, '2023-06-15 06:00:48', '{\"Id\":\"648aa910ea3465d577a2cfc7\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648aa910825aa184b3dddbda\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":0.999981,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T06:00:48.0440000Z\",\"PeriodEnd\":\"2024-06-15T05:50:43.3840000Z\",\"PeriodMultiplier\":0.999981,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":292.43,\"TotalVat\":55.56,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648aa910825aa184b3dddbd7\",\"TotalGross\":347.99,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[{\"ComponentType\":\"QuantityBased\",\"PreventModification\":false,\"VatPercentage\":0,\"TotalNet\":0,\"TotalVat\":0,\"IsQuantityBased\":false,\"StartDate\":\"2023-06-15T06:00:48.0440000Z\",\"ComponentId\":\"63e0b88dc84ad323253cc9fb\",\"Quantity\":1}],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648aa570bb5c66bc3928a744\",\"LastBillingDate\":\"2023-06-15T05:50:43.3840000Z\",\"NextBillingDate\":\"2024-06-15T05:50:43.3840000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648aa570bb5c66bc3928a743\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T05:45:20.3980000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T05:49:23.1340000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T05:50:43.3840000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"mangoit\",\"IBAN\":\"DE91100000000123456789\",\"MandateReference\":\"648aa6-b6bb5c-66bc39-28adff\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman =   MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-15T05:50:46.1980000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T05:50:43.3840000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T05:45:20.3980000Z\",\"BilledUntil\":\"2024-06-15T05:50:43.3840000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":292.43,\"TotalVat\":55.56,\"TotalGross\":347.99,\"NextTotalGross\":586.8,\"NextTotalGrossDate\":\"2024-06-15T05:50:43.3840000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T06:00:48.0000000Z\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T06:00:48.0440000Z\",\"TriggerInterimBilling\":true,\"CustomerId\":\"648aa570bb5c66bc3928a743\",\"ContractId\":\"648aa570bb5c66bc3928a744\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Isabella\",\"LastName\":\"Schulte\",\"EmailAddress\":\"Isabella@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Hopfengarten 1\",\"PostalCode\":\"65795\",\"City\":\"Hesse\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Hopfengarten 1\",\"FormattedCityAddressLine\":\"65795 Hesse\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(153, '648aab10915798110839837c', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-15 06:09:21', '{\"Id\":\"648aab10915798110839837c\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648aab10825aa184b3dde488\",\"LastBillingDate\":\"2023-06-15T06:09:20.0990000Z\",\"NextBillingDate\":\"2023-07-15T06:09:20.0990000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648aab10825aa184b3dde487\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"Mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T06:09:20.0990000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-15T06:09:20.0990000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T06:09:20.0990000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T06:09:20.0990000Z\",\"EndDate\":\"2023-07-15T06:09:20.0990000Z\",\"BilledUntil\":\"2023-07-15T06:09:20.0990000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T06:09:20.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648aab10825aa184b3dde487\",\"ContractId\":\"648aab10825aa184b3dde488\",\"Customer\":{\"CompanyName\":\"Mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"Walter@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(154, '648aac50f83c873fd5176259', NULL, '624d58bced3240ead946eac4', '624d591bc926ef3dec5f5722', '2023-06-15 06:14:42', '{\"Id\":\"648aac50f83c873fd5176259\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648aac50bb5c66bc3928c272\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":6.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T06:14:39.7790000Z\",\"PeriodEnd\":\"2024-06-15T06:14:39.7790000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"624d591bc926ef3dec5f5722\",\"TotalNet\":69.6,\"TotalVat\":13.2,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":82.8,\"ProductDescription\":\"Online-Vereinsverwaltung für Vereine mit max. 99 Mitgliedern: \\n6,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648aab10825aa184b3dde488\",\"LastBillingDate\":\"2023-06-15T06:14:39.7790000Z\",\"NextBillingDate\":\"2024-06-15T06:14:39.7790000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648aab10825aa184b3dde487\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"Mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T06:09:20.0990000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T06:13:18.5390000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T06:14:39.7790000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T06:14:39.7790000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T06:09:20.0990000Z\",\"BilledUntil\":\"2024-06-15T06:14:39.7790000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":69.6,\"TotalVat\":13.2,\"TotalGross\":82.8,\"NextTotalGross\":82.8,\"NextTotalGrossDate\":\"2024-06-15T06:14:39.7790000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T06:14:40.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung SMALL\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T06:14:39.7790000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648aab10825aa184b3dde487\",\"ContractId\":\"648aab10825aa184b3dde488\",\"Customer\":{\"CompanyName\":\"Mangoit\",\"FirstName\":\"Walter\",\"LastName\":\"Heinemann\",\"EmailAddress\":\"Walter@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"\\tZeil 65\",\"PostalCode\":\"60313\",\"City\":\"Hesse\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"\\tZeil 65\",\"FormattedCityAddressLine\":\"60313 Hesse\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(155, '648aace1ce48d099cc53e1d9', NULL, '624d58bced3240ead946eac4', '648040036051424d14298576', '2023-06-15 06:17:07', '{\"Id\":\"648aace1ce48d099cc53e1d9\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"000000000000000000000000\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":-11.999944,\"PricePerUnit\":6.9,\"VatPercentage\":19,\"PeriodStart\":\"2024-06-15T06:14:39.7790000Z\",\"PeriodEnd\":\"2023-06-15T06:17:05.2560000Z\",\"PeriodMultiplier\":-11.999944,\"ScaleAmount\":1,\"ProductId\":\"624d591bc926ef3dec5f5722\",\"TotalNet\":-69.6,\"TotalVat\":-13.2,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":-82.8,\"ProductDescription\":\"Online-Vereinsverwaltung für Vereine mit max. 99 Mitgliedern: \\n6,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"},{\"Id\":\"648aace1bb5c66bc3928c4d6\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":19.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T06:17:05.2560000Z\",\"PeriodEnd\":\"2024-06-15T06:17:05.2560000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"648040036051424d14298576\",\"TotalNet\":200.64,\"TotalVat\":38.16,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":238.8,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud® | Start\\n19,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648aab10825aa184b3dde488\",\"LastBillingDate\":\"2023-06-15T06:17:05.2560000Z\",\"NextBillingDate\":\"2024-06-15T06:17:05.2560000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648aab10825aa184b3dde487\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"Mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T06:09:20.0990000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T06:13:18.5390000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T06:14:39.7790000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T06:17:05.2560000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"Mangoit\",\"IBAN\":\"AD1400080001001234567890\",\"MandateReference\":\"648aac-52825a-a184b3-dde95c\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman = MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-15T06:14:42.6590000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T06:17:05.2560000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T06:09:20.0990000Z\",\"BilledUntil\":\"2024-06-15T06:17:05.2560000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":131.04,\"TotalVat\":24.96,\"TotalGross\":156,\"NextTotalGross\":238.8,\"NextTotalGrossDate\":\"2024-06-15T06:17:05.2560000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T06:17:05.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung + App Light\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T06:17:05.2560000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648aab10825aa184b3dde487\",\"ContractId\":\"648aab10825aa184b3dde488\",\"Customer\":{\"CompanyName\":\"Mangoit\",\"FirstName\":\"Walter\",\"LastName\":\"Heinemann\",\"EmailAddress\":\"Walter@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"\\tZeil 65\",\"PostalCode\":\"60313\",\"City\":\"Hesse\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"\\tZeil 65\",\"FormattedCityAddressLine\":\"60313 Hesse\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(156, '648aad497c89264e16f2e647', 1, NULL, NULL, '2023-06-15 06:18:49', '{\"Id\":\"648aad497c89264e16f2e647\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648aad49825aa184b3ddedfd\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":0.999997,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T06:18:49.6100000Z\",\"PeriodEnd\":\"2024-06-15T06:17:05.2560000Z\",\"PeriodMultiplier\":0.999997,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":292.44,\"TotalVat\":55.56,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648aad49825aa184b3ddedfa\",\"TotalGross\":348,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[{\"ComponentType\":\"QuantityBased\",\"PreventModification\":false,\"VatPercentage\":0,\"TotalNet\":0,\"TotalVat\":0,\"IsQuantityBased\":false,\"StartDate\":\"2023-06-15T06:18:49.6100000Z\",\"ComponentId\":\"63e0b88dc84ad323253cc9fb\",\"Quantity\":1}],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648aab10825aa184b3dde488\",\"LastBillingDate\":\"2023-06-15T06:17:05.2560000Z\",\"NextBillingDate\":\"2024-06-15T06:17:05.2560000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648aab10825aa184b3dde487\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"Mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T06:09:20.0990000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T06:13:18.5390000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T06:14:39.7790000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T06:17:05.2560000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"Mangoit\",\"IBAN\":\"AD1400080001001234567890\",\"MandateReference\":\"648aac-e3825a-a184b3-ddebdc\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman =  MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-15T06:17:07.9900000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T06:17:05.2560000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T06:09:20.0990000Z\",\"BilledUntil\":\"2024-06-15T06:17:05.2560000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":292.44,\"TotalVat\":55.56,\"TotalGross\":348,\"NextTotalGross\":586.8,\"NextTotalGrossDate\":\"2024-06-15T06:17:05.2560000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T06:18:49.0000000Z\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T06:18:49.6100000Z\",\"TriggerInterimBilling\":true,\"CustomerId\":\"648aab10825aa184b3dde487\",\"ContractId\":\"648aab10825aa184b3dde488\",\"Customer\":{\"CompanyName\":\"Mangoit\",\"FirstName\":\"Walter\",\"LastName\":\"Heinemann\",\"EmailAddress\":\"Walter@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"\\tZeil 65\",\"PostalCode\":\"60313\",\"City\":\"Hesse\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"\\tZeil 65\",\"FormattedCityAddressLine\":\"60313 Hesse\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(157, '648addbe3a34e492eeaf4c2d', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-15 09:45:36', '{\"Id\":\"648addbe3a34e492eeaf4c2d\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648addbe000686c5283a7c60\",\"LastBillingDate\":\"2023-06-15T09:45:34.5500000Z\",\"NextBillingDate\":\"2023-07-15T09:45:34.5500000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648addbe000686c5283a7c5f\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T09:45:34.5500000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-15T09:45:34.5500000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T09:45:34.5500000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T09:45:34.5500000Z\",\"EndDate\":\"2023-07-15T09:45:34.5500000Z\",\"BilledUntil\":\"2023-07-15T09:45:34.5500000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T09:45:34.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648addbe000686c5283a7c5f\",\"ContractId\":\"648addbe000686c5283a7c60\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"Irmtraud@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(158, '648ae759105952c3f18b6f0b', NULL, '624d58bced3240ead946eac4', '648040036051424d14298576', '2023-06-15 10:26:35', '{\"Id\":\"648ae759105952c3f18b6f0b\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648ae759000686c5283aac74\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":19.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T10:26:33.1580000Z\",\"PeriodEnd\":\"2024-06-15T10:26:33.1580000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"648040036051424d14298576\",\"TotalNet\":200.64,\"TotalVat\":38.16,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":238.8,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud® | Start\\n19,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648addbe000686c5283a7c60\",\"LastBillingDate\":\"2023-06-15T10:26:33.1580000Z\",\"NextBillingDate\":\"2024-06-15T10:26:33.1580000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648addbe000686c5283a7c5f\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T09:45:34.5500000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T10:24:41.4180000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T10:26:33.1580000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T10:26:33.1580000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T09:45:34.5500000Z\",\"BilledUntil\":\"2024-06-15T10:26:33.1580000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":200.64,\"TotalVat\":38.16,\"TotalGross\":238.8,\"NextTotalGross\":238.8,\"NextTotalGrossDate\":\"2024-06-15T10:26:33.1580000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T10:26:33.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung + App Light\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T10:26:33.1580000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648addbe000686c5283a7c5f\",\"ContractId\":\"648addbe000686c5283a7c60\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Irmtraud\",\"LastName\":\"Diehl\",\"EmailAddress\":\"Irmtraud@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Trojedamm 47\",\"PostalCode\":\"35037\",\"City\":\"Marburg\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Trojedamm 47\",\"FormattedCityAddressLine\":\"35037 Marburg\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(159, '648aeda95fbe1c83de49d980', 1, NULL, NULL, '2023-06-15 10:53:30', '{\"Id\":\"648aeda95fbe1c83de49d980\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648aeda9000686c5283ac932\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":0.999948,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T10:53:29.9330000Z\",\"PeriodEnd\":\"2024-06-15T10:26:33.1580000Z\",\"PeriodMultiplier\":0.999948,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":292.42,\"TotalVat\":55.56,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648aeda9000686c5283ac92f\",\"TotalGross\":347.98,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[{\"ComponentType\":\"QuantityBased\",\"PreventModification\":false,\"VatPercentage\":0,\"TotalNet\":0,\"TotalVat\":0,\"IsQuantityBased\":false,\"StartDate\":\"2023-06-15T10:53:29.9330000Z\",\"ComponentId\":\"63e0b88dc84ad323253cc9fb\",\"Quantity\":1}],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648addbe000686c5283a7c60\",\"LastBillingDate\":\"2023-06-15T10:26:33.1580000Z\",\"NextBillingDate\":\"2024-06-15T10:26:33.1580000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648addbe000686c5283a7c5f\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T09:45:34.5500000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T10:24:41.4180000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T10:26:33.1580000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"mangoit\",\"IBAN\":\"DE91100000000123456789\",\"MandateReference\":\"648ae7-5cbb5c-66bc39-2a35a2\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman =   MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-15T10:26:36.4240000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T10:26:33.1580000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T09:45:34.5500000Z\",\"BilledUntil\":\"2024-06-15T10:26:33.1580000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":292.42,\"TotalVat\":55.56,\"TotalGross\":347.98,\"NextTotalGross\":586.8,\"NextTotalGrossDate\":\"2024-06-15T10:26:33.1580000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T10:53:29.0000000Z\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T10:53:29.9330000Z\",\"TriggerInterimBilling\":true,\"CustomerId\":\"648addbe000686c5283a7c5f\",\"ContractId\":\"648addbe000686c5283a7c60\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Irmtraud\",\"LastName\":\"Diehl\",\"EmailAddress\":\"Irmtraud@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Trojedamm 47\",\"PostalCode\":\"35037\",\"City\":\"Marburg\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Trojedamm 47\",\"FormattedCityAddressLine\":\"35037 Marburg\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(160, '648af4a5d15476d7eb1e6b04', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-15 11:23:19', '{\"Id\":\"648af4a5d15476d7eb1e6b04\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648af4a5000686c5283ae6ec\",\"LastBillingDate\":\"2023-06-15T11:23:17.2110000Z\",\"NextBillingDate\":\"2023-07-15T11:23:17.2110000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648af4a5000686c5283ae6eb\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T11:23:17.2110000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-15T11:23:17.2110000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T11:23:17.2110000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T11:23:17.2110000Z\",\"EndDate\":\"2023-07-15T11:23:17.2110000Z\",\"BilledUntil\":\"2023-07-15T11:23:17.2110000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T11:23:17.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648af4a5000686c5283ae6eb\",\"ContractId\":\"648af4a5000686c5283ae6ec\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"Frau@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}');
INSERT INTO `order_billwerk` (`id`, `order_id`, `quantity`, `planId`, `planVariantId`, `created_at`, `data`) VALUES
(161, '648af5eed9e7f510733984c1', NULL, '624d58bced3240ead946eac4', '648040036051424d14298576', '2023-06-15 11:28:47', '{\"Id\":\"648af5eed9e7f510733984c1\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648af5ee000686c5283aeb46\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":19.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T11:28:45.8060000Z\",\"PeriodEnd\":\"2024-06-15T11:28:45.8060000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"648040036051424d14298576\",\"TotalNet\":200.64,\"TotalVat\":38.16,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":238.8,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud® | Start\\n19,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648af4a5000686c5283ae6ec\",\"LastBillingDate\":\"2023-06-15T11:28:45.8060000Z\",\"NextBillingDate\":\"2024-06-15T11:28:45.8060000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648af4a5000686c5283ae6eb\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T11:23:17.2110000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T11:27:46.4880000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T11:28:45.8060000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T11:28:45.8060000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T11:23:17.2110000Z\",\"BilledUntil\":\"2024-06-15T11:28:45.8060000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":200.64,\"TotalVat\":38.16,\"TotalGross\":238.8,\"NextTotalGross\":238.8,\"NextTotalGrossDate\":\"2024-06-15T11:28:45.8060000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T11:28:46.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung + App Light\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T11:28:45.8060000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648af4a5000686c5283ae6eb\",\"ContractId\":\"648af4a5000686c5283ae6ec\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Frau\",\"LastName\":\"Frauke\",\"EmailAddress\":\"Frau@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Glauburgstrasse 28\",\"PostalCode\":\"60318\",\"City\":\"Hesse\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Glauburgstrasse 28\",\"FormattedCityAddressLine\":\"60318 Hesse\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(162, '648afbcdad0c47ef67dd6a82', 1, NULL, NULL, '2023-06-15 11:53:49', '{\"Id\":\"648afbcdad0c47ef67dd6a82\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648afbcd000686c5283b547e\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":0.999952,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T11:53:49.1790000Z\",\"PeriodEnd\":\"2024-06-15T11:28:45.8060000Z\",\"PeriodMultiplier\":0.999952,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":292.42,\"TotalVat\":55.56,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648afbcd000686c5283b547b\",\"TotalGross\":347.98,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[{\"ComponentType\":\"QuantityBased\",\"PreventModification\":false,\"VatPercentage\":0,\"TotalNet\":0,\"TotalVat\":0,\"IsQuantityBased\":false,\"StartDate\":\"2023-06-15T11:53:49.1790000Z\",\"ComponentId\":\"63e0b88dc84ad323253cc9fb\",\"Quantity\":1}],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648af4a5000686c5283ae6ec\",\"LastBillingDate\":\"2023-06-15T11:28:45.8060000Z\",\"NextBillingDate\":\"2024-06-15T11:28:45.8060000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648af4a5000686c5283ae6eb\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T11:23:17.2110000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T11:27:46.4880000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T11:28:45.8060000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"mangoit\",\"IBAN\":\"AD1400080001001234567890\",\"MandateReference\":\"648af5-f0825a-a184b3-df9898\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman = MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-15T11:28:48.0790000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T11:28:45.8060000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T11:23:17.2110000Z\",\"BilledUntil\":\"2024-06-15T11:28:45.8060000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":292.42,\"TotalVat\":55.56,\"TotalGross\":347.98,\"NextTotalGross\":586.8,\"NextTotalGrossDate\":\"2024-06-15T11:28:45.8060000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T11:53:49.0000000Z\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T11:53:49.1790000Z\",\"TriggerInterimBilling\":true,\"CustomerId\":\"648af4a5000686c5283ae6eb\",\"ContractId\":\"648af4a5000686c5283ae6ec\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Frau\",\"LastName\":\"Frauke\",\"EmailAddress\":\"Frau@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Glauburgstrasse 28\",\"PostalCode\":\"60318\",\"City\":\"Hesse\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Glauburgstrasse 28\",\"FormattedCityAddressLine\":\"60318 Hesse\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(163, '648affab01ab310ea69dbcd7', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-15 12:10:20', '{\"Id\":\"648affab01ab310ea69dbcd7\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648affab000686c5283b834c\",\"LastBillingDate\":\"2023-06-15T12:10:19.1650000Z\",\"NextBillingDate\":\"2023-07-15T12:10:19.1650000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648affab000686c5283b834b\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"Mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:10:19.1650000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-15T12:10:19.1650000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:10:19.1650000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T12:10:19.1650000Z\",\"EndDate\":\"2023-07-15T12:10:19.1650000Z\",\"BilledUntil\":\"2023-07-15T12:10:19.1650000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T12:10:19.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648affab000686c5283b834b\",\"ContractId\":\"648affab000686c5283b834c\",\"Customer\":{\"CompanyName\":\"Mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"Bodo@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(164, '648b00890b64151892b1c494', NULL, '624d58bced3240ead946eac4', '648040036051424d14298576', '2023-06-15 12:14:02', '{\"Id\":\"648b00890b64151892b1c494\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648b0088825aa184b3e0321f\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":19.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T12:14:00.5670000Z\",\"PeriodEnd\":\"2024-06-15T12:14:00.5670000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"648040036051424d14298576\",\"TotalNet\":200.64,\"TotalVat\":38.16,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":238.8,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud® | Start\\n19,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648affab000686c5283b834c\",\"LastBillingDate\":\"2023-06-15T12:14:00.5670000Z\",\"NextBillingDate\":\"2024-06-15T12:14:00.5670000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648affab000686c5283b834b\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"Mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:10:19.1650000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T12:13:08.6100000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:14:00.5670000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:14:00.5670000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T12:10:19.1650000Z\",\"BilledUntil\":\"2024-06-15T12:14:00.5670000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":200.64,\"TotalVat\":38.16,\"TotalGross\":238.8,\"NextTotalGross\":238.8,\"NextTotalGrossDate\":\"2024-06-15T12:14:00.5670000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T12:14:01.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung + App Light\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T12:14:00.5670000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648affab000686c5283b834b\",\"ContractId\":\"648affab000686c5283b834c\",\"Customer\":{\"CompanyName\":\"Mangoit\",\"FirstName\":\"Bodo\",\"LastName\":\"Kretschmer\",\"EmailAddress\":\"Bodo@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"\\tFriedrich-Wilhelm-Strasse 27\",\"PostalCode\":\"37269\",\"City\":\"Eschwege\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"\\tFriedrich-Wilhelm-Strasse 27\",\"FormattedCityAddressLine\":\"37269 Eschwege\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(165, '648b00b4ca5b8c5aaf824ace', 1, NULL, NULL, '2023-06-15 12:14:44', '{\"Id\":\"648b00b4ca5b8c5aaf824ace\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648b00b4bb5c66bc392b0edc\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":0.999999,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T12:14:44.8120000Z\",\"PeriodEnd\":\"2024-06-15T12:14:00.5670000Z\",\"PeriodMultiplier\":0.999999,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":292.44,\"TotalVat\":55.56,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648b00b4bb5c66bc392b0ed8\",\"TotalGross\":348,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[{\"ComponentType\":\"QuantityBased\",\"PreventModification\":false,\"VatPercentage\":0,\"TotalNet\":0,\"TotalVat\":0,\"IsQuantityBased\":false,\"StartDate\":\"2023-06-15T12:14:44.8120000Z\",\"ComponentId\":\"63e0b88dc84ad323253cc9fb\",\"Quantity\":1}],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648affab000686c5283b834c\",\"LastBillingDate\":\"2023-06-15T12:14:00.5670000Z\",\"NextBillingDate\":\"2024-06-15T12:14:00.5670000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648affab000686c5283b834b\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"Mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:10:19.1650000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T12:13:08.6100000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:14:00.5670000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"Mangoit\",\"IBAN\":\"DE91100000000123456789\",\"MandateReference\":\"648b00-8b825a-a184b3-e03255\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman =  MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-15T12:14:03.2640000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:14:00.5670000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T12:10:19.1650000Z\",\"BilledUntil\":\"2024-06-15T12:14:00.5670000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":292.44,\"TotalVat\":55.56,\"TotalGross\":348,\"NextTotalGross\":586.8,\"NextTotalGrossDate\":\"2024-06-15T12:14:00.5670000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T12:14:44.0000000Z\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T12:14:44.8120000Z\",\"TriggerInterimBilling\":true,\"CustomerId\":\"648affab000686c5283b834b\",\"ContractId\":\"648affab000686c5283b834c\",\"Customer\":{\"CompanyName\":\"Mangoit\",\"FirstName\":\"Bodo\",\"LastName\":\"Kretschmer\",\"EmailAddress\":\"Bodo@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"\\tFriedrich-Wilhelm-Strasse 27\",\"PostalCode\":\"37269\",\"City\":\"Eschwege\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"\\tFriedrich-Wilhelm-Strasse 27\",\"FormattedCityAddressLine\":\"37269 Eschwege\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(166, '648b02ab65fa98fa693e938e', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-15 12:23:09', '{\"Id\":\"648b02ab65fa98fa693e938e\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648b02ab000686c5283b8f41\",\"LastBillingDate\":\"2023-06-15T12:23:07.5970000Z\",\"NextBillingDate\":\"2023-07-15T12:23:07.5970000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648b02ab000686c5283b8f40\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:23:07.5970000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-15T12:23:07.5970000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:23:07.5970000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T12:23:07.5970000Z\",\"EndDate\":\"2023-07-15T12:23:07.5970000Z\",\"BilledUntil\":\"2023-07-15T12:23:07.5970000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T12:23:07.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648b02ab000686c5283b8f40\",\"ContractId\":\"648b02ab000686c5283b8f41\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"Peer@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(167, '648b040c394e60d89c9e9a0b', NULL, '624d58bced3240ead946eac4', '648040036051424d14298576', '2023-06-15 12:29:02', '{\"Id\":\"648b040c394e60d89c9e9a0b\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648b040cbb5c66bc392b1ded\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":19.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T12:29:00.2320000Z\",\"PeriodEnd\":\"2024-06-15T12:29:00.2320000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"648040036051424d14298576\",\"TotalNet\":200.64,\"TotalVat\":38.16,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":238.8,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud® | Start\\n19,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648b02ab000686c5283b8f41\",\"LastBillingDate\":\"2023-06-15T12:29:00.2320000Z\",\"NextBillingDate\":\"2024-06-15T12:29:00.2320000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648b02ab000686c5283b8f40\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:23:07.5970000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T12:27:58.3090000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:29:00.2320000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:29:00.2320000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T12:23:07.5970000Z\",\"BilledUntil\":\"2024-06-15T12:29:00.2320000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":200.64,\"TotalVat\":38.16,\"TotalGross\":238.8,\"NextTotalGross\":238.8,\"NextTotalGrossDate\":\"2024-06-15T12:29:00.2320000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T12:29:00.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung + App Light\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T12:29:00.2320000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648b02ab000686c5283b8f40\",\"ContractId\":\"648b02ab000686c5283b8f41\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Peer\",\"LastName\":\"Roder\",\"EmailAddress\":\"Peer@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Kastanienallee 20\",\"PostalCode\":\"63454\",\"City\":\"Hanau\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Kastanienallee 20\",\"FormattedCityAddressLine\":\"63454 Hanau\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(168, '648b0454db782ba4f20d899f', 1, NULL, NULL, '2023-06-15 12:30:12', '{\"Id\":\"648b0454db782ba4f20d899f\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648b0454000686c5283b96ce\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":0.999998,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T12:30:12.7660000Z\",\"PeriodEnd\":\"2024-06-15T12:29:00.2320000Z\",\"PeriodMultiplier\":0.999998,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":292.44,\"TotalVat\":55.56,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648b0454000686c5283b96cb\",\"TotalGross\":348,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[{\"ComponentType\":\"QuantityBased\",\"PreventModification\":false,\"VatPercentage\":0,\"TotalNet\":0,\"TotalVat\":0,\"IsQuantityBased\":false,\"StartDate\":\"2023-06-15T12:30:12.7660000Z\",\"ComponentId\":\"63e0b88dc84ad323253cc9fb\",\"Quantity\":1}],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648b02ab000686c5283b8f41\",\"LastBillingDate\":\"2023-06-15T12:29:00.2320000Z\",\"NextBillingDate\":\"2024-06-15T12:29:00.2320000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648b02ab000686c5283b8f40\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:23:07.5970000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T12:27:58.3090000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:29:00.2320000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"mangoit\",\"IBAN\":\"AD1400080001001234567890\",\"MandateReference\":\"648b04-0f0006-86c528-3b9522\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman = MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-15T12:29:03.1830000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:29:00.2320000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T12:23:07.5970000Z\",\"BilledUntil\":\"2024-06-15T12:29:00.2320000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":292.44,\"TotalVat\":55.56,\"TotalGross\":348,\"NextTotalGross\":586.8,\"NextTotalGrossDate\":\"2024-06-15T12:29:00.2320000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T12:30:12.0000000Z\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T12:30:12.7660000Z\",\"TriggerInterimBilling\":true,\"CustomerId\":\"648b02ab000686c5283b8f40\",\"ContractId\":\"648b02ab000686c5283b8f41\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Peer\",\"LastName\":\"Roder\",\"EmailAddress\":\"Peer@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Kastanienallee 20\",\"PostalCode\":\"63454\",\"City\":\"Hanau\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Kastanienallee 20\",\"FormattedCityAddressLine\":\"63454 Hanau\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(169, '648b0aa9bb4b0960511319e4', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-15 12:57:15', '{\"Id\":\"648b0aa9bb4b0960511319e4\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648b0aa9825aa184b3e065d8\",\"LastBillingDate\":\"2023-06-15T12:57:13.4570000Z\",\"NextBillingDate\":\"2023-07-15T12:57:13.4570000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648b0aa9825aa184b3e065d7\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:57:13.4570000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-15T12:57:13.4570000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:57:13.4570000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T12:57:13.4570000Z\",\"EndDate\":\"2023-07-15T12:57:13.4570000Z\",\"BilledUntil\":\"2023-07-15T12:57:13.4570000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T12:57:13.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648b0aa9825aa184b3e065d7\",\"ContractId\":\"648b0aa9825aa184b3e065d8\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"Christian@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(170, '648b0bb5e9cc4c2ceaf8c8d2', NULL, '624d58bced3240ead946eac4', '648040036051424d14298576', '2023-06-15 13:01:43', '{\"Id\":\"648b0bb5e9cc4c2ceaf8c8d2\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648b0bb5825aa184b3e06a65\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":19.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T13:01:40.6310000Z\",\"PeriodEnd\":\"2024-06-15T13:01:40.6310000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"648040036051424d14298576\",\"TotalNet\":200.64,\"TotalVat\":38.16,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":238.8,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud® | Start\\n19,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648b0aa9825aa184b3e065d8\",\"LastBillingDate\":\"2023-06-15T13:01:40.6310000Z\",\"NextBillingDate\":\"2024-06-15T13:01:40.6310000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648b0aa9825aa184b3e065d7\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:57:13.4570000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T12:59:35.2080000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:01:40.6310000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:01:40.6310000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T12:57:13.4570000Z\",\"BilledUntil\":\"2024-06-15T13:01:40.6310000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":200.64,\"TotalVat\":38.16,\"TotalGross\":238.8,\"NextTotalGross\":238.8,\"NextTotalGrossDate\":\"2024-06-15T13:01:40.6310000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T13:01:41.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung + App Light\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T13:01:40.6310000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648b0aa9825aa184b3e065d7\",\"ContractId\":\"648b0aa9825aa184b3e065d8\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Christian\",\"LastName\":\"Roth\",\"EmailAddress\":\"Christian@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"10589 Berlin Charlottenburg\",\"PostalCode\":\"653625\",\"City\":\"Leopoldstraße\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"10589 Berlin Charlottenburg\",\"FormattedCityAddressLine\":\"653625 Leopoldstraße\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(171, '648b10095cbdf324bbce82f9', 1, NULL, NULL, '2023-06-15 13:20:09', '{\"Id\":\"648b10095cbdf324bbce82f9\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648b1009bb5c66bc392b5da8\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":0.999964,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T13:20:08.9840000Z\",\"PeriodEnd\":\"2024-06-15T13:01:40.6310000Z\",\"PeriodMultiplier\":0.999964,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":292.43,\"TotalVat\":55.56,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648b1008bb5c66bc392b5da4\",\"TotalGross\":347.99,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[{\"ComponentType\":\"QuantityBased\",\"PreventModification\":false,\"VatPercentage\":0,\"TotalNet\":0,\"TotalVat\":0,\"IsQuantityBased\":false,\"StartDate\":\"2023-06-15T13:20:08.9840000Z\",\"ComponentId\":\"63e0b88dc84ad323253cc9fb\",\"Quantity\":1}],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648b0aa9825aa184b3e065d8\",\"LastBillingDate\":\"2023-06-15T13:01:40.6310000Z\",\"NextBillingDate\":\"2024-06-15T13:01:40.6310000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648b0aa9825aa184b3e065d7\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:57:13.4570000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T12:59:35.2080000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:01:40.6310000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"mangoit\",\"IBAN\":\"DE91100000000123456789\",\"MandateReference\":\"648b0b-b7bb5c-66bc39-2b47fa\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman =  MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-15T13:01:43.6840000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:01:40.6310000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T12:57:13.4570000Z\",\"BilledUntil\":\"2024-06-15T13:01:40.6310000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":292.43,\"TotalVat\":55.56,\"TotalGross\":347.99,\"NextTotalGross\":586.8,\"NextTotalGrossDate\":\"2024-06-15T13:01:40.6310000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T13:20:09.0000000Z\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T13:20:08.9840000Z\",\"TriggerInterimBilling\":true,\"CustomerId\":\"648b0aa9825aa184b3e065d7\",\"ContractId\":\"648b0aa9825aa184b3e065d8\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Christian\",\"LastName\":\"Roth\",\"EmailAddress\":\"Christian@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"10589 Berlin Charlottenburg\",\"PostalCode\":\"653625\",\"City\":\"Leopoldstraße\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"10589 Berlin Charlottenburg\",\"FormattedCityAddressLine\":\"653625 Leopoldstraße\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(172, '648b1104f85cd29c006582ca', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-15 13:24:22', '{\"Id\":\"648b1104f85cd29c006582ca\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648b1104000686c5283bd947\",\"LastBillingDate\":\"2023-06-15T13:24:20.1830000Z\",\"NextBillingDate\":\"2023-07-15T13:24:20.1830000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648b1104000686c5283bd946\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:24:20.1830000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-15T13:24:20.1830000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:24:20.1830000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T13:24:20.1830000Z\",\"EndDate\":\"2023-07-15T13:24:20.1830000Z\",\"BilledUntil\":\"2023-07-15T13:24:20.1830000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T13:24:20.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648b1104000686c5283bd946\",\"ContractId\":\"648b1104000686c5283bd947\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"Claudia@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(173, '648b11c50e8b8b815bc87399', NULL, '624d58bced3240ead946eac4', '648040036051424d14298576', '2023-06-15 13:27:35', '{\"Id\":\"648b11c50e8b8b815bc87399\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648b11c5bb5c66bc392b62d8\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":19.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T13:27:33.0930000Z\",\"PeriodEnd\":\"2024-06-15T13:27:33.0930000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"648040036051424d14298576\",\"TotalNet\":200.64,\"TotalVat\":38.16,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":238.8,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud® | Start\\n19,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648b1104000686c5283bd947\",\"LastBillingDate\":\"2023-06-15T13:27:33.0930000Z\",\"NextBillingDate\":\"2024-06-15T13:27:33.0930000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648b1104000686c5283bd946\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:24:20.1830000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T13:26:44.0210000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:27:33.0930000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:27:33.0930000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T13:24:20.1830000Z\",\"BilledUntil\":\"2024-06-15T13:27:33.0930000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":200.64,\"TotalVat\":38.16,\"TotalGross\":238.8,\"NextTotalGross\":238.8,\"NextTotalGrossDate\":\"2024-06-15T13:27:33.0930000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T13:27:33.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung + App Light\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T13:27:33.0930000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648b1104000686c5283bd946\",\"ContractId\":\"648b1104000686c5283bd947\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Claudia\",\"LastName\":\"Maur\",\"EmailAddress\":\"Claudia@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Schönwalder Allee 14\",\"PostalCode\":\"23735\",\"City\":\"Lensahn\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Schönwalder Allee 14\",\"FormattedCityAddressLine\":\"23735 Lensahn\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}');
INSERT INTO `order_billwerk` (`id`, `order_id`, `quantity`, `planId`, `planVariantId`, `created_at`, `data`) VALUES
(174, '648b1200840dc61a458a9e4b', 1, NULL, NULL, '2023-06-15 13:28:32', '{\"Id\":\"648b1200840dc61a458a9e4b\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648b1200825aa184b3e0858e\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":0.999998,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-15T13:28:32.0390000Z\",\"PeriodEnd\":\"2024-06-15T13:27:33.0930000Z\",\"PeriodMultiplier\":0.999998,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":292.44,\"TotalVat\":55.56,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648b1200825aa184b3e0858b\",\"TotalGross\":348,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[{\"ComponentType\":\"QuantityBased\",\"PreventModification\":false,\"VatPercentage\":0,\"TotalNet\":0,\"TotalVat\":0,\"IsQuantityBased\":false,\"StartDate\":\"2023-06-15T13:28:32.0390000Z\",\"ComponentId\":\"63e0b88dc84ad323253cc9fb\",\"Quantity\":1}],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648b1104000686c5283bd947\",\"LastBillingDate\":\"2023-06-15T13:27:33.0930000Z\",\"NextBillingDate\":\"2024-06-15T13:27:33.0930000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648b1104000686c5283bd946\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:24:20.1830000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T13:26:44.0210000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:27:33.0930000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"mangoit\",\"IBAN\":\"AD1400080001001234567890\",\"MandateReference\":\"648b11-c7825a-a184b3-e084c2\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman = MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-15T13:27:35.9170000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:27:33.0930000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T13:24:20.1830000Z\",\"BilledUntil\":\"2024-06-15T13:27:33.0930000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":292.44,\"TotalVat\":55.56,\"TotalGross\":348,\"NextTotalGross\":586.8,\"NextTotalGrossDate\":\"2024-06-15T13:27:33.0930000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-15T13:28:32.0000000Z\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-15T13:28:32.0390000Z\",\"TriggerInterimBilling\":true,\"CustomerId\":\"648b1104000686c5283bd946\",\"ContractId\":\"648b1104000686c5283bd947\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Claudia\",\"LastName\":\"Maur\",\"EmailAddress\":\"Claudia@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Schönwalder Allee 14\",\"PostalCode\":\"23735\",\"City\":\"Lensahn\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Schönwalder Allee 14\",\"FormattedCityAddressLine\":\"23735 Lensahn\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(175, '648c3b7402fab2bc3cdb8eb5', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-16 10:37:43', '{\"Id\":\"648c3b7402fab2bc3cdb8eb5\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648c3b741c4c7c115c0c08cc\",\"LastBillingDate\":\"2023-06-16T10:37:40.6530000Z\",\"NextBillingDate\":\"2023-07-16T10:37:40.6530000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648c3b741c4c7c115c0c08cb\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-16T10:37:40.6530000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-16T10:37:40.6530000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-16T10:37:40.6530000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-16T10:37:40.6530000Z\",\"EndDate\":\"2023-07-16T10:37:40.6530000Z\",\"BilledUntil\":\"2023-07-16T10:37:40.6530000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-16T10:37:40.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648c3b741c4c7c115c0c08cb\",\"ContractId\":\"648c3b741c4c7c115c0c08cc\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"Mathias@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(176, '648c45a0086ab3d256a3c2de', NULL, '624d58bced3240ead946eac4', '624d591bc926ef3dec5f5722', '2023-06-16 11:21:06', '{\"Id\":\"648c45a0086ab3d256a3c2de\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648c45a01c4c7c115c0c52b2\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":6.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-16T11:21:04.1700000Z\",\"PeriodEnd\":\"2024-06-16T11:21:04.1700000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"624d591bc926ef3dec5f5722\",\"TotalNet\":69.6,\"TotalVat\":13.2,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":82.8,\"ProductDescription\":\"Online-Vereinsverwaltung für Vereine mit max. 99 Mitgliedern: \\n6,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"},{\"Id\":\"000000000000000000000000\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":-11.968996,\"PricePerUnit\":19.9,\"VatPercentage\":19,\"PeriodStart\":\"2024-06-15T13:01:40.6310000Z\",\"PeriodEnd\":\"2023-06-16T11:21:04.1700000Z\",\"PeriodMultiplier\":-11.968996,\"ScaleAmount\":1,\"ProductId\":\"648040036051424d14298576\",\"TotalNet\":-200.12,\"TotalVat\":-38.06,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":-238.18,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud® | Start\\n19,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"},{\"Id\":\"648c45a01c4c7c115c0c52b3\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":1,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-16T11:21:04.1700000Z\",\"PeriodEnd\":\"2024-06-16T11:21:04.1700000Z\",\"PeriodMultiplier\":1,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":292.44,\"TotalVat\":55.56,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648b1008bb5c66bc392b5da4\",\"TotalGross\":348,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"},{\"Id\":\"000000000000000000000000\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":-0.997416,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2024-06-15T13:01:40.6310000Z\",\"PeriodEnd\":\"2023-06-16T11:21:04.1700000Z\",\"PeriodMultiplier\":-0.997416,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":-291.68,\"TotalVat\":-55.42,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648b1008bb5c66bc392b5da4\",\"TotalGross\":-347.1,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[{\"ComponentType\":\"QuantityBased\",\"PreventModification\":false,\"VatPercentage\":0,\"TotalNet\":0,\"TotalVat\":0,\"IsQuantityBased\":false,\"StartDate\":\"2023-06-15T13:20:08.9840000Z\",\"ComponentId\":\"63e0b88dc84ad323253cc9fb\",\"Quantity\":1}],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648b0aa9825aa184b3e065d8\",\"LastBillingDate\":\"2023-06-16T11:21:04.1700000Z\",\"NextBillingDate\":\"2024-06-16T11:21:04.1700000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648b0aa9825aa184b3e065d7\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:57:13.4570000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T12:59:35.2080000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:01:40.6310000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-16T11:21:04.1700000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"mangoit\",\"IBAN\":\"DE91100000000123456789\",\"MandateReference\":\"648b10-090006-86c528-3bd485\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman =   MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-15T13:20:09.5810000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-16T11:21:04.1700000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T12:57:13.4570000Z\",\"BilledUntil\":\"2024-06-16T11:21:04.1700000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":-129.76,\"TotalVat\":-24.72,\"TotalGross\":-154.48,\"NextTotalGross\":430.8,\"NextTotalGrossDate\":\"2024-06-16T11:21:04.1700000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-16T11:21:04.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung SMALL\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-16T11:21:04.1700000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648b0aa9825aa184b3e065d7\",\"ContractId\":\"648b0aa9825aa184b3e065d8\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Christian\",\"LastName\":\"Roth\",\"EmailAddress\":\"Christian@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"10589 Berlin Charlottenburg\",\"PostalCode\":\"653625\",\"City\":\"Leopoldstraße\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"10589 Berlin Charlottenburg\",\"FormattedCityAddressLine\":\"653625 Leopoldstraße\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(177, '648fdbb4f60b99f8c20eb026', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-19 04:38:14', '{\"Id\":\"648fdbb4f60b99f8c20eb026\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648fdbb4c54d63b04857bd37\",\"LastBillingDate\":\"2023-06-19T04:38:12.3240000Z\",\"NextBillingDate\":\"2023-07-19T04:38:12.3240000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648fdbb4c54d63b04857bd36\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-19T04:38:12.3240000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-19T04:38:12.3240000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-19T04:38:12.3240000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-19T04:38:12.3240000Z\",\"EndDate\":\"2023-07-19T04:38:12.3240000Z\",\"BilledUntil\":\"2023-07-19T04:38:12.3240000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-19T04:38:12.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648fdbb4c54d63b04857bd36\",\"ContractId\":\"648fdbb4c54d63b04857bd37\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"junker@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(178, '648fea3d197f7d68a173a991', NULL, '624d58bced3240ead946eac4', '624d5901c926ef3dec5f56d2', '2023-06-19 05:40:15', '{\"Id\":\"648fea3d197f7d68a173a991\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648fea3dde0c9ca0b17ad59f\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":13.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-19T05:40:13.2030000Z\",\"PeriodEnd\":\"2024-06-19T05:40:13.2030000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"624d5901c926ef3dec5f56d2\",\"TotalNet\":140.16,\"TotalVat\":26.64,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":166.8,\"ProductDescription\":\"Online-Vereinsverwaltung für Vereine, inkl. DATEV-Schnittstelle:  \\n13,90€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"},{\"Id\":\"000000000000000000000000\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":-11.877485,\"PricePerUnit\":19.9,\"VatPercentage\":19,\"PeriodStart\":\"2024-06-15T13:27:33.0930000Z\",\"PeriodEnd\":\"2023-06-19T05:40:13.2030000Z\",\"PeriodMultiplier\":-11.877485,\"ScaleAmount\":1,\"ProductId\":\"648040036051424d14298576\",\"TotalNet\":-198.59,\"TotalVat\":-37.77,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":-236.36,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud® | Start\\n19,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"},{\"Id\":\"648fea3dde0c9ca0b17ad5a0\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":1,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-19T05:40:13.2030000Z\",\"PeriodEnd\":\"2024-06-19T05:40:13.2030000Z\",\"PeriodMultiplier\":1,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":292.44,\"TotalVat\":55.56,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648b1200825aa184b3e0858b\",\"TotalGross\":348,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"},{\"Id\":\"000000000000000000000000\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":-0.98979,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2024-06-15T13:27:33.0930000Z\",\"PeriodEnd\":\"2023-06-19T05:40:13.2030000Z\",\"PeriodMultiplier\":-0.98979,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":-289.46,\"TotalVat\":-54.99,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648b1200825aa184b3e0858b\",\"TotalGross\":-344.45,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[{\"ComponentType\":\"QuantityBased\",\"PreventModification\":false,\"VatPercentage\":0,\"TotalNet\":0,\"TotalVat\":0,\"IsQuantityBased\":false,\"StartDate\":\"2023-06-15T13:28:32.0390000Z\",\"ComponentId\":\"63e0b88dc84ad323253cc9fb\",\"Quantity\":1}],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648b1104000686c5283bd947\",\"LastBillingDate\":\"2023-06-19T05:40:13.2030000Z\",\"NextBillingDate\":\"2024-06-19T05:40:13.2030000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648b1104000686c5283bd946\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:24:20.1830000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T13:26:44.0210000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:27:33.0930000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-19T05:40:13.2030000Z\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"mangoit\",\"IBAN\":\"AD1400080001001234567890\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman =  MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-15T13:28:32.0000000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-19T05:40:13.2030000Z\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T13:24:20.1830000Z\",\"BilledUntil\":\"2024-06-19T05:40:13.2030000Z\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":-55.45,\"TotalVat\":-10.56,\"TotalGross\":-66.01,\"NextTotalGross\":514.8,\"NextTotalGrossDate\":\"2024-06-19T05:40:13.2030000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-19T05:40:13.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-19T05:40:13.2030000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648b1104000686c5283bd946\",\"ContractId\":\"648b1104000686c5283bd947\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Claudia\",\"LastName\":\"Maur\",\"EmailAddress\":\"Claudia@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Schönwalder Allee 14\",\"PostalCode\":\"23735\",\"City\":\"Lensahn\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Schönwalder Allee 14\",\"FormattedCityAddressLine\":\"23735 Lensahn\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(179, '648febc0a32900bd701a5192', NULL, '624d58bced3240ead946eac4', '648040316051424d142986bc', '2023-06-19 05:46:42', '{\"Id\":\"648febc0a32900bd701a5192\",\"PlanVariantId\":\"648040316051424d142986bc\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"000000000000000000000000\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":-11.999851,\"PricePerUnit\":13.9,\"VatPercentage\":19,\"PeriodStart\":\"2024-06-19T05:40:13.2030000Z\",\"PeriodEnd\":\"2023-06-19T05:46:39.7850000Z\",\"PeriodMultiplier\":-11.999851,\"ScaleAmount\":1,\"ProductId\":\"624d5901c926ef3dec5f56d2\",\"TotalNet\":-140.16,\"TotalVat\":-26.64,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":-166.8,\"ProductDescription\":\"Online-Vereinsverwaltung für Vereine, inkl. DATEV-Schnittstelle:  \\n13,90€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"},{\"Id\":\"648febc0c54d63b04857e125\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":39.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-19T05:46:39.7850000Z\",\"PeriodEnd\":\"2024-06-19T05:46:39.7850000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"648040316051424d142986bc\",\"TotalNet\":402.36,\"TotalVat\":76.44,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":478.8,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud®\\n39,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"},{\"Id\":\"648febc0c54d63b04857e126\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":1,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-19T05:46:39.7850000Z\",\"PeriodEnd\":\"2024-06-19T05:46:39.7850000Z\",\"PeriodMultiplier\":1,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":292.44,\"TotalVat\":55.56,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648b1200825aa184b3e0858b\",\"TotalGross\":348,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"},{\"Id\":\"000000000000000000000000\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":-0.999988,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2024-06-19T05:40:13.2030000Z\",\"PeriodEnd\":\"2023-06-19T05:46:39.7850000Z\",\"PeriodMultiplier\":-0.999988,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":-292.44,\"TotalVat\":-55.56,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648b1200825aa184b3e0858b\",\"TotalGross\":-348,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[{\"ComponentType\":\"QuantityBased\",\"PreventModification\":false,\"VatPercentage\":0,\"TotalNet\":0,\"TotalVat\":0,\"IsQuantityBased\":false,\"StartDate\":\"2023-06-15T13:28:32.0390000Z\",\"ComponentId\":\"63e0b88dc84ad323253cc9fb\",\"Quantity\":1}],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648b1104000686c5283bd947\",\"LastBillingDate\":\"2023-06-19T05:46:39.7850000Z\",\"NextBillingDate\":\"2024-06-19T05:46:39.7850000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648b1104000686c5283bd946\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:24:20.1830000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T13:26:44.0210000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:27:33.0930000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-19T05:40:13.2030000Z\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-19T05:46:39.7850000Z\",\"PlanVariantId\":\"648040316051424d142986bc\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"mangoit\",\"IBAN\":\"AD1400080001001234567890\",\"MandateReference\":\"648fea-40de0c-9ca0b1-7ad5a7\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman =   MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-19T05:40:16.3110000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-19T05:46:39.7850000Z\",\"PlanVariantId\":\"648040316051424d142986bc\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T13:24:20.1830000Z\",\"BilledUntil\":\"2024-06-19T05:46:39.7850000Z\",\"PlanVariantId\":\"648040316051424d142986bc\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":262.2,\"TotalVat\":49.8,\"TotalGross\":312,\"NextTotalGross\":826.8,\"NextTotalGrossDate\":\"2024-06-19T05:46:39.7850000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-19T05:46:40.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung + verein.cloud®\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-19T05:46:39.7850000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648b1104000686c5283bd946\",\"ContractId\":\"648b1104000686c5283bd947\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Claudia\",\"LastName\":\"Maur\",\"EmailAddress\":\"Claudia@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Schönwalder Allee 14\",\"PostalCode\":\"23735\",\"City\":\"Lensahn\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Schönwalder Allee 14\",\"FormattedCityAddressLine\":\"23735 Lensahn\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(180, '648fedbc60e93980fbe00eba', NULL, '624d58bced3240ead946eac4', '624d5901c926ef3dec5f56d2', '2023-06-19 05:55:10', '{\"Id\":\"648fedbc60e93980fbe00eba\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648fedbcc54d63b04857e6c2\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":13.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-19T05:55:08.2870000Z\",\"PeriodEnd\":\"2024-06-19T05:55:08.2870000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"624d5901c926ef3dec5f56d2\",\"TotalNet\":140.16,\"TotalVat\":26.64,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":166.8,\"ProductDescription\":\"Online-Vereinsverwaltung für Vereine, inkl. DATEV-Schnittstelle:  \\n13,90€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"},{\"Id\":\"000000000000000000000000\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":-11.907545,\"PricePerUnit\":6.9,\"VatPercentage\":19,\"PeriodStart\":\"2024-06-16T11:21:04.1700000Z\",\"PeriodEnd\":\"2023-06-19T05:55:08.2870000Z\",\"PeriodMultiplier\":-11.907545,\"ScaleAmount\":1,\"ProductId\":\"624d591bc926ef3dec5f5722\",\"TotalNet\":-69.06,\"TotalVat\":-13.1,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":-82.16,\"ProductDescription\":\"Online-Vereinsverwaltung für Vereine mit max. 99 Mitgliedern: \\n6,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"},{\"Id\":\"648fedbcc54d63b04857e6c3\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":1,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-19T05:55:08.2870000Z\",\"PeriodEnd\":\"2024-06-19T05:55:08.2870000Z\",\"PeriodMultiplier\":1,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":292.44,\"TotalVat\":55.56,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648b1008bb5c66bc392b5da4\",\"TotalGross\":348,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"},{\"Id\":\"000000000000000000000000\",\"Description\":\"Finanzbuchhaltung\",\"Quantity\":-0.992295,\"PricePerUnit\":348,\"VatPercentage\":19,\"PeriodStart\":\"2024-06-16T11:21:04.1700000Z\",\"PeriodEnd\":\"2023-06-19T05:55:08.2870000Z\",\"PeriodMultiplier\":-0.992295,\"ScaleAmount\":1,\"ProductId\":\"63e0b88dc84ad323253cc9fb\",\"TotalNet\":-290.19,\"TotalVat\":-55.13,\"TaxPolicyId\":\"61fa5359523ea258d5967e72\",\"ComponentSubscriptionId\":\"648b1008bb5c66bc392b5da4\",\"TotalGross\":-345.32,\"ProductDescription\":\"verein.cloud® Finanzbuchhaltung \\n29,00€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[{\"ComponentType\":\"QuantityBased\",\"PreventModification\":false,\"VatPercentage\":0,\"TotalNet\":0,\"TotalVat\":0,\"IsQuantityBased\":false,\"StartDate\":\"2023-06-15T13:20:08.9840000Z\",\"ComponentId\":\"63e0b88dc84ad323253cc9fb\",\"Quantity\":1}],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648b0aa9825aa184b3e065d8\",\"LastBillingDate\":\"2023-06-19T05:55:08.2870000Z\",\"NextBillingDate\":\"2024-06-19T05:55:08.2870000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648b0aa9825aa184b3e065d7\",\"IsDeletable\":false,\"LifecycleStatus\":\"Active\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T12:57:13.4570000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-06-15T12:59:35.2080000Z\",\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-15T13:01:40.6310000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-16T11:21:04.1700000Z\",\"PlanVariantId\":\"624d591bc926ef3dec5f5722\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Normal\",\"StartDate\":\"2023-06-19T05:55:08.2870000Z\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentBearer\":{\"Holder\":\"mangoit\",\"IBAN\":\"DE91100000000123456789\",\"MandateReference\":\"648c45-a3916e-9860e6-849a16\",\"MandateText\":\"Ich ermächtige/ Wir ermächtigen <br>\\n(A) Tineon AG Zahlungen von meinem/ unserem Konto mittels Lastschrift einzuziehen.\\nZugleich <br>\\n weise ich (B) mein/ weisen wir unser Kreditinstitut an, die von Tineon AG auf mein/ unser\\nKonto\\ngezogenen Lastschriften einzulösen. <br>\\n<strong>Hinweis:</strong> Ich kann/ Wir können innerhalb von acht Wochen, beginnend mit\\ndem Belastungsdatum, die\\nErstattung des belasteten Betrages verlangen. Es gelten dabei die mit meinem/ unserem\\nKreditinstitut\\nvereinbarten Bedingungen. <br><p> chairman =    MangoIt</p>\",\"MandateSignatureDate\":\"2023-06-16T11:21:07.3420000Z\",\"Type\":\"BankAccount\",\"Country\":\"de\"},\"PaymentProvider\":\"SepaXml\",\"PaymentProviderRole\":\"Debit\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-19T05:55:08.2870000Z\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":true,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-15T12:57:13.4570000Z\",\"BilledUntil\":\"2024-06-19T05:55:08.2870000Z\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":73.35,\"TotalVat\":13.97,\"TotalGross\":87.32,\"NextTotalGross\":514.8,\"NextTotalGrossDate\":\"2024-06-19T05:55:08.2870000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-19T05:55:08.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung\",\"OrderType\":\"Upgrade\",\"ChangeDate\":\"2023-06-19T05:55:08.2870000Z\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648b0aa9825aa184b3e065d7\",\"ContractId\":\"648b0aa9825aa184b3e065d8\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Christian\",\"LastName\":\"Roth\",\"EmailAddress\":\"Christian@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"10589 Berlin Charlottenburg\",\"PostalCode\":\"653625\",\"City\":\"Leopoldstraße\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"10589 Berlin Charlottenburg\",\"FormattedCityAddressLine\":\"653625 Leopoldstraße\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"BillOnContractStartDate\":false}'),
(181, '648ff37f82bf23d56e032d9d', NULL, '624d58bced3240ead946eac4', '648040036051424d14298576', '2023-06-19 06:19:45', '{\"Id\":\"648ff37f82bf23d56e032d9d\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"648ff37fde0c9ca0b17af11a\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":19.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-19T06:19:43.8480000Z\",\"PeriodEnd\":\"2024-06-19T06:19:43.8480000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"648040036051424d14298576\",\"TotalNet\":200.64,\"TotalVat\":38.16,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":238.8,\"ProductDescription\":\"Online-Vereinsverwaltung\\nverein.cloud® | Start\\n19,90€ inkl. MwSt. pro Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"648ff37fde0c9ca0b17af118\",\"LastBillingDate\":\"2023-06-19T06:19:43.8480000Z\",\"NextBillingDate\":\"2024-06-19T06:19:43.8480000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"648c3b741c4c7c115c0c08cb\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-19T06:19:43.8480000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-19T06:19:43.8480000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-19T06:19:43.8480000Z\",\"BilledUntil\":\"2024-06-19T06:19:43.8480000Z\",\"PlanVariantId\":\"648040036051424d14298576\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":200.64,\"TotalVat\":38.16,\"TotalGross\":238.8,\"NextTotalGross\":238.8,\"NextTotalGrossDate\":\"2024-06-19T06:19:43.8480000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-19T06:19:43.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung + App Light\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"648c3b741c4c7c115c0c08cb\",\"ContractId\":\"648ff37fde0c9ca0b17af118\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Mathias\",\"LastName\":\"Mathias\",\"EmailAddress\":\"Mathias@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Lietzensee-Ufer 11\",\"PostalCode\":\"01653\",\"City\":\"Meißen\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Lietzensee-Ufer 11\",\"FormattedCityAddressLine\":\"01653 Meißen\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(182, '6490088521e3573c7aa181ca', NULL, '624d58bced3240ead946eac4', '6273b2bdbc622b258ac8b8e9', '2023-06-19 07:49:27', '{\"Id\":\"6490088521e3573c7aa181ca\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":true,\"LineItems\":[],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"64900885de0c9ca0b17b4f7a\",\"LastBillingDate\":\"2023-06-19T07:49:25.4540000Z\",\"NextBillingDate\":\"2023-07-19T07:49:25.4540000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"64900885de0c9ca0b17b4f79\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-19T07:49:25.4540000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},{\"Type\":\"Inactive\",\"StartDate\":\"2023-07-19T07:49:25.4540000Z\",\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-19T07:49:25.4540000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-19T07:49:25.4540000Z\",\"EndDate\":\"2023-07-19T07:49:25.4540000Z\",\"BilledUntil\":\"2023-07-19T07:49:25.4540000Z\",\"PlanVariantId\":\"6273b2bdbc622b258ac8b8e9\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":0,\"TotalVat\":0,\"TotalGross\":0,\"NextTotalGross\":0,\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-19T07:49:25.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung TESTEN\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"64900885de0c9ca0b17b4f79\",\"ContractId\":\"64900885de0c9ca0b17b4f7a\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"\",\"LastName\":\"\",\"Language\":\"de\",\"EmailAddress\":\"Herrmann@mailinator.com\",\"Address\":{\"Street\":\"\",\"PostalCode\":\"\",\"City\":\"\",\"Country\":\"DE\"},\"Locale\":\"de\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}'),
(183, '64900a51a22cb29e8b117883', NULL, '624d58bced3240ead946eac4', '624d5901c926ef3dec5f56d2', '2023-06-19 07:57:07', '{\"Id\":\"64900a51a22cb29e8b117883\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"PlanId\":\"624d58bced3240ead946eac4\",\"AllowWithoutPaymentData\":false,\"LineItems\":[{\"Id\":\"64900a51c54d63b0485862da\",\"Description\":\"Vereinsverwaltung\",\"Quantity\":12,\"PricePerUnit\":13.9,\"VatPercentage\":19,\"PeriodStart\":\"2023-06-19T07:57:05.6500000Z\",\"PeriodEnd\":\"2024-06-19T07:57:05.6500000Z\",\"PeriodMultiplier\":12,\"ScaleAmount\":1,\"ProductId\":\"624d5901c926ef3dec5f56d2\",\"TotalNet\":140.16,\"TotalVat\":26.64,\"TaxPolicyId\":\"61fa4f42b34a8e2aec09fe9c\",\"TotalGross\":166.8,\"ProductDescription\":\"Online-Vereinsverwaltung für Vereine, inkl. DATEV-Schnittstelle:  \\n13,90€ inkl. Mwst. im Monat\\n\\nVertragslaufzeit: 1 Jahr\\nKündigungsfrist: 1 Monat zum Vertragsende\"}],\"ComponentSubscriptions\":[],\"DiscountSubscriptions\":[],\"MeteredUsages\":[],\"RatedItems\":[],\"Contract\":{\"Id\":\"64900a51c54d63b0485862d8\",\"LastBillingDate\":\"2023-06-19T07:57:05.6500000Z\",\"NextBillingDate\":\"2024-06-19T07:57:05.6500000Z\",\"PlanId\":\"624d58bced3240ead946eac4\",\"CustomerId\":\"64900885de0c9ca0b17b4f79\",\"IsDeletable\":false,\"LifecycleStatus\":\"InOrderProcess\",\"CustomerName\":\"mangoit\",\"CustomerIsLocked\":false,\"Phases\":[{\"Type\":\"Normal\",\"StartDate\":\"2023-06-19T07:57:05.6500000Z\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false}],\"Pauses\":[],\"Balance\":0,\"Currency\":\"EUR\",\"PlanGroupId\":\"61fa4f42b34a8e2aec09fe9e\",\"PriceListId\":\"638df4bfcd42795dd4bc6936\",\"PaymentProviderRole\":\"\",\"InitialPaymentProviderRole\":\"\",\"EscalationSuspended\":false,\"RecurringPaymentsPaused\":false,\"CurrentPhase\":{\"Type\":\"Normal\",\"StartDate\":\"2023-06-19T07:57:05.6500000Z\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"PlanId\":\"624d58bced3240ead946eac4\",\"Quantity\":1,\"InheritStartDate\":false},\"PaymentProviderSupportRefunds\":false,\"BillingSuspended\":false,\"ThresholdBillingDisabled\":false,\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"TimeGranularity\":\"Precise\",\"StartDate\":\"2023-06-19T07:57:05.6500000Z\",\"BilledUntil\":\"2024-06-19T07:57:05.6500000Z\",\"PlanVariantId\":\"624d5901c926ef3dec5f56d2\",\"CustomFields\":{}},\"Currency\":\"EUR\",\"Total\":140.16,\"TotalVat\":26.64,\"TotalGross\":166.8,\"NextTotalGross\":166.8,\"NextTotalGrossDate\":\"2024-06-19T07:57:05.6500000Z\",\"IsTrial\":false,\"TrialEndPolicy\":\"NoTrial\",\"Status\":\"InProgress\",\"CreatedAt\":\"2023-06-19T07:57:05.0000000Z\",\"PlanName\":\"Vereinsverwaltung\",\"PlanVariantName\":\"Vereinsverwaltung\",\"OrderType\":\"Signup\",\"TriggerInterimBilling\":false,\"CustomerId\":\"64900885de0c9ca0b17b4f79\",\"ContractId\":\"64900a51c54d63b0485862d8\",\"Customer\":{\"CompanyName\":\"mangoit\",\"FirstName\":\"Mandy\",\"LastName\":\"Herrmann\",\"EmailAddress\":\"Herrmann@mailinator.com\",\"AdditionalEmailAddresses\":[],\"Address\":{\"Street\":\"Lietzenburger Strasse 98\",\"PostalCode\":\"51427\",\"City\":\"Bergisch\",\"Country\":\"DE\",\"FormattedStreetAddressLine\":\"Lietzenburger Strasse 98\",\"FormattedCityAddressLine\":\"51427 Bergisch\"},\"AdditionalAddresses\":[],\"CustomFields\":{},\"DefaultBearerMedium\":\"Email\",\"CustomerType\":\"Consumer\",\"Hidden\":false},\"ContractCustomFields\":{},\"PreviewAfterTrial\":false,\"CustomFields\":{},\"SalesEntityId\":\"61fa4f42b34a8e2aec09fe94\",\"BillOnContractStartDate\":false}');
