V_QUERY_MEMBERSHIPPROMOCODE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| MEMBERSHIPPROMOID | uniqueidentifier | ||
| PROMOTIONALCODE | nvarchar(50) | ||
| VALIDFROM | datetime | yes | |
| VALIDTO | datetime | yes | |
| SEQUENCE | int | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TSLONG | bigint | yes | |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | |
| ADDEDBY_USERNAME | nvarchar(128) | yes | |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | |
| CHANGEDBY_USERNAME | nvarchar(128) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:31:44 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MEMBERSHIPPROMOCODE AS
select
MEMBERSHIPPROMOCODE.ID,
MEMBERSHIPPROMOCODE.MEMBERSHIPPROMOID,
MEMBERSHIPPROMOCODE.PROMOTIONALCODE,
MEMBERSHIPPROMOCODE.VALIDFROM,
MEMBERSHIPPROMOCODE.VALIDTO,
MEMBERSHIPPROMOCODE.SEQUENCE,
MEMBERSHIPPROMOCODE.DATEADDED,
MEMBERSHIPPROMOCODE.DATECHANGED,
MEMBERSHIPPROMOCODE.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME
/*EXTENSION*/
from
dbo.MEMBERSHIPPROMOCODE
left outer join
dbo.CHANGEAGENT as ADDEDBY on ADDEDBY.ID = MEMBERSHIPPROMOCODE.ADDEDBYID
left outer join
dbo.CHANGEAGENT as CHANGEDBY on CHANGEDBY.ID = MEMBERSHIPPROMOCODE.CHANGEDBYID