Temp Tran Data
In ScopeTechnical: TEMP_TRAN_DATA | ID: OR-MFCS-TEMP_TRAN_DATA
This table is used in deal income processing. It holds a temporary copy of the tran data for the items and locations that are accruing income through a bill back…
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
Field Definitions(25)
Rules & Considerations(55)
Sample Load Data(4)
| _scenario | UNITSR | TIMESTAMPR | DEPT | ITEM | CLASS | AV_COST | ADJ_CODE | LOCATION | LOC_TYPE | PACK_IND | PGM_NAME | REF_NO_1 | REF_NO_2 | SUBCLASS | VAT_RATE | GL_REF_NO | TRAN_CODE | TRAN_DATE | SALES_TYPE | TOTAL_COST | POS_TRAN_ID | TOTAL_RETAIL | NEW_UNIT_RETAIL | OLD_UNIT_RETAIL | SALES_PROCESS_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 11.0000 | 2026-01-06 | 1001 | Temp Tran Data-001 | 1101 | 11.0000 | STD-TEMP_TRAN-001 | 1 | Temp Tran Data-001 | Temp Tran Data-001 | Temp Tran Data Primary | Temp Tran Data-001 | Temp Tran Data-001 | 1111 | 11.0000 | Temp Tran Data-001 | 0001 | 2026-01-01 | Temp Tran Data-001 | 11.0000 | 1000000001 | 11.0000 | 11.0000 | 11.0000 | 1000000001 |
default
- UNITSR
- 11.0000
- TIMESTAMPR
- 2026-01-06
- DEPT
- 1001
- ITEM
- Temp Tran Data-001
- CLASS
- 1101
- AV_COST
- 11.0000
- ADJ_CODE
- STD-TEMP_TRAN-001
- LOCATION
- 1
- LOC_TYPE
- Temp Tran Data-001
- PACK_IND
- Temp Tran Data-001
- PGM_NAME
- Temp Tran Data Primary
- REF_NO_1
- Temp Tran Data-001
- REF_NO_2
- Temp Tran Data-001
- SUBCLASS
- 1111
- VAT_RATE
- 11.0000
- GL_REF_NO
- Temp Tran Data-001
- TRAN_CODE
- 0001
- TRAN_DATE
- 2026-01-01
- SALES_TYPE
- Temp Tran Data-001
- TOTAL_COST
- 11.0000
- POS_TRAN_ID
- 1000000001
- TOTAL_RETAIL
- 11.0000
- NEW_UNIT_RETAIL
- 11.0000
- OLD_UNIT_RETAIL
- 11.0000
- SALES_PROCESS_ID
- 1000000001