用友U8 | 【请购单列表】后台数据库导请购单列表

1、后台导出请购单列表：

---PU_AppVouch 请购单主表

---PU_AppVouchs 请购单子表

---Inventory 存货档案

select a.cCode as '单据编码',
a.ddate as '制单日期',
a.cBusType as '业务类型',
a.cMaker as '制单人',
a.cVerifier as '审核人',
a.cDefine14 as '请购部门',
b.cInvCode as '存货编码',
c.cInvName as '存货名称',
c.cInvStd as '规格型号',
b.fQuantity as '数量',
b.cbMemo as '备注'
from PU_AppVouch a join PU_AppVouchs b on a.ID=b.id join Inventory c on b.cInvCode=c.cInvCode  where dDate>='2020-5-01 00:00:00.000'order by dDate

---PU_AppVouch 请购单主表

---PU_AppVouchs 请购单子表

---Inventory 存货档案

2、栏目设置设置请购单表体的备注列：

表体备注，在栏目设置中把行备注这个字段显示出来。