IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_DISPTBILLENTRY' AND KSQL_COL_NAME ='FDETAILCURRENCYLD') 
 ALTER TABLE T_FA_DISPTBILLENTRY ADD (FDETAILCURRENCYLD BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_DISPTBILLENTRY' AND KSQL_COL_NAME ='FINSTOREPLACEID') 
 ALTER TABLE T_FA_DISPTBILLENTRY ADD (FINSTOREPLACEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_DISPTBILLENTRY' AND KSQL_COL_NAME ='FINUSESTATUSID') 
 ALTER TABLE T_FA_DISPTBILLENTRY ADD (FINUSESTATUSID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_DISPTBILLENTRY' AND KSQL_COL_NAME ='FORIGINMETHODID') 
 ALTER TABLE T_FA_DISPTBILLENTRY ADD (FORIGINMETHODID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_DISPTBILLENTRY' AND KSQL_COL_NAME ='FEVALUATE') 
 ALTER TABLE T_FA_DISPTBILLENTRY ADD (FEVALUATE DECIMAL(19,6) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_DISPTBILL' AND KSQL_COL_NAME ='FDISPATCHTYPE') 
 ALTER TABLE T_FA_DISPTBILL ADD (FDISPATCHTYPE VARCHAR(50) DEFAULT 'A' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_DISPTBILL' AND KSQL_COL_NAME ='FCHANGEMODEID') 
 ALTER TABLE T_FA_DISPTBILL ADD (FCHANGEMODEID BIGINT DEFAULT 0 NOT NULL );