API Price History
In ScopeTechnical: API_PRICE_HIST | ID: OR-PRC-API_PRICE_HIST-API_PRICE_HISTORY
A table to contain price history details to aid processing updates and inserts to the price history table.
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
- API_PRICE_HIST
Field Definitions(5)
Rules & Considerations(12)
validation
constraint
Sample Load Data(4)
| _scenario | LOCRPK | ITEMRPK | SEQ_NORPK | LOC_TYPE | UNIT_COST | UNIT_RETAIL |
|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | S | 1.0000 | 1.0000 |
| default | 3 | API Price Hist-002-ALT | 4 | A | 12.5000 | 12.5000 |
| default | 5 | API Price Hist-003-EDGE | 6 | A | 14.0000 | 14.0000 |
Example values from field definitions
- LOCRPK
- 1
- ITEMRPK
- SAMPLE
- SEQ_NORPK
- 1
- LOC_TYPE
- S
- UNIT_COST
- 1.0000
- UNIT_RETAIL
- 1.0000
default
- LOCRPK
- 3
- ITEMRPK
- API Price Hist-002-ALT
- SEQ_NORPK
- 4
- LOC_TYPE
- A
- UNIT_COST
- 12.5000
- UNIT_RETAIL
- 12.5000
default
- LOCRPK
- 5
- ITEMRPK
- API Price Hist-003-EDGE
- SEQ_NORPK
- 6
- LOC_TYPE
- A
- UNIT_COST
- 14.0000
- UNIT_RETAIL
- 14.0000
Rule Validation Summary
- Source Rule Count
- 15
- Governed Rule Count
- 12