--UPDATE FROM 8.9.0.0 TO 8.9.0.1


DROP TABLE VERSION_8_9_0_0;



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

INSERT INTO ZFST (ZFST_ID, ZFST_LONGDESC, ZFST_WRPT_ID, ZFST_DEFAULT, ZFST_DISPLORDER, ZFST_INACTIVE, ZFST_ZINN_ID, ZFST_PURPOSE, ZFST_NDC) VALUES (SEQ_ZFST.NEXTVAL,'Paid Out',(SELECT WUSS_VALUE FROM WUSS WHERE WUSS_XCMS_ID=0 AND WUSS_NAME='paidoutreceipt'),0,(SELECT MAX(ZFST_DISPLORDER)+1 FROM ZFST),0,NULL,0,0); 

ALTER TABLE ZPOS ADD ZPOS_WPCA_ID NUMBER(30);

ALTER TABLE XCMM ADD XCMM_REPORT_GROUP NUMBER (1);

COMMENT ON COLUMN XCMM.XCMM_REPORT_GROUP IS 'Field is used to sum up categories in reports, possible values are 1, 2, 3 or 4';

ALTER TABLE WMAI ADD WMAI_ERROR VARCHAR2(2000);

COMMENT ON COLUMN WMAI.WMAI_ERROR IS 'Error while sending';
