05/07/2023 09:07:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2297' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 09:07:51 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' , '2297' , '2023-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 05/07/2023 09:07:51 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 = '86636' 05/07/2023 09:07:51 am >> DELETE FROM ps_document_detail WHERE id_document = '86636' 05/07/2023 09:07:52 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 ( '86636' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 05/07/2023 09:48:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2298' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 09:48: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' , '2298' , '2023-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.00' , '38.83' , NOW() , NOW() ) 05/07/2023 09:48: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 = '86637' 05/07/2023 09:48:13 am >> DELETE FROM ps_document_detail WHERE id_document = '86637' 05/07/2023 09:48: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 ( '86637' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 05/07/2023 09:48: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 ( '86637' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '22.50' ) 05/07/2023 09:48: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 ( '86637' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 05/07/2023 09:48: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 ( '86637' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 05/07/2023 09:49:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2299' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 09:49: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' , '2299' , '2023-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 05/07/2023 09:49: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 = '86638' 05/07/2023 09:49:28 am >> DELETE FROM ps_document_detail WHERE id_document = '86638' 05/07/2023 09:49: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 ( '86638' , '21068' , 'MESSALINO AGO/SET/OTT 2023' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '5' , '11.40' ) 05/07/2023 09:57:44 am >> SELECT document_num FROM ps_document WHERE document_num = '59/A' AND id_document != '84203' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-08') 05/07/2023 09:57:44 am >> UPDATE ps_document SET id_document_type = '24', document_num = '59/A', document_date = '2023-05-08', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSP. DA PROCIDA', 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 = '185.10', price_tax_excluded = '155.64', date_upd = NOW() WHERE id_document = '84203' 05/07/2023 09:57:44 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 = '84203' 05/07/2023 09:57:44 am >> DELETE FROM ps_document_detail WHERE id_document = '84203' 05/07/2023 09:57:44 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 ( '84203' , '11151' , 'LIBRI - SUPPLICHE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/07/2023 09:57:44 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 ( '84203' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 05/07/2023 09:57:44 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 ( '84203' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '14.00' ) 05/07/2023 09:57:44 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 ( '84203' , '12529' , 'LAMPADA A SFERA VERDE' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 05/07/2023 09:57:44 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 ( '84203' , '12527' , 'LAMPADA A SFERA VIOLA' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 05/07/2023 09:57:44 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 ( '84203' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 05/07/2023 09:57:44 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 ( '84203' , '11384' , 'VINO BIANCO DOLCE - 102' , '8' , '-8' , '1' , '8' , '6.5573770491803' , '22' , '0' , '64.00' ) 05/07/2023 10:02:56 am >> SELECT document_num FROM ps_document WHERE document_num = '59/A' AND id_document != '84203' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-08') 05/07/2023 10:02:56 am >> UPDATE ps_document SET id_document_type = '24', document_num = '59/A', document_date = '2023-05-08', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSP. DA PROCIDA', 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 = '185.00', price_tax_excluded = '153.75', date_upd = NOW() WHERE id_document = '84203' 05/07/2023 10:02: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 = '84203' 05/07/2023 10:02:56 am >> DELETE FROM ps_document_detail WHERE id_document = '84203' 05/07/2023 10:02: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 ( '84203' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '9.9' , '8.1147540983607' , '22' , '0' , '9.90' ) 05/07/2023 10:02: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 ( '84203' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 05/07/2023 10:02: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 ( '84203' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 05/07/2023 10:02: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 ( '84203' , '12529' , 'LAMPADA A SFERA VERDE' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 05/07/2023 10:02: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 ( '84203' , '12527' , 'LAMPADA A SFERA VIOLA' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 05/07/2023 10:02: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 ( '84203' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 05/07/2023 10:02: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 ( '84203' , '11384' , 'VINO BIANCO DOLCE - 102' , '8' , '-8' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '64.00' ) 05/07/2023 10:04:08 am >> 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('2023-07-05') 05/07/2023 10:04: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 ( '23' , '10/L' , '2023-07-05' , 'L' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA OSPEDALIERA G. DA PROCIDA' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '185.00' , '153.75' , NOW() , NOW() ) 05/07/2023 10:04: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 = '86639' 05/07/2023 10:04:08 am >> DELETE FROM ps_document_detail WHERE id_document = '86639' 05/07/2023 10:04:08 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 ( '86639' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '9.9000' , '8.1148' , '22' , '0' , '9.90' ) 05/07/2023 10:04:08 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 ( '86639' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 05/07/2023 10:04:08 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 ( '86639' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.0000' , '1.9231' , '4' , '0' , '14.00' ) 05/07/2023 10:04:08 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 ( '86639' , '12529' , 'LAMPADA A SFERA VERDE' , '1' , '-1' , '1' , '20.0000' , '16.3934' , '22' , '0' , '20.00' ) 05/07/2023 10:04:08 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 ( '86639' , '12527' , 'LAMPADA A SFERA VIOLA' , '1' , '-1' , '1' , '20.0000' , '16.3934' , '22' , '0' , '20.00' ) 05/07/2023 10:04:08 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 ( '86639' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 05/07/2023 10:04:08 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 ( '86639' , '11384' , 'VINO BIANCO DOLCE - 102' , '8' , '-8' , '1' , '8.0000' , '6.5574' , '22' , '0' , '64.00' ) 05/07/2023 10:04:48 am >> SELECT document_num FROM ps_document WHERE document_num = '10/L' AND id_document != '86639' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 10:04:48 am >> UPDATE ps_document SET id_document_type = '23', document_num = '10/L', document_date = '2023-07-05', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSP. G. DA PROCIDA', 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 = '185.00', price_tax_excluded = '153.75', date_upd = NOW() WHERE id_document = '86639' 05/07/2023 10:04:48 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 = '86639' 05/07/2023 10:04:48 am >> DELETE FROM ps_document_detail WHERE id_document = '86639' 05/07/2023 10:04:48 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 ( '86639' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '9.9000' , '8.1147540983607' , '22' , '0' , '9.90' ) 05/07/2023 10:04:48 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 ( '86639' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 05/07/2023 10:04:48 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 ( '86639' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 05/07/2023 10:04:48 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 ( '86639' , '12529' , 'LAMPADA A SFERA VERDE' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 05/07/2023 10:04:48 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 ( '86639' , '12527' , 'LAMPADA A SFERA VIOLA' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 05/07/2023 10:04:48 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 ( '86639' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 05/07/2023 10:04:48 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 ( '86639' , '11384' , 'VINO BIANCO DOLCE - 102' , '8' , '-8' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '64.00' ) 05/07/2023 10:05:25 am >> SELECT document_num FROM ps_document WHERE document_num = '10/L' AND id_document != '86639' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 10:05:25 am >> UPDATE ps_document SET id_document_type = '23', document_num = '10/L', document_date = '2023-07-05', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSP. G. DA PROCIDA', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '185.00', price_tax_excluded = '153.75', date_upd = NOW() WHERE id_document = '86639' 05/07/2023 10:05: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 = '86639' 05/07/2023 10:05:25 am >> DELETE FROM ps_document_detail WHERE id_document = '86639' 05/07/2023 10:05:26 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 ( '86639' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '9.9000' , '8.1147540983607' , '22' , '0' , '9.90' ) 05/07/2023 10:05:26 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 ( '86639' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 05/07/2023 10:05:26 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 ( '86639' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 05/07/2023 10:05:26 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 ( '86639' , '12529' , 'LAMPADA A SFERA VERDE' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 05/07/2023 10:05:26 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 ( '86639' , '12527' , 'LAMPADA A SFERA VIOLA' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 05/07/2023 10:05:26 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 ( '86639' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 05/07/2023 10:05:26 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 ( '86639' , '11384' , 'VINO BIANCO DOLCE - 102' , '8' , '-8' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '64.00' ) 05/07/2023 10:05:51 am >> DELETE FROM ps_document WHERE id_document = '84203' 05/07/2023 10:05:51 am >> DELETE FROM ps_document_detail WHERE id_document = '84203' 05/07/2023 10:20:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2300' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 10:20: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 ( '11' , '2300' , '2023-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 05/07/2023 10:20: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 = '86640' 05/07/2023 10:20:47 am >> DELETE FROM ps_document_detail WHERE id_document = '86640' 05/07/2023 10:20: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 ( '86640' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '5' , '-5' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '10.00' ) 05/07/2023 10:31:18 am >> SELECT document_num FROM ps_document WHERE document_num = '2301' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 10:31:19 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' , '2301' , '2023-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '185.00' , '155.17' , NOW() , NOW() ) 05/07/2023 10:31:19 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 = '86641' 05/07/2023 10:31:19 am >> DELETE FROM ps_document_detail WHERE id_document = '86641' 05/07/2023 10:31:19 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 ( '86641' , '21189' , 'STATUA SAN CHARBEL CM 40 - 807' , '1' , '-1' , '1' , '109.00' , '89.344262295082' , '22' , '0' , '109.00' ) 05/07/2023 10:31:19 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 ( '86641' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 05/07/2023 10:31:19 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 ( '86641' , '21346' , 'LETTERE VOL. 2' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 05/07/2023 10:31:19 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 ( '86641' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 05/07/2023 10:31:34 am >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '82763' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-12') 05/07/2023 10:31:34 am >> UPDATE ps_document SET id_document_type = '24', document_num = '53/A', document_date = '2023-04-12', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', 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 = '122.85', price_tax_excluded = '118.34', date_upd = NOW() WHERE id_document = '82763' 05/07/2023 10:31: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 = '82763' 05/07/2023 10:31:34 am >> DELETE FROM ps_document_detail WHERE id_document = '82763' 05/07/2023 10:31: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 ( '82763' , '13322' , 'IMMAGINI 70X100 GESU\' MISERICORDIOSO' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 05/07/2023 10:31: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 ( '82763' , '19742' , 'ENCICLICHE SOCIALI' , '1' , '-1' , '4' , '49.0000' , '49' , '0' , '5' , '46.55' ) 05/07/2023 10:31: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 ( '82763' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 05/07/2023 10:31: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 ( '82763' , '3419' , 'DIARIO LA MISERICORDIA DIVINA - S. FAUSTINA K.' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 05/07/2023 10:31: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 ( '82763' , '18047' , 'CUSTODIA LITURGIA DELLE ORE 4 VOL ECO PELLE - L100E' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 05/07/2023 10:31: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 ( '82763' , '21166' , 'ENCICLICHE SOCIALI ' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '5' , '24.70' ) 05/07/2023 10:31: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 ( '82763' , '13780' , 'RISCOPRIAMO LA BELLEZZA DEL BATTESIMO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 05/07/2023 10:39:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2302' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 10:39:22 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' , '2302' , '2023-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.50' , '27.46' , NOW() , NOW() ) 05/07/2023 10:39:22 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 = '86642' 05/07/2023 10:39:22 am >> DELETE FROM ps_document_detail WHERE id_document = '86642' 05/07/2023 10:39:22 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 ( '86642' , '18046' , 'TECA PLACCA SMALTATA - 504' , '1' , '-1' , '1' , '33.50' , '27.459016393443' , '22' , '0' , '33.50' ) 05/07/2023 11:50:56 am >> SELECT document_num FROM ps_document WHERE document_num = '66/A' AND id_document != '85772' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-09') 05/07/2023 11:50:57 am >> UPDATE ps_document SET id_document_type = '24', document_num = '66/A', document_date = '2023-06-09', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'ospedale s. leonardo', 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 = '280.17', price_tax_excluded = '235.06', date_upd = NOW() WHERE id_document = '85772' 05/07/2023 11:50:57 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 = '85772' 05/07/2023 11:50:57 am >> DELETE FROM ps_document_detail WHERE id_document = '85772' 05/07/2023 11:50:57 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 ( '85772' , '21067' , 'AMEN - AGO 23' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 05/07/2023 11:50:57 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 ( '85772' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '15.20' ) 05/07/2023 11:50:57 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 ( '85772' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 05/07/2023 11:50:57 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 ( '85772' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 05/07/2023 11:50:57 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 ( '85772' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 05/07/2023 11:50:57 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 ( '85772' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 05/07/2023 11:50:57 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 ( '85772' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '79.20' ) 05/07/2023 11:50:57 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 ( '85772' , '9124' , 'ROSARIO IN PLASTICA - MARRONE' , '20' , '-20' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '6.00' ) 05/07/2023 11:50:57 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 ( '85772' , '20825' , 'BRUCIA INCENSO STELLA' , '1' , '-1' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '24.00' ) 05/07/2023 11:50:57 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 ( '85772' , '5958' , 'omaggio' , '1' , '-1' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 05/07/2023 11:50:57 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 ( '85772' , '5958' , 'LUCAS 25G - FIORI D\'ARANCIO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '100' , '0.00' ) 05/07/2023 11:50:57 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 ( '85772' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '5' , '-5' , '1' , '0.95' , '0.77868852459016' , '22' , '0' , '4.75' ) 05/07/2023 11:50:57 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 ( '85772' , '20220' , 'MEDAGLIA SAN BENEDETTO CM 2 - 400/n0217' , '5' , '-5' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '6.50' ) 05/07/2023 11:50:57 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 ( '85772' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 05/07/2023 11:55:36 am >> SELECT document_num FROM ps_document WHERE document_num = '106' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 11:55: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 ( '21' , '106' , '2023-07-05' , '' , '0' , '0' , '0' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '280.17' , '235.06' , NOW() , NOW() ) 05/07/2023 11:55: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 = '86643' 05/07/2023 11:55:36 am >> DELETE FROM ps_document_detail WHERE id_document = '86643' 05/07/2023 11:55: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 ( '86643' , '21067' , 'AMEN - AGO 23' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 05/07/2023 11:55: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 ( '86643' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.8000' , '3.1148' , '22' , '0' , '15.20' ) 05/07/2023 11:55: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 ( '86643' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9231' , '4' , '0' , '10.00' ) 05/07/2023 11:55: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 ( '86643' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3654' , '4' , '0' , '14.00' ) 05/07/2023 11:55: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 ( '86643' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5574' , '22' , '0' , '48.00' ) 05/07/2023 11:55: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 ( '86643' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 05/07/2023 11:55: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 ( '86643' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3.3000' , '2.7049' , '22' , '0' , '79.20' ) 05/07/2023 11:55: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 ( '86643' , '9124' , 'ROSARIO IN PLASTICA - MARRONE' , '20' , '-20' , '1' , '0.3000' , '0.2459' , '22' , '0' , '6.00' ) 05/07/2023 11:55: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 ( '86643' , '20825' , 'BRUCIA INCENSO STELLA' , '1' , '-1' , '1' , '24.0000' , '19.6721' , '22' , '0' , '24.00' ) 05/07/2023 11:55: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 ( '86643' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '5' , '-5' , '1' , '0.9500' , '0.7787' , '22' , '0' , '4.75' ) 05/07/2023 11:55: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 ( '86643' , '20220' , 'MEDAGLIA SAN BENEDETTO CM 2 - 400/n0217' , '5' , '-5' , '1' , '1.3000' , '1.0656' , '22' , '0' , '6.50' ) 05/07/2023 11:55: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 ( '86643' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '5' , '-5' , '1' , '1.0000' , '0.8197' , '22' , '0' , '5.00' ) 05/07/2023 11:56:18 am >> SELECT document_num FROM ps_document WHERE document_num = '2303' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 11:56:18 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' , '2303' , '2023-07-05' , '' , '0' , '0' , '0' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '280.17' , '235.06' , NOW() , NOW() ) 05/07/2023 11:56:18 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 = '86644' 05/07/2023 11:56:18 am >> DELETE FROM ps_document_detail WHERE id_document = '86644' 05/07/2023 11:56:18 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 ( '86644' , '21067' , 'AMEN - AGO 23' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 05/07/2023 11:56:19 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 ( '86644' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.8000' , '3.1148' , '22' , '0' , '15.20' ) 05/07/2023 11:56:19 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 ( '86644' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9231' , '4' , '0' , '10.00' ) 05/07/2023 11:56:19 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 ( '86644' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3654' , '4' , '0' , '14.00' ) 05/07/2023 11:56:19 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 ( '86644' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5574' , '22' , '0' , '48.00' ) 05/07/2023 11:56:19 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 ( '86644' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 05/07/2023 11:56:19 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 ( '86644' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3.3000' , '2.7049' , '22' , '0' , '79.20' ) 05/07/2023 11:56:19 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 ( '86644' , '9124' , 'ROSARIO IN PLASTICA - MARRONE' , '20' , '-20' , '1' , '0.3000' , '0.2459' , '22' , '0' , '6.00' ) 05/07/2023 11:56:19 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 ( '86644' , '20825' , 'BRUCIA INCENSO STELLA' , '1' , '-1' , '1' , '24.0000' , '19.6721' , '22' , '0' , '24.00' ) 05/07/2023 11:56:19 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 ( '86644' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '5' , '-5' , '1' , '0.9500' , '0.7787' , '22' , '0' , '4.75' ) 05/07/2023 11:56:19 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 ( '86644' , '20220' , 'MEDAGLIA SAN BENEDETTO CM 2 - 400/n0217' , '5' , '-5' , '1' , '1.3000' , '1.0656' , '22' , '0' , '6.50' ) 05/07/2023 11:56:19 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 ( '86644' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '5' , '-5' , '1' , '1.0000' , '0.8197' , '22' , '0' , '5.00' ) 05/07/2023 11:58:23 am >> SELECT document_num FROM ps_document WHERE document_num = '72/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 11:58:23 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' , '72/A' , '2023-07-05' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'osp s. leonardo' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.94' , '57.25' , NOW() , NOW() ) 05/07/2023 11:58:23 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 = '86645' 05/07/2023 11:58:23 am >> DELETE FROM ps_document_detail WHERE id_document = '86645' 05/07/2023 11:58:23 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 ( '86645' , '21199' , 'AMEN - OTT 2023' , '4' , '-4' , '4' , '3.90' , '3.9' , '0' , '5' , '14.82' ) 05/07/2023 11:58:23 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 ( '86645' , '21198' , 'AMEN - SET 2023' , '4' , '-4' , '4' , '3.90' , '3.9' , '0' , '5' , '14.82' ) 05/07/2023 11:58:23 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 ( '86645' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.70' , '0.7' , '0' , '0' , '24.50' ) 05/07/2023 11:58:23 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 ( '86645' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 05/07/2023 11:59:27 am >> DELETE FROM ps_document WHERE id_document = '85772' 05/07/2023 11:59:27 am >> DELETE FROM ps_document_detail WHERE id_document = '85772' 05/07/2023 12:02:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2303' AND id_document != '86644' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 12:02:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2303', document_date = '2023-07-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', 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 = '280.17', price_tax_excluded = '235.06', date_upd = NOW() WHERE id_document = '86644' 05/07/2023 12:02: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 = '86644' 05/07/2023 12:02:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '86644' 05/07/2023 12:02: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 ( '86644' , '21067' , 'AMEN - AGO 23' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 05/07/2023 12:02: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 ( '86644' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '15.20' ) 05/07/2023 12:02: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 ( '86644' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 05/07/2023 12:02: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 ( '86644' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 05/07/2023 12:02: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 ( '86644' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 05/07/2023 12:02: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 ( '86644' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 05/07/2023 12:02: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 ( '86644' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '79.20' ) 05/07/2023 12:02: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 ( '86644' , '9124' , 'ROSARIO IN PLASTICA - MARRONE' , '20' , '-20' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '6.00' ) 05/07/2023 12:02: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 ( '86644' , '20825' , 'BRUCIA INCENSO STELLA' , '1' , '-1' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '24.00' ) 05/07/2023 12:02: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 ( '86644' , '9125' , 'ROSARIO IN PLASTICA - NERO' , '19' , '-19' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '4.75' ) 05/07/2023 12:02: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 ( '86644' , '20220' , 'MEDAGLIA SAN BENEDETTO CM 2 - 400/n0217' , '5' , '-5' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '6.50' ) 05/07/2023 12:02: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 ( '86644' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '5' , '-5' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '5.00' ) 05/07/2023 12:41:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '11/S' AND id_document != '11351' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-04') 05/07/2023 12:41:00 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '11/S', document_date = '2023-07-04', document_letter = 'S', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO GIUGNO 2023', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '1584.65', price_tax_excluded = '1584.65', date_upd = NOW() WHERE id_document = '11351' 05/07/2023 12:41: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 = '11351' 05/07/2023 12:41:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '11351' 05/07/2023 12:41: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 ( '11351' , '16' , 'MARIA DALLA NASCITA ALLASSUNZIONE' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 05/07/2023 12:41: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 ( '11351' , '17' , 'LA FEDE NELLO ZAINETTO' , '57' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '171.00' ) 05/07/2023 12:41: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 ( '11351' , '19' , 'CHIERICHETTI IERI OGGI DOMANI' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 05/07/2023 12:41: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 ( '11351' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '4' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '3.60' ) 05/07/2023 12:41: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 ( '11351' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '10' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '7.50' ) 05/07/2023 12:41: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 ( '11351' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '27' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '33.75' ) 05/07/2023 12:41: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 ( '11351' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 05/07/2023 12:41: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 ( '11351' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '5' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 05/07/2023 12:41: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 ( '11351' , '125' , 'MIE PREGHIERINE - N. E.' , '7' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '5.25' ) 05/07/2023 12:41: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 ( '11351' , '33' , '100 GIORNI CON LO SPIRITO' , '11' , '0' , '4' , '7.5000' , '7.5' , '0' , '50' , '41.25' ) 05/07/2023 12:41: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 ( '11351' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 05/07/2023 12:41: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 ( '11351' , '50' , 'PERDONAMI SIGNORE' , '17' , '0' , '4' , '2.5' , '2.5' , '0' , '50' , '21.25' ) 05/07/2023 12:41: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 ( '11351' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '5' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '3.75' ) 05/07/2023 12:41: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 ( '11351' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '2' , '0' , '4' , '30.0000' , '30' , '0' , '50' , '30.00' ) 05/07/2023 12:41: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 ( '11351' , '80' , 'MISERICORDIA' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 05/07/2023 12:41: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 ( '11351' , '92' , 'LA PREGHIERA DEL ROSARIO' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 05/07/2023 12:41: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 ( '11351' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '3' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '3.00' ) 05/07/2023 12:41: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 ( '11351' , '101' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '3' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '2.25' ) 05/07/2023 12:41: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 ( '11351' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '17' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '21.25' ) 05/07/2023 12:41: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 ( '11351' , '110' , 'SE MI AMI NON PIANGERE' , '55' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '49.50' ) 05/07/2023 12:41: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 ( '11351' , '111' , 'I NONNI SONO UN TESORO' , '5' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '4.50' ) 05/07/2023 12:41: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 ( '11351' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 05/07/2023 12:41: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 ( '11351' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 05/07/2023 12:41: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 ( '11351' , '117' , 'La preghiera delle cinque dita n.e.' , '7' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '6.30' ) 05/07/2023 12:41: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 ( '11351' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '10' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '12.50' ) 05/07/2023 12:41: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 ( '11351' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '34' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '42.50' ) 05/07/2023 12:41: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 ( '11351' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '3' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '4.50' ) 05/07/2023 12:41: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 ( '11351' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '119' , '0' , '4' , '18.0000' , '18' , '0' , '50' , '1071.00' ) 05/07/2023 12:41: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 ( '11351' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '50' , '9.00' ) 05/07/2023 12:41: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 ( '11351' , '126' , 'SACRAMENTO DEL PERDONO' , '20' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '20.00' ) 05/07/2023 05:18:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1107' AND id_document != '82619' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-03') 05/07/2023 05:18:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1107', document_date = '2023-04-03', 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 = '394.00', price_tax_excluded = '325.79', date_upd = NOW() WHERE id_document = '82619' 05/07/2023 05:18: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 = '82619' 05/07/2023 05:18:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '82619' 05/07/2023 05:18: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 ( '82619' , '19099' , 'INCENSO A' , '2' , '-2' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '92.00' ) 05/07/2023 05:18: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 ( '82619' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 05/07/2023 05:18: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 ( '82619' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 05/07/2023 05:18: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 ( '82619' , '20114' , 'FATIMA CM 95 - 1039/P' , '1' , '-1' , '1' , '270' , '221.31147540984' , '22' , '0' , '270.00' ) 05/07/2023 05:18: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 ( '82619' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 05/07/2023 05:36:01 pm >> DELETE FROM ps_document WHERE id_document = '86643' 05/07/2023 05:36:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '86643' 05/07/2023 05:57:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2304' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 05:57: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' , '2304' , '2023-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.59' , '53.59' , NOW() , NOW() ) 05/07/2023 05:57: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 = '86646' 05/07/2023 05:57:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '86646' 05/07/2023 05:57: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 ( '86646' , '18446' , 'MIA BIBBIA MORBIDA' , '1' , '-1' , '4' , '11.90' , '11.9' , '0' , '5' , '11.31' ) 05/07/2023 05:57: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 ( '86646' , '15563' , 'MIA PRIMA BIBBIA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 05/07/2023 05:57: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 ( '86646' , '9479' , 'SAN MATTEO APOSTOLO ED EVANGELISTA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 05/07/2023 05:57: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 ( '86646' , '20808' , 'CRISTIANESIMO RISORSA PER LA SOCIETA - AAVV' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 05/07/2023 05:57: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 ( '86646' , '20888' , 'PAPA FRANCESCO E IL TESORO DEGLI ANZIANI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 05/07/2023 06:00:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2305' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 06:00:41 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' , '2305' , '2023-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.50' , NOW() , NOW() ) 05/07/2023 06:00:41 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 = '86647' 05/07/2023 06:00:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '86647' 05/07/2023 06:00:41 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 ( '86647' , '21010' , 'NATALE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 05/07/2023 06:05:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1087' AND id_document != '82595' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 05/07/2023 06:05:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1087', document_date = '2023-04-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 = '60.00', price_tax_excluded = '50.08', date_upd = NOW() WHERE id_document = '82595' 05/07/2023 06:05:05 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 = '82595' 05/07/2023 06:05:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '82595' 05/07/2023 06:05:05 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 ( '82595' , '9125' , 'ROSARIO IN PLASTICA - NERO' , '5' , '-5' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '1.00' ) 05/07/2023 06:05:05 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 ( '82595' , '15602' , 'AMICO GESU ALBUM' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 05/07/2023 06:05:05 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 ( '82595' , '475' , 'AMICO GESÙ - FIGURINE' , '6' , '-6' , '4' , '0.5000' , '0.5' , '0' , '0' , '3.00' ) 05/07/2023 06:05:05 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 ( '82595' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '54.00' ) 05/07/2023 06:07:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1106' AND id_document != '82617' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-03') 05/07/2023 06:07:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1106', document_date = '2023-04-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA TORRIONE 84100 SALERNO', 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 = '198.65', price_tax_excluded = '170.52', date_upd = NOW() WHERE id_document = '82617' 05/07/2023 06:07:34 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 = '82617' 05/07/2023 06:07:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '82617' 05/07/2023 06:07:34 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 ( '82617' , '19553' , 'UN PADRE COME CUSTODE - PAPA FRANCESCO' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '5' , '10.45' ) 05/07/2023 06:07:34 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 ( '82617' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '10.50' ) 05/07/2023 06:07:34 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 ( '82617' , '20018' , 'VITA DI GESU - A. TORNIELLI' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '5' , '17.00' ) 05/07/2023 06:07:34 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 ( '82617' , '20817' , 'FACCIA A FACCIA CON GESU - D. RUOTOLO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 05/07/2023 06:07:34 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 ( '82617' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '3' , '-3' , '1' , '27.5000' , '22.540983606557' , '22' , '0' , '82.50' ) 05/07/2023 06:07:34 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 ( '82617' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 05/07/2023 06:07:34 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 ( '82617' , '9125' , 'ROSARIO IN PLASTICA - NERO' , '14' , '-14' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '2.80' ) 05/07/2023 06:07:34 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 ( '82617' , '9124' , 'ROSARIO IN PLASTICA - MARRONE' , '20' , '-20' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '4.00' ) 05/07/2023 06:07:34 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 ( '82617' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 05/07/2023 06:07:34 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 ( '82617' , '20220' , 'MEDAGLIA SAN BENEDETTO CM 2 - 400/n0217' , '5' , '-5' , '1' , '0.64' , '0.52459016393443' , '22' , '0' , '3.20' ) 05/07/2023 06:08:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '987' AND id_document != '82485' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-27') 05/07/2023 06:08:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '987', document_date = '2023-03-27', 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 = '47.00', price_tax_excluded = '38.52', date_upd = NOW() WHERE id_document = '82485' 05/07/2023 06:08:22 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 = '82485' 05/07/2023 06:08:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '82485' 05/07/2023 06:08: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 ( '82485' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 05/07/2023 06:08: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 ( '82485' , '11756' , 'VINO BIANCO SECCO - 14%' , '4' , '-4' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '26.00' ) 05/07/2023 06:08: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 ( '82485' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '14.00' ) 05/07/2023 06:10:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '974' AND id_document != '82466' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 05/07/2023 06:10:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '974', document_date = '2023-03-25', 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 = '110.00', price_tax_excluded = '90.16', date_upd = NOW() WHERE id_document = '82466' 05/07/2023 06:10:34 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 = '82466' 05/07/2023 06:10:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '82466' 05/07/2023 06:10:34 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 ( '82466' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '79.20' ) 05/07/2023 06:10:34 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 ( '82466' , '20825' , 'BRUCIA INCENSO STELLA' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 05/07/2023 06:10:34 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 ( '82466' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.4' , '2.7868852459016' , '22' , '0' , '6.80' ) 05/07/2023 06:13:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2303' AND id_document != '86644' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 06:13:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2303', document_date = '2023-07-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', 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 = '280.17', price_tax_excluded = '235.06', date_upd = NOW() WHERE id_document = '86644' 05/07/2023 06:13: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 = '86644' 05/07/2023 06:13:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '86644' 05/07/2023 06:13: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 ( '86644' , '21067' , 'AMEN - AGO 23' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 05/07/2023 06:13: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 ( '86644' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 05/07/2023 06:13: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 ( '86644' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 05/07/2023 06:13: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 ( '86644' , '21290' , 'ROSARIO ADDOLORATA' , '54' , '-54' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '243.00' ) 05/07/2023 06:13: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 ( '86644' , '13366' , 'CORONA VETRO MM 4 CON SCATOLA' , '1' , '-1' , '1' , '2.05' , '1.6803278688525' , '22' , '0' , '2.05' ) 05/07/2023 07:06:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2306' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 07:06:22 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' , '2306' , '2023-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.80' , '12.95' , NOW() , NOW() ) 05/07/2023 07:06:22 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 = '86648' 05/07/2023 07:06:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '86648' 05/07/2023 07:06: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 ( '86648' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 05/07/2023 07:06: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 ( '86648' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 05/07/2023 07:45:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2307' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-05') 05/07/2023 07:45:31 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' , '2307' , '2023-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 05/07/2023 07:45:31 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 = '86649' 05/07/2023 07:45:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '86649' 05/07/2023 07:45: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 ( '86649' , '21347' , 'SCAPOLARE VERDE E I SUOI PRODIGI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' )