用友U8 合同执行情况视图SQL语句

create view [dbo].[PS_V_HTZXTJB]

as

SELECT a.HT_合同编号, a.合同类型, a.供应商名称, a.合同总金额, a.合同签订日期,

a.合同开始日期, a.合同结束日期, a.部门, a.采购员, a.HT_存货编码, a.HT_存货代码,

a.HT_规格型号, a.HT_存货名称, a.单位, a.质检, a.合同数量, a.税率, a.含税单价,

a.含税金额, a.令号, b.DH_合同编号, b.DH_存货编码, b.到货单号, b.到货属性,

b.到货日期, b.实收数量, c.BJ_合同编号, c.报检日期,

c.BJ_存货编码, c.报检数量, d.JY_合同编号, d.检验日期,

d.JY_存货编码, d.检验合格数量, e.RK_合同编号, e.入库日期,

e.RK_存货编码, e.入库数量

FROM PS_V_CGHT AS a LEFT JOIN

PS_V_CGDH AS b ON a.HT_合同编号 = b.DH_合同编号 AND

a.HT_存货编码 = b.DH_存货编码 LEFT JOIN

PS_V_CGBJ AS c ON b.DH_Autoid = c.DH_Autoid LEFT JOIN

PS_V_CGJY AS d ON b.DH_Autoid = d.DH_Autoid LEFT JOIN

PS_V_CGRK AS e ON b.DH_Autoid = e.DH_Autoid

WHERE 1 = 1

create View [dbo].[PS_V_CGHT]

as

select strContractID as HT_合同编号,cTypeName as 合同类型,strBisectionUnitName as 供应商名称,

dblTotalCurrency as 合同总金额,strContractOrderDat