IF Tran Data
In ScopeTechnical: IF_TRAN_DATA | ID: OR-MFCS-IF_TRAN_DATA
This table is a staging table for financial interface and mirrors tran_data.
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
- IF_TRAN_DATA
Field Definitions(34)
Rules & Considerations(32)
Sample Load Data(4)
| _scenario | DEPTR | CLASSR | UNITSR | LOCATIONR | LOC_TYPER | PGM_NAMER | SUBCLASSR | TRAN_CODER | TRAN_DATER | RECORD_SYS_DATER | ITEM | AV_COST | ADJ_CODE | PACK_IND | REF_NO_1 | REF_NO_2 | VAT_RATE | GL_REF_NO | SALES_TYPE | TOTAL_COST | POS_TRAN_ID | REF_PACK_NO | TOTAL_RETAIL | TRAN_DATA_ID | DEAL_LOCATION | DEAL_LOC_TYPE | DEAL_TOTAL_COST | NEW_UNIT_RETAIL | OLD_UNIT_RETAIL | PROCESSING_VDATE | SALES_PROCESS_ID | DEAL_TOTAL_RETAIL | TOTAL_COST_EXCL_ELC | TRAN_DATA_TIMESTAMP |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1001 | 1101 | 11.0000 | 1 | S | IF Tran Data Primary | 1111 | 0001 | 2026-01-01 | 2026-01-01 | IF Tran Data-001 | 11.0000 | C | IF Tran Data-001 | IF Tran Data-001 | IF Tran Data-001 | 11.0000 | IF Tran Data-001 | value | 11.0000 | 1000000001 | IF Tran Data-001 | 11.0000 | 1000000001 | 1 | IF Tran Data-001 | 11.0000 | 11.0000 | 11.0000 | 2026-01-01 | 1000000001 | 11.0000 | 11.0000 | 2026-01-06 |
default
- DEPTR
- 1001
- CLASSR
- 1101
- UNITSR
- 11.0000
- LOCATIONR
- 1
- LOC_TYPER
- S
- PGM_NAMER
- IF Tran Data Primary
- SUBCLASSR
- 1111
- TRAN_CODER
- 0001
- TRAN_DATER
- 2026-01-01
- RECORD_SYS_DATER
- 2026-01-01
- ITEM
- IF Tran Data-001
- AV_COST
- 11.0000
- ADJ_CODE
- C
- PACK_IND
- IF Tran Data-001
- REF_NO_1
- IF Tran Data-001
- REF_NO_2
- IF Tran Data-001
- VAT_RATE
- 11.0000
- GL_REF_NO
- IF Tran Data-001
- SALES_TYPE
- value
- TOTAL_COST
- 11.0000
- POS_TRAN_ID
- 1000000001
- REF_PACK_NO
- IF Tran Data-001
- TOTAL_RETAIL
- 11.0000
- TRAN_DATA_ID
- 1000000001
- DEAL_LOCATION
- 1
- DEAL_LOC_TYPE
- IF Tran Data-001
- DEAL_TOTAL_COST
- 11.0000
- NEW_UNIT_RETAIL
- 11.0000
- OLD_UNIT_RETAIL
- 11.0000
- PROCESSING_VDATE
- 2026-01-01
- SALES_PROCESS_ID
- 1000000001
- DEAL_TOTAL_RETAIL
- 11.0000
- TOTAL_COST_EXCL_ELC
- 11.0000
- TRAN_DATA_TIMESTAMP
- 2026-01-06