doc/DB/增量脚本/insert_alert_20211109.sql

# 时间:20211109 是否已发版: 测试- 是  生产-否


#视图
CREATE  OR  REPLACE VIEW financeInf AS 
SELECT 
  zfi_id,
  zfi_number,
  zfi_supplier_id,
  zfi_core_id,
  zfi_amount,
  zfi_status,
  zfbr_bill_id 
FROM
  zc_finance_bill_rel 
  LEFT JOIN zc_finance_inf 
    ON zfbr_finance_id = zfi_id 
WHERE (
    zfi_status != '03' 
    AND zfi_status != '99'
  ) 
  OR ISNULL(zfi_status) ;