Item Cost Header

In Scope

Technical: ITEM_COST_HEAD | ID: OR-ITM-ITEM_COST_HEAD-ITEM_COST_HEADER

Stores the item costing record for each item-supplier- country-delivery country.

See how this object fits into Item 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: ITEM_COST_HEAD

Field Definitions(5)

Rules & Considerations(28)

validation

constraint

Sample Load Data(4)

_scenario	ITEMRPK	SUPPLIERRPK	ORIGIN_COUNTRY_IDRPK	PRIM_DLVY_CTRY_INDR	DELIVERY_COUNTRY_IDRPK	BASE_COST	INCLUSIVE_COST	NIC_STATIC_IND	EXTENDED_BASE_COST	NEGOTIATED_ITEM_COST
Example values from field definitions	SAMPLE	1	SAM	S	SAM	1.0000	1.0000	S	1.0000	1.0000
default	Item Cost Head-002-ALT	3	ALT	I	ALT	12.5000	12.5000	I	12.5000	12.5000
default	Item Cost Head-003-EDGE	5	EDG	I	EDG	14.0000	14.0000	I	14.0000	14.0000

Example values from field definitions

ITEMRPK: SAMPLE
SUPPLIERRPK: 1
ORIGIN_COUNTRY_IDRPK: SAM
PRIM_DLVY_CTRY_INDR: S
DELIVERY_COUNTRY_IDRPK: SAM
BASE_COST: 1.0000
INCLUSIVE_COST: 1.0000
NIC_STATIC_IND: S
EXTENDED_BASE_COST: 1.0000
NEGOTIATED_ITEM_COST: 1.0000

default

ITEMRPK: Item Cost Head-002-ALT
SUPPLIERRPK: 3
ORIGIN_COUNTRY_IDRPK: ALT
PRIM_DLVY_CTRY_INDR: I
DELIVERY_COUNTRY_IDRPK: ALT
BASE_COST: 12.5000
INCLUSIVE_COST: 12.5000
NIC_STATIC_IND: I
EXTENDED_BASE_COST: 12.5000
NEGOTIATED_ITEM_COST: 12.5000

default

ITEMRPK: Item Cost Head-003-EDGE
SUPPLIERRPK: 5
ORIGIN_COUNTRY_IDRPK: EDG
PRIM_DLVY_CTRY_INDR: I
DELIVERY_COUNTRY_IDRPK: EDG
BASE_COST: 14.0000
INCLUSIVE_COST: 14.0000
NIC_STATIC_IND: I
EXTENDED_BASE_COST: 14.0000
NEGOTIATED_ITEM_COST: 14.0000

Rule Validation Summary

Source Rule Count: 54
Governed Rule Count: 28