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 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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031312570 |
PRODUCTVENDOR+STATEPROVABBR |
Primary Key |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.