Ordloc Exp

In Scope

Technical: ORDLOC_EXP | ID: OR-MFCS-ORDLOC_EXP

This table will hold one record for each cost component (expense, assessment, upcharge and allowance ) associated with a particular item/location on an order. The expenses are defaulted in from…

See how this object fits into Purchasing

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Target Structure

Load Approach: Table
Target Objects: ORDLOC_EXP

Field Definitions(26)

Rules & Considerations(85)

Sample Load Data(4)

_scenario	ITEMRPK	ORIGINR	SEQ_NOR	COMP_IDRPK	CVB_CODEPK	LOCATIONR	LOC_TYPER	ORDER_NORPK	COMP_RATER	NOM_FLAG_1R	NOM_FLAG_2R	NOM_FLAG_3R	NOM_FLAG_4R	NOM_FLAG_5R	COMP_CURRENCYRPK	DISPLAY_ORDERR	EST_EXP_VALUER	EXCHANGE_RATER	PER_COUNT_UOMPK	EXCHANGE_RATE_INDR	PACK_ITEM	PER_COUNT	COST_BASIS	KEY_VALUE_1	KEY_VALUE_2	DEFAULTED_FROM
default	Ordloc Exp-001	D	000002	STD-ORDLOC_EXP-001	STD-ORDLOC_EXP-001	1	S	2	11.0000	+	Ordloc Exp-001	Ordloc Exp-001	Ordloc Exp-001	Ordloc Exp-001	Ordloc Exp-001	01	11.0000	11.0000	Ordloc Exp-001	L	Ordloc Exp-001	11.0000	Supplier	Ordloc Exp-001	Ordloc Exp-001	P

default

ITEMRPK: Ordloc Exp-001
ORIGINR: D
SEQ_NOR: 000002
COMP_IDRPK: STD-ORDLOC_EXP-001
CVB_CODEPK: STD-ORDLOC_EXP-001
LOCATIONR: 1
LOC_TYPER: S
ORDER_NORPK: 2
COMP_RATER: 11.0000
NOM_FLAG_1R: +
NOM_FLAG_2R: Ordloc Exp-001
NOM_FLAG_3R: Ordloc Exp-001
NOM_FLAG_4R: Ordloc Exp-001
NOM_FLAG_5R: Ordloc Exp-001
COMP_CURRENCYRPK: Ordloc Exp-001
DISPLAY_ORDERR: 01
EST_EXP_VALUER: 11.0000
EXCHANGE_RATER: 11.0000
PER_COUNT_UOMPK: Ordloc Exp-001
EXCHANGE_RATE_INDR: L
PACK_ITEM: Ordloc Exp-001
PER_COUNT: 11.0000
COST_BASIS: Supplier
KEY_VALUE_1: Ordloc Exp-001
KEY_VALUE_2: Ordloc Exp-001
DEFAULTED_FROM: P

All objects