WebSphere Commerce database table: STATECODE

Reference > Database > WebSphere Commerce database tables > S

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 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
SQL100520030430210 PRODUCTVENDOR+STATEPROVABBR Primary Key

Related reference

Country and state code data model

_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

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.