记一次数据库视图建立
问题说明
项目上客户要求费用申请单上,想看到关联的报销单已支付的金额【这个已支付要结算后才算】
由于系统自带公式无法实现,所以通过数据库视图解决
解决步骤
建立视图1
create or replace view vmer_paymentAmount as SELECT s.PK_MTAPP_BILL as pk,sum(b.zfybje) as sum FROM er_mtapp_bill s,er_bxzb b WHERE b.pk_item = s.pk_mtapp_bill and b.payflag = 3 GROUP BY S.PK_MTAPP_BILL
去单据模版写显示公式:
setthmark( zeroifnull(getcolvalue("vmer_paymentAmount" ,"sum" , "pk", pk_mtapp_bill)))