SAP business one查询报表-应收发票

SELECT '应收发票'  as 单据类型,T0.[U_SS_InvoNo] ,t0.docnum,T0.[docentry], T0.[DocType],  T0.[DocStatus], T0.[DocDate], T0.[DocDueDate], T0.[CardCode], T0.[U_SO001], T0.[NumAtCard] 合约号
,T0.[CardName], T0.[DocTotal]-T0.[VatSumSy] as 不含税,T0.[VatSumSy] ,T0.[DocTotal] ,t0.U_kpno_1,t0.U_KPDATE_1,t0.U_kpamounts_1,t0.U_kpno_2,t0.U_KPDATE_2,t0.U_kpamounts_2,t0.U_kpno_3,t0.U_KPDATE_3,t0.U_kpamounts_3,t0.U_kpno_4,t0.U_KPDATE_4,t0.U_kpamounts_4,(T0.[DocTotal]-isnull(t0.U_kpamounts_1,0)-isnull(t0.U_kpamounts_2,0)-isnull(t0.U_kpamounts_3,0)-isnull(t0.U_kpamounts_4,0)) as 未开票金额, CASE A.[BaseType] WHEN '13' THEN '贷项' when '16' then '贷项' end 上下标识类型 , A.DocNum 上下标识单号
 FROM OINV T0  left join(SELECT T0.[DocNum] ,T1.[BaseRef] , T1.[BaseType] FROM ORIN T0  INNER JOIN RIN1 T1 ON T0.[DocEntry] = T1.[DocEntry] where T1.[BaseType] in ('13','16') group by T0.[DocNum] ,T1.[BaseRef] , T1.[BaseType])A on A.BaseRef=t0.docnum

 WHERE T0.[CANCELED]='N'  and  isnull(T0.[NumAtCard],0) not like '%作废%'  and (T0.[DocDate]>=[%0] and T0.[DocDate]<=[%1])
union all
SELECT '应收贷项'  as 单据类型,T0.[U_SS_InvoNo] ,t0.docnum,T0.[docentry], T0.[DocType],T0.[DocStatus], T0.[DocDate], T0.[DocDueDate], T0.[CardCode], T0.[U_SO001], T0.[NumAtCard] 合约号
,T0.[CardName], -(T0.[DocTotal]-T0.[VatSumSy]) as 不含税,-T0.[VatSumSy],-T0.[DocTotal] ,t0.U_kpno_1,t0.U_KPDATE_1,t0.U_kpamounts_1,t0.U_kpno_2,t0.U_KPDATE_2,t0.U_kpamounts_2,t0.U_kpno_3,t0.U_KPDATE_3,t0.U_kpamounts_3,t0.U_kpno_4,t0.U_KPDATE_4,t0.U_kpamounts_4,(T0.[DocTotal]-isnull(t0.U_kpamounts_1,0)-isnull(t0.U_kpamounts_2,0)-isnull(t0.U_kpamounts_3,0)-isnull(t0.U_kpamounts_4,0)) as 未开票金额,  CASE A.[BaseType] WHEN '13' THEN '发票' when '16' then '退货' end 上下标识类型  ,A.BaseRef  上下标识单号
 FROM ORIN T0 left join (SELECT T0.[DocNum] ,T1.[BaseRef] , T1.[BaseType] FROM ORIN T0  INNER JOIN RIN1 T1 ON T0.[DocEntry] = T1.[DocEntry] where T1.[BaseType] in ('13','16') group by T0.[DocNum] ,T1.[BaseRef] , T1.[BaseType])A on A.docnum=t0.docnum

 WHERE  T0.[CANCELED]='N'  and  isnull(T0.[NumAtCard],0)  not like '%作废%' and (T0.[DocDate]>=[%0] and T0.[DocDate]<=[%1])

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值