IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_CONTRACT_NEW' AND KSQL_COL_NAME IN ('FSOURCETYPE'))
 ALTER TABLE T_FA_LEASE_CONTRACT_NEW ADD (FSOURCETYPE CHAR(1) DEFAULT 'A' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_CONTRACT_NEW' AND KSQL_COL_NAME IN ('FASSETSADDUPYEARDEPRE'))
 ALTER TABLE T_FA_LEASE_CONTRACT_NEW ADD (FASSETSADDUPYEARDEPRE DECIMAL(19,4) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_CONTRACT_NEW' AND KSQL_COL_NAME IN ('FISINITDATA'))
 ALTER TABLE T_FA_LEASE_CONTRACT_NEW ADD (FISINITDATA CHAR(1) DEFAULT '1' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_CONTRACT_NEW' AND KSQL_COL_NAME IN ('FHASDEPREMONTHS'))
 ALTER TABLE T_FA_LEASE_CONTRACT_NEW ADD (FHASDEPREMONTHS INT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_CONTRACT_NEW' AND KSQL_COL_NAME IN ('FSYSSWITCHDATE'))
 ALTER TABLE T_FA_LEASE_CONTRACT_NEW ADD (FSYSSWITCHDATE DATETIME );