IMPORTANTgothere112createnewcart112sql error: :INSERT INTO `person` (
`agent_id`,
`name-de`,
`name-en`,
`personal_key`,
`salutation`,
`sex`,
`lastname`,
`firstname`,
`street`,
`zip`,
`city`,
`country`,
`date_of_birth`,
`phone`,
`email`,
`billing_tgtp`,
`health_insurance`,
`health_insurance_card_number`,
`last_reference`,
`last_used_at`
) VALUES (
8,
'',
'',
'',
1,
9,
'',
'',
'',
'3052',
'Zollikofen',
40,
'1983-12-05 00:00:00',
'+41 79 578 00 00',
'oliver@amonn.ch',
96,
'36',
'80756009940017532381',
'0011_000008_11.05.22.csv-import-2',
'2025-03-17 11:11:41'
);
sql error: :INSERT INTO cart (
`agent_id`,
`remitter_type`,
`remitter_source`,
`remitter_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`person_id`,
`date`,
`order_type`,
`cart_status`,
`currency`,
`total_excl_tax`,
`total_tax`,
`total_incl_tax`,
`payment_type`,
`payment_info`,
`external_ordernumber`,
`reference`,
`sampling_date`,
`sampling_type`,
`health_insurance`,
`health_insurance_number`,
`health_insurance_card_number`,
`accident`,
`person_phone`,
`person_email`,
`copy_to_person_by`,
`copy_to_alternate_by`,
`comment`,
`copy_to_alternate_hin`,
`copy_to_alternate_name`,
`invoice_to_remitter_id`,
`invoice_code_to`,
`corona_travel_report`,
`corona_inv_pcr`,
`corona_inv_sero`) VALUES (
8,
36,
38,
2965,
'',
'',
'',
'',
'',
'2022-04-15 11:30:00',
33,
90,
'CHF',
0,
0,
0,
12,
'',
'',
'0011_000008_11.05.22.csv-import-2',
'2022-04-15 11:30:00',
39,
36,
'',
'80756009940017532381',
0,
'+41 79 578 00 00',
'oliver@amonn.ch',
144,
146,
'',
'',
'',
0,
84,
0,
'',
'');
sql error: :INSERT INTO cart_item (
`agent_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`cart_id`,
`position_order`,
`number`,
`analysis_block_id`,
`analysis_id`,
`orderentry_method_id`,
`service_id`,
`lis_code`,
`specialization`,
`material_text`,
`material_code`,
`material_shortname`,
`labor_id`,
`lis_transfer`,
`price_excl`,
`price`,
`total`,
`tax`) VALUES (
8,
'',
'',
'Antigen-Schnelltest SARS-CoV-2',
'',
'',
0,
1,
0,
180,
0,
NULL,
'AgSARSCoV2testc',
'chem',
'Nasopharynxabstrich',
'',
'',
'intern',
1,
47,
47,
47,
0);
gothere112createnewcart112sql error: :INSERT INTO `person` (
`agent_id`,
`name-de`,
`name-en`,
`personal_key`,
`salutation`,
`sex`,
`lastname`,
`firstname`,
`street`,
`zip`,
`city`,
`country`,
`date_of_birth`,
`phone`,
`email`,
`billing_tgtp`,
`health_insurance`,
`health_insurance_card_number`,
`last_reference`,
`last_used_at`
) VALUES (
8,
'',
'',
'',
2,
8,
'',
'',
'',
'3052',
'Zollikofen',
40,
'1985-09-10 00:00:00',
'+41 79 534 62 84',
'christina@amonn.ch',
96,
'7',
'80756003120015422502',
'0011_000008_11.05.22.csv-import-3',
'2025-03-17 11:11:41'
);
sql error: :INSERT INTO cart (
`agent_id`,
`remitter_type`,
`remitter_source`,
`remitter_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`person_id`,
`date`,
`order_type`,
`cart_status`,
`currency`,
`total_excl_tax`,
`total_tax`,
`total_incl_tax`,
`payment_type`,
`payment_info`,
`external_ordernumber`,
`reference`,
`sampling_date`,
`sampling_type`,
`health_insurance`,
`health_insurance_number`,
`health_insurance_card_number`,
`accident`,
`person_phone`,
`person_email`,
`copy_to_person_by`,
`copy_to_alternate_by`,
`comment`,
`copy_to_alternate_hin`,
`copy_to_alternate_name`,
`invoice_to_remitter_id`,
`invoice_code_to`,
`corona_travel_report`,
`corona_inv_pcr`,
`corona_inv_sero`) VALUES (
8,
36,
38,
2965,
'',
'',
'',
'',
'',
'2022-04-15 11:35:00',
33,
90,
'CHF',
0,
0,
0,
12,
'',
'',
'0011_000008_11.05.22.csv-import-3',
'2022-04-15 11:35:00',
39,
7,
'',
'80756003120015422502',
0,
'+41 79 534 62 84',
'christina@amonn.ch',
144,
146,
'',
'',
'',
0,
84,
0,
'',
'');
sql error: :INSERT INTO cart_item (
`agent_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`cart_id`,
`position_order`,
`number`,
`analysis_block_id`,
`analysis_id`,
`orderentry_method_id`,
`service_id`,
`lis_code`,
`specialization`,
`material_text`,
`material_code`,
`material_shortname`,
`labor_id`,
`lis_transfer`,
`price_excl`,
`price`,
`total`,
`tax`) VALUES (
8,
'',
'',
'Antigen-Schnelltest SARS-CoV-2',
'',
'',
0,
1,
0,
180,
0,
NULL,
'AgSARSCoV2testc',
'chem',
'Nasopharynxabstrich',
'',
'',
'intern',
1,
47,
47,
47,
0);
gothere112createnewcart112sql error: :INSERT INTO `person` (
`agent_id`,
`name-de`,
`name-en`,
`personal_key`,
`salutation`,
`sex`,
`lastname`,
`firstname`,
`street`,
`zip`,
`city`,
`country`,
`date_of_birth`,
`phone`,
`email`,
`billing_tgtp`,
`health_insurance`,
`health_insurance_card_number`,
`last_reference`,
`last_used_at`
) VALUES (
8,
'',
'',
'',
1,
9,
'',
'',
'',
'3925',
'Grächen',
40,
'1982-07-31 00:00:00',
'+41 79 860 13 43',
'davide.rausa@icloud.com',
96,
'40',
'80756015090041361071',
'0011_000008_11.05.22.csv-import-4',
'2025-03-17 11:11:41'
);
sql error: :INSERT INTO cart (
`agent_id`,
`remitter_type`,
`remitter_source`,
`remitter_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`person_id`,
`date`,
`order_type`,
`cart_status`,
`currency`,
`total_excl_tax`,
`total_tax`,
`total_incl_tax`,
`payment_type`,
`payment_info`,
`external_ordernumber`,
`reference`,
`sampling_date`,
`sampling_type`,
`health_insurance`,
`health_insurance_number`,
`health_insurance_card_number`,
`accident`,
`person_phone`,
`person_email`,
`copy_to_person_by`,
`copy_to_alternate_by`,
`comment`,
`copy_to_alternate_hin`,
`copy_to_alternate_name`,
`invoice_to_remitter_id`,
`invoice_code_to`,
`corona_travel_report`,
`corona_inv_pcr`,
`corona_inv_sero`) VALUES (
8,
36,
38,
2965,
'',
'',
'',
'',
'',
'2022-04-15 18:05:00',
33,
90,
'CHF',
0,
0,
0,
12,
'',
'',
'0011_000008_11.05.22.csv-import-4',
'2022-04-15 18:05:00',
39,
40,
'',
'80756015090041361071',
0,
'+41 79 860 13 43',
'davide.rausa@icloud.com',
144,
146,
'',
'',
'',
0,
84,
0,
'',
'');
sql error: :INSERT INTO cart_item (
`agent_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`cart_id`,
`position_order`,
`number`,
`analysis_block_id`,
`analysis_id`,
`orderentry_method_id`,
`service_id`,
`lis_code`,
`specialization`,
`material_text`,
`material_code`,
`material_shortname`,
`labor_id`,
`lis_transfer`,
`price_excl`,
`price`,
`total`,
`tax`) VALUES (
8,
'',
'',
'Antigen-Schnelltest SARS-CoV-2',
'',
'',
0,
1,
0,
180,
0,
NULL,
'AgSARSCoV2testc',
'chem',
'Nasopharynxabstrich',
'',
'',
'intern',
1,
47,
47,
47,
0);
gothere112createnewcart112sql error: :INSERT INTO `person` (
`agent_id`,
`name-de`,
`name-en`,
`personal_key`,
`salutation`,
`sex`,
`lastname`,
`firstname`,
`street`,
`zip`,
`city`,
`country`,
`date_of_birth`,
`phone`,
`email`,
`billing_tgtp`,
`health_insurance`,
`health_insurance_card_number`,
`last_reference`,
`last_used_at`
) VALUES (
8,
'',
'',
'',
1,
9,
'',
'',
'',
'3014',
'Bern',
40,
'1968-09-26 00:00:00',
'+41 79 920 42 14',
'dg@feelitprod.ch',
96,
'23',
'80756015620047512554',
'0011_000008_11.05.22.csv-import-5',
'2025-03-17 11:11:41'
);
sql error: :INSERT INTO cart (
`agent_id`,
`remitter_type`,
`remitter_source`,
`remitter_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`person_id`,
`date`,
`order_type`,
`cart_status`,
`currency`,
`total_excl_tax`,
`total_tax`,
`total_incl_tax`,
`payment_type`,
`payment_info`,
`external_ordernumber`,
`reference`,
`sampling_date`,
`sampling_type`,
`health_insurance`,
`health_insurance_number`,
`health_insurance_card_number`,
`accident`,
`person_phone`,
`person_email`,
`copy_to_person_by`,
`copy_to_alternate_by`,
`comment`,
`copy_to_alternate_hin`,
`copy_to_alternate_name`,
`invoice_to_remitter_id`,
`invoice_code_to`,
`corona_travel_report`,
`corona_inv_pcr`,
`corona_inv_sero`) VALUES (
8,
36,
38,
2965,
'',
'',
'',
'',
'',
'2022-04-16 17:35:00',
33,
90,
'CHF',
0,
0,
0,
12,
'',
'',
'0011_000008_11.05.22.csv-import-5',
'2022-04-16 17:35:00',
39,
23,
'',
'80756015620047512554',
0,
'+41 79 920 42 14',
'dg@feelitprod.ch',
144,
146,
'',
'',
'',
0,
84,
0,
'',
'');
sql error: :INSERT INTO cart_item (
`agent_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`cart_id`,
`position_order`,
`number`,
`analysis_block_id`,
`analysis_id`,
`orderentry_method_id`,
`service_id`,
`lis_code`,
`specialization`,
`material_text`,
`material_code`,
`material_shortname`,
`labor_id`,
`lis_transfer`,
`price_excl`,
`price`,
`total`,
`tax`) VALUES (
8,
'',
'',
'Antigen-Schnelltest SARS-CoV-2',
'',
'',
0,
1,
0,
180,
0,
NULL,
'AgSARSCoV2testc',
'chem',
'Nasopharynxabstrich',
'',
'',
'intern',
1,
47,
47,
47,
0);
gothere112createnewcart112sql error: :INSERT INTO `person` (
`agent_id`,
`name-de`,
`name-en`,
`personal_key`,
`salutation`,
`sex`,
`lastname`,
`firstname`,
`street`,
`zip`,
`city`,
`country`,
`date_of_birth`,
`phone`,
`email`,
`billing_tgtp`,
`health_insurance`,
`health_insurance_card_number`,
`last_reference`,
`last_used_at`
) VALUES (
8,
'',
'',
'',
1,
9,
'',
'',
'',
'3303',
'Jegenstorf',
40,
'1966-03-10 00:00:00',
'+41 79 296 36 68',
'',
96,
'50',
'80756005090019654679',
'0011_000008_11.05.22.csv-import-6',
'2025-03-17 11:11:41'
);
sql error: :INSERT INTO cart (
`agent_id`,
`remitter_type`,
`remitter_source`,
`remitter_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`person_id`,
`date`,
`order_type`,
`cart_status`,
`currency`,
`total_excl_tax`,
`total_tax`,
`total_incl_tax`,
`payment_type`,
`payment_info`,
`external_ordernumber`,
`reference`,
`sampling_date`,
`sampling_type`,
`health_insurance`,
`health_insurance_number`,
`health_insurance_card_number`,
`accident`,
`person_phone`,
`person_email`,
`copy_to_person_by`,
`copy_to_alternate_by`,
`comment`,
`copy_to_alternate_hin`,
`copy_to_alternate_name`,
`invoice_to_remitter_id`,
`invoice_code_to`,
`corona_travel_report`,
`corona_inv_pcr`,
`corona_inv_sero`) VALUES (
8,
36,
38,
2965,
'',
'',
'',
'',
'',
'2022-04-16 14:15:00',
33,
90,
'CHF',
0,
0,
0,
12,
'',
'',
'0011_000008_11.05.22.csv-import-6',
'2022-04-16 14:15:00',
39,
50,
'',
'80756005090019654679',
0,
'+41 79 296 36 68',
'',
144,
146,
'',
'',
'',
0,
84,
0,
'',
'');
sql error: :INSERT INTO cart_item (
`agent_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`cart_id`,
`position_order`,
`number`,
`analysis_block_id`,
`analysis_id`,
`orderentry_method_id`,
`service_id`,
`lis_code`,
`specialization`,
`material_text`,
`material_code`,
`material_shortname`,
`labor_id`,
`lis_transfer`,
`price_excl`,
`price`,
`total`,
`tax`) VALUES (
8,
'',
'',
'Antigen-Schnelltest SARS-CoV-2',
'',
'',
0,
1,
0,
180,
0,
NULL,
'AgSARSCoV2testc',
'chem',
'Nasopharynxabstrich',
'',
'',
'intern',
1,
47,
47,
47,
0);
gothere112createnewcart112sql error: :INSERT INTO `person` (
`agent_id`,
`name-de`,
`name-en`,
`personal_key`,
`salutation`,
`sex`,
`lastname`,
`firstname`,
`street`,
`zip`,
`city`,
`country`,
`date_of_birth`,
`phone`,
`email`,
`billing_tgtp`,
`health_insurance`,
`health_insurance_card_number`,
`last_reference`,
`last_used_at`
) VALUES (
8,
'',
'',
'',
1,
9,
'',
'',
'',
'3097',
'Liebefeld',
40,
'2000-09-21 00:00:00',
'+41 79 680 49 47',
'yago@tanzkarussell.com',
96,
'46',
'80756013840040821228',
'0011_000008_11.05.22.csv-import-7',
'2025-03-17 11:11:41'
);
sql error: :INSERT INTO cart (
`agent_id`,
`remitter_type`,
`remitter_source`,
`remitter_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`person_id`,
`date`,
`order_type`,
`cart_status`,
`currency`,
`total_excl_tax`,
`total_tax`,
`total_incl_tax`,
`payment_type`,
`payment_info`,
`external_ordernumber`,
`reference`,
`sampling_date`,
`sampling_type`,
`health_insurance`,
`health_insurance_number`,
`health_insurance_card_number`,
`accident`,
`person_phone`,
`person_email`,
`copy_to_person_by`,
`copy_to_alternate_by`,
`comment`,
`copy_to_alternate_hin`,
`copy_to_alternate_name`,
`invoice_to_remitter_id`,
`invoice_code_to`,
`corona_travel_report`,
`corona_inv_pcr`,
`corona_inv_sero`) VALUES (
8,
36,
38,
2965,
'',
'',
'',
'',
'',
'2022-04-14 11:45:00',
33,
90,
'CHF',
0,
0,
0,
12,
'',
'',
'0011_000008_11.05.22.csv-import-7',
'2022-04-14 11:45:00',
39,
46,
'',
'80756013840040821228',
0,
'+41 79 680 49 47',
'yago@tanzkarussell.com',
144,
146,
'',
'',
'',
0,
84,
0,
'',
'');
sql error: :INSERT INTO cart_item (
`agent_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`cart_id`,
`position_order`,
`number`,
`analysis_block_id`,
`analysis_id`,
`orderentry_method_id`,
`service_id`,
`lis_code`,
`specialization`,
`material_text`,
`material_code`,
`material_shortname`,
`labor_id`,
`lis_transfer`,
`price_excl`,
`price`,
`total`,
`tax`) VALUES (
8,
'',
'',
'Antigen-Schnelltest SARS-CoV-2',
'',
'',
0,
1,
0,
180,
0,
NULL,
'AgSARSCoV2testc',
'chem',
'Nasopharynxabstrich',
'',
'',
'intern',
1,
47,
47,
47,
0);
gothere112createnewcart112sql error: :INSERT INTO `person` (
`agent_id`,
`name-de`,
`name-en`,
`personal_key`,
`salutation`,
`sex`,
`lastname`,
`firstname`,
`street`,
`zip`,
`city`,
`country`,
`date_of_birth`,
`phone`,
`email`,
`billing_tgtp`,
`health_insurance`,
`health_insurance_card_number`,
`last_reference`,
`last_used_at`
) VALUES (
8,
'',
'',
'',
1,
9,
'',
'',
'',
'8004',
'Zürich',
40,
'1988-10-21 00:00:00',
'+41 79 768 80 43',
'd_kummer@msn.com',
96,
'17',
'80756008810013913412',
'0011_000008_11.05.22.csv-import-8',
'2025-03-17 11:11:41'
);
sql error: :INSERT INTO cart (
`agent_id`,
`remitter_type`,
`remitter_source`,
`remitter_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`person_id`,
`date`,
`order_type`,
`cart_status`,
`currency`,
`total_excl_tax`,
`total_tax`,
`total_incl_tax`,
`payment_type`,
`payment_info`,
`external_ordernumber`,
`reference`,
`sampling_date`,
`sampling_type`,
`health_insurance`,
`health_insurance_number`,
`health_insurance_card_number`,
`accident`,
`person_phone`,
`person_email`,
`copy_to_person_by`,
`copy_to_alternate_by`,
`comment`,
`copy_to_alternate_hin`,
`copy_to_alternate_name`,
`invoice_to_remitter_id`,
`invoice_code_to`,
`corona_travel_report`,
`corona_inv_pcr`,
`corona_inv_sero`) VALUES (
8,
36,
38,
2965,
'',
'',
'',
'',
'',
'2022-04-14 17:55:00',
33,
90,
'CHF',
0,
0,
0,
12,
'',
'',
'0011_000008_11.05.22.csv-import-8',
'2022-04-14 17:55:00',
39,
17,
'',
'80756008810013913412',
0,
'+41 79 768 80 43',
'd_kummer@msn.com',
144,
146,
'',
'',
'',
0,
84,
0,
'',
'');
sql error: :INSERT INTO cart_item (
`agent_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`cart_id`,
`position_order`,
`number`,
`analysis_block_id`,
`analysis_id`,
`orderentry_method_id`,
`service_id`,
`lis_code`,
`specialization`,
`material_text`,
`material_code`,
`material_shortname`,
`labor_id`,
`lis_transfer`,
`price_excl`,
`price`,
`total`,
`tax`) VALUES (
8,
'',
'',
'Antigen-Schnelltest SARS-CoV-2',
'',
'',
0,
1,
0,
180,
0,
NULL,
'AgSARSCoV2testc',
'chem',
'Nasopharynxabstrich',
'',
'',
'intern',
1,
47,
47,
47,
0);
gothere112createnewcart112sql error: :INSERT INTO `person` (
`agent_id`,
`name-de`,
`name-en`,
`personal_key`,
`salutation`,
`sex`,
`lastname`,
`firstname`,
`street`,
`zip`,
`city`,
`country`,
`date_of_birth`,
`phone`,
`email`,
`billing_tgtp`,
`health_insurance`,
`health_insurance_card_number`,
`last_reference`,
`last_used_at`
) VALUES (
8,
'',
'',
'',
1,
9,
'',
'',
'',
'3014',
'Bern',
40,
'1994-04-13 00:00:00',
'+41 78 683 60 63',
'remomichael@hotmail.de',
96,
'40',
'80756015090038771705',
'0011_000008_11.05.22.csv-import-9',
'2025-03-17 11:11:41'
);
sql error: :INSERT INTO cart (
`agent_id`,
`remitter_type`,
`remitter_source`,
`remitter_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`person_id`,
`date`,
`order_type`,
`cart_status`,
`currency`,
`total_excl_tax`,
`total_tax`,
`total_incl_tax`,
`payment_type`,
`payment_info`,
`external_ordernumber`,
`reference`,
`sampling_date`,
`sampling_type`,
`health_insurance`,
`health_insurance_number`,
`health_insurance_card_number`,
`accident`,
`person_phone`,
`person_email`,
`copy_to_person_by`,
`copy_to_alternate_by`,
`comment`,
`copy_to_alternate_hin`,
`copy_to_alternate_name`,
`invoice_to_remitter_id`,
`invoice_code_to`,
`corona_travel_report`,
`corona_inv_pcr`,
`corona_inv_sero`) VALUES (
8,
36,
38,
2966,
'',
'',
'',
'',
'',
'2022-04-15 12:00:00',
33,
90,
'CHF',
0,
0,
0,
12,
'',
'',
'0011_000008_11.05.22.csv-import-9',
'2022-04-15 12:00:00',
39,
40,
'',
'80756015090038771705',
0,
'+41 78 683 60 63',
'remomichael@hotmail.de',
144,
146,
'',
'',
'',
0,
84,
0,
'',
'');
sql error: :INSERT INTO cart_item (
`agent_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`cart_id`,
`position_order`,
`number`,
`analysis_block_id`,
`analysis_id`,
`orderentry_method_id`,
`service_id`,
`lis_code`,
`specialization`,
`material_text`,
`material_code`,
`material_shortname`,
`labor_id`,
`lis_transfer`,
`price_excl`,
`price`,
`total`,
`tax`) VALUES (
8,
'',
'',
'Antigen-Schnelltest SARS-CoV-2',
'',
'',
0,
1,
0,
180,
0,
NULL,
'AgSARSCoV2testc',
'chem',
'Nasopharynxabstrich',
'',
'',
'intern',
1,
47,
47,
47,
0);
gothere112createnewcart112sql error: :INSERT INTO `person` (
`agent_id`,
`name-de`,
`name-en`,
`personal_key`,
`salutation`,
`sex`,
`lastname`,
`firstname`,
`street`,
`zip`,
`city`,
`country`,
`date_of_birth`,
`phone`,
`email`,
`billing_tgtp`,
`health_insurance`,
`health_insurance_card_number`,
`last_reference`,
`last_used_at`
) VALUES (
8,
'',
'',
'',
1,
9,
'',
'',
'',
'3012',
'Bern',
40,
'1983-07-20 00:00:00',
'+41 78 770 06 79',
'thierry.beyeler@vicero.com',
96,
'36',
'80756009940011812646',
'0011_000008_11.05.22.csv-import-10',
'2025-03-17 11:11:41'
);
sql error: :INSERT INTO cart (
`agent_id`,
`remitter_type`,
`remitter_source`,
`remitter_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`person_id`,
`date`,
`order_type`,
`cart_status`,
`currency`,
`total_excl_tax`,
`total_tax`,
`total_incl_tax`,
`payment_type`,
`payment_info`,
`external_ordernumber`,
`reference`,
`sampling_date`,
`sampling_type`,
`health_insurance`,
`health_insurance_number`,
`health_insurance_card_number`,
`accident`,
`person_phone`,
`person_email`,
`copy_to_person_by`,
`copy_to_alternate_by`,
`comment`,
`copy_to_alternate_hin`,
`copy_to_alternate_name`,
`invoice_to_remitter_id`,
`invoice_code_to`,
`corona_travel_report`,
`corona_inv_pcr`,
`corona_inv_sero`) VALUES (
8,
36,
38,
2965,
'',
'',
'',
'',
'',
'2022-04-14 12:05:00',
33,
90,
'CHF',
0,
0,
0,
12,
'',
'',
'0011_000008_11.05.22.csv-import-10',
'2022-04-14 12:05:00',
39,
36,
'',
'80756009940011812646',
0,
'+41 78 770 06 79',
'thierry.beyeler@vicero.com',
144,
146,
'',
'',
'',
0,
84,
0,
'',
'');
sql error: :INSERT INTO cart_item (
`agent_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`cart_id`,
`position_order`,
`number`,
`analysis_block_id`,
`analysis_id`,
`orderentry_method_id`,
`service_id`,
`lis_code`,
`specialization`,
`material_text`,
`material_code`,
`material_shortname`,
`labor_id`,
`lis_transfer`,
`price_excl`,
`price`,
`total`,
`tax`) VALUES (
8,
'',
'',
'Antigen-Schnelltest SARS-CoV-2',
'',
'',
0,
1,
0,
180,
0,
NULL,
'AgSARSCoV2testc',
'chem',
'Nasopharynxabstrich',
'',
'',
'intern',
1,
47,
47,
47,
0);
fehlt kkgothere112createnewcart112
deckungsabfragbar112:11
sql error: :INSERT INTO `person` (
`agent_id`,
`name-de`,
`name-en`,
`personal_key`,
`salutation`,
`sex`,
`lastname`,
`firstname`,
`street`,
`zip`,
`city`,
`country`,
`date_of_birth`,
`phone`,
`email`,
`billing_tgtp`,
`health_insurance`,
`health_insurance_card_number`,
`last_reference`,
`last_used_at`
) VALUES (
8,
'',
'',
'',
2,
8,
'',
'',
'',
'3924',
'St. Niklaus',
40,
'1979-05-30 00:00:00',
'+41 79 307 90 13',
'patricia_anthamatten@bluewin.ch',
96,
'0',
'80756015690012303643',
'0011_000008_11.05.22.csv-import-11',
'2025-03-17 11:11:41'
);
sql error: :INSERT INTO cart (
`agent_id`,
`remitter_type`,
`remitter_source`,
`remitter_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`person_id`,
`date`,
`order_type`,
`cart_status`,
`currency`,
`total_excl_tax`,
`total_tax`,
`total_incl_tax`,
`payment_type`,
`payment_info`,
`external_ordernumber`,
`reference`,
`sampling_date`,
`sampling_type`,
`health_insurance`,
`health_insurance_number`,
`health_insurance_card_number`,
`accident`,
`person_phone`,
`person_email`,
`copy_to_person_by`,
`copy_to_alternate_by`,
`comment`,
`copy_to_alternate_hin`,
`copy_to_alternate_name`,
`invoice_to_remitter_id`,
`invoice_code_to`,
`corona_travel_report`,
`corona_inv_pcr`,
`corona_inv_sero`) VALUES (
8,
36,
38,
2965,
'',
'',
'',
'',
'',
'2022-04-14 16:00:00',
33,
90,
'CHF',
0,
0,
0,
12,
'',
'',
'0011_000008_11.05.22.csv-import-11',
'2022-04-14 16:00:00',
39,
0,
'',
'80756015690012303643',
0,
'+41 79 307 90 13',
'patricia_anthamatten@bluewin.ch',
144,
146,
'',
'',
'',
0,
84,
0,
'',
'');
sql error: :INSERT INTO cart_item (
`agent_id`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`cart_id`,
`position_order`,
`number`,
`analysis_block_id`,
`analysis_id`,
`orderentry_method_id`,
`service_id`,
`lis_code`,
`specialization`,
`material_text`,
`material_code`,
`material_shortname`,
`labor_id`,
`lis_transfer`,
`price_excl`,
`price`,
`total`,
`tax`) VALUES (
8,
'',
'',
'PCR SARS-CoV-2',
'',
'',
0,
1,
0,
181,
0,
NULL,
'PCRSARSCoV2testc',
'chem',
'Nasopharynxabstrich',
'',
'',
'intern',
1,
159,
159,
159,
0);
deckungsql error: :UPDATE cart SET veka_req_datetime ='2025-03-17 11:11:41' WHERE id =