syteline7中收货单数据

shijian.zhou

SELECT dbo.vendaddr.name as 供应商姓名, dbo.grn_line.po_num as 采购单号, dbo.grn_line.po_line as 采购单行,
      dbo.grn_line.u_m, as 单位 dbo.grn_line.qty_rec as 接收数量, dbo.grn_line.qty_rej as 拒收数量,
      dbo.grn_line.qty_shipped_conv as 发出数量, dbo.taxcode.tax_rate as 税率, dbo.poitem.item as 产品编号,
      dbo.poitem.description as 产品名称, dbo.grn_line.vend_num as 供应商编号, dbo.grn_line.grn_num as 收货单号,
      dbo.grn_line.grn_line as 收货单行, dbo.poitem.item_cost as 价格
FROM dbo.grn_line LEFT OUTER JOIN
      dbo.vendaddr ON
      dbo.grn_line.vend_num = dbo.vendaddr.vend_num LEFT OUTER JOIN
      dbo.poitem ON dbo.grn_line.po_num = dbo.poitem.po_num AND
      dbo.grn_line.po_line = dbo.poitem.po_line LEFT OUTER JOIN
      dbo.taxcode ON dbo.poitem.tax_code1 = dbo.taxcode.tax_code

grn_line为收货单行
vendaddr 为供应商地址
poitem 为采购单
taxcode 为税