WebSphere Commerce database table: STATECODE

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031312570 PRODUCTVENDOR+STATEPROVABBR Primary Key

Feedback