Daily Data
In ScopeTechnical: DAILY_DATA | ID: OR-FIN-DAILY_DATA-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- DAILY_DATA
Field Definitions(5)
Rules & Considerations(109)
constraint
validation
Sample Load Data(4)
| _scenario | DEPTRPK | CLASSRPK | LOCATIONRPK | LOC_TYPERPK | SUBCLASSRPK | DAY_NO | VAT_IN | HALF_NO | VAT_OUT | WEEK_NO | EOW_DATE | MONTH_NO | RTV_COST | DATA_DATE | PURCH_COST | RTV_RETAIL | SALES_UNITS | TSF_IN_COST | CURRENCY_IND | 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 | SET_OF_BOOKS_ID | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | S | 1 | 1 | 1.0000 | 1 | 1.0000 | 1 | 2026-01-01 | 1 | 1.0000 | 2026-01-01 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | S | 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 | 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 |
| default | 1003 | 1103 | 3 | W | 1113 | 4 | 12.5000 | 4 | 12.5000 | 4 | 2026-01-03 | 4 | 12.5000 | 2026-01-03 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | D | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 1000000003 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 |
| default | 1005 | 1105 | 5 | E | 1115 | 6 | 14.0000 | 6 | 14.0000 | 6 | 2026-01-05 | 6 | 14.0000 | 2026-01-05 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | D | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 1000000005 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 |
Example values from field definitions
- DEPTRPK
- 1
- CLASSRPK
- 1
- LOCATIONRPK
- 1
- LOC_TYPERPK
- S
- SUBCLASSRPK
- 1
- DAY_NO
- 1
- VAT_IN
- 1.0000
- HALF_NO
- 1
- VAT_OUT
- 1.0000
- WEEK_NO
- 1
- EOW_DATE
- 2026-01-01
- MONTH_NO
- 1
- RTV_COST
- 1.0000
- DATA_DATE
- 2026-01-01
- PURCH_COST
- 1.0000
- RTV_RETAIL
- 1.0000
- SALES_UNITS
- 1.0000
- TSF_IN_COST
- 1.0000
- CURRENCY_IND
- S
- FREIGHT_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
- MARKUP_RETAIL
- 1.0000
- TSF_IN_RETAIL
- 1.0000
- NET_SALES_COST
- 1.0000
- RESTOCKING_FEE
- 1.0000
- RETURNS_RETAIL
- 1.0000
- STOCK_ADJ_COST
- 1.0000
- TSF_OUT_RETAIL
- 1.0000
- RECLASS_IN_COST
- 1.0000
- RECOVERABLE_TAX
- 1.0000
- SET_OF_BOOKS_ID
- 1
- UP_CHRG_AMT_EXP
- 1.0000
- EMPL_DISC_RETAIL
- 1.0000
- NET_SALES_RETAIL
- 1.0000
- RECLASS_OUT_COST
- 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
- TSF_IN_BOOK_RETAIL
- 1.0000
- UP_CHRG_AMT_PROFIT
- 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
- 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
default
- DEPTRPK
- 1003
- CLASSRPK
- 1103
- LOCATIONRPK
- 3
- LOC_TYPERPK
- W
- SUBCLASSRPK
- 1113
- DAY_NO
- 4
- VAT_IN
- 12.5000
- HALF_NO
- 4
- VAT_OUT
- 12.5000
- WEEK_NO
- 4
- EOW_DATE
- 2026-01-03
- MONTH_NO
- 4
- RTV_COST
- 12.5000
- DATA_DATE
- 2026-01-03
- PURCH_COST
- 12.5000
- RTV_RETAIL
- 12.5000
- SALES_UNITS
- 12.5000
- TSF_IN_COST
- 12.5000
- CURRENCY_IND
- D
- FREIGHT_COST
- 12.5000
- PURCH_RETAIL
- 12.5000
- RETURNS_COST
- 12.5000
- TSF_OUT_COST
- 12.5000
- WORKROOM_AMT
- 12.5000
- CASH_DISC_AMT
- 12.5000
- MARKUP_RETAIL
- 12.5000
- TSF_IN_RETAIL
- 12.5000
- NET_SALES_COST
- 12.5000
- RESTOCKING_FEE
- 12.5000
- RETURNS_RETAIL
- 12.5000
- STOCK_ADJ_COST
- 12.5000
- TSF_OUT_RETAIL
- 12.5000
- RECLASS_IN_COST
- 12.5000
- RECOVERABLE_TAX
- 12.5000
- SET_OF_BOOKS_ID
- 1000000003
- UP_CHRG_AMT_EXP
- 12.5000
- EMPL_DISC_RETAIL
- 12.5000
- NET_SALES_RETAIL
- 12.5000
- RECLASS_OUT_COST
- 12.5000
- STOCK_ADJ_RETAIL
- 12.5000
- TSF_IN_BOOK_COST
- 12.5000
- COST_VARIANCE_AMT
- 12.5000
- DEAL_INCOME_PURCH
- 12.5000
- DEAL_INCOME_SALES
- 12.5000
- MARKUP_CAN_RETAIL
- 12.5000
- RECLASS_IN_RETAIL
- 12.5000
- TSF_OUT_BOOK_COST
- 12.5000
- DEAL_COST_VARIANCE
- 12.5000
- DEAL_INCOME_ISSUES
- 12.5000
- FREIGHT_CLAIM_COST
- 12.5000
- RECLASS_OUT_RETAIL
- 12.5000
- TSF_IN_BOOK_RETAIL
- 12.5000
- UP_CHRG_AMT_PROFIT
- 12.5000
- INTERCOMPANY_MARKUP
- 12.5000
- MARKDOWN_CAN_RETAIL
- 12.5000
- REVERSE_TAX_IN_COST
- 12.5000
- STOCK_ADJ_COGS_COST
- 12.5000
- TSF_OUT_BOOK_RETAIL
- 12.5000
- WO_ACTIVITY_UPD_INV
- 12.5000
- DEAL_COST_ADJUSTMENT
- 12.5000
- FRANCHISE_SALES_COST
- 12.5000
- FREIGHT_CLAIM_RETAIL
- 12.5000
- INTERCOMPANY_IN_COST
- 12.5000
- MARGIN_COST_VARIANCE
- 12.5000
- PERM_MARKDOWN_RETAIL
- 12.5000
- PROM_MARKDOWN_RETAIL
- 12.5000
- RETAIL_COST_VARIANCE
- 12.5000
- WO_ACTIVITY_POST_FIN
- 12.5000
- CLEAR_MARKDOWN_RETAIL
- 12.5000
- INTERCOMPANY_MARKDOWN
- 12.5000
- INTERCOMPANY_OUT_COST
- 12.5000
- REC_COST_ADJ_VARIANCE
- 12.5000
- STOCK_ADJ_COGS_RETAIL
- 12.5000
- FRANCHISE_RETURNS_COST
- 12.5000
- FRANCHISE_SALES_RETAIL
- 12.5000
- INTERCOMPANY_IN_RETAIL
- 12.5000
- NET_SALES_NON_INV_COST
- 12.5000
- REVERSE_TAX_OUT_RETAIL
- 12.5000
- WEIGHT_VARIANCE_RETAIL
- 12.5000
- FRANCHISE_MARKUP_RETAIL
- 12.5000
- INTERCOMPANY_OUT_RETAIL
- 12.5000
- NET_SALES_RETAIL_EX_VAT
- 12.5000
- FRANCHISE_RESTOCKING_FEE
- 12.5000
- FRANCHISE_RETURNS_RETAIL
- 12.5000
- NET_SALES_NON_INV_RETAIL
- 12.5000
- FRANCHISE_MARKDOWN_RETAIL
- 12.5000
- NET_SALES_NON_INV_RTL_EX_VAT
- 12.5000
default
- DEPTRPK
- 1005
- CLASSRPK
- 1105
- LOCATIONRPK
- 5
- LOC_TYPERPK
- E
- SUBCLASSRPK
- 1115
- DAY_NO
- 6
- VAT_IN
- 14.0000
- HALF_NO
- 6
- VAT_OUT
- 14.0000
- WEEK_NO
- 6
- EOW_DATE
- 2026-01-05
- MONTH_NO
- 6
- RTV_COST
- 14.0000
- DATA_DATE
- 2026-01-05
- PURCH_COST
- 14.0000
- RTV_RETAIL
- 14.0000
- SALES_UNITS
- 14.0000
- TSF_IN_COST
- 14.0000
- CURRENCY_IND
- D
- FREIGHT_COST
- 14.0000
- PURCH_RETAIL
- 14.0000
- RETURNS_COST
- 14.0000
- TSF_OUT_COST
- 14.0000
- WORKROOM_AMT
- 14.0000
- CASH_DISC_AMT
- 14.0000
- MARKUP_RETAIL
- 14.0000
- TSF_IN_RETAIL
- 14.0000
- NET_SALES_COST
- 14.0000
- RESTOCKING_FEE
- 14.0000
- RETURNS_RETAIL
- 14.0000
- STOCK_ADJ_COST
- 14.0000
- TSF_OUT_RETAIL
- 14.0000
- RECLASS_IN_COST
- 14.0000
- RECOVERABLE_TAX
- 14.0000
- SET_OF_BOOKS_ID
- 1000000005
- UP_CHRG_AMT_EXP
- 14.0000
- EMPL_DISC_RETAIL
- 14.0000
- NET_SALES_RETAIL
- 14.0000
- RECLASS_OUT_COST
- 14.0000
- STOCK_ADJ_RETAIL
- 14.0000
- TSF_IN_BOOK_COST
- 14.0000
- COST_VARIANCE_AMT
- 14.0000
- DEAL_INCOME_PURCH
- 14.0000
- DEAL_INCOME_SALES
- 14.0000
- MARKUP_CAN_RETAIL
- 14.0000
- RECLASS_IN_RETAIL
- 14.0000
- TSF_OUT_BOOK_COST
- 14.0000
- DEAL_COST_VARIANCE
- 14.0000
- DEAL_INCOME_ISSUES
- 14.0000
- FREIGHT_CLAIM_COST
- 14.0000
- RECLASS_OUT_RETAIL
- 14.0000
- TSF_IN_BOOK_RETAIL
- 14.0000
- UP_CHRG_AMT_PROFIT
- 14.0000
- INTERCOMPANY_MARKUP
- 14.0000
- MARKDOWN_CAN_RETAIL
- 14.0000
- REVERSE_TAX_IN_COST
- 14.0000
- STOCK_ADJ_COGS_COST
- 14.0000
- TSF_OUT_BOOK_RETAIL
- 14.0000
- WO_ACTIVITY_UPD_INV
- 14.0000
- DEAL_COST_ADJUSTMENT
- 14.0000
- FRANCHISE_SALES_COST
- 14.0000
- FREIGHT_CLAIM_RETAIL
- 14.0000
- INTERCOMPANY_IN_COST
- 14.0000
- MARGIN_COST_VARIANCE
- 14.0000
- PERM_MARKDOWN_RETAIL
- 14.0000
- PROM_MARKDOWN_RETAIL
- 14.0000
- RETAIL_COST_VARIANCE
- 14.0000
- WO_ACTIVITY_POST_FIN
- 14.0000
- CLEAR_MARKDOWN_RETAIL
- 14.0000
- INTERCOMPANY_MARKDOWN
- 14.0000
- INTERCOMPANY_OUT_COST
- 14.0000
- REC_COST_ADJ_VARIANCE
- 14.0000
- STOCK_ADJ_COGS_RETAIL
- 14.0000
- FRANCHISE_RETURNS_COST
- 14.0000
- FRANCHISE_SALES_RETAIL
- 14.0000
- INTERCOMPANY_IN_RETAIL
- 14.0000
- NET_SALES_NON_INV_COST
- 14.0000
- REVERSE_TAX_OUT_RETAIL
- 14.0000
- WEIGHT_VARIANCE_RETAIL
- 14.0000
- FRANCHISE_MARKUP_RETAIL
- 14.0000
- INTERCOMPANY_OUT_RETAIL
- 14.0000
- NET_SALES_RETAIL_EX_VAT
- 14.0000
- FRANCHISE_RESTOCKING_FEE
- 14.0000
- FRANCHISE_RETURNS_RETAIL
- 14.0000
- NET_SALES_NON_INV_RETAIL
- 14.0000
- FRANCHISE_MARKDOWN_RETAIL
- 14.0000
- NET_SALES_NON_INV_RTL_EX_VAT
- 14.0000
Rule Validation Summary
- Source Rule Count
- 116
- Governed Rule Count
- 109