tCountryCurrencyXref Table

Description

System reference table used to map currencies to countries when exporting company loss files (CLFs) and UNICEDE/2 files for CATRADER.

Properties

Columns

Column Name	Description	Datatype	Length
CountryCode	ISO 2-character code for the country in which the location resides. For a complete list of codes, see tCountry Table.	varchar	15
CurrencyCode	ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table.	char	3
IsDefault	Indicates whether the currency is the default. 1 = Yes (default) 0 = No (not default)	bit	1

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

CountryCode

ISO 2-character code for the country in which the location resides.

For a complete list of codes, see tCountry Table.

varchar

CurrencyCode

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

char

IsDefault

Indicates whether the currency is the default.

bit

Objects that tCountryCurrencyXref depends on

	Database Object	Object Type	Description	Dep Level
	tCurrency	Table	Stores AIR currency codes.	1