IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_CONTRACT_NEW' AND KSQL_COL_NAME ='FLEASETERMSTARTDATE')
 ALTER TABLE T_FA_LEASE_CONTRACT_NEW ADD (FLEASETERMSTARTDATE DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_CONTRACT_NEW' AND KSQL_COL_NAME ='FASSETSACCUMDEPRE')
 ALTER TABLE T_FA_LEASE_CONTRACT_NEW ADD (FASSETSACCUMDEPRE 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 ='FTRANSITIONPLAN')
 ALTER TABLE T_FA_LEASE_CONTRACT_NEW ADD (FTRANSITIONPLAN CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_PAY_PLAN' AND KSQL_COL_NAME ='FDISCOUNTDAYS2')
 ALTER TABLE T_FA_LEASE_PAY_PLAN ADD (FDISCOUNTDAYS2 INT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_PAY_PLAN' AND KSQL_COL_NAME ='FDISCOUNTFACTOR2')
 ALTER TABLE T_FA_LEASE_PAY_PLAN ADD (FDISCOUNTFACTOR2 DECIMAL(19,4) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_PAY_PLAN' AND KSQL_COL_NAME ='FPRESENTVALUE2')
 ALTER TABLE T_FA_LEASE_PAY_PLAN ADD (FPRESENTVALUE2 DECIMAL(19,4) DEFAULT 0 NOT NULL );