REVENUEREFERENCE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| REFERENCE | nvarchar(255) | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime |
Definition
Copy
CREATE view dbo.REVENUEREFERENCE with schemabinding as
select
ID
,REFERENCE
,ADDEDBYID
,CHANGEDBYID
,DATEADDED
,DATECHANGED
from
dbo.REVENUE_EXT
--where not nullif(REFERENCE,'') is NULL