Deal Threshold Rev
In ScopeTechnical: DEAL_THRESHOLD_REV | ID: OR-CST-DEAL_THRESHOLD_REV-DEAL_THRESHOLD_REV
This table will be used to hold the deal threshold revisions.
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_THRESHOLD_REV
Field Definitions(5)
Rules & Considerations(32)
validation
constraint
Sample Load Data(4)
| _scenario | REV_NORPK | DEAL_IDRPK | LOWER_LIMITRPK | UPPER_LIMITRPK | DEAL_DETAIL_IDRPK | VALUE | ACTION | REASON | TOTAL_IND | REVISION_DATE | LAST_UPDATE_ID | TARGET_LEVEL_IND | ALLOWANCE_COMP_ID | ALLOWANCE_COMP_RATE | ALLOWANCE_CALC_BASIS | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1.0000 | 1.0000 | 1 | 1.0000 | SAMPLE | SAMPLE | S | 2026-01-01 | SAMPLE | S | SAMPLE | 1.0000 | SAMPLE | 2026-01-01 |
| default | 4 | 1000000003 | 12.5000 | 12.5000 | 1000000003 | 12.5000 | U | Deal Threshold Rev-002-ALT | N | 2026-01-03 | MDM_USER | Y | ALT-DEAL_T | 12.5000 | S | 2026-01-03 |
| default | 6 | 1000000005 | 14.0000 | 14.0000 | 1000000005 | 14.0000 | I | Deal Threshold Rev-003-EDGE | N | 2026-01-05 | BATCH_USER | Y | EDGE-DEAL_ | 14.0000 | V | 2026-01-05 |
Example values from field definitions
- REV_NORPK
- 1
- DEAL_IDRPK
- 1
- LOWER_LIMITRPK
- 1.0000
- UPPER_LIMITRPK
- 1.0000
- DEAL_DETAIL_IDRPK
- 1
- VALUE
- 1.0000
- ACTION
- SAMPLE
- REASON
- SAMPLE
- TOTAL_IND
- S
- REVISION_DATE
- 2026-01-01
- LAST_UPDATE_ID
- SAMPLE
- TARGET_LEVEL_IND
- S
- ALLOWANCE_COMP_ID
- SAMPLE
- ALLOWANCE_COMP_RATE
- 1.0000
- ALLOWANCE_CALC_BASIS
- SAMPLE
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- REV_NORPK
- 4
- DEAL_IDRPK
- 1000000003
- LOWER_LIMITRPK
- 12.5000
- UPPER_LIMITRPK
- 12.5000
- DEAL_DETAIL_IDRPK
- 1000000003
- VALUE
- 12.5000
- ACTION
- U
- REASON
- Deal Threshold Rev-002-ALT
- TOTAL_IND
- N
- REVISION_DATE
- 2026-01-03
- LAST_UPDATE_ID
- MDM_USER
- TARGET_LEVEL_IND
- Y
- ALLOWANCE_COMP_ID
- ALT-DEAL_T
- ALLOWANCE_COMP_RATE
- 12.5000
- ALLOWANCE_CALC_BASIS
- S
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- REV_NORPK
- 6
- DEAL_IDRPK
- 1000000005
- LOWER_LIMITRPK
- 14.0000
- UPPER_LIMITRPK
- 14.0000
- DEAL_DETAIL_IDRPK
- 1000000005
- VALUE
- 14.0000
- ACTION
- I
- REASON
- Deal Threshold Rev-003-EDGE
- TOTAL_IND
- N
- REVISION_DATE
- 2026-01-05
- LAST_UPDATE_ID
- BATCH_USER
- TARGET_LEVEL_IND
- Y
- ALLOWANCE_COMP_ID
- EDGE-DEAL_
- ALLOWANCE_COMP_RATE
- 14.0000
- ALLOWANCE_CALC_BASIS
- V
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 68
- Governed Rule Count
- 32