Daily Data Backpost
In ScopeTechnical: DAILY_DATA_BACKPOST | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- DAILY_DATA_BACKPOST
Field Definitions(70)
Rules & Considerations(11)
Sample Load Data(4)
| _scenario | DEPTR | CLASSR | LOCATIONR | LOC_TYPER | SUBCLASSR | DATA_DATER | SET_OF_BOOKS_IDR | VAT_IN | VAT_OUT | RTV_COST | 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 | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1001 | 1101 | 1 | S | 1111 | 2026-01-01 | 1000000001 | 11.0000 | 11.0000 | 11.0000 | 2026-01-01 | 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
- DEPTR
- 1001
- CLASSR
- 1101
- LOCATIONR
- 1
- LOC_TYPER
- S
- SUBCLASSR
- 1111
- DATA_DATER
- 2026-01-01
- SET_OF_BOOKS_IDR
- 1000000001
- VAT_IN
- 11.0000
- VAT_OUT
- 11.0000
- RTV_COST
- 11.0000
- POST_DATE
- 2026-01-01
- 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
- 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
- MARKUP_CAN_RETAIL
- 11.0000
- RECLASS_IN_RETAIL
- 11.0000
- TSF_OUT_BOOK_COST
- 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
- FRANCHISE_SALES_COST
- 11.0000
- FREIGHT_CLAIM_RETAIL
- 11.0000
- INTERCOMPANY_IN_COST
- 11.0000
- PERM_MARKDOWN_RETAIL
- 11.0000
- PROM_MARKDOWN_RETAIL
- 11.0000
- WO_ACTIVITY_POST_FIN
- 11.0000
- CLEAR_MARKDOWN_RETAIL
- 11.0000
- INTERCOMPANY_MARKDOWN
- 11.0000
- INTERCOMPANY_OUT_COST
- 11.0000
- STOCK_ADJ_COGS_RETAIL
- 11.0000
- FRANCHISE_RETURNS_COST
- 11.0000
- FRANCHISE_SALES_RETAIL
- 11.0000
- INTERCOMPANY_IN_RETAIL
- 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
- FRANCHISE_MARKDOWN_RETAIL
- 11.0000