用友U8 采购订单列表的SQL 语句

 

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 地址
 From zpurpoheader
 left join zPurpotail on zpurpoheader.POID=zPurpotail.POID 
Where  1=1  and ( 1=1   And ((dPODate >= N'2015-06-01') And (dPODate <= N'2015-06-05')))