EXEC P_ALTERPK 'PK_T_IFM_DEDUCTION_E', 'T_IFM_DEDUCTION_E', 'FID', '1';

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IFM_DEDUCTION_E_CURR') CREATE INDEX IDX_IFM_DEDUCTION_E_CURR ON T_IFM_DEDUCTION_E ( FBASECURRENCYID );


EXEC P_ALTERPK 'PK_T_IFM_RECTRANSBILL_E', 'T_IFM_RECTRANSBILL_E', 'FID', '1';

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IFM_RECTRANSBILL_E_CURR') CREATE INDEX IDX_IFM_RECTRANSBILL_E_CURR ON T_IFM_RECTRANSBILL_E ( FBASECURRENCYID );

