Fixed Deal Related Reference Data
In ScopeTechnical: FIXED_DEAL_GL_REF_DATA | ID: OR-CST-FIXED_DEAL_GL_REF_DATA-FIXED_DEAL_GL_REFERENCE_DATA
Stores the fixed deal related reference data.
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
- FIXED_DEAL_GL_REF_DATA
Field Definitions(5)
Rules & Considerations(20)
constraint
validation
Sample Load Data(4)
| _scenario | DEPTR | DEAL_NOR | COLLECT_DATER | FIXED_DEAL_AMTR | ID | CLASS | LOCATION | LOC_TYPE | SUBCLASS | CONTRIB_RATIO | CONTRIB_AMOUNT | SET_OF_BOOKS_ID | REFERENCE_TRACE_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 2026-01-01 | 1.0000 | 1 | 1 | 1 | S | 1 | SAMPLE | 1.0000 | 1 | SAMPLE |
| default | 1003 | 4 | 2026-01-03 | 12.5000 | 3 | 1103 | 3 | F | 1113 | Fixed | 12.5000 | 1000000003 | ALT-FIXED_DEAL-002 |
| default | 1005 | 6 | 2026-01-05 | 14.0000 | 5 | 1105 | 5 | F | 1115 | Fixed | 14.0000 | 1000000005 | EDGE-FIXED_DEAL-003 |
Example values from field definitions
- DEPTR
- 1
- DEAL_NOR
- 1
- COLLECT_DATER
- 2026-01-01
- FIXED_DEAL_AMTR
- 1.0000
- ID
- 1
- CLASS
- 1
- LOCATION
- 1
- LOC_TYPE
- S
- SUBCLASS
- 1
- CONTRIB_RATIO
- SAMPLE
- CONTRIB_AMOUNT
- 1.0000
- SET_OF_BOOKS_ID
- 1
- REFERENCE_TRACE_ID
- SAMPLE
default
- DEPTR
- 1003
- DEAL_NOR
- 4
- COLLECT_DATER
- 2026-01-03
- FIXED_DEAL_AMTR
- 12.5000
- ID
- 3
- CLASS
- 1103
- LOCATION
- 3
- LOC_TYPE
- F
- SUBCLASS
- 1113
- CONTRIB_RATIO
- Fixed
- CONTRIB_AMOUNT
- 12.5000
- SET_OF_BOOKS_ID
- 1000000003
- REFERENCE_TRACE_ID
- ALT-FIXED_DEAL-002
default
- DEPTR
- 1005
- DEAL_NOR
- 6
- COLLECT_DATER
- 2026-01-05
- FIXED_DEAL_AMTR
- 14.0000
- ID
- 5
- CLASS
- 1105
- LOCATION
- 5
- LOC_TYPE
- F
- SUBCLASS
- 1115
- CONTRIB_RATIO
- Fixed
- CONTRIB_AMOUNT
- 14.0000
- SET_OF_BOOKS_ID
- 1000000005
- REFERENCE_TRACE_ID
- EDGE-FIXED_DEAL-003
Rule Validation Summary
- Source Rule Count
- 38
- Governed Rule Count
- 20