Dc Item Cost Header

In Scope

Technical: DC_ITEM_COST_HEAD | ID: OR-ITM-DC_ITEM_COST_HEAD-DC_ITEM_COST_HEADER

This table is a staging table for data conversion and will hold data of ITEM_COST_HEAD table.

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: DC_ITEM_COST_HEAD

Field Definitions(5)

Rules & Considerations(10)

Sample Load Data(4)

_scenario	ITEM	SUPPLIER	BASE_COST	INCLUSIVE_COST	NIC_STATIC_IND	ORIGIN_COUNTRY_ID	EXTENDED_BASE_COST	PRIM_DLVY_CTRY_IND	DELIVERY_COUNTRY_ID	NEGOTIATED_ITEM_COST
Example values from field definitions	SAMPLE	1	1.0000	1.0000	S	SAM	1.0000	S	SAM	1.0000
default	Dc Item Cost Head-002-ALT	3	12.5000	12.5000	D	ALT	12.5000	D	ALT	12.5000
default	Dc Item Cost Head-003-EDG	5	14.0000	14.0000	D	EDG	14.0000	D	EDG	14.0000

Example values from field definitions

ITEM: SAMPLE
SUPPLIER: 1
BASE_COST: 1.0000
INCLUSIVE_COST: 1.0000
NIC_STATIC_IND: S
ORIGIN_COUNTRY_ID: SAM
EXTENDED_BASE_COST: 1.0000
PRIM_DLVY_CTRY_IND: S
DELIVERY_COUNTRY_ID: SAM
NEGOTIATED_ITEM_COST: 1.0000

default

ITEM: Dc Item Cost Head-002-ALT
SUPPLIER: 3
BASE_COST: 12.5000
INCLUSIVE_COST: 12.5000
NIC_STATIC_IND: D
ORIGIN_COUNTRY_ID: ALT
EXTENDED_BASE_COST: 12.5000
PRIM_DLVY_CTRY_IND: D
DELIVERY_COUNTRY_ID: ALT
NEGOTIATED_ITEM_COST: 12.5000

default

ITEM: Dc Item Cost Head-003-EDG
SUPPLIER: 5
BASE_COST: 14.0000
INCLUSIVE_COST: 14.0000
NIC_STATIC_IND: D
ORIGIN_COUNTRY_ID: EDG
EXTENDED_BASE_COST: 14.0000
PRIM_DLVY_CTRY_IND: D
DELIVERY_COUNTRY_ID: EDG
NEGOTIATED_ITEM_COST: 14.0000

Rule Validation Summary

Source Rule Count: 16
Governed Rule Count: 10