06/06/2022 08:38:29 am >> SELECT document_num FROM ps_document
WHERE document_num = '1792' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 08:38:29 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' ,
'1792' ,
'2022-06-06' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.40' ,
'9.40' ,
NOW() ,
NOW() )
06/06/2022 08:38:29 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 = '58611'
06/06/2022 08:38:29 am >> DELETE FROM ps_document_detail WHERE id_document = '58611'
06/06/2022 08:38:29 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
( '58611' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '0' , '2.50' )
06/06/2022 08:38:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '18597' AND id_supplier = ''
06/06/2022 08:38:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18597' , '' , '1' )
06/06/2022 08:38:29 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
( '58611' , '19420' , 'PREGO ANCHE IO ' , '1' , '-1' , '4' ,
'1.90' , '1.9' , '0' , '0' , '1.90' )
06/06/2022 08:38:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '19420' AND id_supplier = ''
06/06/2022 08:38:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19420' , '' , '1' )
06/06/2022 08:38:30 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58611' , '12147' , 'ANGELO CUSTODE RACCONTATO AI BAMBINI - B. FERRERO' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '0' , '5.00' )
06/06/2022 08:38:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '12147' AND id_supplier = ''
06/06/2022 08:38:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12147' , '' , '1' )
06/06/2022 08:55:40 am >> SELECT document_num FROM ps_document
WHERE document_num = '9/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 08:55:40 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' ,
'9/S' ,
'2022-06-06' ,
'S' ,
'402' ,
'0' ,
'4670248' ,
'VIA F. WENNER, 37 84080 PELLEZZANO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'293.15' ,
'293.15' ,
NOW() ,
NOW() )
06/06/2022 08:55:40 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 = '5365'
06/06/2022 08:55:40 am >> DELETE FROM ps_document_detail WHERE id_document = '5365'
06/06/2022 08:55:40 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
( '5365' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '20' , '-20' , '4' ,
'3.00' , '3' , '0' , '35' , '39.00' )
06/06/2022 08:55:40 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
( '5365' , '50' , 'PERDONAMI SIGNORE' , '70' , '-70' , '4' ,
'2.00' , '2' , '0' , '35' , '91.00' )
06/06/2022 08:55:40 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
( '5365' , '117' , 'La prehiera delle cinque dita n.e.' , '27' , '-27' , '4' ,
'1.50' , '1.5' , '0' , '35' , '26.32' )
06/06/2022 08:55:40 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
( '5365' , '9' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' ,
'10.50' , '10.5' , '0' , '35' , '6.83' )
06/06/2022 08:55:40 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
( '5365' , '110' , 'SE MI AMI NON PIANGERE' , '100' , '-100' , '4' ,
'1.50' , '1.5' , '0' , '35' , '97.50' )
06/06/2022 08:55:40 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
( '5365' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '20' , '-20' , '4' ,
'2.50' , '2.5' , '0' , '35' , '32.50' )
06/06/2022 09:15:58 am >> SELECT document_num FROM ps_document
WHERE document_num = '1785' AND id_document != '58604' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04')
06/06/2022 09:15:58 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1785',
document_date = '2022-06-04',
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 = '32.20',
price_tax_excluded = '26.39',
date_upd = NOW()
WHERE id_document = '58604'
06/06/2022 09:15:58 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 = '58604'
06/06/2022 09:15:59 am >> DELETE FROM ps_document_detail WHERE id_document = '58604'
06/06/2022 09:15:59 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
( '58604' , '18274' , 'BRACCIALE A NODI - 2610' , '23' , '-23' , '1' ,
'1.40' , '1.1475409836066' , '22' , '0' , '32.20' )
06/06/2022 09:15:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '18274' AND id_supplier = ''
06/06/2022 09:15:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18274' , '' , '1' )
06/06/2022 09:16:31 am >> SELECT document_num FROM ps_document
WHERE document_num = '1783' AND id_document != '58602' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04')
06/06/2022 09:16:31 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1783',
document_date = '2022-06-04',
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 = '939.42',
price_tax_excluded = '925.35',
date_upd = NOW()
WHERE id_document = '58602'
06/06/2022 09:16:31 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58602'
06/06/2022 09:16:31 am >> DELETE FROM ps_document_detail WHERE id_document = '58602'
06/06/2022 09:16:31 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58602' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'36' , '29.508196721311' , '22' , '0' , '36.00' )
06/06/2022 09:16:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = ''
06/06/2022 09:16:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )
06/06/2022 09:16:31 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58602' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '49' , '-49' , '4' ,
'18.5000' , '18.5' , '0' , '5' , '861.42' )
06/06/2022 09:16:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = ''
06/06/2022 09:16:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' )
06/06/2022 09:16:31 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58602' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' ,
'7.0000' , '5.7377049180328' , '22' , '0' , '42.00' )
06/06/2022 09:16:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = ''
06/06/2022 09:16:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' )
06/06/2022 09:39:56 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'32' ,
'6022259141' ,
'2022-05-31' ,
'' ,
'0' ,
'109' ,
'4669106' ,
'VIA G. VERDI, 8 20090 ASSAGO' ,
'' ,
'' ,
'5.10' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'12' ,
'0' ,
'127.31' ,
'127.31' ,
NOW() ,
NOW() )
06/06/2022 09:39: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 = '58612'
06/06/2022 09:39:56 am >> DELETE FROM ps_document_detail WHERE id_document = '58612'
06/06/2022 09:39: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
( '58612' , '10915' , 'UNA COMUNITÀ LEGGE IL VANGELO DI LUCA' , '1' , '0' , '4' ,
'43.01' , '43.01' , '0' , '0' , '43.0100' )
06/06/2022 09:39:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '10915' AND id_supplier = '109'
06/06/2022 09:39:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10915' , '109' , '1' )
06/06/2022 09:39: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
( '58612' , '822' , 'ATTI DEGLI APOSTOLI - S. FAUSTI' , '2' , '0' , '4' ,
'39.6' , '39.6' , '0' , '0' , '79.2000' )
06/06/2022 09:39:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '822' AND id_supplier = '109'
06/06/2022 09:39:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '822' , '109' , '1' )
06/06/2022 09:40:44 am >> SELECT document_num FROM ps_document
WHERE document_num = '1793' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 09:40:44 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' ,
'1793' ,
'2022-06-06' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'3.50' ,
'2.87' ,
NOW() ,
NOW() )
06/06/2022 09:40: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 = '58613'
06/06/2022 09:40:44 am >> DELETE FROM ps_document_detail WHERE id_document = '58613'
06/06/2022 09:40: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
( '58613' , '9539' , 'SANTANTONIO DA PADOVA - 41' , '1' , '-1' , '1' ,
'3.50' , '2.8688524590164' , '22' , '0' , '3.50' )
06/06/2022 09:40:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '9539' AND id_supplier = ''
06/06/2022 09:40:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9539' , '' , '1' )
06/06/2022 09:46:54 am >> SELECT document_num FROM ps_document
WHERE document_num = '1794' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 09:46:54 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' ,
'1794' ,
'2022-06-06' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'13.00' ,
'10.66' ,
NOW() ,
NOW() )
06/06/2022 09:46:54 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 = '58614'
06/06/2022 09:46:54 am >> DELETE FROM ps_document_detail WHERE id_document = '58614'
06/06/2022 09:46:54 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
( '58614' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' ,
'0.80' , '0.65573770491803' , '22' , '0' , '0.80' )
06/06/2022 09:46:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = ''
06/06/2022 09:46:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' )
06/06/2022 09:46:54 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
( '58614' , '16252' , 'CUORE PENDENTE' , '1' , '-1' , '1' ,
'12.20' , '10' , '22' , '0' , '12.20' )
06/06/2022 09:46:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '16252' AND id_supplier = ''
06/06/2022 09:46:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16252' , '' , '1' )
06/06/2022 11:18:54 am >> SELECT document_num FROM ps_document
WHERE document_num = '1795' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 11:18:55 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1795' ,
'2022-06-06' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'143.00' ,
'117.21' ,
NOW() ,
NOW() )
06/06/2022 11:18:55 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58615'
06/06/2022 11:18:55 am >> DELETE FROM ps_document_detail WHERE id_document = '58615'
06/06/2022 11:18:55 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58615' , '17544' , 'CAMICE BAMBOO' , '1' , '-1' , '1' ,
'143.00' , '117.2131147541' , '22' , '0' , '143.00' )
06/06/2022 11:18:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '17544' AND id_supplier = ''
06/06/2022 11:18:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17544' , '' , '1' )
06/06/2022 11:42:03 am >> SELECT document_num FROM ps_document
WHERE document_num = '1796' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 11:42:03 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' ,
'1796' ,
'2022-06-06' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'97.20' ,
'87.50' ,
NOW() ,
NOW() )
06/06/2022 11:42:03 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 = '58616'
06/06/2022 11:42:03 am >> DELETE FROM ps_document_detail WHERE id_document = '58616'
06/06/2022 11:42:03 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
( '58616' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '8' , '-8' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '28.00' )
06/06/2022 11:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = ''
06/06/2022 11:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' )
06/06/2022 11:42:04 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58616' , '7311' , 'OSTIA SOTTILE 74MM' , '8' , '-8' , '3' ,
'1.90' , '1.8269230769231' , '4' , '0' , '15.20' )
06/06/2022 11:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = ''
06/06/2022 11:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' )
06/06/2022 11:42:04 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58616' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' ,
'4.00' , '3.8461538461538' , '4' , '0' , '12.00' )
06/06/2022 11:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = ''
06/06/2022 11:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' )
06/06/2022 11:42:04 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58616' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' ,
'7' , '5.7377049180328' , '22' , '0' , '42.00' )
06/06/2022 11:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = ''
06/06/2022 11:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' )
06/06/2022 11:55:38 am >> SELECT document_num FROM ps_document
WHERE document_num = '1797' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 11:55:38 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1797' ,
'2022-06-06' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'300.00' ,
'245.90' ,
NOW() ,
NOW() )
06/06/2022 11:55:38 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58617'
06/06/2022 11:55:38 am >> DELETE FROM ps_document_detail WHERE id_document = '58617'
06/06/2022 11:55:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58617' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' ,
'4.5' , '3.6885245901639' , '22' , '0' , '270.00' )
06/06/2022 11:55:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = ''
06/06/2022 11:55:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' )
06/06/2022 11:55:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58617' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' ,
'30' , '24.590163934426' , '22' , '0' , '30.00' )
06/06/2022 11:55:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '2164' AND id_supplier = ''
06/06/2022 11:55:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2164' , '' , '1' )
06/06/2022 12:35:21 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1798' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 12:35:21 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1798' ,
'2022-06-06' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'102.00' ,
'85.17' ,
NOW() ,
NOW() )
06/06/2022 12:35:21 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58618'
06/06/2022 12:35:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '58618'
06/06/2022 12:35:21 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58618' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '30' , '-30' , '1' ,
'2.5' , '2.0491803278689' , '22' , '0' , '75.00' )
06/06/2022 12:35:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9688' AND id_supplier = ''
06/06/2022 12:35:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9688' , '' , '1' )
06/06/2022 12:35: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
( '58618' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '7.00' )
06/06/2022 12:35:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = ''
06/06/2022 12:35:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' )
06/06/2022 12:35: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
( '58618' , '17883' , 'CROCE MOGANO CORPO MET CM 28- 169M' , '1' , '-1' , '1' ,
'16.00' , '13.114754098361' , '22' , '0' , '16.00' )
06/06/2022 12:35:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17883' AND id_supplier = ''
06/06/2022 12:35:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17883' , '' , '1' )
06/06/2022 12:35: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
( '58618' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '4.00' )
06/06/2022 12:35:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = ''
06/06/2022 12:35:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' )
06/06/2022 12:57:20 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1798' AND id_document != '58618' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 12:57:20 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1798',
document_date = '2022-06-06',
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 = '102.00',
price_tax_excluded = '85.17',
date_upd = NOW()
WHERE id_document = '58618'
06/06/2022 12:57:20 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58618'
06/06/2022 12:57:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '58618'
06/06/2022 12:57:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58618' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'75' , '61.475409836066' , '22' , '0' , '75.00' )
06/06/2022 12:57:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = ''
06/06/2022 12:57:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )
06/06/2022 12:57:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58618' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' ,
'3.5000' , '3.3653846153846' , '4' , '0' , '7.00' )
06/06/2022 12:57:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = ''
06/06/2022 12:57:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' )
06/06/2022 12:57:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58618' , '17883' , 'CROCE MOGANO CORPO MET CM 28- 169M' , '1' , '-1' , '1' ,
'16.0000' , '13.114754098361' , '22' , '0' , '16.00' )
06/06/2022 12:57:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17883' AND id_supplier = ''
06/06/2022 12:57:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17883' , '' , '1' )
06/06/2022 12:57:20 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58618' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' ,
'2.0000' , '1.9230769230769' , '4' , '0' , '4.00' )
06/06/2022 12:57:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = ''
06/06/2022 12:57:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' )
06/06/2022 02:44:27 pm >> SELECT document_num FROM ps_document
WHERE document_num = '17' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 02:44:27 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'24' ,
'17' ,
'2022-06-06' ,
'' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'CARTA D\'IDENTITA\' ARRIVERA\' DIRETTAMENTE DA VELAR' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'1274.00' ,
'1274.00' ,
NOW() ,
NOW() )
06/06/2022 02:44:27 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 = '58619'
06/06/2022 02:44:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '58619'
06/06/2022 02:44:27 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
( '58619' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '320' , '-320' , '4' ,
'1.60' , '1.6' , '0' , '0' , '512.00' )
06/06/2022 02:44:27 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
( '58619' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '320' , '-320' , '4' ,
'1.60' , '1.6' , '0' , '0' , '512.00' )
06/06/2022 02:44:27 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
( '58619' , '17861' , 'CARTA D\'IDENTITA\' DELLA CHIESA - R. LUPI' , '100' , '-100' , '4' ,
'2.50' , '2.5' , '0' , '0' , '250.00' )
06/06/2022 02:46:03 pm >> SELECT document_num FROM ps_document
WHERE document_num = '17/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 02:46:03 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'23' ,
'17/E' ,
'2022-06-06' ,
'E' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'14' ,
'0' ,
'592.20' ,
'485.41' ,
NOW() ,
NOW() )
06/06/2022 02:46:03 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 = '58620'
06/06/2022 02:46:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '58620'
06/06/2022 02:46:03 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
( '58620' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' ,
'38.00' , '31.147540983607' , '22' , '40' , '273.60' )
06/06/2022 02:46:03 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
( '58620' , '12815' , 'LIBRO DEI CRESIMATI' , '12' , '-12' , '1' ,
'38.00' , '31.147540983607' , '22' , '40' , '273.60' )
06/06/2022 02:46:03 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
( '58620' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '250' , '-250' , '1' ,
'0.30' , '0.24590163934426' , '22' , '40' , '45.00' )
06/06/2022 02:48:06 pm >> SELECT document_num FROM ps_document
WHERE document_num = '6' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 02:48:06 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'24' ,
'6' ,
'2022-06-06' ,
'' ,
'6541' ,
'0' ,
'9339920' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'3075.00' ,
'3075.00' ,
NOW() ,
NOW() )
06/06/2022 02:48:06 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5366'
06/06/2022 02:48:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '5366'
06/06/2022 02:48:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5366' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '270' , '-270' , '4' ,
'2.50' , '2.5' , '0' , '0' , '675.00' )
06/06/2022 02:48:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5366' , '110' , 'SE MI AMI NON PIANGERE' , '500' , '-500' , '4' ,
'1.50' , '1.5' , '0' , '0' , '750.00' )
06/06/2022 02:48:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5366' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '300' , '-300' , '4' ,
'1.50' , '1.5' , '0' , '0' , '450.00' )
06/06/2022 02:48:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5366' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '480' , '-480' , '4' ,
'2.50' , '2.5' , '0' , '0' , '1200.00' )
06/06/2022 03:16:12 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1799' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 03:16:12 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1799' ,
'2022-06-06' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'1.20' ,
'0.98' ,
NOW() ,
NOW() )
06/06/2022 03:16:12 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58621'
06/06/2022 03:16:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '58621'
06/06/2022 03:16:12 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58621' , '3074' , 'CROCE PRIMA COMUNIONE LEGNO CHIARO - 713/11' , '1' , '-1' , '1' ,
'1.20' , '0.98360655737705' , '22' , '0' , '1.20' )
06/06/2022 03:16:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3074' AND id_supplier = ''
06/06/2022 03:16:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3074' , '' , '1' )
06/06/2022 03:59:39 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1800' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 03:59:39 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1800' ,
'2022-06-06' ,
'' ,
'' ,
'' ,
'' ,
'VIA SAN LEONARDO 239 84131 SALERNO' ,
'' ,
'' ,
'0.00' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'58.60' ,
'49.03' ,
NOW() ,
NOW() )
06/06/2022 03:59:39 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58622'
06/06/2022 03:59:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '58622'
06/06/2022 03:59:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58622' , '7912' , 'PERGAMENE - 1A COMUNIONE MOD. C' , '13' , '-13' , '1' ,
'0.7000' , '0.5738' , '22' , '0' , '9.10' )
06/06/2022 03:59:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7912' AND id_supplier = ''
06/06/2022 03:59:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7912' , '' , '1' )
06/06/2022 03:59:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58622' , '12044' , 'CONFEZIONE CARTONCINO CON CROCE - 2342/K126' , '13' , '-13' , '1' ,
'2.5000' , '2.0492' , '22' , '0' , '32.50' )
06/06/2022 03:59:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12044' AND id_supplier = ''
06/06/2022 03:59:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12044' , '' , '1' )
06/06/2022 03:59:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58622' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '7.00' )
06/06/2022 03:59:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = ''
06/06/2022 03:59:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' )
06/06/2022 03:59:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58622' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' , '-20' , '1' ,
'0.50' , '0.40983606557377' , '22' , '0' , '10.00' )
06/06/2022 03:59:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7936' AND id_supplier = ''
06/06/2022 03:59:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7936' , '' , '1' )
06/06/2022 03:59:46 pm >> DELETE FROM ps_document WHERE id_document = '58415'
06/06/2022 03:59:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '58415'
06/06/2022 04:24:30 pm >> SELECT document_num FROM ps_document
WHERE document_num = '18/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 04:24: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 (
'22' ,
'18/E' ,
'2022-06-06' ,
'E' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'VENDUTO MAGGIO 2022' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'14' ,
'0' ,
'6426.71' ,
'6425.36' ,
NOW() ,
NOW() )
06/06/2022 04:24: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 = '58623'
06/06/2022 04:24:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '58623'
06/06/2022 04:24: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
( '58623' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '211' , '0' , '4' ,
'2.40' , '2.4' , '0' , '50' , '253.20' )
06/06/2022 04:24: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
( '58623' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '5' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '6.25' )
06/06/2022 04:24: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
( '58623' , '5446' , 'IO SONO CON VOI - GUIDA' , '9' , '0' , '4' ,
'6.00' , '6' , '0' , '50' , '27.00' )
06/06/2022 04:24: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
( '58623' , '11183' , 'VENITE CON ME - GUIDA' , '7' , '0' , '4' ,
'6.00' , '6' , '0' , '50' , '21.00' )
06/06/2022 04:24: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
( '58623' , '5548' , 'LAMPADA AI MIEI PASSI - ANNO C' , '1' , '0' , '4' ,
'10.33' , '10.33' , '0' , '50' , '5.17' )
06/06/2022 04:24: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
( '58623' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '3' , '0' , '4' ,
'6.20' , '6.2' , '0' , '50' , '9.30' )
06/06/2022 04:24: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
( '58623' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '2' , '0' , '4' ,
'5.16' , '5.16' , '0' , '50' , '5.16' )
06/06/2022 04:24: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
( '58623' , '9675' , 'SARETE MIEI TESTIMONI' , '59' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '88.50' )
06/06/2022 04:24: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
( '58623' , '8254' , 'PREGHIAMO CON MARIA' , '11' , '0' , '4' ,
'0.65' , '0.65' , '0' , '50' , '3.58' )
06/06/2022 04:24: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
( '58623' , '5457' , 'IO SONO CON VOI 1 PARTE' , '697' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '871.25' )
06/06/2022 04:24: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
( '58623' , '5458' , 'IO SONO CON VOI 2 PARTE' , '510' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '637.50' )
06/06/2022 04:24: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
( '58623' , '11191' , 'VENITE CON ME 1 PARTE' , '520' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '650.00' )
06/06/2022 04:24: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
( '58623' , '11192' , 'VENITE CON ME 2 PARTE' , '272' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '340.00' )
06/06/2022 04:24: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
( '58623' , '1882' , 'CELEBRAZIONI PER LANNO CATECHISTICO' , '1' , '0' , '4' ,
'10.00' , '10' , '0' , '50' , '5.00' )
06/06/2022 04:24: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
( '58623' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '7' , '0' , '4' ,
'8.00' , '8' , '0' , '50' , '28.00' )
06/06/2022 04:24: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
( '58623' , '8243' , 'PREGARE OGNI GIORNO' , '16' , '0' , '4' ,
'1.00' , '1' , '0' , '50' , '8.00' )
06/06/2022 04:24: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
( '58623' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '25' , '0' , '4' ,
'3.40' , '3.4' , '0' , '50' , '42.50' )
06/06/2022 04:24: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
( '58623' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '4' , '0' , '4' ,
'5.00' , '5' , '0' , '50' , '10.00' )
06/06/2022 04:24: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
( '58623' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '3' , '0' , '4' ,
'10.00' , '10' , '0' , '50' , '15.00' )
06/06/2022 04:24: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
( '58623' , '11308' , 'VIA CRUCIS ' , '2' , '0' , '4' ,
'1.50' , '1.5' , '0' , '50' , '1.50' )
06/06/2022 04:24: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
( '58623' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '9' , '0' , '4' ,
'6.00' , '6' , '0' , '50' , '27.00' )
06/06/2022 04:24: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
( '58623' , '6629' , 'MIA PREGHIERA' , '10' , '0' , '4' ,
'0.65' , '0.65' , '0' , '50' , '3.25' )
06/06/2022 04:24: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
( '58623' , '8408' , 'PRENDETE E MANGIATE' , '64' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '96.00' )
06/06/2022 04:24: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
( '58623' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '5' , '0' , '4' ,
'5.00' , '5' , '0' , '50' , '12.50' )
06/06/2022 04:24: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
( '58623' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '4' , '0' , '4' ,
'5.00' , '5' , '0' , '50' , '10.00' )
06/06/2022 04:24: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
( '58623' , '4154' , 'FESTA DEL PERDONO' , '39' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '58.50' )
06/06/2022 04:24: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
( '58623' , '2679' , 'CONOSCERE GESU' , '59' , '0' , '4' ,
'3.50' , '3.5' , '0' , '50' , '103.25' )
06/06/2022 04:24: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
( '58623' , '2680' , 'CONOSCERE GESU - GUIDA' , '5' , '0' , '4' ,
'6.00' , '6' , '0' , '50' , '15.00' )
06/06/2022 04:24: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
( '58623' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '2' , '0' , '4' ,
'5.00' , '5' , '0' , '50' , '5.00' )
06/06/2022 04:24: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
( '58623' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '3' , '0' , '4' ,
'8.50' , '8.5' , '0' , '50' , '12.75' )
06/06/2022 04:24: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
( '58623' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '2' , '0' , '4' ,
'12.00' , '12' , '0' , '50' , '12.00' )
06/06/2022 04:24: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
( '58623' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '15' , '0' , '4' ,
'1.60' , '1.6' , '0' , '50' , '12.00' )
06/06/2022 04:24: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
( '58623' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '821' , '0' , '4' ,
'1.60' , '1.6' , '0' , '50' , '656.80' )
06/06/2022 04:24: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
( '58623' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '1' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '1.50' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '7543' , 'PARABOLE DI GESÙ' , '1' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '1.50' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '0' , '4' ,
'3.50' , '3.5' , '0' , '50' , '1.75' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '793' , '0' , '4' ,
'1.60' , '1.6' , '0' , '50' , '634.40' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '12819' , 'REGISTRO DEL CATECHISTA ' , '15' , '0' , '1' ,
'1.00' , '0.81967213114754' , '22' , '50' , '7.50' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '12253' , 'MIO LIBRO DI PREGHIERE' , '29' , '0' , '4' ,
'2.80' , '2.8' , '0' , '50' , '40.60' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '12255' , 'IN CAMMINO CON GESU' , '82' , '0' , '4' ,
'3.80' , '3.8' , '0' , '50' , '155.80' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '4' , '0' , '4' ,
'3.50' , '3.5' , '0' , '50' , '7.00' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '30' , '0' , '4' ,
'3.50' , '3.5' , '0' , '50' , '52.50' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '7' , '0' , '4' ,
'6.00' , '6' , '0' , '50' , '21.00' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '2' , '0' , '4' ,
'10.00' , '10' , '0' , '50' , '10.00' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '13397' , 'MIO GESU' , '29' , '0' , '4' ,
'3.50' , '3.5' , '0' , '50' , '50.75' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '14031' , 'SEGNO DELLA CROCE' , '1' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '1.50' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '48' , '0' , '4' ,
'1.00' , '1' , '0' , '50' , '24.00' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '15019' , 'PREGHIAMO CON MARIA' , '31' , '0' , '4' ,
'0.80' , '0.8' , '0' , '50' , '12.40' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '15020' , 'PREGARE OGNI GIORNO' , '76' , '0' , '4' ,
'1.00' , '1' , '0' , '50' , '38.00' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '5' , '0' , '4' ,
'3.50' , '3.5' , '0' , '50' , '8.75' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '7' , '0' , '4' ,
'1.00' , '1' , '0' , '50' , '3.50' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '13' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '13.00' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '16667' , 'VIA CRUCIS' , '5' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '7.50' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '9' , '0' , '4' ,
'15.00' , '15' , '0' , '50' , '67.50' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '17257' , 'IO TI BATTEZZO ' , '81' , '0' , '4' ,
'1.80' , '1.8' , '0' , '50' , '72.90' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '23' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '34.50' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '17582' , 'SAN CESARE DE BUS' , '9' , '0' , '4' ,
'5.00' , '5' , '0' , '50' , '22.50' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '7' , '0' , '4' ,
'20.00' , '20' , '0' , '50' , '70.00' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '5' , '0' , '4' ,
'3.80' , '3.8' , '0' , '50' , '9.50' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '16' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '20.00' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '2' , '0' , '4' ,
'12.00' , '12' , '0' , '50' , '12.00' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '5' , '0' , '4' ,
'1.00' , '1' , '0' , '50' , '2.50' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '14' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '14.00' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '0' , '4' ,
'15.00' , '15' , '0' , '50' , '7.50' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '1.25' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '47' , '0' , '4' ,
'1.90' , '1.9' , '0' , '50' , '44.65' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '26' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '32.50' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '18528' , 'CON GESU VERSO IL CALVARIO - P. G. VALSECCHI' , '6' , '0' , '4' ,
'1.50' , '1.5' , '0' , '50' , '4.50' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '3' , '0' , '4' ,
'16.00' , '16' , '0' , '50' , '24.00' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '3' , '0' , '4' ,
'16.00' , '16' , '0' , '50' , '24.00' )
06/06/2022 04:24:32 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58623' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '6' , '0' , '4' ,
'16.00' , '16' , '0' , '50' , '48.00' )
06/06/2022 04:24:33 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
( '58623' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '12' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '12.00' )
06/06/2022 04:24:33 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
( '58623' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '5' , '0' , '4' ,
'5.00' , '5' , '0' , '50' , '12.50' )
06/06/2022 04:24:33 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
( '58623' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '8' , '0' , '4' ,
'20.00' , '20' , '0' , '50' , '80.00' )
06/06/2022 04:24:33 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
( '58623' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '5' , '0' , '4' ,
'15.00' , '15' , '0' , '50' , '37.50' )
06/06/2022 04:24:33 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
( '58623' , '18657' , 'HO DATO LORO LA TUA PAROLA - P. VALSECCHI' , '7' , '0' , '4' ,
'16.00' , '16' , '0' , '50' , '56.00' )
06/06/2022 04:24:33 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
( '58623' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '8' , '0' , '4' ,
'7.00' , '7' , '0' , '50' , '28.00' )
06/06/2022 04:24:33 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
( '58623' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '5' , '0' , '4' ,
'4.80' , '4.8' , '0' , '50' , '12.00' )
06/06/2022 04:24:33 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
( '58623' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '20' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '20.00' )
06/06/2022 04:24:33 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
( '58623' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '12' , '0' , '4' ,
'9.00' , '9' , '0' , '50' , '54.00' )
06/06/2022 04:24:33 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
( '58623' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '9' , '0' , '4' ,
'9.00' , '9' , '0' , '50' , '40.50' )
06/06/2022 04:24:33 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
( '58623' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '9' , '0' , '4' ,
'9.00' , '9' , '0' , '50' , '40.50' )
06/06/2022 04:24:33 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
( '58623' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '5' , '0' , '4' ,
'10.00' , '10' , '0' , '50' , '25.00' )
06/06/2022 04:24:33 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
( '58623' , '18950' , 'DOVE FINITO IL CONCILIO? - F. CERRI' , '1' , '0' , '4' ,
'18.00' , '18' , '0' , '50' , '9.00' )
06/06/2022 04:24:33 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
( '58623' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '13' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '13.00' )
06/06/2022 04:24:33 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
( '58623' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '15' , '0' , '4' ,
'20.00' , '20' , '0' , '50' , '150.00' )
06/06/2022 04:24:33 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
( '58623' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '30' , '0' , '4' ,
'12.00' , '12' , '0' , '50' , '180.00' )
06/06/2022 04:40:27 pm >> SELECT document_num FROM ps_document
WHERE document_num = '19/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 04:40:27 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 (
'25' ,
'19/E' ,
'2022-06-06' ,
'E' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'RESA MAGGIO 2022' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'672.37' ,
'672.01' ,
NOW() ,
NOW() )
06/06/2022 04:40:27 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 = '58624'
06/06/2022 04:40:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '58624'
06/06/2022 04:40:27 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
( '58624' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '8' , '8' , '4' ,
'2.40' , '2.4' , '0' , '50' , '9.60' )
06/06/2022 04:40:27 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
( '58624' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '1' , '4' ,
'2.50' , '2.5' , '0' , '50' , '1.25' )
06/06/2022 04:40:27 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
( '58624' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '2' , '4' ,
'6.00' , '6' , '0' , '50' , '6.00' )
06/06/2022 04:40:27 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
( '58624' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '1' , '4' ,
'6.00' , '6' , '0' , '50' , '3.00' )
06/06/2022 04:40:27 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
( '58624' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '2' , '2' , '4' ,
'6.20' , '6.2' , '0' , '50' , '6.20' )
06/06/2022 04:40:27 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
( '58624' , '5457' , 'IO SONO CON VOI 1 PARTE' , '4' , '4' , '4' ,
'2.50' , '2.5' , '0' , '50' , '5.00' )
06/06/2022 04:40:27 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
( '58624' , '5458' , 'IO SONO CON VOI 2 PARTE' , '15' , '15' , '4' ,
'2.50' , '2.5' , '0' , '50' , '18.75' )
06/06/2022 04:40:27 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
( '58624' , '11191' , 'VENITE CON ME 1 PARTE' , '26' , '26' , '4' ,
'2.50' , '2.5' , '0' , '50' , '32.50' )
06/06/2022 04:40:27 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
( '58624' , '11192' , 'VENITE CON ME 2 PARTE' , '6' , '6' , '4' ,
'2.50' , '2.5' , '0' , '50' , '7.50' )
06/06/2022 04:40:27 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
( '58624' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '3' , '3' , '4' ,
'0.85' , '0.85' , '0' , '50' , '1.27' )
06/06/2022 04:40:27 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
( '58624' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '2' , '2' , '4' ,
'3.40' , '3.4' , '0' , '50' , '3.40' )
06/06/2022 04:40:27 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
( '58624' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '1' , '4' ,
'8.00' , '8' , '0' , '50' , '4.00' )
06/06/2022 04:40:27 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
( '58624' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '1' , '4' ,
'3.40' , '3.4' , '0' , '50' , '1.70' )
06/06/2022 04:40:27 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
( '58624' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '1' , '4' ,
'10.00' , '10' , '0' , '50' , '5.00' )
06/06/2022 04:40:27 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
( '58624' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '1' , '4' ,
'5.00' , '5' , '0' , '50' , '2.50' )
06/06/2022 04:40:27 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
( '58624' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '4' , '4' , '4' ,
'6.00' , '6' , '0' , '50' , '12.00' )
06/06/2022 04:40:27 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
( '58624' , '8408' , 'PRENDETE E MANGIATE' , '1' , '1' , '4' ,
'3.00' , '3' , '0' , '50' , '1.50' )
06/06/2022 04:40:27 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
( '58624' , '2680' , 'CONOSCERE GESU - GUIDA' , '2' , '2' , '4' ,
'6.00' , '6' , '0' , '50' , '6.00' )
06/06/2022 04:40:27 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
( '58624' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '2' , '4' ,
'5.00' , '5' , '0' , '50' , '5.00' )
06/06/2022 04:40:27 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
( '58624' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '4' , '4' , '4' ,
'1.60' , '1.6' , '0' , '50' , '3.20' )
06/06/2022 04:40:27 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
( '58624' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '11' , '11' , '4' ,
'1.60' , '1.6' , '0' , '50' , '8.80' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '1' , '4' ,
'3.50' , '3.5' , '0' , '50' , '1.75' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '12819' , 'REGISTRO DEL CATECHISTA ' , '4' , '4' , '1' ,
'1.00' , '0.81967213114754' , '22' , '50' , '2.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '2' , '4' ,
'3.50' , '3.5' , '0' , '50' , '3.50' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '2' , '2' , '4' ,
'3.50' , '3.5' , '0' , '50' , '3.50' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '1' , '4' ,
'1.00' , '1' , '0' , '50' , '0.50' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '27' , '27' , '4' ,
'1.00' , '1' , '0' , '50' , '13.50' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '9' , '9' , '4' ,
'2.00' , '2' , '0' , '50' , '9.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '16667' , 'VIA CRUCIS' , '12' , '12' , '4' ,
'3.00' , '3' , '0' , '50' , '18.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '1' , '4' ,
'20.00' , '20' , '0' , '50' , '10.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18036' , 'FERITE FERITOIE ' , '2' , '2' , '4' ,
'8.00' , '8' , '0' , '50' , '8.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '1' , '4' ,
'12.00' , '12' , '0' , '50' , '6.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '6' , '6' , '4' ,
'4.80' , '4.8' , '0' , '50' , '14.40' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '18' , '18' , '4' ,
'2.00' , '2' , '0' , '50' , '18.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '2' , '2' , '4' ,
'15.00' , '15' , '0' , '50' , '15.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '2' , '2' , '4' ,
'2.50' , '2.5' , '0' , '50' , '2.50' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18528' , 'CON GESU VERSO IL CALVARIO - P. G. VALSECCHI' , '27' , '27' , '4' ,
'1.50' , '1.5' , '0' , '50' , '20.25' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '1' , '4' ,
'16.00' , '16' , '0' , '50' , '8.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '2' , '2' , '4' ,
'16.00' , '16' , '0' , '50' , '16.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '2' , '2' , '4' ,
'16.00' , '16' , '0' , '50' , '16.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '17' , '17' , '4' ,
'2.00' , '2' , '0' , '50' , '17.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '4' , '4' , '4' ,
'20.00' , '20' , '0' , '50' , '40.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '1' , '1' , '4' ,
'15.00' , '15' , '0' , '50' , '7.50' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18657' , 'HO DATO LORO LA TUA PAROLA - P. VALSECCHI' , '3' , '3' , '4' ,
'16.00' , '16' , '0' , '50' , '24.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '2' , '2' , '4' ,
'4.80' , '4.8' , '0' , '50' , '4.80' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '4' , '4' , '4' ,
'2.00' , '2' , '0' , '50' , '4.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '12' , '12' , '4' ,
'9.00' , '9' , '0' , '50' , '54.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '11' , '11' , '4' ,
'9.00' , '9' , '0' , '50' , '49.50' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '3' , '3' , '4' ,
'9.00' , '9' , '0' , '50' , '13.50' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '1' , '4' ,
'10.00' , '10' , '0' , '50' , '5.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '20' , '20' , '4' ,
'10.00' , '10' , '0' , '50' , '100.00' )
06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58624' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '23' , '23' , '4' ,
'2.00' , '2' , '0' , '50' , '23.00' )
06/06/2022 04:56:38 pm >> SELECT document_num FROM ps_document
WHERE document_num = '10/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 04:56:38 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 (
'22' ,
'10/S' ,
'2022-06-06' ,
'S' ,
'6541' ,
'0' ,
'9339920' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'VENDUTO MAGGIO 2022' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'14' ,
'0' ,
'2156.75' ,
'2156.75' ,
NOW() ,
NOW() )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5367'
06/06/2022 04:56:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '5367'
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '17' , 'LA FEDE NELLO ZAINETTO' , '40' , '0' , '4' ,
'5.00' , '5' , '0' , '50' , '100.00' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '391' , '0' , '4' ,
'1.50' , '1.5' , '0' , '50' , '293.25' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '182' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '227.50' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '96' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '120.00' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '6' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '7.50' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '238' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '297.50' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '125' , 'MIE PREGHIERINE - N. E.' , '292' , '0' , '4' ,
'1.50' , '1.5' , '0' , '50' , '219.00' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '33' , '100 GIORNI CON LO SPIRITO' , '90' , '0' , '4' ,
'7.00' , '7' , '0' , '50' , '315.00' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '2' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '2.50' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '36' , 'IL CANTICO DEI CANTICI' , '2' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '2.50' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU\'' , '8' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '12.00' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '50' , 'PERDONAMI SIGNORE' , '6' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '6.00' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '52' , 'Il Padre Nostro spiegato ai bambini' , '1' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '1.00' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '55' , '0' , '4' ,
'1.50' , '1.5' , '0' , '50' , '41.25' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '56' , 'MARIA LA MAMMA DI GESU' , '1' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '1.25' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '13' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '13.00' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '1' , '0' , '4' ,
'30.00' , '30' , '0' , '50' , '15.00' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '66' , 'BEATI GLI INVITATI ALLA CENA DEL SIGNORE' , '2' , '0' , '4' ,
'6.50' , '6.5' , '0' , '50' , '6.50' )
06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '4' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '4.00' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '72' , 'FEDE, SPERANZA E CARITA\'' , '3' , '0' , '4' ,
'6.00' , '6' , '0' , '50' , '9.00' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '75' , 'IL SEGNO DELLA CROCE' , '5' , '0' , '4' ,
'1.50' , '1.5' , '0' , '50' , '3.75' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '88' , 'GESÙ È RISORTO' , '1' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '1.00' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '92' , 'LA PREGHIERA DEL ROSARIO' , '10' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '12.50' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '131' , 'LIBRO AGENDA CATTOLICO 2022' , '15' , '0' , '4' ,
'16.00' , '16' , '0' , '50' , '120.00' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '94' , 'IL BATTESIMO' , '15' , '0' , '4' ,
'1.50' , '1.5' , '0' , '50' , '11.25' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '1' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '1.00' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '35' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '43.75' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '110' , 'SE MI AMI NON PIANGERE' , '8' , '0' , '4' ,
'1.50' , '1.5' , '0' , '50' , '6.00' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '5' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '7.50' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '25' , '0' , '4' ,
'4.00' , '4' , '0' , '50' , '50.00' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '117' , 'La prehiera delle cinque dita n.e.' , '55' , '0' , '4' ,
'1.50' , '1.5' , '0' , '50' , '41.25' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '14' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '17.50' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '40' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '50.00' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '7' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '10.50' )
06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '5367' , '126' , 'SACRAMENTO DEL PERDONO' , '87' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '87.00' )
06/06/2022 05:00:23 pm >> SELECT document_num FROM ps_document
WHERE document_num = '11/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 05:00:23 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 (
'25' ,
'11/S' ,
'2022-06-06' ,
'S' ,
'6541' ,
'0' ,
'9339920' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'RESA MAGGIO 2022' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'326.50' ,
'326.50' ,
NOW() ,
NOW() )
06/06/2022 05:00:23 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 = '5368'
06/06/2022 05:00:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '5368'
06/06/2022 05:00:23 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
( '5368' , '33' , '100 GIORNI CON LO SPIRITO' , '1' , '1' , '4' ,
'7.00' , '7' , '0' , '50' , '3.50' )
06/06/2022 05:00:23 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
( '5368' , '47' , 'IL ROSARIO SPIEGATO AI BAMBINI ' , '11' , '11' , '4' ,
'2.50' , '2.5' , '0' , '50' , '13.75' )
06/06/2022 05:00:23 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
( '5368' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '30' , '30' , '4' ,
'2.00' , '2' , '0' , '50' , '30.00' )
06/06/2022 05:00:23 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
( '5368' , '60' , 'IL NATALE SPIEGATO AI BAMBINI' , '1' , '1' , '4' ,
'2.00' , '2' , '0' , '50' , '1.00' )
06/06/2022 05:00:23 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
( '5368' , '62' , 'GIOVANNI XXIII° SANTO .....IL PAPA BUONO' , '1' , '1' , '4' ,
'2.50' , '2.5' , '0' , '50' , '1.25' )
06/06/2022 05:00:23 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
( '5368' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '5' , '5' , '4' ,
'2.00' , '2' , '0' , '50' , '5.00' )
06/06/2022 05:00:23 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
( '5368' , '72' , 'FEDE, SPERANZA E CARITA' , '1' , '1' , '4' ,
'6.00' , '6' , '0' , '50' , '3.00' )
06/06/2022 05:00:23 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
( '5368' , '90' , 'ATTO DI AFFIDAMENTO A MARIA' , '1' , '1' , '4' ,
'1.50' , '1.5' , '0' , '50' , '0.75' )
06/06/2022 05:00:23 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
( '5368' , '131' , 'LIBRO AGENDA CATTOLICO 2022' , '18' , '18' , '4' ,
'16.00' , '16' , '0' , '50' , '144.00' )
06/06/2022 05:00:23 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
( '5368' , '119' , 'Rosario spiegato ai bambini ' , '1' , '1' , '4' ,
'2.50' , '2.5' , '0' , '50' , '1.25' )
06/06/2022 05:00:23 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
( '5368' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '82' , '82' , '4' ,
'3.00' , '3' , '0' , '50' , '123.00' )
06/06/2022 05:04:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571030' AND id_product != '131' AND ean13 != ''
06/06/2022 05:04:00 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788899571030',
date_upd = NOW()
WHERE id_product = '131'
06/06/2022 05:04:00 pm >> UPDATE ps_product_lang SET
name = 'LIBRO AGENDA CATTOLICO 2022',
description = 'Questa agenda risponde alle esigenze ecumeniche della società di oggi.
Nell’agenda potete trovare:
• le pagine riservate ai dati personali;
• i calendari del 2021 e 2022;
• il calendario annuale per appuntamenti;
• le solennità e le feste del rito romano e ambrosiano;
• la tabella delle principali celebrazioni dell’anno liturgico;
• le abbreviazioni dei libri biblici.
In più tante altre notizie per l\'anno liturgico.
'
WHERE id_product = '131'
06/06/2022 05:04:00 pm >> UPDATE ps_product SET
wholesale_price = '3.80',
on_sale = '0',
price = '16.00'
WHERE id_product = '131'
06/06/2022 05:04:00 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.80',
price = '16.00',
id_tax_rules_group = '4',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '448',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '131'
06/06/2022 05:04:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '131'
06/06/2022 05:04:00 pm >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '131' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
06/06/2022 05:05:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571573' AND id_product != '133' AND ean13 != ''
06/06/2022 05:05:25 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788899571573',
date_upd = NOW()
WHERE id_product = '133'
06/06/2022 05:05:25 pm >> UPDATE ps_product_lang SET
name = 'LIBRO AGENDA CATTOLICO 2023',
description = 'Questa agenda risponde alle esigenze ecumeniche della società di oggi.
Nell’agenda potete trovare:
• le pagine riservate ai dati personali;
• i calendari del 2022 e 2023;
• il calendario annuale per appuntamenti;
• le solennità e le feste del rito romano e ambrosiano;
• la tabella delle principali celebrazioni dell’anno liturgico;
• le abbreviazioni dei libri biblici.
In più tante altre notizie per l\'anno liturgico.
'
WHERE id_product = '133'
06/06/2022 05:05:25 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '18'
WHERE id_product = '133'
06/06/2022 05:05:26 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '18',
id_tax_rules_group = '4',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '448',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '133'
06/06/2022 05:05:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '133'
06/06/2022 05:05:47 pm >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '131'
06/06/2022 05:05:48 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '133'
06/06/2022 05:21:30 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1801' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 05:21: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' ,
'1801' ,
'2022-06-06' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'12.00' ,
'12.00' ,
NOW() ,
NOW() )
06/06/2022 05:21: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 = '58625'
06/06/2022 05:21:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '58625'
06/06/2022 05:21: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
( '58625' , '19506' , 'MESSA MEDITAZIONE - GIU 2022' , '1' , '-1' , '4' ,
'4.00' , '4' , '0' , '0' , '4.00' )
06/06/2022 05:21:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19506' AND id_supplier = ''
06/06/2022 05:21:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19506' , '' , '1' )
06/06/2022 05:21: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
( '58625' , '19507' , 'MESSA MEDITAZIONE - LUG/AGO 2022' , '1' , '-1' , '4' ,
'8.00' , '8' , '0' , '0' , '8.00' )
06/06/2022 05:21:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19507' AND id_supplier = ''
06/06/2022 05:21:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19507' , '' , '1' )
06/06/2022 05:42:12 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1802' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 05:42:12 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1802' ,
'2022-06-06' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'31.80' ,
'26.07' ,
NOW() ,
NOW() )
06/06/2022 05:42:12 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58626'
06/06/2022 05:42:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '58626'
06/06/2022 05:42:12 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58626' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '1' , '-1' , '1' ,
'3.30' , '2.7049180327869' , '22' , '0' , '3.30' )
06/06/2022 05:42:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15403' AND id_supplier = ''
06/06/2022 05:42:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15403' , '' , '1' )
06/06/2022 05:42:12 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58626' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'19.5' , '15.983606557377' , '22' , '0' , '19.50' )
06/06/2022 05:42:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = ''
06/06/2022 05:42:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )
06/06/2022 05:42:12 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58626' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '1' , '-1' , '1' ,
'1.00' , '0.81967213114754' , '22' , '0' , '1.00' )
06/06/2022 05:42:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18213' AND id_supplier = ''
06/06/2022 05:42:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18213' , '' , '1' )
06/06/2022 05:42:12 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58626' , '6075' , 'LOURDES BABY - 023 LDS/9 BB' , '1' , '-1' , '1' ,
'8.00' , '6.5573770491803' , '22' , '0' , '8.00' )
06/06/2022 05:42:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6075' AND id_supplier = ''
06/06/2022 05:42:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6075' , '' , '1' )
06/06/2022 05:54:11 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1803' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 05:54:11 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1803' ,
'2022-06-06' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'14.70' ,
'14.10' ,
NOW() ,
NOW() )
06/06/2022 05:54:11 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58627'
06/06/2022 05:54:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '58627'
06/06/2022 05:54:11 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58627' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' ,
'12.00' , '12' , '0' , '5' , '11.40' )
06/06/2022 05:54:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18920' AND id_supplier = ''
06/06/2022 05:54:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18920' , '' , '1' )
06/06/2022 05:54:11 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58627' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'2.5' , '2.0491803278689' , '22' , '0' , '2.50' )
06/06/2022 05:54:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = ''
06/06/2022 05:54:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )
06/06/2022 05:54:11 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58627' , '18353' , 'PORTA ROSARIO IN VELLUTO PICCOLO - 313-NT 4' , '1' , '-1' , '1' ,
'0.80' , '0.65573770491803' , '22' , '0' , '0.80' )
06/06/2022 05:54:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18353' AND id_supplier = ''
06/06/2022 05:54:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18353' , '' , '1' )
06/06/2022 05:57:25 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1751' AND id_document != '58565' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03')
06/06/2022 05:57:25 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1751',
document_date = '2022-06-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 = '22.55',
price_tax_excluded = '20.91',
date_upd = NOW()
WHERE id_document = '58565'
06/06/2022 05:57:25 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58565'
06/06/2022 05:57:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '58565'
06/06/2022 05:57:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58565' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' ,
'1.9000' , '1.8269230769231' , '4' , '0' , '7.60' )
06/06/2022 05:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = ''
06/06/2022 05:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' )
06/06/2022 05:57:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58565' , '5312' , 'INNO ALLO SPIRITO SANTO' , '3' , '-3' , '4' ,
'0.1500' , '0.15' , '0' , '0' , '0.45' )
06/06/2022 05:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5312' AND id_supplier = ''
06/06/2022 05:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5312' , '' , '1' )
06/06/2022 05:57:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58565' , '9664' , 'SAPIENZA - 117' , '50' , '-50' , '1' ,
'0.1500' , '0.12295081967213' , '22' , '0' , '7.50' )
06/06/2022 05:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9664' AND id_supplier = ''
06/06/2022 05:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9664' , '' , '1' )
06/06/2022 05:57:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58565' , '19507' , 'MESSA MEDITAZIONE - LUG/AGO 2022' , '1' , '-1' , '4' ,
'7' , '7' , '0' , '0' , '7.00' )
06/06/2022 05:57:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19507' AND id_supplier = ''
06/06/2022 05:57:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19507' , '' , '1' )
06/06/2022 05:58:06 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1727' AND id_document != '58533' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31')
06/06/2022 05:58:06 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1727',
document_date = '2022-05-31',
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 = '19.87',
price_tax_excluded = '18.52',
date_upd = NOW()
WHERE id_document = '58533'
06/06/2022 05:58:06 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58533'
06/06/2022 05:58:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '58533'
06/06/2022 05:58:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58533' , '9664' , 'SAPIENZA - 117' , '50' , '-50' , '1' ,
'0.1500' , '0.12295081967213' , '22' , '0' , '7.50' )
06/06/2022 05:58:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9664' AND id_supplier = ''
06/06/2022 05:58:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9664' , '' , '1' )
06/06/2022 05:58:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58533' , '12712' , 'CRESIMA UNA FESTA DA VIVERE' , '2' , '-2' , '4' ,
'1.9000' , '1.9' , '0' , '5' , '3.62' )
06/06/2022 05:58:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12712' AND id_supplier = ''
06/06/2022 05:58:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12712' , '' , '1' )
06/06/2022 05:58:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58533' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA' , '1' , '-1' , '4' ,
'2.0000' , '2' , '0' , '5+' , '1.90' )
06/06/2022 05:58:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2777' AND id_supplier = ''
06/06/2022 05:58:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2777' , '' , '1' )
06/06/2022 05:58:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58533' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' ,
'1.0000' , '1' , '0' , '0' , '1.00' )
06/06/2022 05:58:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = ''
06/06/2022 05:58:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '' , '1' )
06/06/2022 05:58:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58533' , '15125' , 'MESSA DI PRIMA COMUNIONE - 8338' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '5' , '2.85' )
06/06/2022 05:58:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15125' AND id_supplier = ''
06/06/2022 05:58:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15125' , '' , '1' )
06/06/2022 05:58:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58533' , '19506' , 'MESSA MEDITAZIONE - GIU 2022' , '1' , '-1' , '4' ,
'3' , '3' , '0' , '0' , '3.00' )
06/06/2022 05:58:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19506' AND id_supplier = ''
06/06/2022 05:58:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19506' , '' , '1' )
06/06/2022 06:27:10 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1804' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 06:27:10 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' ,
'1804' ,
'2022-06-06' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'1.60' ,
'1.60' ,
NOW() ,
NOW() )
06/06/2022 06:27:10 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 = '58628'
06/06/2022 06:27:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '58628'
06/06/2022 06:27:10 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
( '58628' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '1' , '-1' , '4' ,
'1.60' , '1.6' , '0' , '0' , '1.60' )
06/06/2022 06:27:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = ''
06/06/2022 06:27:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' )
06/06/2022 07:20:11 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1805' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 07:20:11 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'1805' ,
'2022-06-06' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'36.80' ,
'31.07' ,
NOW() ,
NOW() )
06/06/2022 07:20:11 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58629'
06/06/2022 07:20:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '58629'
06/06/2022 07:20:11 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58629' , '18129' , 'TAU COLORATO - T56' , '25' , '-25' , '1' ,
'1.20' , '0.98360655737705' , '22' , '0' , '30.00' )
06/06/2022 07:20:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18129' AND id_supplier = ''
06/06/2022 07:20:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18129' , '' , '1' )
06/06/2022 07:20:11 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58629' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'5' , '5' , '0' , '0' , '5.00' )
06/06/2022 07:20:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = ''
06/06/2022 07:20:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' )
06/06/2022 07:20:11 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58629' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' ,
'1.00' , '0.81967213114754' , '22' , '0' , '1.00' )
06/06/2022 07:20:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = ''
06/06/2022 07:20:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' )
06/06/2022 07:20:11 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58629' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' ,
'0.80' , '0.65573770491803' , '22' , '0' , '0.80' )
06/06/2022 07:20:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = ''
06/06/2022 07:20:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' )
06/06/2022 07:41:26 pm >> SELECT document_num FROM ps_document
WHERE document_num = '17' AND id_document != '58619' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-06-06')
06/06/2022 07:41:26 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '17',
document_date = '2022-06-06',
document_letter = '',
id_customer = '3000',
id_supplier = '',
id_address = '4669629',
address1 = 'VIA DEI CASTANI, 116 00172 ROMA',
address2 = '',
note = 'CARTA D\'IDENTITA\' ARRIVERA\' DIRETTAMENTE DA VELAR',
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 = '2274.00',
price_tax_excluded = '2274.00',
date_upd = NOW()
WHERE id_document = '58619'
06/06/2022 07:41:26 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58619'
06/06/2022 07:41:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '58619'
06/06/2022 07:41:26 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58619' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '320' , '-320' , '4' ,
'1.6000' , '1.6' , '0' , '0' , '512.00' )
06/06/2022 07:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = ''
06/06/2022 07:41:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' )
06/06/2022 07:41:26 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58619' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '320' , '-320' , '4' ,
'1.6000' , '1.6' , '0' , '0' , '512.00' )
06/06/2022 07:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12355' AND id_supplier = ''
06/06/2022 07:41:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12355' , '' , '1' )
06/06/2022 07:41:26 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58619' , '17861' , 'CARTA D\'IDENTITA\' DELLA CHIESA - R. LUPI' , '100' , '-100' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '250.00' )
06/06/2022 07:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17861' AND id_supplier = ''
06/06/2022 07:41:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17861' , '' , '1' )
06/06/2022 07:41:26 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '58619' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '50' , '-50' , '4' ,
'20.00' , '20' , '0' , '0' , '1000.00' )
06/06/2022 07:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19562' AND id_supplier = ''
06/06/2022 07:41:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19562' , '' , '1' )