Timeline
In ScopeTechnical: 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(17)
Rules & Considerations(22)
constraint
validation
Sample Load Data(4)
| _scenario | STEP_NOR | CREATE_IDR | KEY_VALUE_1R | TIMELINE_NORPK | TIMELINE_KEYRPK | TIMELINE_TYPER | LAST_UPDATE_IDR | CREATE_DATETIMER | LAST_UPDATE_DATETIMER | BASE_DATE | ACTUAL_DATE | DISPLAY_SEQ | KEY_VALUE_2 | REASON_CODE | COMMENT_DESC | REVISED_DATE | ORIGINAL_DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | 2026-01-01 | 2026-01-01 | 1 | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 |
Example values from field definitions
- STEP_NOR
- 1
- CREATE_IDR
- SAMPLE
- KEY_VALUE_1R
- SAMPLE
- TIMELINE_NORPK
- 1
- TIMELINE_KEYRPK
- 1
- TIMELINE_TYPER
- SAMPLE
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- BASE_DATE
- 2026-01-01
- 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
Rule Validation Summary
- Source Rule Count
- 30
- Governed Rule Count
- 22