lyfz_repos/经典版源码/document/数据库表脚本/singleincommoneyview-其它2销视图.sql

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				/* 接单点 */
*/