IF EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_RECE_FITEMPAYERTYPEID') DROP INDEX T_CAS_RECEIVINGBILL_E.IDX_CAS_RECE_FITEMPAYERTYPEID;

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_RECE_FITEMPAYERID') CREATE INDEX IDX_CAS_RECE_FITEMPAYERID ON T_CAS_RECEIVINGBILL_E ( FITEMPAYERID );

