--UPDATE FROM 8.7.4.12 TO 8.7.4.13


DROP TABLE VERSION_8_7_4_12;



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

ALTER TABLE ZLOG ADD (ZLOG_AMOUNT NUMBER(30,4), ZLOG_ZDCO_ID NUMBER(30), ZLOG_ZCAS_ID NUMBER(30));

COMMENT ON COLUMN ZLOG.ZLOG_AMOUNT IS 'posting amount, used on posting deletion';

COMMENT ON COLUMN ZLOG.ZLOG_ZDCO_ID IS 'posting dept code, used on posting deletion';

COMMENT ON COLUMN ZLOG.ZLOG_ZCAS_ID IS 'cashier id';
