IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_OFFSETRULE' AND KSQL_COL_NAME ='FMETRICQTYID') 
 ALTER TABLE T_EB_OFFSETRULE ADD (FMETRICQTYID BIGINT DEFAULT 0 NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_OFFSETENTRY' AND KSQL_COL_NAME ='FMETRICQTYID') 
ALTER TABLE T_EB_OFFSETENTRY ADD (FMETRICQTYID BIGINT DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_OFFSETENTRYDETAIL' AND KSQL_COL_NAME ='FAMOUNTQTY') 
ALTER TABLE T_EB_OFFSETENTRYDETAIL ADD (FAMOUNTQTY DECIMAL(23,10) DEFAULT 0 NOT NULL );