REVENUEREFERENCEAUDIT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| AUDITID | uniqueidentifier | ||
| AUDITRECORDID | uniqueidentifier | ||
| AUDITKEY | uniqueidentifier | ||
| AUDITCHANGEAGENTID | uniqueidentifier | ||
| AUDITDATE | datetime | ||
| AUDITTYPECODE | tinyint | ||
| AUDITTYPE | nvarchar(13) | yes | |
| REFERENCE | nvarchar(255) | yes | |
| ADDEDBYID | uniqueidentifier | yes | |
| CHANGEDBYID | uniqueidentifier | yes | |
| DATEADDED | datetime | yes | |
| DATECHANGED | datetime | yes |
Definition
Copy
create view dbo.REVENUEREFERENCEAUDIT as
select
T.AUDITID
,T.AUDITRECORDID
,T.AUDITKEY
,T.AUDITCHANGEAGENTID
,T.AUDITDATE
,T.AUDITTYPECODE
,T.AUDITTYPE
,T.REFERENCE
,T.ADDEDBYID
,T.CHANGEDBYID
,T.DATECHANGED DATEADDED
,T.DATECHANGED
from
REVENUE_EXTAUDIT as T
left outer join REVENUE_EXTAUDIT as T1 on T.AUDITKEY = T1.AUDITKEY and T.AUDITTYPECODE<>T1.AUDITTYPECODE
where
(not ( T1.REFERENCE = '' and T1.AUDITTYPECODE = 0 and T.AUDITTYPECODE = 1 )
and not ( T.REFERENCE = '' and T1.AUDITTYPECODE = 1 and T.AUDITTYPECODE = 0 )
)
or T1.AUDITID is null
union all
select
T.AUDITID
,T.AUDITRECORDID
,T.AUDITKEY
,T.AUDITCHANGEAGENTID
,T.AUDITDATE
,T.AUDITTYPECODE
,T.AUDITTYPE
,T.REFERENCE
,T.ADDEDBYID
,T.CHANGEDBYID
,T.DATEADDED
,T.DATECHANGED
from
REVENUEREFERENCEAUDITORIGINAL as T