Skip to main content
Skip table of contents

States (ver7.0.0)

This table currently contains the fifty-five United States and territories and the thirteen Canadian provinces.

Column NameInitial VersionData TypeDescription

Country

7.0.0

Varchar2(10)

Three digit ISO country code. Required.

ID

7.0.0

Number(10,0)

Unique sequential number generated by the application. Required.

State

7.0.0

Varchar2(10)

Two-digit postal code. Required.

WhenCreated

7.0.0

Timestamp(6)

Date and time the record was created. Defaults to system date. Required.

WhenModified

7.0.0

Timestamp(6)

Date and time the record was modified. Defaults to system date. Required.

WhoCreated

7.0.0

Varchar2(100)

The user login that created the record. Defaults to database user. Required.

WhoModified

7.0.0

Varchar2(100)

The user login that modified the record. Defaults to database user. Required.

 

 

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.