State

List of available States linked to a Country

Data Element

Data Type

What is it

Mandatory

Id

Integer

The unique identifier of the record

No

Country

Integer

The unique id of the Country record linked to this State record

Yes

Code

VarChar

The code for the state

Yes

Active

Bit

Whether the state record is active or not

Yes

SortOrder

Integer

An integer to customise to sort order of the state list

No

State

VarChar

The full name of the state

Yes

Creator

Integer

When the record was originally created

No

Created

DateTime

When the record was originally created

No

Modified

DateTime

The last time the record was modified

No

Foreign Objects which can be linked with the Resource API

CountryObject