IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_PURRECBILL' AND KSQL_COL_NAME ='FQUOTATION')
ALTER TABLE T_IM_PURRECBILL ADD (FQUOTATION VARCHAR(50) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_PURINBILL' AND KSQL_COL_NAME ='FQUOTATION')
ALTER TABLE T_IM_PURINBILL ADD (FQUOTATION VARCHAR(50) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_SALOUTBILL' AND KSQL_COL_NAME ='FQUOTATION')
ALTER TABLE T_IM_SALOUTBILL ADD (FQUOTATION VARCHAR(50) DEFAULT '0' NOT NULL );