MerchantAccountUsage
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ClientSitesID | int | ||
| id | int | ||
| PartName | nvarchar(256) | yes | |
| ContentType | nvarchar(139) | ||
| ContentTypeID | int | ||
| MerchantAccount | nvarchar(100) | yes | |
| Active | bit | ||
| MerchantAccountID | int |
Definition
Copy
CREATE VIEW [dbo].[MerchantAccountUsage] as
select sitecontent.ClientSitesID [ClientSitesID], sitecontent.id, sitecontent.Title [PartName], case when ContentTypes.id=69 then ContentTypes.name + ' (Donation)' else ContentTypes.name end [ContentType], ContentTypes.id [ContentTypeID], ClientMerchantAccounts.Name [MerchantAccount], ClientMerchantAccounts.Active, ClientMerchantAccounts.ID [MerchantAccountID]
from dbo.ClientDonations inner join dbo.SiteContent on ClientDonations.ContentID=SiteContent.ID
inner join dbo.ContentTypes on sitecontent.contentTypesID=ContentTypes.id
inner join dbo.ClientMerchantAccounts on ClientDonations.MerchantAccount=ClientMerchantAccounts.id
union
select sitecontent.ClientSitesID, sitecontent.id, sitecontent.Title [PartName], case when ContentTypes.id=69 then ContentTypes.name + ' (Event)' else ContentTypes.name end [ContentType], ContentTypes.id [ContentTypeID], ClientMerchantAccounts.Name [MerchantAccount], ClientMerchantAccounts.Active, ClientMerchantAccounts.ID
from dbo.ClientEvents inner join dbo.SiteContent on ClientEvents.ContentID=SiteContent.ID
inner join dbo.ContentTypes on sitecontent.contentTypesID=ContentTypes.id
inner join dbo.ClientMerchantAccounts on ClientEvents.MerchantAccount=ClientMerchantAccounts.id
union
select sitecontent.ClientSitesID, sitecontent.id, sitecontent.Title [PartName], ContentTypes.name [ContentType], ContentTypes.id [ContentTypeID], ClientMerchantAccounts.Name [MerchantAccount], ClientMerchantAccounts.Active, ClientMerchantAccounts.ID
from dbo.ClientMemberships inner join dbo.SiteContent on ClientMemberships.SiteContentID=SiteContent.ID
inner join dbo.ContentTypes on sitecontent.contentTypesID=ContentTypes.id
inner join dbo.ClientMerchantAccounts on ClientMemberships.MerchantAccount=ClientMerchantAccounts.id
union
select sitecontent.ClientSitesID, sitecontent.id, sitecontent.Title, ContentTypes.name, ContentTypes.id, ClientMerchantAccounts.Name, ClientMerchantAccounts.Active, ClientMerchantAccounts.ID
from dbo.ShoppingCartPart inner join dbo.SiteContent on ShoppingCartPart.SiteContentID=SiteContent.ID
inner join dbo.ContentTypes on sitecontent.contentTypesID=ContentTypes.id
inner join dbo.ClientMerchantAccounts on ShoppingCartPart.MerchantAccountID=ClientMerchantAccounts.id
union
select sitecontent.ClientSitesID, sitecontent.id, sitecontent.Title, ContentTypes.name, ContentTypes.id, ClientMerchantAccounts.Name, ClientMerchantAccounts.Active, ClientMerchantAccounts.ID
from dbo.SHOPPINGCARTSETTINGS SCS
inner join dbo.SiteContent on SCS.ID=SiteContent.GUID
inner join dbo.ContentTypes on sitecontent.contentTypesID=ContentTypes.id
inner join dbo.ClientMerchantAccounts on SCS.MerchantAccountID=ClientMerchantAccounts.BBPSID