Differentiator Ratio Header
In ScopeTechnical: DIFF_RATIO_HEAD | ID: OR-ITM-DIFF_RATIO_HEAD-DIFFERENTIATOR_RATIO_HEADER
This table will hold all the dept/class/subclass parameters that are used to build size ratios.
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_HEAD
Field Definitions(5)
Rules & Considerations(28)
constraint
validation
Sample Load Data(4)
| _scenario | DEPTR | CLASSR | SUBCLASSR | DESCRIPTIONR | DIFF_RATIO_IDRPK | END_DATE | START_DATE | UPDATE_IND | WEEKS_BACK | PERIOD_TYPE | DIFF_GROUP_1 | DIFF_GROUP_2 | DIFF_GROUP_3 | REVIEW_WEEKS | PROM_SALES_IND | SYSTEM_GEN_IND | CLEAR_SALES_IND | LAST_REVIEW_DATE | REGULAR_SALES_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | SAMPLE | 1 | 2026-01-01 | 2026-01-01 | S | 1 | S | SAMPLE | SAMPLE | SAMPLE | 1 | S | S | S | 2026-01-01 | S |
| default | 1003 | 1103 | 1113 | Diff Ratio Head-002-ALT | 100003 | 2026-01-03 | 2026-01-03 | 2 | 3 | W | Diff Ratio | Diff Ratio | Diff Ratio | 3 | D | D | D | 2026-01-03 | D |
| default | 1005 | 1105 | 1115 | Diff Ratio Head-003-EDGE | 100005 | 2026-01-05 | 2026-01-05 | 2 | 5 | D | Diff Ratio | Diff Ratio | Diff Ratio | 5 | D | D | D | 2026-01-05 | D |
Example values from field definitions
- DEPTR
- 1
- CLASSR
- 1
- SUBCLASSR
- 1
- DESCRIPTIONR
- SAMPLE
- DIFF_RATIO_IDRPK
- 1
- END_DATE
- 2026-01-01
- START_DATE
- 2026-01-01
- UPDATE_IND
- S
- WEEKS_BACK
- 1
- PERIOD_TYPE
- S
- DIFF_GROUP_1
- SAMPLE
- DIFF_GROUP_2
- SAMPLE
- DIFF_GROUP_3
- SAMPLE
- REVIEW_WEEKS
- 1
- PROM_SALES_IND
- S
- SYSTEM_GEN_IND
- S
- CLEAR_SALES_IND
- S
- LAST_REVIEW_DATE
- 2026-01-01
- REGULAR_SALES_IND
- S
default
- DEPTR
- 1003
- CLASSR
- 1103
- SUBCLASSR
- 1113
- DESCRIPTIONR
- Diff Ratio Head-002-ALT
- DIFF_RATIO_IDRPK
- 100003
- END_DATE
- 2026-01-03
- START_DATE
- 2026-01-03
- UPDATE_IND
- 2
- WEEKS_BACK
- 3
- PERIOD_TYPE
- W
- DIFF_GROUP_1
- Diff Ratio
- DIFF_GROUP_2
- Diff Ratio
- DIFF_GROUP_3
- Diff Ratio
- REVIEW_WEEKS
- 3
- PROM_SALES_IND
- D
- SYSTEM_GEN_IND
- D
- CLEAR_SALES_IND
- D
- LAST_REVIEW_DATE
- 2026-01-03
- REGULAR_SALES_IND
- D
default
- DEPTR
- 1005
- CLASSR
- 1105
- SUBCLASSR
- 1115
- DESCRIPTIONR
- Diff Ratio Head-003-EDGE
- DIFF_RATIO_IDRPK
- 100005
- END_DATE
- 2026-01-05
- START_DATE
- 2026-01-05
- UPDATE_IND
- 2
- WEEKS_BACK
- 5
- PERIOD_TYPE
- D
- DIFF_GROUP_1
- Diff Ratio
- DIFF_GROUP_2
- Diff Ratio
- DIFF_GROUP_3
- Diff Ratio
- REVIEW_WEEKS
- 5
- PROM_SALES_IND
- D
- SYSTEM_GEN_IND
- D
- CLEAR_SALES_IND
- D
- LAST_REVIEW_DATE
- 2026-01-05
- REGULAR_SALES_IND
- D
Rule Validation Summary
- Source Rule Count
- 36
- Governed Rule Count
- 28