Item Cost Header (Service Layer)

In Scope

Technical: SVC_ITEM_COST_HEAD | ID: OR-ITM-SVC_ITEM_COST_HEAD-ITEM_COST_HEADER_SERVICE_LAYER

This is the staging table for Item Induction module. It is used to temporarily hold data before it is uploaded/updated in ITEM_COST_HEAD.

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
SVC_ITEM_COST_HEAD

Field Definitions(5)

Rules & Considerations(22)

constraint

validation

Sample Load Data(4)

Example values from field definitions

ROW_SEQRPK
1
CHUNK_IDR
1
PROCESS_IDRPK
1
ITEM
SAMPLE
ACTION
SAMPLE
SUPPLIER
1
BASE_COST
1.0000
CREATE_ID
SAMPLE
LAST_UPD_ID
SAMPLE
INCLUSIVE_COST
1.0000
NIC_STATIC_IND
S
PROCESS$STATUS
SAMPLE
CREATE_DATETIME
2026-01-01
LAST_UPD_DATETIME
2026-01-01
ORIGIN_COUNTRY_ID
SAM
EXTENDED_BASE_COST
1.0000
PRIM_DLVY_CTRY_IND
S
DELIVERY_COUNTRY_ID
SAM
NEGOTIATED_ITEM_COST
1.0000

default

ROW_SEQRPK
3
CHUNK_IDR
1000000003
PROCESS_IDRPK
1000000003
ITEM
Svc Item Cost Head-002-AL
ACTION
Svc Item C
SUPPLIER
3
BASE_COST
12.5000
CREATE_ID
C LIENT_INFO
LAST_UPD_ID
C LIENT_INFO
INCLUSIVE_COST
12.5000
NIC_STATIC_IND
S
PROCESS$STATUS
N
CREATE_DATETIME
2026-01-03
LAST_UPD_DATETIME
2026-01-03
ORIGIN_COUNTRY_ID
ALT
EXTENDED_BASE_COST
12.5000
PRIM_DLVY_CTRY_IND
S
DELIVERY_COUNTRY_ID
ALT
NEGOTIATED_ITEM_COST
12.5000

default

ROW_SEQRPK
5
CHUNK_IDR
1000000005
PROCESS_IDRPK
1000000005
ITEM
Svc Item Cost Head-003-ED
ACTION
Svc Item C
SUPPLIER
5
BASE_COST
14.0000
CREATE_ID
USE RENV
LAST_UPD_ID
USE RENV
INCLUSIVE_COST
14.0000
NIC_STATIC_IND
S
PROCESS$STATUS
N
CREATE_DATETIME
2026-01-05
LAST_UPD_DATETIME
2026-01-05
ORIGIN_COUNTRY_ID
EDG
EXTENDED_BASE_COST
14.0000
PRIM_DLVY_CTRY_IND
S
DELIVERY_COUNTRY_ID
EDG
NEGOTIATED_ITEM_COST
14.0000

Rule Validation Summary

Source Rule Count
42
Governed Rule Count
22