/*借款单借款分录添加立项号、单头添加关联业务字段*/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYLOANDETAIL' AND KSQL_COL_NAME ='FAPPLYPROJECTNO') 
 ALTER TABLE T_ER_DAILYLOANDETAIL ADD (FAPPLYPROJECTNO VARCHAR(80) DEFAULT ' ' NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYLOANBILL' AND KSQL_COL_NAME ='FRELATEDBIZ') 
 ALTER TABLE T_ER_DAILYLOANBILL ADD (FRELATEDBIZ VARCHAR(50) DEFAULT 'relatedtype_other' NOT NULL );