V_MKTREVENUELETTER
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RECORDSOURCEID | uniqueidentifier | yes | |
| ID | uniqueidentifier | ||
| REVENUEID | varchar(36) | yes | |
| LETTERCODEID | uniqueidentifier | ||
| PROCESSDATE | datetime | yes | |
| ACKNOWLEDGEDATE | datetime | yes | |
| MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUSID | uniqueidentifier | yes | |
| MKTSEGMENTATIONID | uniqueidentifier | yes | |
| MKTSEGMENTID | uniqueidentifier | yes | |
| MKTPACKAGEID | uniqueidentifier | yes | |
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes |
Definition
Copy
CREATE view dbo.[V_MKTREVENUELETTER]
as
select cast('09A6D736-2ACB-42FF-87DB-F4F92A2025E1' as uniqueidentifier) as [RECORDSOURCEID], [RL].[ID], cast([RL].[REVENUEID] as varchar(36)) as [REVENUEID], [RL].[LETTERCODEID], [RL].[PROCESSDATE], [RL].[ACKNOWLEDGEDATE], [RL].[MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUSID], [RL].[MKTSEGMENTATIONID], [RL].[MKTSEGMENTID], cast(null as uniqueidentifier) as [MKTPACKAGEID], [RL].[ADDEDBYID], [RL].[CHANGEDBYID], [RL].[DATEADDED], [RL].[DATECHANGED], [RL].[TS], [RL].[TSLONG]
from dbo.[MKTREVENUELETTER_09A6D736_2ACB_42FF_87DB_F4F92A2025E1] as [RL]