Timeline
In ScopeTechnical: TIMELINE | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- TIMELINE
Field Definitions(17)
Rules & Considerations(49)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 0002 | USERENV | Timeline-001 | 000002 | 000001 | Timeline-001 | MIG_USER | 2026-01-01 | 2026-01-01 | 2026-01-01 | 2026-01-01 | 0001 | Timeline-001 | STD-TIMELINE-001 | Timeline-001 | 2026-01-01 | 2026-01-01 |
default
- STEP_NOR
- 0002
- CREATE_IDR
- USERENV
- KEY_VALUE_1R
- Timeline-001
- TIMELINE_NORPK
- 000002
- TIMELINE_KEYRPK
- 000001
- TIMELINE_TYPER
- Timeline-001
- LAST_UPDATE_IDR
- MIG_USER
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- BASE_DATE
- 2026-01-01
- ACTUAL_DATE
- 2026-01-01
- DISPLAY_SEQ
- 0001
- KEY_VALUE_2
- Timeline-001
- REASON_CODE
- STD-TIMELINE-001
- COMMENT_DESC
- Timeline-001
- REVISED_DATE
- 2026-01-01
- ORIGINAL_DATE
- 2026-01-01