Tran Data
In ScopeTechnical: TRAN_DATA | ID: OR-MFCS-TRAN_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
Target Structure
- Load Approach
- Table
- Target Objects
- TRAN_DATA
Field Definitions(33)
Rules & Considerations(38)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1001 | 1101 | 11.0000 | 1 | S | Tran Data Primary | 1111 | 2026-01-06 | 0001 | 2026-01-01 | 2026-01-01 | Tran Data-001 | 11.0000 | C | Tran Data-001 | Tran Data-001 | Tran Data-001 | 11.0000 | Tran Data-001 | value | 11.0000 | 1000000001 | Tran Data-001 | 11.0000 | 1000000001 | 1 | Tran Data-001 | 11.0000 | 11.0000 | 11.0000 | 1000000001 | 11.0000 | 11.0000 |
default
- DEPTRPK
- 1001
- CLASSR
- 1101
- UNITSR
- 11.0000
- LOCATIONR
- 1
- LOC_TYPER
- S
- PGM_NAMER
- Tran Data Primary
- SUBCLASSR
- 1111
- TIMESTAMPR
- 2026-01-06
- TRAN_CODERPK
- 0001
- TRAN_DATER
- 2026-01-01
- RECORD_SYS_DATER
- 2026-01-01
- ITEM
- Tran Data-001
- AV_COST
- 11.0000
- ADJ_CODE
- C
- PACK_IND
- Tran Data-001
- REF_NO_1
- Tran Data-001
- REF_NO_2
- Tran Data-001
- VAT_RATE
- 11.0000
- GL_REF_NO
- Tran Data-001
- SALES_TYPE
- value
- TOTAL_COST
- 11.0000
- POS_TRAN_ID
- 1000000001
- REF_PACK_NO
- Tran Data-001
- TOTAL_RETAIL
- 11.0000
- TRAN_DATA_ID
- 1000000001
- DEAL_LOCATION
- 1
- DEAL_LOC_TYPE
- Tran Data-001
- DEAL_TOTAL_COST
- 11.0000
- NEW_UNIT_RETAIL
- 11.0000
- OLD_UNIT_RETAIL
- 11.0000
- SALES_PROCESS_ID
- 1000000001
- DEAL_TOTAL_RETAIL
- 11.0000
- TOTAL_COST_EXCL_ELC
- 11.0000