Deal Perf Transaction Data
In ScopeTechnical: DEAL_PERF_TRAN_DATA | ID: OR-CST-DEAL_PERF_TRAN_DATA-DEAL_PERF_TRANSACTION_DATA
Stores the deal related transaction data that are generated throughout on-line day as well as from batch processes. Each night, specific deal related transactions on tran_data will be copied to…
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
- DEAL_PERF_TRAN_DATA
Field Definitions(28)
Rules & Considerations(36)
Sample Load Data(4)
| _scenario | DEPTR | CLASSR | UNITSR | LOCATIONR | LOC_TYPER | PGM_NAMER | SUBCLASSR | TRAN_CODER | TRAN_DATER | ITEM | AV_COST | REF_NO1 | REF_NO2 | ADJ_CODE | PACK_IND | VAT_RATE | GL_REF_NO | SALES_TYPE | STORE_TYPE | TOTAL_COST | COSTING_LOC | REF_PACK_NO | TOTAL_RETAIL | TRAN_DATA_ID | NEW_UNIT_RETAIL | OLD_UNIT_RETAIL | COSTING_LOC_TYPE | STOCKHOLDING_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1.0000 | 1 | S | SAMPLE | 1 | 1 | 2026-01-01 | SAMPLE | 1.0000 | SAMPLE | SAMPLE | S | S | 1.0000000000 | SAMPLE | S | S | 1.0000 | 1 | SAMPLE | 1.0000 | 1 | 1.0000 | 1.0000 | S | S |
Example values from field definitions
- DEPTR
- 1
- CLASSR
- 1
- UNITSR
- 1.0000
- LOCATIONR
- 1
- LOC_TYPER
- S
- PGM_NAMER
- SAMPLE
- SUBCLASSR
- 1
- TRAN_CODER
- 1
- TRAN_DATER
- 2026-01-01
- ITEM
- SAMPLE
- AV_COST
- 1.0000
- REF_NO1
- SAMPLE
- REF_NO2
- SAMPLE
- ADJ_CODE
- S
- PACK_IND
- S
- VAT_RATE
- 1.0000000000
- GL_REF_NO
- SAMPLE
- SALES_TYPE
- S
- STORE_TYPE
- S
- TOTAL_COST
- 1.0000
- COSTING_LOC
- 1
- REF_PACK_NO
- SAMPLE
- TOTAL_RETAIL
- 1.0000
- TRAN_DATA_ID
- 1
- NEW_UNIT_RETAIL
- 1.0000
- OLD_UNIT_RETAIL
- 1.0000
- COSTING_LOC_TYPE
- S
- STOCKHOLDING_IND
- S
Rule Validation Summary
- Source Rule Count
- 44
- Governed Rule Count
- 36