V_MKTREVENUERECEIPTAUDIT
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 | |
| RECEIPTNUMBER | int | yes | |
| PROCESSDATE | datetime | yes | |
| RECEIPTDATE | datetime | yes | |
| MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUSID | uniqueidentifier | yes | |
| MKTSEGMENTATIONID | uniqueidentifier | yes | |
| MKTSEGMENTID | uniqueidentifier | yes | |
| ADDEDBYID | uniqueidentifier | yes | |
| CHANGEDBYID | uniqueidentifier | yes | |
| DATEADDED | datetime | yes | |
| DATECHANGED | datetime | yes |
Definition
Copy
CREATE view dbo.[V_MKTREVENUERECEIPTAUDIT]
as
select cast('09A6D736-2ACB-42FF-87DB-F4F92A2025E1' as uniqueidentifier) as [RECORDSOURCEID], [RRA].[AUDITID], [RRA].[AUDITRECORDID], [RRA].[AUDITKEY], [RRA].[AUDITCHANGEAGENTID], [RRA].[AUDITDATE], [RRA].[AUDITTYPECODE], [RRA].[AUDITTYPE], cast([RRA].[REVENUEID] as varchar(36)) as [REVENUEID],[RRA]. [RECEIPTNUMBER], [RRA].[PROCESSDATE], [RRA].[RECEIPTDATE], [RRA].[MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUSID], [RRA].[MKTSEGMENTATIONID], [RRA].[MKTSEGMENTID], [RRA].[ADDEDBYID], [RRA].[CHANGEDBYID], [RRA].[DATEADDED], [RRA].[DATECHANGED]
from dbo.[MKTREVENUERECEIPT_09A6D736_2ACB_42FF_87DB_F4F92A2025E1AUDIT] as [RRA]