Temp Tran Data Sum
In ScopeTechnical: TEMP_TRAN_DATA_SUM | ID: OR-MFCS-TEMP_TRAN_DATA_SUM
This table summarizes the tran data information for items and locations that are accruing income through a bill back deal.
See how this object fits into Cost
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
- TEMP_TRAN_DATA_SUM
Field Definitions(11)
Rules & Considerations(33)
Sample Load Data(4)
| _scenario | DEPTR | CLASSR | LOCATIONR | LOC_TYPER | SUBCLASSR | TRAN_DATER | SALES_TOTALR | ISSUES_TOTAL | PURCHASE_TOTAL | DEAL_COST_VARIANCE_TOTAL | DEAL_COST_ADJUSTMENT_TOTAL |
|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1001 | 1101 | Temp Tran Data Sum-001 | S | 1111 | 2026-01-01 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 |
default
- DEPTR
- 1001
- CLASSR
- 1101
- LOCATIONR
- Temp Tran Data Sum-001
- LOC_TYPER
- S
- SUBCLASSR
- 1111
- TRAN_DATER
- 2026-01-01
- SALES_TOTALR
- 11.0000
- ISSUES_TOTAL
- 11.0000
- PURCHASE_TOTAL
- 11.0000
- DEAL_COST_VARIANCE_TOTAL
- 11.0000
- DEAL_COST_ADJUSTMENT_TOTAL
- 11.0000