IF Transaction Data
In ScopeTechnical: IF_TRAN_DATA | ID: OR-FIN-IF_TRAN_DATA-IF_TRANSACTION_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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- IF_TRAN_DATA
Field Definitions(5)
Rules & Considerations(40)
constraint
validation
Sample Load Data(4)
| _scenario | DEPTR | CLASSR | SUBCLASSR | ITEM | UNITS | AV_COST | ADJ_CODE | LOCATION | LOC_TYPE | PACK_IND | PGM_NAME | REF_NO_1 | REF_NO_2 | VAT_RATE | GL_REF_NO | TRAN_CODE | TRAN_DATE | 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 | RECORD_SYS_DATE | PROCESSING_VDATE | SALES_PROCESS_ID | DEAL_TOTAL_RETAIL | TOTAL_COST_EXCL_ELC | TRAN_DATA_TIMESTAMP |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | SAMPLE | 1.0000 | 1.0000 | S | 1 | S | S | SAMPLE | SAMPLE | SAMPLE | 1.0000000000 | SAMPLE | 1 | 2026-01-01 | S | 1.0000 | 1 | SAMPLE | 1.0000 | 1 | 1 | S | 1.0000 | 1.0000 | 1.0000 | 2026-01-01 | 2026-01-01 | 1 | 1.0000 | 1.0000 | 2026-01-01 |
| default | 1003 | 1103 | 1113 | IF Tran Data-002-ALT | 12.5000 | 12.5000 | R | 3 | W | I | IF Tran Data Secondary | IF Tran Data-002-ALT | IF Tran Data-002-ALT | 12.5000000000 | IF Tran Data-002-ALT | 3 | 2026-01-03 | v | 12.5000 | 1000000003 | IF Tran Data-002-ALT | 12.5000 | 1000000003 | 3 | I | 12.5000 | 12.5000 | 12.5000 | 2026-01-03 | 2026-01-03 | 1000000003 | 12.5000 | 12.5000 | 2026-02-09 |
| default | 1005 | 1105 | 1115 | IF Tran Data-003-EDGE | 14.0000 | 14.0000 | U | 5 | E | I | IF Tran Data Core | IF Tran Data-003-EDGE | IF Tran Data-003-EDGE | 14.0000000000 | IF Tran Data-003-EDGE | 5 | 2026-01-05 | v | 14.0000 | 1000000005 | IF Tran Data-003-EDGE | 14.0000 | 1000000005 | 5 | I | 14.0000 | 14.0000 | 14.0000 | 2026-01-05 | 2026-01-05 | 1000000005 | 14.0000 | 14.0000 | 2026-03-12 |
Example values from field definitions
- DEPTR
- 1
- CLASSR
- 1
- SUBCLASSR
- 1
- ITEM
- SAMPLE
- UNITS
- 1.0000
- AV_COST
- 1.0000
- ADJ_CODE
- S
- LOCATION
- 1
- LOC_TYPE
- S
- PACK_IND
- S
- PGM_NAME
- SAMPLE
- REF_NO_1
- SAMPLE
- REF_NO_2
- SAMPLE
- VAT_RATE
- 1.0000000000
- GL_REF_NO
- SAMPLE
- TRAN_CODE
- 1
- TRAN_DATE
- 2026-01-01
- SALES_TYPE
- S
- TOTAL_COST
- 1.0000
- POS_TRAN_ID
- 1
- REF_PACK_NO
- SAMPLE
- TOTAL_RETAIL
- 1.0000
- TRAN_DATA_ID
- 1
- DEAL_LOCATION
- 1
- DEAL_LOC_TYPE
- S
- DEAL_TOTAL_COST
- 1.0000
- NEW_UNIT_RETAIL
- 1.0000
- OLD_UNIT_RETAIL
- 1.0000
- RECORD_SYS_DATE
- 2026-01-01
- PROCESSING_VDATE
- 2026-01-01
- SALES_PROCESS_ID
- 1
- DEAL_TOTAL_RETAIL
- 1.0000
- TOTAL_COST_EXCL_ELC
- 1.0000
- TRAN_DATA_TIMESTAMP
- 2026-01-01
default
- DEPTR
- 1003
- CLASSR
- 1103
- SUBCLASSR
- 1113
- ITEM
- IF Tran Data-002-ALT
- UNITS
- 12.5000
- AV_COST
- 12.5000
- ADJ_CODE
- R
- LOCATION
- 3
- LOC_TYPE
- W
- PACK_IND
- I
- PGM_NAME
- IF Tran Data Secondary
- REF_NO_1
- IF Tran Data-002-ALT
- REF_NO_2
- IF Tran Data-002-ALT
- VAT_RATE
- 12.5000000000
- GL_REF_NO
- IF Tran Data-002-ALT
- TRAN_CODE
- 3
- TRAN_DATE
- 2026-01-03
- SALES_TYPE
- v
- TOTAL_COST
- 12.5000
- POS_TRAN_ID
- 1000000003
- REF_PACK_NO
- IF Tran Data-002-ALT
- TOTAL_RETAIL
- 12.5000
- TRAN_DATA_ID
- 1000000003
- DEAL_LOCATION
- 3
- DEAL_LOC_TYPE
- I
- DEAL_TOTAL_COST
- 12.5000
- NEW_UNIT_RETAIL
- 12.5000
- OLD_UNIT_RETAIL
- 12.5000
- RECORD_SYS_DATE
- 2026-01-03
- PROCESSING_VDATE
- 2026-01-03
- SALES_PROCESS_ID
- 1000000003
- DEAL_TOTAL_RETAIL
- 12.5000
- TOTAL_COST_EXCL_ELC
- 12.5000
- TRAN_DATA_TIMESTAMP
- 2026-02-09
default
- DEPTR
- 1005
- CLASSR
- 1105
- SUBCLASSR
- 1115
- ITEM
- IF Tran Data-003-EDGE
- UNITS
- 14.0000
- AV_COST
- 14.0000
- ADJ_CODE
- U
- LOCATION
- 5
- LOC_TYPE
- E
- PACK_IND
- I
- PGM_NAME
- IF Tran Data Core
- REF_NO_1
- IF Tran Data-003-EDGE
- REF_NO_2
- IF Tran Data-003-EDGE
- VAT_RATE
- 14.0000000000
- GL_REF_NO
- IF Tran Data-003-EDGE
- TRAN_CODE
- 5
- TRAN_DATE
- 2026-01-05
- SALES_TYPE
- v
- TOTAL_COST
- 14.0000
- POS_TRAN_ID
- 1000000005
- REF_PACK_NO
- IF Tran Data-003-EDGE
- TOTAL_RETAIL
- 14.0000
- TRAN_DATA_ID
- 1000000005
- DEAL_LOCATION
- 5
- DEAL_LOC_TYPE
- I
- DEAL_TOTAL_COST
- 14.0000
- NEW_UNIT_RETAIL
- 14.0000
- OLD_UNIT_RETAIL
- 14.0000
- RECORD_SYS_DATE
- 2026-01-05
- PROCESSING_VDATE
- 2026-01-05
- SALES_PROCESS_ID
- 1000000005
- DEAL_TOTAL_RETAIL
- 14.0000
- TOTAL_COST_EXCL_ELC
- 14.0000
- TRAN_DATA_TIMESTAMP
- 2026-03-12
Rule Validation Summary
- Source Rule Count
- 51
- Governed Rule Count
- 40