Season Mfqueue
In ScopeTechnical: SEASON_MFQUEUE | ID: OR-REPL-SEASON_MFQUEUE-SEASON_MFQUEUE
A staging table for seasons and phases message as they wait to be sent over to the RIB.
See how this object fits into Replenishment
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
- SEASON_MFQUEUE
Field Definitions(5)
Rules & Considerations(13)
Sample Load Data(4)
| _scenario | SEQ_NORPK | FAMILY | END_DATE | PHASE_ID | SEASON_ID | THREAD_NO | PHASE_DESC | PUB_STATUS | START_DATE | SEASON_DESC | MESSAGE_TYPE | TRANSACTION_NUMBER | CUSTOM_MESSAGE_TYPE | TRANSACTION_TIME_STAMP |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 2026-01-01 | 1 | 1 | 1 | SAMPLE | S | 2026-01-01 | SAMPLE | SAMPLE | 1 | S | 2026-01-01 |
| Closed record for historical season. | 2 | Footwear | 20251231 | 2 | 2 | 1 | Phase 2 Launch | U | 20250801 | Fall 2025 | Insert | 1002 | B | 2025-08-01 |
| New season with minimal data fields. | 3 | — | 99991231 | 3 | 3 | — | — | — | 20270301 | — | — | 1003 | — | — |
Example values from field definitions
- SEQ_NORPK
- 1
- FAMILY
- SAMPLE
- END_DATE
- 2026-01-01
- PHASE_ID
- 1
- SEASON_ID
- 1
- THREAD_NO
- 1
- PHASE_DESC
- SAMPLE
- PUB_STATUS
- S
- START_DATE
- 2026-01-01
- SEASON_DESC
- SAMPLE
- MESSAGE_TYPE
- SAMPLE
- TRANSACTION_NUMBER
- 1
- CUSTOM_MESSAGE_TYPE
- S
- TRANSACTION_TIME_STAMP
- 2026-01-01
Closed record for historical season.
- SEQ_NORPK
- 2
- FAMILY
- Footwear
- END_DATE
- 20251231
- PHASE_ID
- 2
- SEASON_ID
- 2
- THREAD_NO
- 1
- PHASE_DESC
- Phase 2 Launch
- PUB_STATUS
- U
- START_DATE
- 20250801
- SEASON_DESC
- Fall 2025
- MESSAGE_TYPE
- Insert
- TRANSACTION_NUMBER
- 1002
- CUSTOM_MESSAGE_TYPE
- B
- TRANSACTION_TIME_STAMP
- 2025-08-01
New season with minimal data fields.
- SEQ_NORPK
- 3
- FAMILY
- —
- END_DATE
- 99991231
- PHASE_ID
- 3
- SEASON_ID
- 3
- THREAD_NO
- —
- PHASE_DESC
- —
- PUB_STATUS
- —
- START_DATE
- 20270301
- SEASON_DESC
- —
- MESSAGE_TYPE
- —
- TRANSACTION_NUMBER
- 1003
- CUSTOM_MESSAGE_TYPE
- —
- TRANSACTION_TIME_STAMP
- —
Rule Validation Summary
- Source Rule Count
- 19
- Governed Rule Count
- 13