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 Name | Column Type | Column 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 | CHARACTER (20) NOT NULL |
The internal State or Province Code for the specified state or province assigned by the third-party product or vendor. |
STATEPROVCODE | CHARACTER (5) NULL |
The State or Province Code used by the third-party product or vendor for this State or Province. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035108000 | PRODUCTVENDOR, STATEPROVABBR | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|