BI分析：一条SQL语句可轻松查询EPR采购订单执行情况

在BI分析中，通常在BI分析系统对业务系统数据进行抽取查询，下面就给大家讲解在 u8 ERP系统中通过在数据库中执行SQL语句对采购订单执行情况进行查询，同时也用于从事 U8 ERP系统维护人员日常对数据排错。

Select 
cpoid as 订单号码,dpodate 采购日期,cbustype as 业务类型,cvencode as 供应单位,cvenname as 供应商名称,
cinvcode 存货编码,
cinvname 存货名称,
cinvstd  规格型号,
iquantity as 数量,
inum as 件数,
iarrqty as 累计到货数量,
iarrqty as 累计到货数量,
ireceivedqty  as 累计入库数量,
iinvqty  as 累计开票数量,
iunitprice as 单价,
imoney as 原币金额,
itax   as 税额,
isum   as 价税合计,
darrivedate as 计划到货日期,
cmemo  as 备注,cexch_name as 币种,cmaker as 创建人,cverifier as 审批人,cptname as 采购类型,cvenaddress as 地址,citemcode as 项目编码,citemname as 项目名称 
 From zpurpoheader
 left join zPurpotail on zpurpoheader.POID=zPurpotail.POID 
Where  1=1  and ( 1=1   And ((dPODate >= N'2020-06-01') And (dPODate <= N'2020-12-05')))
---dPODate 单据日期字段。

提示：SQL语句较多时，可通过创建视图的方式进行查询，以便在BI系统中调用视图。如果您觉得不错，可以点赞收藏，关注我，一起学习。