Timeline

In Scope

Technical: TIMELINE | ID: OR-PUR-TIMELINE-TIMELINE

Stores one row for each timeline that can be defined within Oracle Retail. A timeline is used to create a series of dates (held on the TIMELINE_STEPS table) which can...

See how this object fits into Purchasing

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

Field Definitions(5)

Rules & Considerations(25)

constraint

validation

Sample Load Data(4)

_scenario	KEY_VALUE_1R	TIMELINE_NOR	TIMELINE_KEYRPK	TIMELINE_TYPER	STEP_NO	BASE_DATE	CREATE_ID	ACTUAL_DATE	DISPLAY_SEQ	KEY_VALUE_2	REASON_CODE	COMMENT_DESC	REVISED_DATE	ORIGINAL_DATE	LAST_UPDATE_ID	CREATE_DATETIME	LAST_UPDATE_DATETIME
Example values from field definitions	SAMPLE	1	1	SAMPLE	1	2026-01-01	SAMPLE	2026-01-01	1	SAMPLE	SAMPLE	SAMPLE	2026-01-01	2026-01-01	SAMPLE	2026-01-01	2026-01-01
default	Timeline-002-ALT	4	3	Timeli	4	2026-01-03	C LIENT_INFO	2026-01-03	3	Timeline-002-ALT	ALT-TI	Timeline-002-ALT	2026-01-03	2026-01-03	MDM_USER	2026-01-03	2026-01-03
default	Timeline-003-EDGE	6	5	Timeli	6	2026-01-05	USE RENV	2026-01-05	5	Timeline-003-EDGE	EDGE-T	Timeline-003-EDGE	2026-01-05	2026-01-05	BATCH_USER	2026-01-05	2026-01-05

Example values from field definitions

KEY_VALUE_1R: SAMPLE
TIMELINE_NOR: 1
TIMELINE_KEYRPK: 1
TIMELINE_TYPER: SAMPLE
STEP_NO: 1
BASE_DATE: 2026-01-01
CREATE_ID: SAMPLE
ACTUAL_DATE: 2026-01-01
DISPLAY_SEQ: 1
KEY_VALUE_2: SAMPLE
REASON_CODE: SAMPLE
COMMENT_DESC: SAMPLE
REVISED_DATE: 2026-01-01
ORIGINAL_DATE: 2026-01-01
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
LAST_UPDATE_DATETIME: 2026-01-01

default

KEY_VALUE_1R: Timeline-002-ALT
TIMELINE_NOR: 4
TIMELINE_KEYRPK: 3
TIMELINE_TYPER: Timeli
STEP_NO: 4
BASE_DATE: 2026-01-03
CREATE_ID: C LIENT_INFO
ACTUAL_DATE: 2026-01-03
DISPLAY_SEQ: 3
KEY_VALUE_2: Timeline-002-ALT
REASON_CODE: ALT-TI
COMMENT_DESC: Timeline-002-ALT
REVISED_DATE: 2026-01-03
ORIGINAL_DATE: 2026-01-03
LAST_UPDATE_ID: MDM_USER
CREATE_DATETIME: 2026-01-03
LAST_UPDATE_DATETIME: 2026-01-03