Differentiator Ratio Detail
In ScopeTechnical: DIFF_RATIO_DETAIL | ID: OR-ITM-DIFF_RATIO_DETAIL-DIFFERENTIATOR_RATIO_DETAIL
This table will hold all of the diff ratios. All diff IDs will be members of the associated groups on the diff_ratio_head table.
See how this object fits into Item Management
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
- DIFF_RATIO_DETAIL
Field Definitions(5)
Rules & Considerations(18)
validation
constraint
Sample Load Data(4)
| _scenario | DIFF_1R | SEQ_NORPK | DIFF_RATIO_IDRPK | PCT | QTY | STORE | DIFF_2 | DIFF_3 |
|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1.0000 | 1.0000 | 1 | SAMPLE | SAMPLE |
| default | Diff Ratio | 4 | 100003 | 12.5000 | 12.5000 | 1003 | Diff Ratio | Diff Ratio |
| default | Diff Ratio | 6 | 100005 | 14.0000 | 14.0000 | 1005 | Diff Ratio | Diff Ratio |
Example values from field definitions
- DIFF_1R
- SAMPLE
- SEQ_NORPK
- 1
- DIFF_RATIO_IDRPK
- 1
- PCT
- 1.0000
- QTY
- 1.0000
- STORE
- 1
- DIFF_2
- SAMPLE
- DIFF_3
- SAMPLE
default
- DIFF_1R
- Diff Ratio
- SEQ_NORPK
- 4
- DIFF_RATIO_IDRPK
- 100003
- PCT
- 12.5000
- QTY
- 12.5000
- STORE
- 1003
- DIFF_2
- Diff Ratio
- DIFF_3
- Diff Ratio
default
- DIFF_1R
- Diff Ratio
- SEQ_NORPK
- 6
- DIFF_RATIO_IDRPK
- 100005
- PCT
- 14.0000
- QTY
- 14.0000
- STORE
- 1005
- DIFF_2
- Diff Ratio
- DIFF_3
- Diff Ratio
Rule Validation Summary
- Source Rule Count
- 24
- Governed Rule Count
- 18