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

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

宝贝啊！

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

阅读量755

点赞数

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

版权

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