金蝶K3提取采购价格管理数据

最新推荐文章于 2023-06-30 15:54:47 发布

hzfw2008

最新推荐文章于 2023-06-30 15:54:47 发布

阅读量4.1k

点赞数 2

分类专栏：金蝶K3 MSSQL 文章标签：金蝶 K3 采购价格数据

本文链接：https://blog.csdn.net/hzfw2008/article/details/78968262

版权

金蝶K3 同时被 2 个专栏收录

181 篇文章

订阅专栏

MSSQL

114 篇文章

订阅专栏

USE [portal]
GO

/****** Object:  View [dbo].[T13881121V17w4910]    Script Date: 01/04/2018 10:39:20 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE view [dbo].[T13881121V17w4910]
AS
SELECT distinct convert(int,row_number()over(order by Fc13117Q421174920)) as id,a.* from(
SELECT 51 DirID,convert(tinyint,'0') SecLevel,'admin' Builder,case when t.fcheckdate is null then t.flastmodifieddate else t.fcheckdate end LastModified,t4.fname LastMender,
t1.fnumber Fc13117Q421174920,
t1.fname F13131r21174J930,
t2.fname F13L1128611749x39,
fstartqty F131y121160749N53,
fendqty F1311I2611x17501,
fprice Fo13112119N475025,
fquotetime F131fS12491175052,
fdisabledate F13112C1h1757415,
fremark F131881211Xc75131,
t4.fname F13112118C2265p16,
t5.fname FQRZH5S,--审核人
t.fcheckdate FNGG2HB--审核日期
FROM [AIS20140104204141].[dbo].t_supplyentry t
	INNER JOIN [AIS20140104204141].[dbo].t_icitem t1 ON t1.fitemid = t.fitemid
	INNER JOIN [AIS20140104204141].[dbo].t_supplier t2 ON t2.fitemid = t.Fsupid
	INNER JOIN [AIS20140104204141].[dbo].t_user t4 ON t4.fuserID = t.Flastmodifiedby
	LEFT JOIN [AIS20140104204141].[dbo].t_user t5 ON t5.fuserID = t.Fcheckerid

)a
GO