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