iqd-file

USE [Udit.Mms]
GO

/****** Object:  View [dbo].[iqc_file]    Script Date: 2023/9/26 20:38:20 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




CREATE VIEW [dbo].[iqc_file]
AS
select *
FROM      OPENQUERY(ERP, 
                '
SELECT ltrim(rtrim(TA001)) iqc01,ltrim(rtrim(TA002)) 到货单号,ltrim(rtrim(TA001))+''-''+ltrim(rtrim(TA002)) iqc02,cast(TA003 as int) iqc03,ltrim(rtrim(TAC04)) iqc04,cast(TA019 as date) iqc05,
rtrim(ltrim(CD004)) iqc06,CD005 iqc07,CD006 iqc08,CC004 iqc09,CD010+''-''+CD011+''-''+CD012 采购单号,ltrim(rtrim(CD010))+''-''+ltrim(rtrim(CD011)) iqc10,TAC01 iqc11,TA008 iqc12  
FROM UNP.dbo.QMSTA 
INNER JOIN UNP.dbo.PURCD AS PURCD ON CD001=TA001 AND CD002=TA002 AND CD003=TA003
INNER JOIN UNP.dbo.PURCC AS PURCC ON CC001=CD001 AND CC002=CD002
WHERE TA014=''Y''
')
                 AS derivedtbl_1








GO