Item Cost Detail

In Scope

Technical: ITEM_COST_DETAIL | ID: OR-ITM-ITEM_COST_DETAIL-ITEM_COST_DETAIL

Stores the details of the components that makes up the items cost. This table can hold the details like tax and expenses which are part of the items cost.

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_DETAIL

Field Definitions(5)

Rules & Considerations(25)

constraint

validation

Sample Load Data(4)

_scenario	ITEMRPK	SUPPLIERRPK	COND_TYPERPK	ORIGIN_COUNTRY_IDRPK	DELIVERY_COUNTRY_IDRPK	COMP_RATE	APPLIED_ON	COND_VALUE	CALCULATION_BASIS	RECOVERABLE_AMOUNT	MODIFIED_TAXABLE_BASE
Example values from field definitions	SAMPLE	1	SAMPLE	SAM	SAM	1.0000000000	1.0000	1.0000	S	1.0000	1.0000
default	Item Cost Detail-002-ALT	3	Item Cost	ALT	ALT	12.5000000000	12.5000	12.5000	V	12.5000	12.5000
default	Item Cost Detail-003-EDGE	5	Item Cost	EDG	EDG	14.0000000000	14.0000	14.0000	P	14.0000	14.0000

Example values from field definitions

ITEMRPK: SAMPLE
SUPPLIERRPK: 1
COND_TYPERPK: SAMPLE
ORIGIN_COUNTRY_IDRPK: SAM
DELIVERY_COUNTRY_IDRPK: SAM
COMP_RATE: 1.0000000000
APPLIED_ON: 1.0000
COND_VALUE: 1.0000
CALCULATION_BASIS: S
RECOVERABLE_AMOUNT: 1.0000
MODIFIED_TAXABLE_BASE: 1.0000

default

ITEMRPK: Item Cost Detail-002-ALT
SUPPLIERRPK: 3
COND_TYPERPK: Item Cost
ORIGIN_COUNTRY_IDRPK: ALT
DELIVERY_COUNTRY_IDRPK: ALT
COMP_RATE: 12.5000000000
APPLIED_ON: 12.5000
COND_VALUE: 12.5000
CALCULATION_BASIS: V
RECOVERABLE_AMOUNT: 12.5000
MODIFIED_TAXABLE_BASE: 12.5000