Cost Susp Supplier Detail Location
In ScopeTechnical: COST_SUSP_SUP_DETAIL_LOC | ID: OR-CST-COST_SUSP_SUP_DETAIL_LOC-COST_SUSP_SUPPLIER_DETAIL_LOCATION
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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- COST_SUSP_SUP_DETAIL_LOC
Field Definitions(5)
Rules & Considerations(29)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMR | LOC_TYPER | SUPPLIERR | COST_CHANGER | ORIGIN_COUNTRY_IDR | LOC | 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 | S | 1 | 1 | SAM | 1 | 1 | 1.0000 | SAMP | 1.0000 | 1 | 1.0000 | 1.0000 | S | 1 | SA | S | 1.0000 | S | SAM |
| default | Cost Susp Sup Detail Loc- | C | 3 | 3 | ALT | 3 | 1003 | 12.5000 | Cost | 12.5000 | 1 | 12.5000 | 12.5000 | N | 4 | Co | P | 12.5000 | C | ALT |
| default | Cost Susp Sup Detail Loc- | C | 5 | 5 | EDG | 5 | 1005 | 14.0000 | Cost | 14.0000 | 2 | 14.0000 | 14.0000 | Y | 6 | Co | C | 14.0000 | C | EDG |
Example values from field definitions
- ITEMR
- SAMPLE
- LOC_TYPER
- S
- SUPPLIERR
- 1
- COST_CHANGER
- 1
- ORIGIN_COUNTRY_IDR
- SAM
- LOC
- 1
- 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
- ITEMR
- Cost Susp Sup Detail Loc-
- LOC_TYPER
- C
- SUPPLIERR
- 3
- COST_CHANGER
- 3
- ORIGIN_COUNTRY_IDR
- ALT
- LOC
- 3
- 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
- ITEMR
- Cost Susp Sup Detail Loc-
- LOC_TYPER
- C
- SUPPLIERR
- 5
- COST_CHANGER
- 5
- ORIGIN_COUNTRY_IDR
- EDG
- LOC
- 5
- 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
- 57
- Governed Rule Count
- 29