Daily Data Backpost
In ScopeTechnical: DAILY_DATA_BACKPOST | ID: OR-FND-DAILY_DATA_BACKPOST-DAILY_DATA_BACKPOST
Stores the rolled up data for all back posted transactions.
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
- DAILY_DATA_BACKPOST
Field Definitions(5)
Rules & Considerations(75)
constraint
validation
Sample Load Data(4)
| _scenario | DEPTR | CLASSR | LOCATIONR | LOC_TYPER | SUBCLASSR | VAT_IN | VAT_OUT | RTV_COST | DATA_DATE | POST_DATE | 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 | 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 | MARKUP_CAN_RETAIL | RECLASS_IN_RETAIL | TSF_OUT_BOOK_COST | 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 | FRANCHISE_SALES_COST | FREIGHT_CLAIM_RETAIL | INTERCOMPANY_IN_COST | PERM_MARKDOWN_RETAIL | PROM_MARKDOWN_RETAIL | WO_ACTIVITY_POST_FIN | CLEAR_MARKDOWN_RETAIL | INTERCOMPANY_MARKDOWN | INTERCOMPANY_OUT_COST | STOCK_ADJ_COGS_RETAIL | FRANCHISE_RETURNS_COST | FRANCHISE_SALES_RETAIL | INTERCOMPANY_IN_RETAIL | REVERSE_TAX_OUT_RETAIL | WEIGHT_VARIANCE_RETAIL | FRANCHISE_MARKUP_RETAIL | INTERCOMPANY_OUT_RETAIL | NET_SALES_RETAIL_EX_VAT | FRANCHISE_RESTOCKING_FEE | FRANCHISE_RETURNS_RETAIL | FRANCHISE_MARKDOWN_RETAIL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | S | 1 | 1.0000 | 1.0000 | 1.0000 | 2026-01-01 | 2026-01-01 | 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 | 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 | 12.5000 | 12.5000 | 12.5000 | 2026-01-03 | 2026-01-03 | 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 | 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 |
| default | 1005 | 1105 | 5 | E | 1115 | 14.0000 | 14.0000 | 14.0000 | 2026-01-05 | 2026-01-05 | 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 | 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 |
Example values from field definitions
- DEPTR
- 1
- CLASSR
- 1
- LOCATIONR
- 1
- LOC_TYPER
- S
- SUBCLASSR
- 1
- VAT_IN
- 1.0000
- VAT_OUT
- 1.0000
- RTV_COST
- 1.0000
- DATA_DATE
- 2026-01-01
- POST_DATE
- 2026-01-01
- PURCH_COST
- 1.0000
- RTV_RETAIL
- 1.0000
- SALES_UNITS
- 1.0000
- TSF_IN_COST
- 1.0000
- 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
- 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
- MARKUP_CAN_RETAIL
- 1.0000
- RECLASS_IN_RETAIL
- 1.0000
- TSF_OUT_BOOK_COST
- 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
- FRANCHISE_SALES_COST
- 1.0000
- FREIGHT_CLAIM_RETAIL
- 1.0000
- INTERCOMPANY_IN_COST
- 1.0000
- PERM_MARKDOWN_RETAIL
- 1.0000
- PROM_MARKDOWN_RETAIL
- 1.0000
- WO_ACTIVITY_POST_FIN
- 1.0000
- CLEAR_MARKDOWN_RETAIL
- 1.0000
- INTERCOMPANY_MARKDOWN
- 1.0000
- INTERCOMPANY_OUT_COST
- 1.0000
- STOCK_ADJ_COGS_RETAIL
- 1.0000
- FRANCHISE_RETURNS_COST
- 1.0000
- FRANCHISE_SALES_RETAIL
- 1.0000
- INTERCOMPANY_IN_RETAIL
- 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
- FRANCHISE_MARKDOWN_RETAIL
- 1.0000
default
- DEPTR
- 1003
- CLASSR
- 1103
- LOCATIONR
- 3
- LOC_TYPER
- W
- SUBCLASSR
- 1113
- VAT_IN
- 12.5000
- VAT_OUT
- 12.5000
- RTV_COST
- 12.5000
- DATA_DATE
- 2026-01-03
- POST_DATE
- 2026-01-03
- PURCH_COST
- 12.5000
- RTV_RETAIL
- 12.5000
- SALES_UNITS
- 12.5000
- TSF_IN_COST
- 12.5000
- 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
- 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
- MARKUP_CAN_RETAIL
- 12.5000
- RECLASS_IN_RETAIL
- 12.5000
- TSF_OUT_BOOK_COST
- 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
- FRANCHISE_SALES_COST
- 12.5000
- FREIGHT_CLAIM_RETAIL
- 12.5000
- INTERCOMPANY_IN_COST
- 12.5000
- PERM_MARKDOWN_RETAIL
- 12.5000
- PROM_MARKDOWN_RETAIL
- 12.5000
- WO_ACTIVITY_POST_FIN
- 12.5000
- CLEAR_MARKDOWN_RETAIL
- 12.5000
- INTERCOMPANY_MARKDOWN
- 12.5000
- INTERCOMPANY_OUT_COST
- 12.5000
- STOCK_ADJ_COGS_RETAIL
- 12.5000
- FRANCHISE_RETURNS_COST
- 12.5000
- FRANCHISE_SALES_RETAIL
- 12.5000
- INTERCOMPANY_IN_RETAIL
- 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
- FRANCHISE_MARKDOWN_RETAIL
- 12.5000
default
- DEPTR
- 1005
- CLASSR
- 1105
- LOCATIONR
- 5
- LOC_TYPER
- E
- SUBCLASSR
- 1115
- VAT_IN
- 14.0000
- VAT_OUT
- 14.0000
- RTV_COST
- 14.0000
- DATA_DATE
- 2026-01-05
- POST_DATE
- 2026-01-05
- PURCH_COST
- 14.0000
- RTV_RETAIL
- 14.0000
- SALES_UNITS
- 14.0000
- TSF_IN_COST
- 14.0000
- 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
- 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
- MARKUP_CAN_RETAIL
- 14.0000
- RECLASS_IN_RETAIL
- 14.0000
- TSF_OUT_BOOK_COST
- 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
- FRANCHISE_SALES_COST
- 14.0000
- FREIGHT_CLAIM_RETAIL
- 14.0000
- INTERCOMPANY_IN_COST
- 14.0000
- PERM_MARKDOWN_RETAIL
- 14.0000
- PROM_MARKDOWN_RETAIL
- 14.0000
- WO_ACTIVITY_POST_FIN
- 14.0000
- CLEAR_MARKDOWN_RETAIL
- 14.0000
- INTERCOMPANY_MARKDOWN
- 14.0000
- INTERCOMPANY_OUT_COST
- 14.0000
- STOCK_ADJ_COGS_RETAIL
- 14.0000
- FRANCHISE_RETURNS_COST
- 14.0000
- FRANCHISE_SALES_RETAIL
- 14.0000
- INTERCOMPANY_IN_RETAIL
- 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
- FRANCHISE_MARKDOWN_RETAIL
- 14.0000
Rule Validation Summary
- Source Rule Count
- 79
- Governed Rule Count
- 75