Data Conversion Information Specific To Clearances
In ScopeTechnical: RPM_DC_CLEARANCE | ID: OR-PRC-RPM_DC_CLEARANCE-RPM_DC_CLEARANCE
Stores data conversion information specific to clearances.
See how this object fits into Pricing & Promotions
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
- RPM_DC_CLEARANCE
Field Definitions(5)
Rules & Considerations(19)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMR | ZONE_NODE_IDR | ZONE_NODE_TYPER | CLEARANCE_RETAILR | STATUS | DIFF_ID | REASON_CODE | CLEARANCE_ID | ERROR_MESSAGE | MARKDOWN_CODE | THREAD_NUMBER | CLEARANCE_GROUPING | CLEARANCE_GROUP_ID | CLEARANCE_GROUP_DESCRIPTIO |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1.0000 | S | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | 1 | 1 | 1 | SAMPLE |
| default | RPM Dc Clearance-002-ALT | 1000000003 | 1 | 12.5000 | N | ALT-RPM_DC | ALT-RP | 1000000003 | RPM Dc Clearance-002-ALT | ALT-RP | 3 | 3 | 1000000003 | RPM Dc Clearance-002-ALT |
| default | RPM Dc Clearance-003-EDGE | 1000000005 | 2 | 14.0000 | N | EDGE-RPM_D | EDGE-R | 1000000005 | RPM Dc Clearance-003-EDGE | EDGE-R | 5 | 5 | 1000000005 | RPM Dc Clearance-003-EDGE |
Example values from field definitions
- ITEMR
- SAMPLE
- ZONE_NODE_IDR
- 1
- ZONE_NODE_TYPER
- 1
- CLEARANCE_RETAILR
- 1.0000
- STATUS
- S
- DIFF_ID
- SAMPLE
- REASON_CODE
- SAMPLE
- CLEARANCE_ID
- 1
- ERROR_MESSAGE
- SAMPLE
- MARKDOWN_CODE
- SAMPLE
- THREAD_NUMBER
- 1
- CLEARANCE_GROUPING
- 1
- CLEARANCE_GROUP_ID
- 1
- CLEARANCE_GROUP_DESCRIPTIO
- SAMPLE
default
- ITEMR
- RPM Dc Clearance-002-ALT
- ZONE_NODE_IDR
- 1000000003
- ZONE_NODE_TYPER
- 1
- CLEARANCE_RETAILR
- 12.5000
- STATUS
- N
- DIFF_ID
- ALT-RPM_DC
- REASON_CODE
- ALT-RP
- CLEARANCE_ID
- 1000000003
- ERROR_MESSAGE
- RPM Dc Clearance-002-ALT
- MARKDOWN_CODE
- ALT-RP
- THREAD_NUMBER
- 3
- CLEARANCE_GROUPING
- 3
- CLEARANCE_GROUP_ID
- 1000000003
- CLEARANCE_GROUP_DESCRIPTIO
- RPM Dc Clearance-002-ALT
default
- ITEMR
- RPM Dc Clearance-003-EDGE
- ZONE_NODE_IDR
- 1000000005
- ZONE_NODE_TYPER
- 2
- CLEARANCE_RETAILR
- 14.0000
- STATUS
- N
- DIFF_ID
- EDGE-RPM_D
- REASON_CODE
- EDGE-R
- CLEARANCE_ID
- 1000000005
- ERROR_MESSAGE
- RPM Dc Clearance-003-EDGE
- MARKDOWN_CODE
- EDGE-R
- THREAD_NUMBER
- 5
- CLEARANCE_GROUPING
- 5
- CLEARANCE_GROUP_ID
- 1000000005
- CLEARANCE_GROUP_DESCRIPTIO
- RPM Dc Clearance-003-EDGE
Rule Validation Summary
- Source Rule Count
- 24
- Governed Rule Count
- 19