10/05/2024 08:28:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1518' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 08:28:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1518' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 10/05/2024 08:28:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91721' 10/05/2024 08:28:38 am >> DELETE FROM ps_document_detail WHERE id_document = '91721' 10/05/2024 08:28:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91721' , '22475' , 'AMEN - LUG. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 10/05/2024 08:28:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91721' , '22476' , 'AMEN - AGO 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 10/05/2024 09:55:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1519' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 09:55:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1519' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.21' , NOW() , NOW() ) 10/05/2024 09:55:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91722' 10/05/2024 09:55:13 am >> DELETE FROM ps_document_detail WHERE id_document = '91722' 10/05/2024 09:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91722' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '30' , '-30' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '21.00' ) 10/05/2024 09:55:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1520' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 09:55:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1520' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 10/05/2024 09:55:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91723' 10/05/2024 09:55:20 am >> DELETE FROM ps_document_detail WHERE id_document = '91723' 10/05/2024 09:55:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91723' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 10/05/2024 09:57:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1521' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 09:57:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1521' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 10/05/2024 09:57:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91724' 10/05/2024 09:57:10 am >> DELETE FROM ps_document_detail WHERE id_document = '91724' 10/05/2024 09:57:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91724' , '21099' , 'BRACCIALE DECINA - BD008' , '6' , '-6' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '12.00' ) 10/05/2024 10:33:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1522' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 10:33:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1522' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.30' , '13.30' , NOW() , NOW() ) 10/05/2024 10:33:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91725' 10/05/2024 10:33:43 am >> DELETE FROM ps_document_detail WHERE id_document = '91725' 10/05/2024 10:33:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91725' , '22510' , 'DA CUORE A CUORE - M. CROVETTO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 10/05/2024 10:52:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1523' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 10:52:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1523' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '45.00' , NOW() , NOW() ) 10/05/2024 10:52:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91726' 10/05/2024 10:52:15 am >> DELETE FROM ps_document_detail WHERE id_document = '91726' 10/05/2024 10:52:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91726' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' ) 10/05/2024 11:08:08 am >> SELECT document_num FROM ps_document WHERE document_num = '23' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 11:08:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '23' , '2024-05-10' , '' , '7099' , '0' , '177359031' , 'via fogazzaro , 8 97100 Ragusa' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '18.34' , '18.34' , NOW() , NOW() ) 10/05/2024 11:08:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14724' 10/05/2024 11:08:08 am >> DELETE FROM ps_document_detail WHERE id_document = '14724' 10/05/2024 11:08:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14724' , '125' , 'MIE PREGHIERINE - N. E.' , '8' , '-8' , '4' , '1.43' , '1.43' , '0' , '0' , '11.44' ) 10/05/2024 11:16:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1524' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 11:16:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1524' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.00' , '23.77' , NOW() , NOW() ) 10/05/2024 11:16:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91727' 10/05/2024 11:16:34 am >> DELETE FROM ps_document_detail WHERE id_document = '91727' 10/05/2024 11:16:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91727' , '18045' , 'TECA INCISA - 515' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 10/05/2024 11:24:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1525' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 11:24:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1525' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.00' , '59.02' , NOW() , NOW() ) 10/05/2024 11:24:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91728' 10/05/2024 11:24:28 am >> DELETE FROM ps_document_detail WHERE id_document = '91728' 10/05/2024 11:24:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91728' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '10' , '36.00' ) 10/05/2024 11:24:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91728' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '10' , '36.00' ) 10/05/2024 11:31:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1526' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 11:31:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1526' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.08' , '48.70' , NOW() , NOW() ) 10/05/2024 11:31:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91729' 10/05/2024 11:31:33 am >> DELETE FROM ps_document_detail WHERE id_document = '91729' 10/05/2024 11:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91729' , '10330' , 'STRAPPINO SACRAMENTI CON BRACCIALE - CONFESSIONE ' , '3' , '-3' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '5.40' ) 10/05/2024 11:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91729' , '5832' , 'LIBRO DEI SANTI' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 10/05/2024 11:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91729' , '21057' , 'MIA CONFESSIONE' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 10/05/2024 11:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91729' , '21055' , 'MIA PRIMA EUCARISTIA ' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 10/05/2024 11:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91729' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '5' , '-5' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '30.00' ) 10/05/2024 11:31:56 am >> SELECT document_num FROM ps_document WHERE document_num = '1527' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 11:31:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1527' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.80' , '23.61' , NOW() , NOW() ) 10/05/2024 11:31:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91730' 10/05/2024 11:31:56 am >> DELETE FROM ps_document_detail WHERE id_document = '91730' 10/05/2024 11:31:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91730' , '21103' , 'ROSARIO DECINA GIALLO - R333-32' , '36' , '-36' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '28.80' ) 10/05/2024 11:32:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1528' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 11:32:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1528' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 10/05/2024 11:32:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91731' 10/05/2024 11:32:55 am >> DELETE FROM ps_document_detail WHERE id_document = '91731' 10/05/2024 11:32:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91731' , '19316' , 'SCATOLINA METALLO CON CORONCINA CONFESSIONE - 1016/K159' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 10/05/2024 12:04:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1529' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 12:04:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1529' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '23.08' , NOW() , NOW() ) 10/05/2024 12:04:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91732' 10/05/2024 12:04:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '91732' 10/05/2024 12:04:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91732' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 10/05/2024 12:04:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91732' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 10/05/2024 12:04:47 pm >> DELETE FROM ps_document WHERE id_document = '91480' 10/05/2024 12:04:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '91480' 10/05/2024 12:05:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1530' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 12:05:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1530' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.90' , '16.31' , NOW() , NOW() ) 10/05/2024 12:05:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91733' 10/05/2024 12:05:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '91733' 10/05/2024 12:05:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91733' , '10475' , 'TEALIGHTS X 50 ' , '1' , '-1' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '3.90' ) 10/05/2024 12:05:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91733' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '32' , '-32' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '16.00' ) 10/05/2024 12:12:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1531' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 12:12:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1531' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '6.73' , NOW() , NOW() ) 10/05/2024 12:12:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91734' 10/05/2024 12:12:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '91734' 10/05/2024 12:12:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91734' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 10/05/2024 12:18:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1532' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 12:18:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1532' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '187.61' , '159.80' , NOW() , NOW() ) 10/05/2024 12:18:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91735' 10/05/2024 12:18:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '91735' 10/05/2024 12:18:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 10/05/2024 12:18:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '3' , '-3' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '30.00' ) 10/05/2024 12:18:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '14.00' ) 10/05/2024 12:18:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 10/05/2024 12:18:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '10471' , 'TAVOLETTE SAGOMATE 10X15 - S. PIO' , '4' , '-4' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '8.80' ) 10/05/2024 12:18:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 10/05/2024 12:18:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '22511' , 'VIVE - CD' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 10/05/2024 12:18:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '22513' , 'VIVE - SPARTITO' , '1' , '-1' , '3' , '12.00' , '11.538461538462' , '4' , '5' , '11.40' ) 10/05/2024 12:18:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 10/05/2024 12:18:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '24' , '19.672131147541' , '22' , '0' , '24.00' ) 10/05/2024 12:38:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1533' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 12:38:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1533' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '207.10' , '172.84' , NOW() , NOW() ) 10/05/2024 12:38:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91736' 10/05/2024 12:38:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '91736' 10/05/2024 12:38:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91736' , '22515' , 'BORSA PORTAELEMOSINA CON LUCCHETTO - 750/L' , '2' , '-2' , '1' , '95' , '77.868852459016' , '22' , '0' , '190.00' ) 10/05/2024 12:38:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91736' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 10/05/2024 01:01:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1534' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 01:01:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1534' , '2024-05-10' , '' , '1203' , '0' , '4669427' , 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.60' , '2.95' , NOW() , NOW() ) 10/05/2024 01:01:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91737' 10/05/2024 01:01:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '91737' 10/05/2024 01:01:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91737' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 10/05/2024 01:03:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1535' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 01:03:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1535' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '499.40' , '409.34' , NOW() , NOW() ) 10/05/2024 01:03:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91738' 10/05/2024 01:03:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '91738' 10/05/2024 01:03:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '79.0000' , '64.7541' , '22' , '0' , '79.00' ) 10/05/2024 01:03:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 10/05/2024 01:03:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '16310' , 'PORTACHIAVI COLOMBA - KP027' , '15' , '-15' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '18.00' ) 10/05/2024 01:03:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '19594' , 'POLO JERSEY COTONE 100%' , '3' , '-3' , '1' , '38.0000' , '31.1475' , '22' , '0' , '114.00' ) 10/05/2024 01:03:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '22318' , 'BOSSOLO OTTONE 8X14 - 162' , '1' , '-1' , '1' , '69.0000' , '56.5574' , '22' , '0' , '69.00' ) 10/05/2024 01:03:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '36' , '-36' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '64.80' ) 10/05/2024 01:03:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '20072' , 'BRACCIALE - BC1759N' , '36' , '-36' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '72.00' ) 10/05/2024 01:03:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '18222' , 'ROSARIO COLORATO - R316' , '15' , '-15' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '10.50' ) 10/05/2024 01:03:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '59.9' , '49.098360655738' , '22' , '0' , '59.90' ) 10/05/2024 01:04:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1534' AND id_document != '91737' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 01:04:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1534', document_date = '2024-05-10', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.60', price_tax_excluded = '2.95', date_upd = NOW() WHERE id_document = '91737' 10/05/2024 01:04:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91737' 10/05/2024 01:04:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '91737' 10/05/2024 01:04:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91737' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 10/05/2024 02:03:56 pm >> DELETE FROM ps_document WHERE id_document = '91421' 10/05/2024 02:03:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '91421' 10/05/2024 02:05:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '145/A' AND id_document != '89628' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-21') 10/05/2024 02:05:06 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '145/A', document_date = '2023-12-21', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTO € 150 + 100 per cero pasquale', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '660.00', price_tax_excluded = '604.10', date_upd = NOW() WHERE id_document = '89628' 10/05/2024 02:05:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89628' 10/05/2024 02:05:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '89628' 10/05/2024 02:05:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89628' , '0' , 'PRESEPE ANTICO' , '1' , '-1' , '0' , '350.0000' , '350' , '0' , '0' , '350.00' ) 10/05/2024 02:05:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89628' , '19077' , 'GRUPPO NATIVITA STOFFA CM 30 - PB18552 ++ campana 25x40' , '1' , '-1' , '1' , '160.0000' , '131.14754098361' , '22' , '0' , '160.00' ) 10/05/2024 02:05:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89628' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '150.0000' , '122.95081967213' , '22' , '0' , '150.00' ) 10/05/2024 02:07:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1532' AND id_document != '91735' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 02:07:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1532', document_date = '2024-05-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '187.61', price_tax_excluded = '159.80', date_upd = NOW() WHERE id_document = '91735' 10/05/2024 02:07:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91735' 10/05/2024 02:07:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '91735' 10/05/2024 02:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 10/05/2024 02:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 10/05/2024 02:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '14.00' ) 10/05/2024 02:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 10/05/2024 02:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '10471' , 'TAVOLETTE SAGOMATE 10X15 - S. PIO' , '4' , '-4' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '8.80' ) 10/05/2024 02:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 10/05/2024 02:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '22511' , 'VIVE - CD' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '5' , '16.06' ) 10/05/2024 02:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '22513' , 'VIVE - SPARTITO' , '1' , '-1' , '3' , '12.0000' , '11.538461538462' , '4' , '5' , '11.40' ) 10/05/2024 02:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 10/05/2024 02:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11.4' , '9.344262295082' , '22' , '0' , '11.40' ) 10/05/2024 02:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '14136' , 'MADONNA DEL ROSARIO DI POMPEI - 125' , '3' , '-3' , '1' , '3' , '2.4590163934426' , '22' , '0' , '9.00' ) 10/05/2024 02:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91735' , '4991' , 'SAN PIO DA PIETRELCINA - 315' , '1' , '-1' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '3.60' ) 10/05/2024 02:21:41 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'vsW1NmpROhPvWx1h' , NOW() , NOW() ) 10/05/2024 02:21:41 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4106' , '1' ) 10/05/2024 02:21:41 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4106' , '2' ) 10/05/2024 02:21:41 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4106' , '3' ) 10/05/2024 02:23:29 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4106' 10/05/2024 02:23:29 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4106' , '10' , '210' , 'CABOTO COSTRUZIONI srl' , 'BUONOMANO' , 'ANGELA' , 'VICOLO BATTIPAGLIA 11' , '' , '84066' , 'PISCIOTTA' , '' , '0899950583' , '3397225956' , '06022420654' , '' , NOW() , NOW() ) 10/05/2024 02:23:29 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4106' 10/05/2024 02:26:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '10/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 02:26:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '10/L' , '2024-05-10' , 'L' , '4106' , '0' , '4679318' , 'VICOLO BATTIPAGLIA 11 84066 PISCIOTTA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 10/05/2024 02:26:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91739' 10/05/2024 02:26:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '91739' 10/05/2024 02:26:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91739' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 10/05/2024 02:26:34 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4106' 10/05/2024 02:26:34 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4106' , '10' , '210' , 'CABOTO COSTRUZIONI srl' , 'BUONOMANO' , 'ANGELA' , 'VICOLO BATTIPAGLIA 11' , '' , '84066' , 'PISCIOTTA' , '' , '0899950583' , '3397225956' , '06022420654' , '' , NOW() , NOW() ) 10/05/2024 02:26:34 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = 'cabotocostruzionisrl@pec.it', date_upd = NOW() WHERE id_customer = '4106' 10/05/2024 02:33:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '10/L' AND id_document != '91739' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 02:33:15 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '10/L', document_date = '2024-05-10', document_letter = 'L', id_customer = '4106', id_supplier = '', id_address = '4679318', address1 = 'VICOLO BATTIPAGLIA 11 84066 PISCIOTTA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '91739' 10/05/2024 02:33:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91739' 10/05/2024 02:33:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '91739' 10/05/2024 02:33:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91739' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 10/05/2024 02:33:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91739' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 10/05/2024 02:33:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91739' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 10/05/2024 05:05:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1536' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 05:05:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1536' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '222.81' , '222.81' , NOW() , NOW() ) 10/05/2024 05:05:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91740' 10/05/2024 05:05:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '91740' 10/05/2024 05:05:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91740' , '22445' , 'PARABOLE DELLA PREGHIERA - 5' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 10/05/2024 05:05:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91740' , '22446' , 'PREGARE CON SANTI E PECCATORI - 4' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 10/05/2024 05:05:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91740' , '22449' , 'PREGHIERA CHE GESU CI HA INSEGNATO - 8' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 10/05/2024 05:05:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91740' , '22448' , 'PREGHIERA DI MARIA - 7' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 10/05/2024 05:05:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91740' , '22290' , 'CHIESA IN PREGHIERA - 6' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 10/05/2024 05:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91740' , '22192' , 'PREGHIERA DI GESU - 3' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 10/05/2024 05:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91740' , '22191' , 'PREGARE CON I SALMI - 2' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 10/05/2024 05:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91740' , '19123' , 'CHIESA SEGNO TRA I POPOLI - OPERA OMNIA - RATZINGER' , '1' , '-1' , '4' , '90.00' , '90' , '0' , '5' , '85.50' ) 10/05/2024 05:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91740' , '16137' , 'INSEGNAMENTO DEL CONCILIO VATICANO II - OPERA OMNIA - RATZINGER' , '1' , '-1' , '4' , '85.00' , '85' , '0' , '5' , '80.75' ) 10/05/2024 05:06:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1537' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 05:06:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1537' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.50' , '34.84' , NOW() , NOW() ) 10/05/2024 05:06:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91741' 10/05/2024 05:06:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '91741' 10/05/2024 05:06:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91741' , '7931' , 'PERGAMENE - CRESIMA MOD. A' , '25' , '-25' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '12.50' ) 10/05/2024 05:06:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91741' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 10/05/2024 05:16:33 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4106' 10/05/2024 05:16:33 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4106' , '10' , '210' , 'CABOTO COSTRUZIONI srl' , 'BUONOMANO' , 'ANGELA' , 'VICOLO BATTIPAGLIA 11' , '' , '84066' , 'PISCIOTTA' , '' , '0899950583' , '3397225956' , '06022420654' , '' , NOW() , NOW() ) 10/05/2024 05:16:33 pm >> UPDATE ps_customer SET email = '', sdi = 'KRRH6B9', pec = 'cabotocostruzionisrl@pec.it', date_upd = NOW() WHERE id_customer = '4106' 10/05/2024 05:17:45 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4106' 10/05/2024 05:17:45 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4106' , '10' , '210' , 'CABOTO COSTRUZIONI srl' , 'BUONOMANO' , 'ANGELA' , 'VICOLO BATTIPAGLIA 11' , '' , '84066' , 'PISCIOTTA' , '' , '0899950583' , '3397225956' , '06022420654' , '' , NOW() , NOW() ) 10/05/2024 05:17:45 pm >> UPDATE ps_customer SET email = '', sdi = 'KRRH6B9', pec = 'cabotocostruzionisrl@pec.it', date_upd = NOW() WHERE id_customer = '4106' 10/05/2024 06:19:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1538' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 06:19:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1538' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.10' , '9.71' , NOW() , NOW() ) 10/05/2024 06:19:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91742' 10/05/2024 06:19:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '91742' 10/05/2024 06:19:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91742' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 10/05/2024 06:19:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91742' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '2' , '-2' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '6.60' ) 10/05/2024 06:20:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1539' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 06:20:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1539' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '8.00' , NOW() , NOW() ) 10/05/2024 06:20:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91743' 10/05/2024 06:20:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '91743' 10/05/2024 06:20:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91743' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 10/05/2024 06:20:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91743' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '6.1' , '6.1' , '0' , '' , '6.10' ) 10/05/2024 06:30:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '46/A' AND id_document != '91065' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-03') 10/05/2024 06:30:59 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '46/A', document_date = '2024-04-03', document_letter = 'A', id_customer = '2912', id_supplier = '', id_address = '4672779', address1 = 'P. ZZA CARMINE PASTORE, 10 84080 CAPRIGLIA - PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '55.00', date_upd = NOW() WHERE id_document = '91065' 10/05/2024 06:30:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91065' 10/05/2024 06:30:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '91065' 10/05/2024 06:30:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91065' , '0' , 'tunica bordo oro' , '1' , '-1' , '0' , '55.0000' , '55' , '0' , '0' , '55.00' ) 10/05/2024 06:30:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91065' , '0' , '100 n 1' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 10/05/2024 06:30:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91065' , '0' , '105 - n 2' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 10/05/2024 06:30:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91065' , '0' , '110 - n. 3' , '1' , '-1' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 10/05/2024 06:30:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91065' , '0' , '115 - n 6' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 10/05/2024 06:30:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91065' , '0' , '120 - n 1' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 10/05/2024 06:30:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91065' , '0' , '125 - n 1' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 10/05/2024 06:48:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '85' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 06:48:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '85' , '2024-05-10' , '' , '2912' , '0' , '4672779' , 'P. ZZA CARMINE PASTORE, 10 84080 CAPRIGLIA - PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '5' , '0' , '54.74' , '54.74' , NOW() , NOW() ) 10/05/2024 06:48:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91744' 10/05/2024 06:48:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '91744' 10/05/2024 06:48:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91744' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '23' , '-23' , '4' , '2.80' , '2.8' , '0' , '15' , '54.74' ) 10/05/2024 07:02:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1540' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 07:02:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1540' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 10/05/2024 07:02:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91745' 10/05/2024 07:02:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '91745' 10/05/2024 07:02:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91745' , '21729' , 'CROCE SAN BENEDETTO CON BASE - CZ11BSNIK' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 10/05/2024 07:09:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1541' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 07:09:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1541' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.90' , '19.80' , NOW() , NOW() ) 10/05/2024 07:09:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91746' 10/05/2024 07:09:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '91746' 10/05/2024 07:09:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91746' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 10/05/2024 07:09:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91746' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 10/05/2024 07:09:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91746' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 10/05/2024 07:09:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1542' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 07:09:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1542' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '5.64' , NOW() , NOW() ) 10/05/2024 07:09:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91747' 10/05/2024 07:09:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '91747' 10/05/2024 07:09:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91747' , '20319' , 'SAN NICOLA DA TOLENTINO - R. PICCOLOMINI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 10/05/2024 07:09:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91747' , '21099' , 'BRACCIALE DECINA - BD008' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 10/05/2024 07:28:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '85' AND id_document != '91744' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 07:28:38 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '85', document_date = '2024-05-10', document_letter = '', id_customer = '2912', id_supplier = '', id_address = '4672779', address1 = 'P. ZZA CARMINE PASTORE, 10 84080 CAPRIGLIA - PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '54.74', price_tax_excluded = '54.74', date_upd = NOW() WHERE id_document = '91744' 10/05/2024 07:28:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91744' 10/05/2024 07:28:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '91744' 10/05/2024 07:28:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91744' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '23' , '-23' , '4' , '2.8000' , '2.8' , '0' , '15' , '54.74' ) 10/05/2024 07:44:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1543' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 07:44:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1543' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.86' , '93.95' , NOW() , NOW() ) 10/05/2024 07:44:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91748' 10/05/2024 07:44:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '91748' 10/05/2024 07:44:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91748' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '10' , '-10' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '7.00' ) 10/05/2024 07:44:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91748' , '1132' , 'BIBBIA DELLA PRIMA COMUNIONE - RIL' , '5' , '-5' , '4' , '12.90' , '12.9' , '0' , '5' , '61.30' ) 10/05/2024 07:44:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91748' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 10/05/2024 07:44:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91748' , '5436' , 'IO MI CONFESSO ' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 10/05/2024 07:44:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91748' , '15316' , 'COME PREPARARSI ALLA CONFESSIONE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 10/05/2024 07:44:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91748' , '15318' , 'PERDONAMI SIGNORE ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 10/05/2024 07:44:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91748' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 10/05/2024 07:44:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91748' , '21055' , 'MIA PRIMA EUCARISTIA ' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 10/05/2024 07:44:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91748' , '22177' , 'TANTI VOLTI UNA SOLA BELLEZZA ' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 10/05/2024 07:46:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1544' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 10/05/2024 07:46:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1544' , '2024-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '55.00' , NOW() , NOW() ) 10/05/2024 07:46:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91749' 10/05/2024 07:46:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '91749' 10/05/2024 07:46:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91749' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '55' , '55' , '0' , '0' , '55.00' )