Item Seasons
In ScopeTechnical: ITEM_SEASONS | ID: OR-ITM-ITEM_SEASONS-ITEM_SEASONS
This table will contain all seasons/phases for a given item. Any given item may have multiple seasons and/or multiple phases.
See how this object fits into Item Management
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
- ITEM_SEASONS
Field Definitions(5)
Rules & Considerations(24)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMRPK | PHASE_IDR | SEASON_IDR | ITEM_SEASON_SEQ_NORPK | DIFF_ID | CREATE_ID | LAST_UPDATE_ID | CREATE_DATETIME | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 |
| default | Item Seasons-002-ALT | 100003 | 100003 | 4 | ALT-ITEM_S | C LIENT_INFO | MDM_USER | 2026-01-03 | 2026-01-03 |
| default | Item Seasons-003-EDGE | 100005 | 100005 | 6 | EDGE-ITEM_ | USE RENV | BATCH_USER | 2026-01-05 | 2026-01-05 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- PHASE_IDR
- 1
- SEASON_IDR
- 1
- ITEM_SEASON_SEQ_NORPK
- 1
- DIFF_ID
- SAMPLE
- CREATE_ID
- SAMPLE
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- ITEMRPK
- Item Seasons-002-ALT
- PHASE_IDR
- 100003
- SEASON_IDR
- 100003
- ITEM_SEASON_SEQ_NORPK
- 4
- DIFF_ID
- ALT-ITEM_S
- CREATE_ID
- C LIENT_INFO
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- ITEMRPK
- Item Seasons-003-EDGE
- PHASE_IDR
- 100005
- SEASON_IDR
- 100005
- ITEM_SEASON_SEQ_NORPK
- 6
- DIFF_ID
- EDGE-ITEM_
- CREATE_ID
- USE RENV
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 50
- Governed Rule Count
- 24