Mc Charge Detail

In Scope

Technical: MC_CHRG_DETAIL | ID: OR-ITM-MC_CHRG_DETAIL-MC_CHARGE_DETAIL

This temporary table will be used to maintain item list upcharge detail records until they are blown down to the item level on the ITEM_CHRG_DETAIL 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: MC_CHRG_DETAIL

Field Definitions(5)

Rules & Considerations(43)

constraint

validation

Sample Load Data(4)

_scenario	TO_LOCRPK	COMP_IDRPK	FROM_LOCRPK	ITEM_LISTRPK	FROM_LOC_TYPER	CVB_CODE	COMP_RATE	PER_COUNT	COST_BASIS	TO_LOC_TYPE	COMP_CURRENCY	DISPLAY_ORDER	PER_COUNT_UOM	UP_CHRG_GROUP	MAINTENANCE_TYPE	INCLUDE_IN_TOTAL_UP_CHRG_IND
Example values from field definitions	1	SAMPLE	1	1	S	SAMPLE	1.0000	1.0000	SAMPLE	S	SAM	1	SAMP	SAMPLE	S	S
default	3	ALT-MC_CHR	3	3	M	ALT-MC_CHR	12.5000	12.5000	W	M	Mc	3	Mc C	Mc Chr	M	Y
default	5	EDGE-MC_CH	5	5	M	EDGE-MC_CH	14.0000	14.0000	S	M	Mc	5	Mc C	Mc Chr	M	Y

Example values from field definitions

TO_LOCRPK: 1
COMP_IDRPK: SAMPLE
FROM_LOCRPK: 1
ITEM_LISTRPK: 1
FROM_LOC_TYPER: S
CVB_CODE: SAMPLE
COMP_RATE: 1.0000
PER_COUNT: 1.0000
COST_BASIS: SAMPLE
TO_LOC_TYPE: S
COMP_CURRENCY: SAM
DISPLAY_ORDER: 1
PER_COUNT_UOM: SAMP
UP_CHRG_GROUP: SAMPLE
MAINTENANCE_TYPE: S
INCLUDE_IN_TOTAL_UP_CHRG_IND: S

default

TO_LOCRPK: 3
COMP_IDRPK: ALT-MC_CHR
FROM_LOCRPK: 3
ITEM_LISTRPK: 3
FROM_LOC_TYPER: M
CVB_CODE: ALT-MC_CHR
COMP_RATE: 12.5000
PER_COUNT: 12.5000
COST_BASIS: W
TO_LOC_TYPE: M
COMP_CURRENCY: Mc
DISPLAY_ORDER: 3
PER_COUNT_UOM: Mc C
UP_CHRG_GROUP: Mc Chr
MAINTENANCE_TYPE: M
INCLUDE_IN_TOTAL_UP_CHRG_IND: Y