Cost Susp Supplier Header

In Scope

Technical: COST_SUSP_SUP_HEAD | ID: OR-PRC-COST_SUSP_SUP_HEAD-COST_SUSP_SUPPLIER_HEADER

Stores one row for each cost/retail event created within the company. If the cost event has retail changes associated with it, the retail changes are stored on the price_susp tables.

See how this object fits into Pricing & Promotions

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

Field Definitions(5)

Rules & Considerations(19)

validation

constraint

Sample Load Data(4)

_scenario	REASONR	STATUSR	ACTIVE_DATER	COST_CHANGERPK	COST_CHANGE_DESCR	CREATE_ID	APPROVAL_ID	CREATE_DATE	APPROVAL_DATE	LAST_UPDATE_ID	COST_CHANGE_ORIGIN	LAST_UPDATE_DATETIME
Example values from field definitions	1	S	2026-01-01	1	SAMPLE	SAMPLE	SAMPLE	2026-01-01	2026-01-01	SAMPLE	SAM	2026-01-01
default	3	D	2026-01-03	3	Cost Susp Sup Head-002-ALT	MDM_USER	ALT-COST_SUSP-002	2026-01-03	2026-01-03	APP_USER_ID	SKU	2026-01-03
default	5	C	2026-01-05	5	Cost Susp Sup Head-003-EDGE	BATCH_USER	EDGE-COST_SUSP-003	2026-01-05	2026-01-05	USERENV	SUP	2026-01-05

Example values from field definitions

REASONR: 1
STATUSR: S
ACTIVE_DATER: 2026-01-01
COST_CHANGERPK: 1
COST_CHANGE_DESCR: SAMPLE
CREATE_ID: SAMPLE
APPROVAL_ID: SAMPLE
CREATE_DATE: 2026-01-01
APPROVAL_DATE: 2026-01-01
LAST_UPDATE_ID: SAMPLE
COST_CHANGE_ORIGIN: SAM
LAST_UPDATE_DATETIME: 2026-01-01

default

REASONR: 3
STATUSR: D
ACTIVE_DATER: 2026-01-03
COST_CHANGERPK: 3
COST_CHANGE_DESCR: Cost Susp Sup Head-002-ALT
CREATE_ID: MDM_USER
APPROVAL_ID: ALT-COST_SUSP-002
CREATE_DATE: 2026-01-03
APPROVAL_DATE: 2026-01-03
LAST_UPDATE_ID: APP_USER_ID
COST_CHANGE_ORIGIN: SKU
LAST_UPDATE_DATETIME: 2026-01-03