V_QUERY_COUNTRY
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| COUNTRY | nvarchar(100) | ||
| ABBREVIATION | nvarchar(5) | ||
| ADDRESSFORMAT | nvarchar(50) | ||
| ACTIVE | bit | ||
| DEFAULT | int | ||
| COUNTRYCODE | nvarchar(10) | ||
| PHONEFORMAT | nvarchar(20) | yes | |
| ISO3166 | nvarchar(2) | ||
| PHONEFORMATCODE | tinyint |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:08:37 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_COUNTRY AS
select
COUNTRY.ID,
COUNTRY.DESCRIPTION as COUNTRY,
COUNTRY.ABBREVIATION,
COUNTRYADDRESSFORMAT.FORMATNAME as ADDRESSFORMAT,
COUNTRY.ACTIVE,
case when [I].[ID] is null then 0 else 1 end [DEFAULT],
COUNTRY.COUNTRYCODE,
dbo.UFN_PHONEFORMATCODE_GETFORMAT(COUNTRY.PHONEFORMATCODE) as PHONEFORMAT,
COUNTRY.ISO3166,
COUNTRY.PHONEFORMATCODE
from
dbo.COUNTRY
inner join dbo.COUNTRYADDRESSFORMAT on COUNTRYADDRESSFORMAT.ID = COUNTRY.COUNTRYADDRESSFORMATID
left outer join dbo.[INTERNATIONALIZATIONINFO] [I] on [COUNTRY].[ID] = [I].[DEFAULTCOUNTRYID]