/**Begin D:\PDM_UPGRADE\PDM1\BEI_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BEI_ELECSTATEMENT_ENTRY') CREATE INDEX IDX_BEI_ELECSTATEMENT_ENTRY ON T_BEI_ELECSTATEMENT_ENTRY ( FID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BEI_ELECSTATEMENT_L') CREATE INDEX IDX_BEI_ELECSTATEMENT_L ON T_BEI_ELECSTATEMENT_L ( FID ,FLOCALEID );

EXEC p_DropIdx 'IDX_PK_T_BEI_BANKLOGENTRY_FID', 'T_BEI_BANKLOGENTRY';
EXEC p_DropIdx 'IDX_PK_T_BEI_BANKLOGENTRY_BIDBLT', 'T_BEI_BANKLOGENTRY';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_BEI_BANKLOGENTRY_FID') CREATE INDEX IDX_T_BEI_BANKLOGENTRY_FID ON T_BEI_BANKLOGENTRY ( FID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_BEI_BANKLOGENTRY_BIDBLT') CREATE INDEX IDX_T_BEI_BANKLOGENTRY_BIDBLT ON T_BEI_BANKLOGENTRY ( FBILLID ,FBANKLOGTYPE );

EXEC p_DropIdx 'IDX_BEI_FCOMPANYID', 'T_BEI_TRANSDETAIL';

/**End D:\PDM_UPGRADE\PDM1\BEI_constraint.sql **/
