给客户做报表写sql,在我的码猴数据字典一直找不到关于采购员的表,后来在社区找到了,采购员所在的表 V_BD_BUYER_L
```SELECT
PORY.FID 订单内码,
PORY.FENTRYID 订单分录内码,
POR.FPURCHASEORGID 采购组织,
POR.FBUSINESSTYPE 业务类型代码,
POR.FBILLNO 订单编号,
TBSL.FNAME 供应商,
VBBL.FNAME 采购员,
PORY.FQTY 采购数量,
PORYR.FRECEIVEQTY 累计收货数量,
PORYR.FMRBQTY 累计退货数量,
PORYD.FDELIVERYDATE 订单交货日期
FROM
T_PUR_POORDERENTRY PORY --采购订单表体
INNER JOIN T_PUR_POORDER POR --采购订单表头
ON POR.FID= PORY.FID
LEFT JOIN t_BD_Supplier TBS ON POR.FSUPPLIERID = TBS.FSupplierId --供应商
LEFT JOIN t_BD_Supplier_L TBSL ON TBS.FSupplierId = TBSL.FSupplierId AND TBSL.FLocaleId = '2052' --供应商多语言
LEFT JOIN V_BD_BUYER VBB ON POR.FPURCHASERID = VBB.FID
LEFT JOIN V_BD_BUYER_L VBBL ON VBB.FID = VBBL.FID AND VBBL.FLocaleId = '2052'
```
