11/10/2024 08:24:58 am >> DELETE FROM ps_document WHERE id_document = '93528' 11/10/2024 08:24:58 am >> DELETE FROM ps_document_detail WHERE id_document = '93528' 11/10/2024 08:25:46 am >> SELECT document_num FROM ps_document WHERE document_num = '2877' AND id_document != '93399' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-02') 11/10/2024 08:25:46 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2877', document_date = '2024-10-02', 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 = '23.00', price_tax_excluded = '20.66', date_upd = NOW() WHERE id_document = '93399' 11/10/2024 08:25:46 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 = '93399' 11/10/2024 08:25:46 am >> DELETE FROM ps_document_detail WHERE id_document = '93399' 11/10/2024 08:25:46 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 ( '93399' , '16834' , 'LITURGICO CARTA 8GG' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 11/10/2024 08:25:46 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 ( '93399' , '1116' , 'BIBBIA DEI BAMBINI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 11/10/2024 08:25:46 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 ( '93399' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '5' , '9.50' ) 11/10/2024 10:21:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2996' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 10:21:25 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' , '2996' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 11/10/2024 10:21:25 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 = '93558' 11/10/2024 10:21:25 am >> DELETE FROM ps_document_detail WHERE id_document = '93558' 11/10/2024 10:21:25 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 ( '93558' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 11/10/2024 10:21:25 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 ( '93558' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '3' , '-3' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '30.00' ) 11/10/2024 10:24:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2997' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 10:24:04 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' , '2997' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 11/10/2024 10:24:04 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 = '93559' 11/10/2024 10:24:04 am >> DELETE FROM ps_document_detail WHERE id_document = '93559' 11/10/2024 10:24:04 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 ( '93559' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 11/10/2024 10:24:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2998' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 10:24:27 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' , '2998' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '122.95' , NOW() , NOW() ) 11/10/2024 10:24:27 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 = '93560' 11/10/2024 10:24:27 am >> DELETE FROM ps_document_detail WHERE id_document = '93560' 11/10/2024 10:24:27 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 ( '93560' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '150' , '122.95081967213' , '22' , '0' , '150.00' ) 11/10/2024 10:32:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2998' AND id_document != '93560' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 10:32:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2998', document_date = '2024-10-11', 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 = '150.00', price_tax_excluded = '122.95', date_upd = NOW() WHERE id_document = '93560' 11/10/2024 10:32:04 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 = '93560' 11/10/2024 10:32:04 am >> DELETE FROM ps_document_detail WHERE id_document = '93560' 11/10/2024 10:32:04 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 ( '93560' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 11/10/2024 10:32:04 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 ( '93560' , '20272' , 'CASULA CROCE - 652' , '2' , '-2' , '1' , '60' , '49.180327868852' , '22' , '0' , '120.00' ) 11/10/2024 10:32:31 am >> SELECT document_num FROM ps_document WHERE document_num = '2997' AND id_document != '93559' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 10:32:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2997', document_date = '2024-10-11', 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 = '100.00', price_tax_excluded = '81.97', date_upd = NOW() WHERE id_document = '93559' 11/10/2024 10:32:31 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 = '93559' 11/10/2024 10:32:31 am >> DELETE FROM ps_document_detail WHERE id_document = '93559' 11/10/2024 10:32:31 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 ( '93559' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 11/10/2024 10:32:31 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 ( '93559' , '16405' , 'CASULA MORELLO' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 11/10/2024 11:12:36 am >> SELECT document_num FROM ps_document WHERE document_num = '105/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 11:12:36 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 ( '24' , '105/A' , '2024-10-11' , 'A' , '3536' , '0' , '4673201' , 'VIA SANT\\\'ANNA 4 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '33.00' , NOW() , NOW() ) 11/10/2024 11:12:36 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 = '93561' 11/10/2024 11:12:36 am >> DELETE FROM ps_document_detail WHERE id_document = '93561' 11/10/2024 11:12:36 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 ( '93561' , '18357' , 'MIE PREGHIERINE N.E.' , '22' , '-22' , '4' , '1.50' , '1.5' , '0' , '0' , '33.00' ) 11/10/2024 11:23:47 am >> SELECT document_num FROM ps_document WHERE document_num = '106/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 11:23:47 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 ( '24' , '106/A' , '2024-10-11' , 'A' , '232' , '0' , '4671450' , 'VIA V. LASPRO, 8/A 84126 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.70' , '79.80' , NOW() , NOW() ) 11/10/2024 11:23:47 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 = '93562' 11/10/2024 11:23:47 am >> DELETE FROM ps_document_detail WHERE id_document = '93562' 11/10/2024 11:23:47 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 ( '93562' , '12819' , 'REGISTRO DEL CATECHISTA ' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 11/10/2024 11:23:47 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 ( '93562' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 11/10/2024 11:23:47 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 ( '93562' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '5' , '-5' , '4' , '3.80' , '3.8' , '0' , '0' , '19.00' ) 11/10/2024 11:23:47 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 ( '93562' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '8' , '-8' , '4' , '3.80' , '3.8' , '0' , '0' , '30.40' ) 11/10/2024 11:23:47 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 ( '93562' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '6' , '-6' , '4' , '3.80' , '3.8' , '0' , '0' , '22.80' ) 11/10/2024 11:24:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2999' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 11:24:02 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' , '2999' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '5.77' , NOW() , NOW() ) 11/10/2024 11:24:02 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 = '93563' 11/10/2024 11:24:02 am >> DELETE FROM ps_document_detail WHERE id_document = '93563' 11/10/2024 11:24:02 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 ( '93563' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 11/10/2024 11:32:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3000' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 11:32:11 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' , '3000' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '310.00' , '263.11' , NOW() , NOW() ) 11/10/2024 11:32:11 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 = '93564' 11/10/2024 11:32:11 am >> DELETE FROM ps_document_detail WHERE id_document = '93564' 11/10/2024 11:32:11 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 ( '93564' , '14578' , 'CAMICE GOTICO - MISTO LANA LEGGERO - 328' , '1' , '-1' , '1' , '190.00' , '155.73770491803' , '22' , '0' , '190.00' ) 11/10/2024 11:32:11 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 ( '93564' , '19793' , 'STOLA IHS - 220' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 11/10/2024 11:32:12 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 ( '93564' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 11/10/2024 11:32:12 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 ( '93564' , '10914' , 'UNA COMUNITÀ LEGGE IL VANGELO DI GIOVANNI' , '1' , '-1' , '4' , '48.00' , '48' , '0' , '0' , '48.00' ) 11/10/2024 11:42:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3001' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 11:42:30 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' , '3001' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.95' , '30.19' , NOW() , NOW() ) 11/10/2024 11:42:30 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 = '93565' 11/10/2024 11:42:30 am >> DELETE FROM ps_document_detail WHERE id_document = '93565' 11/10/2024 11:42:30 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 ( '93565' , '4949' , 'IMITAZIONE DI MARIA - 8296' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 11/10/2024 11:42:30 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 ( '93565' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '22.80' ) 11/10/2024 11:42:30 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 ( '93565' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 11/10/2024 11:42:39 am >> SELECT document_num FROM ps_document WHERE document_num = '144' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 11:42:39 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' , '144' , '2024-10-11' , '' , '3821' , '0' , '4672560' , 'P. ZZA S. CATERINA 1 84090 GIFFONI SEI CASALI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.55' , '53.55' , NOW() , NOW() ) 11/10/2024 11:42:39 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 = '93566' 11/10/2024 11:42:39 am >> DELETE FROM ps_document_detail WHERE id_document = '93566' 11/10/2024 11:42:39 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 ( '93566' , '2869' , 'CREDO, PREGHIERA E IMPEGNO' , '30' , '-30' , '4' , '2.10' , '2.1' , '0' , '15' , '53.55' ) 11/10/2024 11:45:00 am >> SELECT document_num FROM ps_document WHERE document_num = '144' AND id_document != '93566' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 11:45:00 am >> UPDATE ps_document SET id_document_type = '21', document_num = '144', document_date = '2024-10-11', document_letter = '', id_customer = '3821', id_supplier = '', id_address = '4672560', address1 = 'P. ZZA S. CATERINA 1 84090 GIFFONI SEI CASALI', 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 = '53.55', price_tax_excluded = '53.55', date_upd = NOW() WHERE id_document = '93566' 11/10/2024 11:45:00 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 = '93566' 11/10/2024 11:45:00 am >> DELETE FROM ps_document_detail WHERE id_document = '93566' 11/10/2024 11:45:00 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 ( '93566' , '2869' , 'CREDO, PREGHIERA E IMPEGNO' , '30' , '-30' , '4' , '2.1000' , '2.1' , '0' , '15' , '53.55' ) 11/10/2024 12:38:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '145' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 12:38:48 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' , '145' , '2024-10-11' , '' , '4119' , '0' , '4679375' , 'PIAZZA MICHELE D\\\'ASTE 2 84042 ACERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '98.72' , '98.72' , NOW() , NOW() ) 11/10/2024 12:38:48 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 = '93567' 11/10/2024 12:38:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '93567' 11/10/2024 12:38:48 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 ( '93567' , '11191' , 'VENITE CON ME 1 PARTE' , '14' , '-14' , '4' , '2.80' , '2.8' , '0' , '15' , '33.32' ) 11/10/2024 12:38:48 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 ( '93567' , '11183' , 'VENITE CON ME - GUIDA' , '4' , '-4' , '4' , '8.00' , '8' , '0' , '15' , '27.20' ) 11/10/2024 12:38:48 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 ( '93567' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '15' , '6.80' ) 11/10/2024 12:38:48 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 ( '93567' , '7543' , 'PARABOLE DI GESÙ' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 11/10/2024 12:38:48 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 ( '93567' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 11/10/2024 12:38:48 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 ( '93567' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 11/10/2024 12:38:48 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 ( '93567' , '13956' , 'MIRACOLI DI GESU' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 11/10/2024 12:38:48 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 ( '93567' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '15' , '7.65' ) 11/10/2024 12:38:48 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 ( '93567' , '18152' , 'BIBBIA A COLORI ' , '1' , '-1' , '4' , '8.90' , '8.9' , '0' , '5' , '8.46' ) 11/10/2024 12:38:48 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 ( '93567' , '18666' , 'SCOPRIAMO LA BIBBIA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 11/10/2024 12:50:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3002' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 12:50:11 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' , '3002' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.20' , '19.78' , NOW() , NOW() ) 11/10/2024 12:50:11 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 = '93568' 11/10/2024 12:50:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '93568' 11/10/2024 12:50:11 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 ( '93568' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 11/10/2024 12:50:11 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 ( '93568' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 11/10/2024 01:01:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3003' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 01:01:59 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' , '3003' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '257.90' , '211.39' , NOW() , NOW() ) 11/10/2024 01:01: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 = '93569' 11/10/2024 01:01:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '93569' 11/10/2024 01:01: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 ( '93569' , '15893' , 'CINGOLO - CING17' , '1' , '-1' , '1' , '48.00' , '39.344262295082' , '22' , '0' , '48.00' ) 11/10/2024 01:01: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 ( '93569' , '19793' , 'STOLA IHS - 220' , '1' , '-1' , '1' , '73.00' , '59.83606557377' , '22' , '0' , '73.00' ) 11/10/2024 01:01: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 ( '93569' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '136.9' , '112.2131147541' , '22' , '0' , '136.90' ) 11/10/2024 01:02:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3004' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 01:02:52 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' , '3004' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.80' , '6.80' , NOW() , NOW() ) 11/10/2024 01:02:52 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 = '93570' 11/10/2024 01:02:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '93570' 11/10/2024 01:02:52 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 ( '93570' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.8' , '6.8' , '0' , '0' , '6.80' ) 11/10/2024 01:07:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3005' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 01:07:48 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' , '3005' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '13.92' , NOW() , NOW() ) 11/10/2024 01:07:48 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 = '93571' 11/10/2024 01:07:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '93571' 11/10/2024 01:07:48 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 ( '93571' , '9444' , 'SAN GIACOMO AP.- A.GOVERNALE' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 11/10/2024 01:07:48 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 ( '93571' , '9536' , 'SANTANTONIO - L.GJERGJI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 11/10/2024 01:07:48 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 ( '93571' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' ) 11/10/2024 03:54:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '95/A' AND id_document != '93084' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-10') 11/10/2024 03:54:54 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '95/A', document_date = '2024-09-10', document_letter = 'A', id_customer = '2757', id_supplier = '', id_address = '4679343', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', 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 = '638.50', price_tax_excluded = '523.36', date_upd = NOW() WHERE id_document = '93084' 11/10/2024 03:54:54 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 = '93084' 11/10/2024 03:54:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '93084' 11/10/2024 03:54:54 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 ( '93084' , '16796' , 'LUMINO 5F BIANCO' , '672' , '-672' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '134.40' ) 11/10/2024 03:54:54 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 ( '93084' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 11/10/2024 03:54:54 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 ( '93084' , '16796' , 'LUMINO 5B BIANCO' , '1008' , '-1008' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '201.60' ) 11/10/2024 03:54:54 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 ( '93084' , '0' , 'supplca' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 11/10/2024 03:54:54 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 ( '93084' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '15.00' ) 11/10/2024 03:54:54 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 ( '93084' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '7.50' ) 11/10/2024 04:19:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3006' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 04:19: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' , '3006' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '132.00' , '108.20' , NOW() , NOW() ) 11/10/2024 04:19: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 = '93572' 11/10/2024 04:19:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '93572' 11/10/2024 04:19: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 ( '93572' , '14725' , 'STOLA LANA/SETA/VISC. - ART. 1125' , '1' , '-1' , '1' , '132.00' , '108.19672131148' , '22' , '0' , '132.00' ) 11/10/2024 04:19:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3007' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 04:19: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' , '3007' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '139.34' , NOW() , NOW() ) 11/10/2024 04:19: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 = '93573' 11/10/2024 04:19:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '93573' 11/10/2024 04:19: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 ( '93573' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '170.00' , '139.34426229508' , '22' , '0' , '170.00' ) 11/10/2024 04:48:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '107/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 04:48:36 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 ( '24' , '107/A' , '2024-10-11' , 'A' , '3549' , '0' , '4671010' , 'PIAZZA SAN MARCO 03037 PONTECORVO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '462.60' , '388.40' , NOW() , NOW() ) 11/10/2024 04:48:36 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 = '93574' 11/10/2024 04:48:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '93574' 11/10/2024 04:48:36 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 ( '93574' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 11/10/2024 04:48:36 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 ( '93574' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '102.00' ) 11/10/2024 04:48:36 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 ( '93574' , '1914' , 'CERA DELLA LITURGIA' , '48' , '-48' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '225.60' ) 11/10/2024 04:48:36 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 ( '93574' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 11/10/2024 04:48:36 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 ( '93574' , '7311' , 'OSTIA SOTTILE 74MM' , '15' , '-15' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '30.00' ) 11/10/2024 04:48:36 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 ( '93574' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 11/10/2024 04:48:36 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 ( '93574' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 11/10/2024 05:54:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3008' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 05:54:06 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' , '3008' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.55' , '37.55' , NOW() , NOW() ) 11/10/2024 05:54: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 = '93575' 11/10/2024 05:54:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '93575' 11/10/2024 05:54:06 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 ( '93575' , '22915' , 'CINQUE PANI DORZO 2025' , '5' , '-5' , '4' , '7.90' , '7.9' , '0' , '5' , '37.55' ) 11/10/2024 06:08:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '108/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 06:08: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 ( '24' , '108/A' , '2024-10-11' , 'A' , '922' , '0' , '4671011' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '111.00' , '90.98' , NOW() , NOW() ) 11/10/2024 06:08: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 = '93576' 11/10/2024 06:08:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '93576' 11/10/2024 06:08: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 ( '93576' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '3' , '-3' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '111.00' ) 11/10/2024 06:26:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3009' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 06:26:18 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' , '3009' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.92' , NOW() , NOW() ) 11/10/2024 06:26:18 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 = '93577' 11/10/2024 06:26:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '93577' 11/10/2024 06:26: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 ( '93577' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 11/10/2024 06:42:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3010' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 06:42:16 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' , '3010' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 11/10/2024 06:42:16 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 = '93578' 11/10/2024 06:42:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '93578' 11/10/2024 06:42: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 ( '93578' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 11/10/2024 07:40:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3011' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-11') 11/10/2024 07:40:53 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' , '3011' , '2024-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 11/10/2024 07:40:53 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 = '93579' 11/10/2024 07:40:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '93579' 11/10/2024 07:40:53 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 ( '93579' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 11/10/2024 07:42:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2867' AND id_document != '93381' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-01') 11/10/2024 07:42:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2867', document_date = '2024-10-01', 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 = '9.80', price_tax_excluded = '8.39', date_upd = NOW() WHERE id_document = '93381' 11/10/2024 07:42:43 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 = '93381' 11/10/2024 07:42:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '93381' 11/10/2024 07:42:44 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 ( '93381' , '14773' , 'BRACCIALE RIGATO - 0825N' , '6' , '-6' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '7.80' ) 11/10/2024 07:42:44 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 ( '93381' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' )