-- 租金结算、计息明细分录都加上来源类型字段
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_RENT_SETTLE' AND KSQL_COL_NAME IN ('FSOURCETYPE'))
ALTER TABLE T_FA_LEASE_RENT_SETTLE ADD (FSOURCETYPE CHAR(1) DEFAULT 'A' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_INTEREST_DETAIL_E' AND KSQL_COL_NAME IN ('FSOURCETYPE'))
ALTER TABLE T_FA_INTEREST_DETAIL_E ADD (FSOURCETYPE CHAR(1) DEFAULT 'A' NOT NULL );