请购单连接采购订单
select
qgzb.cCode 请购订单号,
qgmx.cInvcode 物料编号,
wl.cInvName 物料名称,
wl.cInvStd 规格型号,
qgmx.FQuantity 数量,
cgmx.cbsysbarcode 采购订单号,
cgmx.cInvcode 物料编号,
wl.cInvName 物料名称,
wl.cInvStd 规格型号,
cgmx.iQuantity 数量
from PU_AppVouch qgzb
left join PU_AppVouchs qgmx on qgzb.id=qgmx.id
left join inventory wl on wl.cInvCode=qgmx.cInvCode --存货档案
--left join PO_Pomain cgzb on cgzb.cappcode=qgzb.cCode
left join PO_Podetails cgmx on qgzb.cCode=cgmx.cupsocode and qgmx.cInvCode=cgmx.cInvCode
销售订单连接发货单
select
xsdd.cSOCode 销售订单号,
(case
when xsdd.cstcode='01' then '销售订单'
when xsdd.cstcode='02' then '租赁订单'
end
) 订单类型
,
case xsdd.cstcode
when '01' then '销售订单'
when '02' then '租赁订单'
end
订单类型,
xsmx.iQuantity 数量,
xsmx.inatsum 价税合计,
bm.cDepName 部门名称,
CAST(xsdd.dDate AS DATE )AS 业务日期,
xsdd.cexch_name 币种,
xsdd.cCusName 客户简称,
wl.cInvName 物料名称,
wl.cInvStd 规格型号,
xsmx.iTaxRate 税率,
xsmx.iUnitPrice 无税单价,
xsmx.iTaxUnitPrice 含税单价,
xsmx.iMoney 无税金额,
xsmx.iTax 税额,
xsmx.iSum 价税合计,
fhd.cDLCode AS 发货单号,
fhmx.iQuantity 发货数量,
CAST(fhd.dDate AS DATE) AS 发货时间,
dw.unit_name 单位
from
so_somain xsdd
left join so_soDetails xsmx on xsdd.cSOCode=xsmx.cSOCode
left join department bm on bm.cDepCode=xsdd.cDepCode
left join inventory wl on wl.cInvCode=xsmx.cInvCode --存货档案
left join DispatchList fhd on fhd.csocode=xsdd.cSOCode
left join DispatchLists fhmx on fhd.DLID=fhmx.DLID
left join tc_unit dw on wl.cComUnitCode=dw.unit_id