WebSphere Commerce database table: STATECODE

This table maps the internal StateProv Abbreviation Code to the State or Province Code. They are dictated by the third-party product or vendor identified in the PRODUCTVENDOR column.

Column Descriptions

Column Name	Column Type	Description
PRODUCTVENDOR	VARCHAR(64) NOT NULL	String that identifies the third-party product or vendor using this State or Province code for the State or Province identified by this StateProvAbbr code.
STATEPROVABBR	CHAR(20) NOT NULL	The internal State or Province Code for the specified state or province assigned by the third-party product or vendor.
STATEPROVCODE	CHAR(5)	The State or Province Code used by the third-party product or vendor for this State or Province.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235251660	PRODUCTVENDOR+STATEPROVABBR	Primary Key

Related reference

• Country and state code data model