Salweek C Week
In ScopeTechnical: SALWEEK_C_WEEK | ID: OR-FND-SALWEEK_C_WEEK-SALWEEK_C_WEEK
This is a temporary table created by prepost and used by salweek.
See how this object fits into Foundation Data
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
- SALWEEK_C_WEEK
Field Definitions(5)
Rules & Considerations(32)
validation
constraint
Sample Load Data(4)
| _scenario | DEPTR | CLASSR | LOCATIONR | LOC_TYPER | SUBCLASSR | HALF_NO | WEEK_NO | EOW_DATE | WD_ROWID | CURRENCY_IND | OPN_STK_COST | CURRENCY_COST | EOW_PLUS_7_DD | EOW_PLUS_7_MM | CUM_MARKON_PCT | OPN_STK_RETAIL | CURRENCY_RETAIL | EOW_PLUS_7_YYYY | SET_OF_BOOKS_ID | STOCKTAKE_ADJ_COST | EOW_PLUS_7_YYYYMMDD | STOCKTAKE_ADJ_RETAIL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | S | 1 | 1 | 1 | SAMPLE | SAMPLE | S | 1.0000 | 1.0000 | 1 | 1 | SAMPLE | 1.0000 | 1.0000 | 1 | 1 | 1.0000 | SAMPLE | 1.0000 |
| default | 1003 | 1103 | 3 | S | 1113 | 4 | 4 | 2026-01- | Salweek C Week-002 | S | 12.5000 | 12.5000 | 3 | 3 | Salweek C Week-002-ALT | 12.5000 | 12.5000 | 3 | 1000000003 | 12.5000 | Salweek | 12.5000 |
| default | 1005 | 1105 | 5 | S | 1115 | 6 | 6 | 2026-01- | Salweek C Week-003 | S | 14.0000 | 14.0000 | 5 | 5 | Salweek C Week-003-EDGE | 14.0000 | 14.0000 | 5 | 1000000005 | 14.0000 | Salweek | 14.0000 |
Example values from field definitions
- DEPTR
- 1
- CLASSR
- 1
- LOCATIONR
- 1
- LOC_TYPER
- S
- SUBCLASSR
- 1
- HALF_NO
- 1
- WEEK_NO
- 1
- EOW_DATE
- SAMPLE
- WD_ROWID
- SAMPLE
- CURRENCY_IND
- S
- OPN_STK_COST
- 1.0000
- CURRENCY_COST
- 1.0000
- EOW_PLUS_7_DD
- 1
- EOW_PLUS_7_MM
- 1
- CUM_MARKON_PCT
- SAMPLE
- OPN_STK_RETAIL
- 1.0000
- CURRENCY_RETAIL
- 1.0000
- EOW_PLUS_7_YYYY
- 1
- SET_OF_BOOKS_ID
- 1
- STOCKTAKE_ADJ_COST
- 1.0000
- EOW_PLUS_7_YYYYMMDD
- SAMPLE
- STOCKTAKE_ADJ_RETAIL
- 1.0000
default
- DEPTR
- 1003
- CLASSR
- 1103
- LOCATIONR
- 3
- LOC_TYPER
- S
- SUBCLASSR
- 1113
- HALF_NO
- 4
- WEEK_NO
- 4
- EOW_DATE
- 2026-01-
- WD_ROWID
- Salweek C Week-002
- CURRENCY_IND
- S
- OPN_STK_COST
- 12.5000
- CURRENCY_COST
- 12.5000
- EOW_PLUS_7_DD
- 3
- EOW_PLUS_7_MM
- 3
- CUM_MARKON_PCT
- Salweek C Week-002-ALT
- OPN_STK_RETAIL
- 12.5000
- CURRENCY_RETAIL
- 12.5000
- EOW_PLUS_7_YYYY
- 3
- SET_OF_BOOKS_ID
- 1000000003
- STOCKTAKE_ADJ_COST
- 12.5000
- EOW_PLUS_7_YYYYMMDD
- Salweek
- STOCKTAKE_ADJ_RETAIL
- 12.5000
default
- DEPTR
- 1005
- CLASSR
- 1105
- LOCATIONR
- 5
- LOC_TYPER
- S
- SUBCLASSR
- 1115
- HALF_NO
- 6
- WEEK_NO
- 6
- EOW_DATE
- 2026-01-
- WD_ROWID
- Salweek C Week-003
- CURRENCY_IND
- S
- OPN_STK_COST
- 14.0000
- CURRENCY_COST
- 14.0000
- EOW_PLUS_7_DD
- 5
- EOW_PLUS_7_MM
- 5
- CUM_MARKON_PCT
- Salweek C Week-003-EDGE
- OPN_STK_RETAIL
- 14.0000
- CURRENCY_RETAIL
- 14.0000
- EOW_PLUS_7_YYYY
- 5
- SET_OF_BOOKS_ID
- 1000000005
- STOCKTAKE_ADJ_COST
- 14.0000
- EOW_PLUS_7_YYYYMMDD
- Salweek
- STOCKTAKE_ADJ_RETAIL
- 14.0000
Rule Validation Summary
- Source Rule Count
- 35
- Governed Rule Count
- 32
