/** 添加发票信息表 发票号码、发票代码索引 **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_ER_INVOICEINFO' AND KSQL_INDNAME = 'IDX_ER_INVOICE_INVQ')
 CREATE INDEX IDX_ER_INVOICE_INVQ ON T_ER_INVOICEINFO (FINVOICENO ,FINVOICECODE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_ER_INVOICEINFOCP' AND KSQL_INDNAME = 'IDX_ER_INVOICECP_INVQ')
 CREATE INDEX IDX_ER_INVOICECP_INVQ ON T_ER_INVOICEINFOCP (FINVOICENO ,FINVOICECODE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_ER_PUBREIMINVOICEINFO' AND KSQL_INDNAME = 'IDX_ER_INVOICE_PUB_INVQ')
 CREATE INDEX IDX_ER_INVOICE_PUB_INVQ ON T_ER_PUBREIMINVOICEINFO (FINVOICENO ,FINVOICECODE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_ER_NINVOICEINFO' AND KSQL_INDNAME = 'IDX_ER_NINVOICEINFO_INVQ')
 CREATE INDEX IDX_ER_NINVOICEINFO_INVQ ON T_ER_NINVOICEINFO (FINVOICENO, FINVOICECODE);

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_ER_INVOICEPOOLINFO' AND KSQL_INDNAME = 'IDX_ER_INVOICEPOOL_INVQ')
 CREATE INDEX IDX_ER_INVOICEPOOL_INVQ ON T_ER_INVOICEPOOLINFO (FINVOICENO ,FINVOICECODE );

  IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_ER_BILLINGPOOL' AND KSQL_INDNAME = 'IDX_ER_BILLINGPOOL_FSERIALNO')
  CREATE INDEX IDX_ER_BILLINGPOOL_FSERIALNO ON T_ER_BILLINGPOOL (FSERIALNO );

