| 123456789101112131415161718192021222324252627282930 |
- USE [db]
- GO
- /****** 对象: View [dbo].[singleincomemoneyview] 脚本日期: 05/27/2014 16:05:40 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- ALTER VIEW [dbo].[singleincomemoneyview]
- AS SELECT
- dbo.singleincomemoney.*,
- dbo.singleincome.name, /* 其它2销名称 */
- dbo.singleincome.sale2type, /* 其它2销类型 */
- dbo.singleincome.renyuan3, /* 开单人 */
- dbo.singleincome.renyuan1 /* 客户 */
- FROM
- dbo.singleincomemoney INNER JOIN
- dbo.singleincome
- ON dbo.singleincomemoney.id = dbo.singleincome.id
- /* singleincomemoney表: /* 财务审核过的singleincome表记录,才会在这里出现 */
- [id] [nvarchar](50) NULL, /* 其它2销id */
- [money] [nvarchar](50) NULL, /* 其它2销收入金额 */
- [date] [nvarchar](50) NULL, /* 日期 */
- [clerk] [nvarchar](50) NULL, /* 经手人 */
- [paytype] [nvarchar](50) NULL, /* 支付方式 */
- [autoid] [int] IDENTITY(1,1) NOT NULL, /* 其它2销id */
- [financecheck] [nvarchar](10) NULL, /* 财务审核 */
- [time] [nvarchar](50) NULL, /* 时间 */
- [jdd] [nvarchar](50) NULL /* 接单点 */
- */
|
