--UPDATE FROM 8.10.2.40.1 TO 8.10.2.50


 	
DROP TABLE VERSION_8_10_2_40_1;


/*  VERSION_8_10_2_50  */
CREATE TABLE VERSION_8_10_2_50 (
	 DUMMY	NUMBER	    NULL
)
;

delete from xpdt where exists (select 1 from xcms where xcms_id=xpdt_xcms_id and xcms_active=5);
delete from xpdt where exists (select 1 from xcms where xcms_id=xpdt_other_xcms_id and xcms_active=5);

alter table zfcf add zfcf_original_zinv_id number(30);

comment on column zfcf.zfcf_original_zinv_id is 'Stores original ricevuta zinv_id while issuing credit notes (applicable only for Italian fiscal opertion)';

UPDATE WUSS SET WUSS_VALUE='De-identified' WHERE WUSS_NAME='GuestAnonymizationText';
