State

In Scope

Technical: STATE | ID: OR-FND-STATE-STATE

Stores one row for each state and province in the system.

See how this object fits into Foundation Data

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity
Medium
Sequencing
Stage 2
Typical Sources
ERPLegacy

Classification

Object Type
dictionary

Target Structure

Load Approach
Table
Target Objects
STATE

Field Definitions(6)

Rules & Considerations(12)

validation

constraint

Sample Load Data(4)

Example values from field definitions

STATERPK
SAM
CREATE_IDR
SAMPLE
COUNTRY_IDRPK
SAM
DESCRIPTIONR
SAMPLE
CREATE_DATETIMER
2026-01-01
EXTERNAL_REF_ID
SAMPLE

Rule Validation Summary

Source Rule Count
21
Governed Rule Count
12