| 123456789101112131415161718192021222324252627 |
- 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
|
