Cost Susp Sup Detail Loc
In ScopeTechnical: COST_SUSP_SUP_DETAIL_LOC | ID: OR-MFCS-COST_SUSP_SUP_DETAIL_LOC
Stores all locations that an item/supplier/country cost change applies to. If no records exist on this table for a cost change, the cost change is assumed to apply to all…
See how this object fits into Cost
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- COST_SUSP_SUP_DETAIL_LOC
Field Definitions(20)
Rules & Considerations(55)
Sample Load Data(4)
| _scenario | LOCR | ITEMR | LOC_TYPER | SUPPLIERR | UNIT_COSTR | COST_CHANGER | RECALC_ORD_INDR | ORIGIN_COUNTRY_IDR | DEFAULT_BRACKET_INDR | DEPT | BRACKET_UOM1 | PURCHASE_RATE | PURCHASE_TYPE | BRACKET_VALUE1 | BRACKET_VALUE2 | SUP_DEPT_SEQ_NO | COST_CHANGE_TYPE | CALCULATION_BASIS | COST_CHANGE_VALUE | DELIVERY_COUNTRY_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | Cost Susp Sup Detail Loc-001 | Cost Susp Sup Detail Loc-001 | 1 | 11.0000 | 1 | Y | STD-COST_SUSP-001 | Cost Susp Sup Detail Loc-001 | 1001 | Cost Susp Sup Detail Loc-001 | 11.0000 | 0 | 11.0000 | 11.0000 | 2 | Cost Susp Sup Detail Loc-001 | C | 11.0000 | STD-COST_SUSP-001 |
default
- LOCR
- 1
- ITEMR
- Cost Susp Sup Detail Loc-001
- LOC_TYPER
- Cost Susp Sup Detail Loc-001
- SUPPLIERR
- 1
- UNIT_COSTR
- 11.0000
- COST_CHANGER
- 1
- RECALC_ORD_INDR
- Y
- ORIGIN_COUNTRY_IDR
- STD-COST_SUSP-001
- DEFAULT_BRACKET_INDR
- Cost Susp Sup Detail Loc-001
- DEPT
- 1001
- BRACKET_UOM1
- Cost Susp Sup Detail Loc-001
- PURCHASE_RATE
- 11.0000
- PURCHASE_TYPE
- 0
- BRACKET_VALUE1
- 11.0000
- BRACKET_VALUE2
- 11.0000
- SUP_DEPT_SEQ_NO
- 2
- COST_CHANGE_TYPE
- Cost Susp Sup Detail Loc-001
- CALCULATION_BASIS
- C
- COST_CHANGE_VALUE
- 11.0000
- DELIVERY_COUNTRY_ID
- STD-COST_SUSP-001