视图

CREATE VIEW dbo.视图_应收帐
AS
SELECT a.*, a.虚金额 AS 应收金额, a.实金额 AS 收款金额, b.类别 AS 类别,
      b.编码 AS 业务伙伴编码, b.名称 AS 业务伙伴, c.往来备注 AS 往来备注,
      c.欠款限额 AS 欠款限额, c.信用等级 AS 信用等级, '客户' AS 往来帐格式
FROM dbo.[视图_应收应付基本视图] a INNER JOIN
      dbo.实体 b ON a.业务伙伴Id_ = b.id_ INNER JOIN
      dbo.[实体_客户] c ON b.id_ = c.id_