Cost Susp Supplier Detail (Service Layer)

In Scope

Technical: SVC_COST_SUSP_SUP_DETAIL | ID: OR-CST-SVC_COST_SUSP_SUP_DETAIL-COST_SUSP_SUPPLIER_DETAIL_SERVICE_LAYER

This is the staging table for Item Induction modules cost change functionality. It is used to temporarily hold data before it is uploaded/updated in COST_SUSP_SUP_DETAIL.

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

Field Definitions(5)

Rules & Considerations(19)

constraint

validation

Sample Load Data(4)

_scenario	ROW_SEQR	CHUNK_IDR	PROCESS_IDRPK	ITEM	ACTION	SUPPLIER	UNIT_COST	COST_CHANGE	BRACKET_UOM1	BRACKET_VALUE1	BRACKET_VALUE2	PROCESS$STATUS	COST_CHANGE_TYPE	COST_CHANGE_VALUE	ORIGIN_COUNTRY_ID
Example values from field definitions	1	1	1	SAMPLE	SAMPLE	1	1.0000	1	SAMP	1.0000	1.0000	SAMPLE	SA	1.0000	SAM
default	3	1000000003	1000000003	Svc Cost Susp Sup Detail-	Svc Cost S	3	12.5000	3	Svc	12.5000	12.5000	N	Sv	12.5000	ALT
default	5	1000000005	1000000005	Svc Cost Susp Sup Detail-	Svc Cost S	5	14.0000	5	Svc	14.0000	14.0000	N	Sv	14.0000	EDG

Example values from field definitions

ROW_SEQR: 1
CHUNK_IDR: 1
PROCESS_IDRPK: 1
ITEM: SAMPLE
ACTION: SAMPLE
SUPPLIER: 1
UNIT_COST: 1.0000
COST_CHANGE: 1
BRACKET_UOM1: SAMP
BRACKET_VALUE1: 1.0000
BRACKET_VALUE2: 1.0000
PROCESS$STATUS: SAMPLE
COST_CHANGE_TYPE: SA
COST_CHANGE_VALUE: 1.0000
ORIGIN_COUNTRY_ID: SAM

default

ROW_SEQR: 3
CHUNK_IDR: 1000000003
PROCESS_IDRPK: 1000000003
ITEM: Svc Cost Susp Sup Detail-
ACTION: Svc Cost S
SUPPLIER: 3
UNIT_COST: 12.5000
COST_CHANGE: 3
BRACKET_UOM1: Svc
BRACKET_VALUE1: 12.5000
BRACKET_VALUE2: 12.5000
PROCESS$STATUS: N
COST_CHANGE_TYPE: Sv
COST_CHANGE_VALUE: 12.5000
ORIGIN_COUNTRY_ID: ALT