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:
| Name | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | PRODUCTVENDOR+STATEPROVABBR | Primary Key |