Reference > Database > WebSphere Commerce database tables > C

WebSphere Commerce database table: 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 Name	Column 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	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL100520030319460	PRODUCTVENDOR+COUNTRYABBR	Primary Key

Related reference

• Country and state code data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search