Temporary Transaction Data
In ScopeTechnical: TEMP_TRAN_DATA | ID: OR-CST-TEMP_TRAN_DATA-TEMPORARY_TRANSACTION_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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- TEMP_TRAN_DATA
Field Definitions(25)
Rules & Considerations(25)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1.0000 | 2026-01-01 | 1 | SAMPLE | 1 | 1.0000 | S | 1 | S | S | SAMPLE | SAMPLE | SAMPLE | 1 | 1.0000000000 | SAMPLE | 1 | 2026-01-01 | S | 1.0000 | 1 | 1.0000 | 1.0000 | 1.0000 | 1 |
Example values from field definitions
- UNITSR
- 1.0000
- TIMESTAMPR
- 2026-01-01
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- 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
- SUBCLASS
- 1
- 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
- TOTAL_RETAIL
- 1.0000
- NEW_UNIT_RETAIL
- 1.0000
- OLD_UNIT_RETAIL
- 1.0000
- SALES_PROCESS_ID
- 1
Rule Validation Summary
- Source Rule Count
- 31
- Governed Rule Count
- 25