/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\CAS_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_RECE_BILLNO') CREATE INDEX IDX_CAS_RECE_BILLNO ON T_CAS_RECEIVINGBILL ( FBILLNO );

EXEC p_DropIdx 'IDX_CAS_AgentPayBill_E', 'T_CAS_AGENTPAYBILL_E';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_AGENTPAYBILL_RB') CREATE INDEX IDX_AGENTPAYBILL_RB ON T_CAS_AGENTPAYBILL_E ( FEXRATETABLEID );


/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\CAS_constraint.sql **/
