Daily Data
In ScopeTechnical: DAILY_DATA | ID: OR-MFCS-DAILY_DATA
Daily stock-ledger history captured at department, class, subclass, location, date, day, week, month, and half grain, including sales, stock adjustments, purchases, returns to vendor, transfers, markdowns, retail measures, and cost…
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
Target Structure
- Load Approach
- Table
- Target Objects
- DAILY_DATA
Field Definitions(87)
Rules & Considerations(34)
Sample Load Data(4)
| _scenario | DEPTRPK | CLASSR | HALF_NORPK | EOW_DATER | LOCATIONR | LOC_TYPER | MONTH_NOR | SUBCLASSR | DATA_DATER | CURRENCY_INDR | SET_OF_BOOKS_IDR | DAY_NO | VAT_IN | VAT_OUT | WEEK_NO | RTV_COST | PURCH_COST | RTV_RETAIL | SALES_UNITS | TSF_IN_COST | FREIGHT_COST | PURCH_RETAIL | RETURNS_COST | TSF_OUT_COST | WORKROOM_AMT | CASH_DISC_AMT | MARKUP_RETAIL | TSF_IN_RETAIL | NET_SALES_COST | RESTOCKING_FEE | RETURNS_RETAIL | STOCK_ADJ_COST | TSF_OUT_RETAIL | RECLASS_IN_COST | RECOVERABLE_TAX | UP_CHRG_AMT_EXP | EMPL_DISC_RETAIL | NET_SALES_RETAIL | RECLASS_OUT_COST | 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 | TSF_IN_BOOK_RETAIL | UP_CHRG_AMT_PROFIT | 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 | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1001 | 1101 | 00002 | 2026-01-01 | 1 | S | 02 | 1111 | 2026-01-01 | Daily Data-001 | 1000000001 | 02 | 11.0000 | 11.0000 | 02 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 |
default
- DEPTRPK
- 1001
- CLASSR
- 1101
- HALF_NORPK
- 00002
- EOW_DATER
- 2026-01-01
- LOCATIONR
- 1
- LOC_TYPER
- S
- MONTH_NOR
- 02
- SUBCLASSR
- 1111
- DATA_DATER
- 2026-01-01
- CURRENCY_INDR
- Daily Data-001
- SET_OF_BOOKS_IDR
- 1000000001
- DAY_NO
- 02
- VAT_IN
- 11.0000
- VAT_OUT
- 11.0000
- WEEK_NO
- 02
- RTV_COST
- 11.0000
- PURCH_COST
- 11.0000
- RTV_RETAIL
- 11.0000
- SALES_UNITS
- 11.0000
- TSF_IN_COST
- 11.0000
- FREIGHT_COST
- 11.0000
- PURCH_RETAIL
- 11.0000
- RETURNS_COST
- 11.0000
- TSF_OUT_COST
- 11.0000
- WORKROOM_AMT
- 11.0000
- CASH_DISC_AMT
- 11.0000
- MARKUP_RETAIL
- 11.0000
- TSF_IN_RETAIL
- 11.0000
- NET_SALES_COST
- 11.0000
- RESTOCKING_FEE
- 11.0000
- RETURNS_RETAIL
- 11.0000
- STOCK_ADJ_COST
- 11.0000
- TSF_OUT_RETAIL
- 11.0000
- RECLASS_IN_COST
- 11.0000
- RECOVERABLE_TAX
- 11.0000
- UP_CHRG_AMT_EXP
- 11.0000
- EMPL_DISC_RETAIL
- 11.0000
- NET_SALES_RETAIL
- 11.0000
- RECLASS_OUT_COST
- 11.0000
- STOCK_ADJ_RETAIL
- 11.0000
- TSF_IN_BOOK_COST
- 11.0000
- COST_VARIANCE_AMT
- 11.0000
- DEAL_INCOME_PURCH
- 11.0000
- DEAL_INCOME_SALES
- 11.0000
- MARKUP_CAN_RETAIL
- 11.0000
- RECLASS_IN_RETAIL
- 11.0000
- TSF_OUT_BOOK_COST
- 11.0000
- DEAL_COST_VARIANCE
- 11.0000
- DEAL_INCOME_ISSUES
- 11.0000
- FREIGHT_CLAIM_COST
- 11.0000
- RECLASS_OUT_RETAIL
- 11.0000
- TSF_IN_BOOK_RETAIL
- 11.0000
- UP_CHRG_AMT_PROFIT
- 11.0000
- INTERCOMPANY_MARKUP
- 11.0000
- MARKDOWN_CAN_RETAIL
- 11.0000
- REVERSE_TAX_IN_COST
- 11.0000
- STOCK_ADJ_COGS_COST
- 11.0000
- TSF_OUT_BOOK_RETAIL
- 11.0000
- WO_ACTIVITY_UPD_INV
- 11.0000
- DEAL_COST_ADJUSTMENT
- 11.0000
- FRANCHISE_SALES_COST
- 11.0000
- FREIGHT_CLAIM_RETAIL
- 11.0000
- INTERCOMPANY_IN_COST
- 11.0000
- MARGIN_COST_VARIANCE
- 11.0000
- PERM_MARKDOWN_RETAIL
- 11.0000
- PROM_MARKDOWN_RETAIL
- 11.0000
- RETAIL_COST_VARIANCE
- 11.0000
- WO_ACTIVITY_POST_FIN
- 11.0000
- CLEAR_MARKDOWN_RETAIL
- 11.0000
- INTERCOMPANY_MARKDOWN
- 11.0000
- INTERCOMPANY_OUT_COST
- 11.0000
- REC_COST_ADJ_VARIANCE
- 11.0000
- STOCK_ADJ_COGS_RETAIL
- 11.0000
- FRANCHISE_RETURNS_COST
- 11.0000
- FRANCHISE_SALES_RETAIL
- 11.0000
- INTERCOMPANY_IN_RETAIL
- 11.0000
- NET_SALES_NON_INV_COST
- 11.0000
- REVERSE_TAX_OUT_RETAIL
- 11.0000
- WEIGHT_VARIANCE_RETAIL
- 11.0000
- FRANCHISE_MARKUP_RETAIL
- 11.0000
- INTERCOMPANY_OUT_RETAIL
- 11.0000
- NET_SALES_RETAIL_EX_VAT
- 11.0000
- FRANCHISE_RESTOCKING_FEE
- 11.0000
- FRANCHISE_RETURNS_RETAIL
- 11.0000
- NET_SALES_NON_INV_RETAIL
- 11.0000
- FRANCHISE_MARKDOWN_RETAIL
- 11.0000
- NET_SALES_NON_INV_RTL_EX_VAT
- 11.0000