V_MKTREVENUELETTERAUDIT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RECORDSOURCEID | uniqueidentifier | yes | |
| AUDITID | uniqueidentifier | ||
| AUDITRECORDID | uniqueidentifier | ||
| AUDITKEY | uniqueidentifier | ||
| AUDITCHANGEAGENTID | uniqueidentifier | ||
| AUDITDATE | datetime | ||
| AUDITTYPECODE | tinyint | ||
| AUDITTYPE | nvarchar(13) | yes | |
| REVENUEID | varchar(36) | yes | |
| LETTERCODEID | uniqueidentifier | yes | |
| PROCESSDATE | datetime | yes | |
| ACKNOWLEDGEDATE | datetime | yes | |
| MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUSID | uniqueidentifier | yes | |
| MKTSEGMENTATIONID | uniqueidentifier | yes | |
| MKTSEGMENTID | uniqueidentifier | yes | |
| MKTPACKAGEID | uniqueidentifier | yes | |
| ADDEDBYID | uniqueidentifier | yes | |
| CHANGEDBYID | uniqueidentifier | yes | |
| DATEADDED | datetime | yes | |
| DATECHANGED | datetime | yes |
Definition
Copy
CREATE view dbo.[V_MKTREVENUELETTERAUDIT]
as
select cast('09A6D736-2ACB-42FF-87DB-F4F92A2025E1' as uniqueidentifier) as [RECORDSOURCEID], [RLA].[AUDITID], [RLA].[AUDITRECORDID], [RLA].[AUDITKEY], [RLA].[AUDITCHANGEAGENTID], [RLA].[AUDITDATE], [RLA].[AUDITTYPECODE], [RLA].[AUDITTYPE], cast([RLA].[REVENUEID] as varchar(36)) as [REVENUEID], [RLA].[LETTERCODEID], [RLA].[PROCESSDATE], [RLA].[ACKNOWLEDGEDATE], [RLA].[MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUSID], [RLA].[MKTSEGMENTATIONID], [RLA].[MKTSEGMENTID], cast(null as uniqueidentifier) as [MKTPACKAGEID], [RLA].[ADDEDBYID], [RLA].[CHANGEDBYID], [RLA].[DATEADDED], [RLA].[DATECHANGED]
from dbo.[MKTREVENUELETTER_09A6D736_2ACB_42FF_87DB_F4F92A2025E1AUDIT] as [RLA]