Week Data
In ScopeTechnical: WEEK_DATA | ID: OR-FIN-WEEK_DATA-WEEK_DATA
This table provides a history, by week, of all dollar figures that are maintained by stock ledger module. This table contains one row for each subclass/location/half/week number combination within the…
See how this object fits into Finance
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
- WEEK_DATA
Field Definitions(98)
Rules & Considerations(110)
constraint
validation
Sample Load Data(4)
| _scenario | DEPTRPK | CLASSR | HALF_NORPK | WEEK_NOR | EOW_DATER | LOCATIONR | LOC_TYPER | MONTH_NOR | SUBCLASSR | CURRENCY_INDR | SET_OF_BOOKS_IDR | VAT_IN | VAT_OUT | RTV_COST | PURCH_COST | RTV_RETAIL | SALES_UNITS | TSF_IN_COST | CLS_STK_COST | FREIGHT_COST | OPN_STK_COST | PURCH_RETAIL | RETURNS_COST | TSF_OUT_COST | WORKROOM_AMT | CASH_DISC_AMT | HTD_GAFS_COST | MARKUP_RETAIL | TSF_IN_RETAIL | CLS_STK_RETAIL | CUM_MARKON_PCT | NET_SALES_COST | OPN_STK_RETAIL | RESTOCKING_FEE | RETURNS_RETAIL | SHRINKAGE_COST | STOCK_ADJ_COST | TSF_OUT_RETAIL | HTD_GAFS_RETAIL | RECLASS_IN_COST | RECOVERABLE_TAX | UP_CHRG_AMT_EXP | EMPL_DISC_RETAIL | GROSS_MARGIN_AMT | NET_SALES_RETAIL | RECLASS_OUT_COST | SHRINKAGE_RETAIL | STOCK_ADJ_RETAIL | TSF_IN_BOOK_COST | COST_VARIANCE_AMT | DEAL_INCOME_PURCH | DEAL_INCOME_SALES | MARKUP_CAN_RETAIL | RECLASS_IN_RETAIL | TSF_OUT_BOOK_COST | DEAL_COST_VARIANCE | DEAL_INCOME_ISSUES | FREIGHT_CLAIM_COST | RECLASS_OUT_RETAIL | STOCKTAKE_ADJ_COST | TSF_IN_BOOK_RETAIL | UP_CHRG_AMT_PROFIT | INTERCOMPANY_MARGIN | INTERCOMPANY_MARKUP | MARKDOWN_CAN_RETAIL | REVERSE_TAX_IN_COST | STOCK_ADJ_COGS_COST | TSF_OUT_BOOK_RETAIL | WO_ACTIVITY_UPD_INV | DEAL_COST_ADJUSTMENT | FRANCHISE_SALES_COST | FREIGHT_CLAIM_RETAIL | INTERCOMPANY_IN_COST | MARGIN_COST_VARIANCE | PERM_MARKDOWN_RETAIL | PROM_MARKDOWN_RETAIL | RETAIL_COST_VARIANCE | STOCKTAKE_ADJ_RETAIL | WO_ACTIVITY_POST_FIN | CLEAR_MARKDOWN_RETAIL | INTERCOMPANY_MARKDOWN | INTERCOMPANY_OUT_COST | REC_COST_ADJ_VARIANCE | STOCK_ADJ_COGS_RETAIL | FRANCHISE_RETURNS_COST | FRANCHISE_SALES_RETAIL | INTERCOMPANY_IN_RETAIL | NET_SALES_NON_INV_COST | REVERSE_TAX_OUT_RETAIL | WEIGHT_VARIANCE_RETAIL | FRANCHISE_MARKUP_RETAIL | INTERCOMPANY_OUT_RETAIL | NET_SALES_RETAIL_EX_VAT | FRANCHISE_RESTOCKING_FEE | FRANCHISE_RETURNS_RETAIL | NET_SALES_NON_INV_RETAIL | FRANCHISE_MARKDOWN_RETAIL | NET_SALES_NON_INV_RTL_EX_VAT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 2026-01-01 | 1 | S | 1 | 1 | S | 1 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 |
Example values from field definitions
- DEPTRPK
- 1
- CLASSR
- 1
- HALF_NORPK
- 1
- WEEK_NOR
- 1
- EOW_DATER
- 2026-01-01
- LOCATIONR
- 1
- LOC_TYPER
- S
- MONTH_NOR
- 1
- SUBCLASSR
- 1
- CURRENCY_INDR
- S
- SET_OF_BOOKS_IDR
- 1
- VAT_IN
- 1.0000
- VAT_OUT
- 1.0000
- RTV_COST
- 1.0000
- PURCH_COST
- 1.0000
- RTV_RETAIL
- 1.0000
- SALES_UNITS
- 1.0000
- TSF_IN_COST
- 1.0000
- CLS_STK_COST
- 1.0000
- FREIGHT_COST
- 1.0000
- OPN_STK_COST
- 1.0000
- PURCH_RETAIL
- 1.0000
- RETURNS_COST
- 1.0000
- TSF_OUT_COST
- 1.0000
- WORKROOM_AMT
- 1.0000
- CASH_DISC_AMT
- 1.0000
- HTD_GAFS_COST
- 1.0000
- MARKUP_RETAIL
- 1.0000
- TSF_IN_RETAIL
- 1.0000
- CLS_STK_RETAIL
- 1.0000
- CUM_MARKON_PCT
- 1.0000
- NET_SALES_COST
- 1.0000
- OPN_STK_RETAIL
- 1.0000
- RESTOCKING_FEE
- 1.0000
- RETURNS_RETAIL
- 1.0000
- SHRINKAGE_COST
- 1.0000
- STOCK_ADJ_COST
- 1.0000
- TSF_OUT_RETAIL
- 1.0000
- HTD_GAFS_RETAIL
- 1.0000
- RECLASS_IN_COST
- 1.0000
- RECOVERABLE_TAX
- 1.0000
- UP_CHRG_AMT_EXP
- 1.0000
- EMPL_DISC_RETAIL
- 1.0000
- GROSS_MARGIN_AMT
- 1.0000
- NET_SALES_RETAIL
- 1.0000
- RECLASS_OUT_COST
- 1.0000
- SHRINKAGE_RETAIL
- 1.0000
- STOCK_ADJ_RETAIL
- 1.0000
- TSF_IN_BOOK_COST
- 1.0000
- COST_VARIANCE_AMT
- 1.0000
- DEAL_INCOME_PURCH
- 1.0000
- DEAL_INCOME_SALES
- 1.0000
- MARKUP_CAN_RETAIL
- 1.0000
- RECLASS_IN_RETAIL
- 1.0000
- TSF_OUT_BOOK_COST
- 1.0000
- DEAL_COST_VARIANCE
- 1.0000
- DEAL_INCOME_ISSUES
- 1.0000
- FREIGHT_CLAIM_COST
- 1.0000
- RECLASS_OUT_RETAIL
- 1.0000
- STOCKTAKE_ADJ_COST
- 1.0000
- TSF_IN_BOOK_RETAIL
- 1.0000
- UP_CHRG_AMT_PROFIT
- 1.0000
- INTERCOMPANY_MARGIN
- 1.0000
- INTERCOMPANY_MARKUP
- 1.0000
- MARKDOWN_CAN_RETAIL
- 1.0000
- REVERSE_TAX_IN_COST
- 1.0000
- STOCK_ADJ_COGS_COST
- 1.0000
- TSF_OUT_BOOK_RETAIL
- 1.0000
- WO_ACTIVITY_UPD_INV
- 1.0000
- DEAL_COST_ADJUSTMENT
- 1.0000
- FRANCHISE_SALES_COST
- 1.0000
- FREIGHT_CLAIM_RETAIL
- 1.0000
- INTERCOMPANY_IN_COST
- 1.0000
- MARGIN_COST_VARIANCE
- 1.0000
- PERM_MARKDOWN_RETAIL
- 1.0000
- PROM_MARKDOWN_RETAIL
- 1.0000
- RETAIL_COST_VARIANCE
- 1.0000
- STOCKTAKE_ADJ_RETAIL
- 1.0000
- WO_ACTIVITY_POST_FIN
- 1.0000
- CLEAR_MARKDOWN_RETAIL
- 1.0000
- INTERCOMPANY_MARKDOWN
- 1.0000
- INTERCOMPANY_OUT_COST
- 1.0000
- REC_COST_ADJ_VARIANCE
- 1.0000
- STOCK_ADJ_COGS_RETAIL
- 1.0000
- FRANCHISE_RETURNS_COST
- 1.0000
- FRANCHISE_SALES_RETAIL
- 1.0000
- INTERCOMPANY_IN_RETAIL
- 1.0000
- NET_SALES_NON_INV_COST
- 1.0000
- REVERSE_TAX_OUT_RETAIL
- 1.0000
- WEIGHT_VARIANCE_RETAIL
- 1.0000
- FRANCHISE_MARKUP_RETAIL
- 1.0000
- INTERCOMPANY_OUT_RETAIL
- 1.0000
- NET_SALES_RETAIL_EX_VAT
- 1.0000
- FRANCHISE_RESTOCKING_FEE
- 1.0000
- FRANCHISE_RETURNS_RETAIL
- 1.0000
- NET_SALES_NON_INV_RETAIL
- 1.0000
- FRANCHISE_MARKDOWN_RETAIL
- 1.0000
- NET_SALES_NON_INV_RTL_EX_VAT
- 1.0000
Rule Validation Summary
- Source Rule Count
- 117
- Governed Rule Count
- 110