详见附件,以下是SQL SELECT 应付单号,SUM(贷方原币金额),sum(借方原币金额),应付单据标识 from( SELECT PK_BUSIDATA as 主键,PK_BILL as 应付单据标识, pk_item AS 应付单行标识 ,PK_CORBILL as 付款单标识,PK_CORITEM as 付款单行标识,BILLNO AS 应付单号,BILLCLASS AS 单据大类,CORBILLCLASS AS 对应单据大类,DEF8 AS 摘要, local_money_cr AS 贷方本币金额,money_cr AS 贷方原币金额,pk_busidata AS 业务处理明细标识, pk_org AS 财务组织, pk_currtype AS 币种, pk_tradetypeid AS 交易类型ID , prepay AS 预收付标识 , tallydate AS 记账日期 , verifyfinishdate AS 核销完成日期 , pk_dealnum AS 业务处理批次号 FROM arap_tally h --从下面添加付款单信息 WHERE nvl( busitype, 0 ) <> 411 and MONEY_CR>0 and billno='应付_20220221023895') a left join (SELECT SUM(借方原币金额) AS 借方原币金额,对应单据标识 from( SELECT PK_CORBILL as 对应单据标识 ,BILLNO AS 付款单号,DEF8 AS 摘要,MONEY_DE AS 借方原币金额 FROM arap_tally WHERE nvl( busitype, 0 ) <> 411 and MONEY_DE<0 and billno='付款_20220307024806') group by 对应单据标识 ) b on a.应付单据标识=b.对应单据标识 group by 应付单号,应付单据标识--抽取应付单中贷方原币金额大于0的记录即应付单信息 --从这里开始通过应付单据标识抽取付款信息 |
最佳回答 |
||||
0
|
|