lyfz_repos/经典版源码/document/数据库表脚本/dindanbukuanview2.sql

USE [db]
GO
/****** 对象:  View [dbo].[dindanbukuanview2]    脚本日期: 05/27/2014 15:41:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[dindanbukuanview2]
AS SELECT     
dbo.dindan.name1,				/* 姓名1-男宾*/
dbo.dindan.name2,				/* 姓名2-女宾*/
dbo.dindanbukuan.autoid,		/* 自动id */
dbo.dindanbukuan.id,			/* 订单id */
dbo.dindanbukuan.money,			/* 补款金额(收入) */
dbo.dindanbukuan.ren,			/* 开单人 */
dbo.dindanbukuan.date,			/* 开单日期 */
dbo.dindanbukuan.bz,			/* 备注(补款类型描述) */
dbo.dindanbukuan.kind,			/* 补款类型 */
dbo.dindanbukuan.ren2,			/* 收款人 */
dbo.dindanbukuan.item,			/* ?? */
dbo.dindanbukuan.paytype,		/* 支付方式 */
dbo.dindanbukuan.jdd,			/*  接单点 */
dbo.dindanbukuan.financecheck,	/* 财务审核 */
dbo.dindanbukuan.discount,		/* 折扣 */
dbo.dindanbukuan.time			/* 补款时间 */	
FROM         
dbo.dindanbukuan INNER JOIN dbo.dindan ON dbo.dindanbukuan.id = dbo.dindan.id