K3 WISE销售出库单增加不含税单价金额以及税率

最新推荐文章于 2020-12-25 08:21:22 发布

Najd

最新推荐文章于 2020-12-25 08:21:22 发布

阅读量1.3k

点赞数

分类专栏： K3 WISE

本文链接：https://blog.csdn.net/Atonei/article/details/105703434

版权

--------查询销售出库单-------------
select * from ICStockBill where FTranType=21
--------普通发票视图创建-----------
alter view ptfp
as
select a.finterid,a.FItemID,sum(a.FQty) as sl,sum(a.FAmountincludetax) as bhsje,SUM(a.FTaxAmount) as se,A.FTaxRate,a.FSourceBillNo,a.FSourceEntryID,a.FSourceInterId
from ICSaleentry a inner join ICSale b on a.FInterID=b.FInterID where b.FTranType=86
group by a.finterid,a.FItemID,a.FSourceBillNo,a.FSourceEntryID,a.FSourceInterId,A.FTaxRate
--------专业发票视图创建-----------
alter view zyfp
as
select a.finterid,a.FItemID,sum(a.FQty) as sl,sum(a.FStdAmount) as bhsje,SUM(a.FStdTaxAmount) as se,A.FTaxRate,a.FSourceBillNo,a.FSourceEntryID,a.FSourceInterId
from ICSaleentry a inner join ICSale b on a.FInterID=b.FInterID where b.FTranType=80
group by a.finterid,a.FItemID,a.FSourceBillNo,a.FSourceEntryID,a.FSourceInterId,A.FTaxRate
-------------单据类型字段--------------------