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