COUNTCODE

Each row of this table maps the country or region abbreviation code representing a country or region to a numeric code. The mapping is dictated by the third-party product or vendor identified by the string in the PRODUCTVENDOR column.

Column Descriptions:

Name	Type	Description
PRODUCTVENDOR	VARCHAR (64) NOT NULL	String that identifies the third-party product or vendor using this country code for the country or region identified by this country or region abbreviation code.
COUNTRYABBR	CHAR (5) NOT NULL	Country or region abbreviation code for the country or region. The name of the country or region are stored in the COUNTRY table.
COUNTRYCODE	CHAR (5)	The internal country or region code for the specified country or region assigned by the third party product or vendor.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	PRODUCTVENDOR+COUNTRYABBR	Primary Key