IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CAS_TRANSFERAPPLYBILL' AND KSQL_COL_NAME IN ('FISCROSSPAY'))
ALTER TABLE T_CAS_TRANSFERAPPLYBILL ADD (FISCROSSPAY CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CAS_TRANSFERAPPLY_ENTRY' AND KSQL_COL_NAME IN ('FEACCOUNTACCTNAME'))
 ALTER TABLE T_CAS_TRANSFERAPPLY_ENTRY ADD (FEACCOUNTACCTNAME NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CAS_TRANSFERAPPLY_ENTRY' AND KSQL_COL_NAME ='FPAYEEBANKNAME')
ALTER TABLE T_CAS_TRANSFERAPPLY_ENTRY ADD (FPAYEEBANKNAME NVARCHAR(255) DEFAULT ' ' NOT NULL );