--UPDATE FROM 8.13.7.0 TO 8.13.8.0


 	
DROP TABLE VERSION_8_13_7_0;


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


ALTER TABLE W8HP ADD W8HP_WLAN_ID NUMBER(30);
comment on column w8hp.w8hp_wlan_id is 'Default Language';

ALTER TABLE W8HP ADD W8HP_XCOU_ID NUMBER(30);
comment on column w8hp.w8hp_xcou_id is 'Default Country';

ALTER TABLE ZTXC ADD ZTXC_EINVOICE_VATCODE VARCHAR2(10 byte);
COMMENT ON COLUMN ZTXC.ZTXC_EINVOICE_VATCODE is 'einvoice vatcode for italy Electronic Invoice';

alter table w8hp add w8hp_bonus_zdco_id number;
comment on column w8hp.w8hp_bonus_zdco_id is 'Department code for bonus point redemption'; 

alter table w8hp add w8hp_bonus_payment_type number(1) DEFAULT -1;
comment on column w8hp.w8hp_bonus_payment_type is '0 : Full payment and 1: Partial payment';  

alter table w8hp add w8hp_enablebonusredemption number(1);
comment on column w8hp.w8hp_enablebonusredemption is '1:Enables bonus redemption for web connect and 0: Disables bonus redemption for web connect'; 
