?
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')))