Difference between revisions of "Sales.CountryRegionCurrency (table)"

From dbscript Online Help
Jump to: navigation, search
Line 38: Line 38:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|-
 +
| [[Person.CountryRegion_(table)|Person.CountryRegion]]
 +
| CountryRegionCode
 +
| CountryRegionCode
 +
|-
 +
| [[Sales.Currency_(table)|Sales.Currency]]
 +
| CurrencyCode
 +
| CurrencyCode
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Sales.CountryRegionCurrency
 +
|-
 +
 +
| '''Description
 +
| Cross-reference table mapping ISO currency codes to a country or region.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
| '''PK / Index
 +
 +
|-
 +
| CountryRegionCode
 +
| nvarchar(3)
 +
| not null
 +
|
 +
| ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
 +
| PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
 +
|-
 +
| CurrencyCode
 +
| nchar(3)
 +
| not null
 +
|
 +
| ISO standard currency code. Foreign key to Currency.CurrencyCode.
 +
| PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeIX_CountryRegionCurrency_CurrencyCode
 +
|-
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (GETDATE())
 +
| Date and time the record was last updated.
 
|  
 
|  
 
|}
 
|}

Revision as of 00:26, 27 November 2009

wikibot

Table Sales.CountryRegionCurrency


Column Data Type Nullable Default PK Index
CountryRegionCode nvarchar(3) not null PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
CurrencyCode nchar(3) not null PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode IX_CountryRegionCurrency_CurrencyCode
ModifiedDate datetime not null (getdate())


Relation Column Referenced Column
Person.CountryRegion CountryRegionCode CountryRegionCode
Sales.Currency CurrencyCode CurrencyCode

automatically generated

Table Sales.CountryRegionCurrency
Description Cross-reference table mapping ISO currency codes to a country or region.


Column Data Type Nullable Default Description PK / Index
CountryRegionCode nvarchar(3) not null ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode. PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
CurrencyCode nchar(3) not null ISO standard currency code. Foreign key to Currency.CurrencyCode. PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeIX_CountryRegionCurrency_CurrencyCode
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Person.CountryRegion CountryRegionCode CountryRegionCode
Sales.Currency CurrencyCode CurrencyCode
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.CountryRegionCurrency_(table)&oldid=1081"