IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PUR_BIDBILLENTRY' AND KSQL_COL_NAME IN ('fisupdateasinfo')) 
 update T_PUR_BIDBILLENTRY set fisupdateasinfo='0' where fisupdateasinfo = ' ';
 
 IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PUR_COMPARENTRY' AND KSQL_COL_NAME IN ('fisupdateasinfo')) 
 update T_PUR_COMPARENTRY set fisupdateasinfo='0' where fisupdateasinfo = ' ';