EXEC p_DropIdx 'IDX_CAS_PBE_FUnsettledAmount', 'T_CAS_PAYMENTBILLENTRY';
EXEC p_DropIdx 'IDX_RBE_FUnsettledAmount', 'T_CAS_RECEIVINGBILLENTRY';
EXEC p_DropIdx 'IDX_CAS_RECE_FActRecAmt', 'T_CAS_RECEIVINGBILL';
EXEC p_DropIdx 'IDX_PAYMENTBILL_E_FIsWaitSche', 'T_CAS_PAYMENTBILL_E';
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_PB_FSOURCEBILLID') CREATE INDEX IDX_CAS_PB_FSOURCEBILLID ON T_CAS_PAYMENTBILL ( FSOURCEBILLID );
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_PAYMENTBILL_E_FSCHEID') CREATE INDEX IDX_PAYMENTBILL_E_FSCHEID ON T_CAS_PAYMENTBILLENTRY ( FSCHEID );
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_BS_ACCOUNTBANKIDDATE') CREATE INDEX IDX_CAS_BS_ACCOUNTBANKIDDATE ON T_CAS_BANKSTATEMENT ( FACCOUNTBANKID ,FBIZDATE );
