Detail Sku/Supplier Cost Event Records
In ScopeTechnical: COST_SUSP_SUP_DETAIL | ID: OR-SUP-COST_SUSP_SUP_DETAIL-COST_SUSP_SUPPLIER_DETAIL
Stores the detail SKU/Supplier cost event records.
See how this object fits into Supplier 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
- COST_SUSP_SUP_DETAIL
Field Definitions(5)
Rules & Considerations(31)
Sample Load Data(4)
| _scenario | ITEMRPK | SUPPLIERR | COST_CHANGERPK | ORIGIN_COUNTRY_IDR | DEPT | UNIT_COST | BRACKET_UOM1 | PURCHASE_RATE | PURCHASE_TYPE | BRACKET_VALUE1 | BRACKET_VALUE2 | RECALC_ORD_IND | SUP_DEPT_SEQ_NO | COST_CHANGE_TYPE | CALCULATION_BASIS | COST_CHANGE_VALUE | DEFAULT_BRACKET_IND | DELIVERY_COUNTRY_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | SAM | 1 | 1.0000 | SAMP | 1.0000 | 1 | 1.0000 | 1.0000 | S | 1 | SA | S | 1.0000 | S | SAM |
| default | Cost Susp Sup Detail-002- | 3 | 3 | ALT | 1003 | 12.5000 | Cost | 12.5000 | 1 | 12.5000 | 12.5000 | N | 4 | Co | P | 12.5000 | C | ALT |
| default | Cost Susp Sup Detail-003- | 5 | 5 | EDG | 1005 | 14.0000 | Cost | 14.0000 | 2 | 14.0000 | 14.0000 | Y | 6 | Co | C | 14.0000 | C | EDG |
Example values from field definitions
- ITEMRPK
- SAMPLE
- SUPPLIERR
- 1
- COST_CHANGERPK
- 1
- ORIGIN_COUNTRY_IDR
- SAM
- DEPT
- 1
- UNIT_COST
- 1.0000
- BRACKET_UOM1
- SAMP
- PURCHASE_RATE
- 1.0000
- PURCHASE_TYPE
- 1
- BRACKET_VALUE1
- 1.0000
- BRACKET_VALUE2
- 1.0000
- RECALC_ORD_IND
- S
- SUP_DEPT_SEQ_NO
- 1
- COST_CHANGE_TYPE
- SA
- CALCULATION_BASIS
- S
- COST_CHANGE_VALUE
- 1.0000
- DEFAULT_BRACKET_IND
- S
- DELIVERY_COUNTRY_ID
- SAM
default
- ITEMRPK
- Cost Susp Sup Detail-002-
- SUPPLIERR
- 3
- COST_CHANGERPK
- 3
- ORIGIN_COUNTRY_IDR
- ALT
- DEPT
- 1003
- UNIT_COST
- 12.5000
- BRACKET_UOM1
- Cost
- PURCHASE_RATE
- 12.5000
- PURCHASE_TYPE
- 1
- BRACKET_VALUE1
- 12.5000
- BRACKET_VALUE2
- 12.5000
- RECALC_ORD_IND
- N
- SUP_DEPT_SEQ_NO
- 4
- COST_CHANGE_TYPE
- Co
- CALCULATION_BASIS
- P
- COST_CHANGE_VALUE
- 12.5000
- DEFAULT_BRACKET_IND
- C
- DELIVERY_COUNTRY_ID
- ALT
default
- ITEMRPK
- Cost Susp Sup Detail-003-
- SUPPLIERR
- 5
- COST_CHANGERPK
- 5
- ORIGIN_COUNTRY_IDR
- EDG
- DEPT
- 1005
- UNIT_COST
- 14.0000
- BRACKET_UOM1
- Cost
- PURCHASE_RATE
- 14.0000
- PURCHASE_TYPE
- 2
- BRACKET_VALUE1
- 14.0000
- BRACKET_VALUE2
- 14.0000
- RECALC_ORD_IND
- Y
- SUP_DEPT_SEQ_NO
- 6
- COST_CHANGE_TYPE
- Co
- CALCULATION_BASIS
- C
- COST_CHANGE_VALUE
- 14.0000
- DEFAULT_BRACKET_IND
- C
- DELIVERY_COUNTRY_ID
- EDG
Rule Validation Summary
- Source Rule Count
- 43
- Governed Rule Count
- 31