Transaction Data
In ScopeTechnical: TRAN_DATA | ID: OR-FIN-TRAN_DATA-TRANSACTION_DATA
Stores the stock ledger financial transaction data that are generated throughout on-line day as well as from batch processes which affect the stock ledger. Each night, all transactions on the…
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
- TRAN_DATA
Field Definitions(33)
Rules & Considerations(43)
Sample Load Data(4)
| _scenario | DEPTRPK | CLASSR | UNITSR | LOCATIONR | LOC_TYPER | PGM_NAMER | SUBCLASSR | TIMESTAMPR | TRAN_CODERPK | 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 | SALES_PROCESS_ID | DEAL_TOTAL_RETAIL | TOTAL_COST_EXCL_ELC |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1.0000 | 1 | S | SAMPLE | 1 | 2026-01-01 | 1 | 2026-01-01 | 2026-01-01 | SAMPLE | 1.0000 | S | S | SAMPLE | SAMPLE | 1.0000000000 | SAMPLE | S | 1.0000 | 1 | SAMPLE | 1.0000 | 1 | 1 | S | 1.0000 | 1.0000 | 1.0000 | 1 | 1.0000 | 1.0000 |
Example values from field definitions
- DEPTRPK
- 1
- CLASSR
- 1
- UNITSR
- 1.0000
- LOCATIONR
- 1
- LOC_TYPER
- S
- PGM_NAMER
- SAMPLE
- SUBCLASSR
- 1
- TIMESTAMPR
- 2026-01-01
- TRAN_CODERPK
- 1
- TRAN_DATER
- 2026-01-01
- RECORD_SYS_DATER
- 2026-01-01
- ITEM
- SAMPLE
- AV_COST
- 1.0000
- ADJ_CODE
- S
- PACK_IND
- S
- REF_NO_1
- SAMPLE
- REF_NO_2
- SAMPLE
- VAT_RATE
- 1.0000000000
- GL_REF_NO
- SAMPLE
- 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
- SALES_PROCESS_ID
- 1
- DEAL_TOTAL_RETAIL
- 1.0000
- TOTAL_COST_EXCL_ELC
- 1.0000
Rule Validation Summary
- Source Rule Count
- 54
- Governed Rule Count
- 43