Information About Sequence Settings For Integration

In Scope

Technical: SEQUENCE_ADMIN | ID: OR-STO-SEQUENCE_ADMIN-SEQUENCE_ADMINISTRATION

Stores information about sequence settings for integration.

See how this object fits into Store Operations

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: SEQUENCE_ADMIN

Field Definitions(5)

Rules & Considerations(12)

constraint

validation

Sample Load Data(4)

_scenario	SEQUENCE_NAMERPK	MAX_VALUE	MIN_VALUE	TABLE_NAME	UPDATE_USER	MODIFY_ALLOWED	SEQUENCE_COLUMN	LAST_UPDATE_DATE	MODIFIED_END_VALUE	MODIFIED_START_VALUE
Example values from field definitions	SAMPLE	1	1	SAMPLE	SAMPLE	S	SAMPLE	2026-01-01	1	1
default	Sequence Admin Secondary	3	3	Sequence Admin Secondary	2026-01-02-ALT	N	Sequence Admin-002-ALT	2026-01-03	3	3
default	Sequence Admin Core	5	5	Sequence Admin Core	2026-01-03-EDGE	N	Sequence Admin-003-EDGE	2026-01-05	5	5

Example values from field definitions

SEQUENCE_NAMERPK: SAMPLE
MAX_VALUE: 1
MIN_VALUE: 1
TABLE_NAME: SAMPLE
UPDATE_USER: SAMPLE
MODIFY_ALLOWED: S
SEQUENCE_COLUMN: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
MODIFIED_END_VALUE: 1
MODIFIED_START_VALUE: 1

default

SEQUENCE_NAMERPK: Sequence Admin Secondary
MAX_VALUE: 3
MIN_VALUE: 3
TABLE_NAME: Sequence Admin Secondary
UPDATE_USER: 2026-01-02-ALT
MODIFY_ALLOWED: N
SEQUENCE_COLUMN: Sequence Admin-002-ALT
LAST_UPDATE_DATE: 2026-01-03
MODIFIED_END_VALUE: 3
MODIFIED_START_VALUE: 3

default

SEQUENCE_NAMERPK: Sequence Admin Core
MAX_VALUE: 5
MIN_VALUE: 5
TABLE_NAME: Sequence Admin Core
UPDATE_USER: 2026-01-03-EDGE
MODIFY_ALLOWED: N
SEQUENCE_COLUMN: Sequence Admin-003-EDGE
LAST_UPDATE_DATE: 2026-01-05
MODIFIED_END_VALUE: 5
MODIFIED_START_VALUE: 5

Rule Validation Summary

Source Rule Count: 16
Governed Rule Count: 12