用友U8 ERP到货单查询SQL语句

SELECT a.id ,

a.ccode '单据号 ' ,

a.cptname '采购类型' ,

a.cvenabbname '供应商 ' ,

a.cdepname '部门' ,

a.cpersonname '业务员 ' ,

a.cmemo '备注' ,

a.cmaker '制单人' ,

a.ddate '日期' ,

a.cverifier '审核人' ,

a.caudittime '审核时间 ' ,

CASE WHEN a.ibilltype = 0 THEN '到货单'

WHEN a.ibilltype = 1 THEN '退货单'

WHEN a.ibilltype = 2 THEN '拒收单'

END 到货单类型,

b.ivouchrowno '行号',

b.cinvcode '存货编码',

b.cinvaddcode '存货代码',

b.cinvname '存货名称',

b.cinvstd '规格型号',

b.cinvm_unit '单位',

b.iquantity '数量',

b.frealquantity '实收数量',

b.fValidinQuan '入库数量'

FROM pu_ArrHead a

INNER JOIN pu_arrbody b ON a.id = b.id

WHERE b.fValidinQuan < b.iquantity

ORDER BY a.ddate

--a.ccode='0000003976';