yilv_new/AA/sql/审核view.sql

use wtu
go
--데앴뚤亮깊
if exists (select * from sysobjects where id = object_id('dbo.usp_datamaps') )
        drop view dbo.usp_audit
go
Create  view usp_audit
as

select '페儉흙욋데' as vouchertype,ccode,ddate from UFDATA_002_2019..rdrecord08  where dnverifytime is null   
union
select '페儉놔욋데' as vouchertype,ccode,ddate from UFDATA_002_2019..rdrecord09  where dnverifytime is null   
union
select '꽃뭔흙욋데' as vouchertype,ccode,ddate from UFDATA_002_2019..rdrecord01  where dnverifytime is null   
union
select '꽃뭔藁새데' as vouchertype,ccode,ddate from UFDATA_002_2019..PU_ArrivalVouch  where caudittime is null   
union
select '饋簡랙새데' as vouchertype,cDLCode,ddate from UFDATA_002_2019..DispatchList  where dverifysystime is null   
union
select '꽃뭔땐데'   as vouchertype,cPOID,dPODate  from UFDATA_002_2019..PO_Pomain  where cAuditTime is null   

go