Ordloc Expense

In Scope

Technical: ORDLOC_EXP | ID: OR-PUR-ORDLOC_EXP-ORDLOC_EXPENSE

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

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: ORDLOC_EXP

Field Definitions(5)

Rules & Considerations(58)

constraint

validation

Sample Load Data(4)

_scenario	ITEMR	SEQ_NORPK	LOCATIONR	ORDER_NORPK	ORIGIN	COMP_ID	CVB_CODE	LOC_TYPE	COMP_RATE	PACK_ITEM	PER_COUNT	COST_BASIS	NOM_FLAG_1	NOM_FLAG_2	NOM_FLAG_3	NOM_FLAG_4	NOM_FLAG_5	KEY_VALUE_1	KEY_VALUE_2	COMP_CURRENCY	DISPLAY_ORDER	EST_EXP_VALUE	EXCHANGE_RATE	PER_COUNT_UOM	DEFAULTED_FROM	EXCHANGE_RATE_IND
Example values from field definitions	SAMPLE	1	1	1	S	SAMPLE	SAMPLE	S	1.0000	SAMPLE	1.0000	S	S	S	S	S	S	SAMPLE	SAMPLE	SAM	1	1.0000000000	1.0000000000	SAMP	SAMPLE	S
default	Ordloc Exp-002-ALT	4	3	4	D	ALT-ORDLOC	ALT-ORDLOC	S	12.5000	Ordloc Exp-002-ALT	12.5000	O	-	O	O	O	O	Ordloc Exp	Ordloc Exp	Ord	3	12.5000000000	12.5000000000	Ordl	P	P
default	Ordloc Exp-003-EDGE	6	5	6	D	EDGE-ORDLO	EDGE-ORDLO	S	14.0000	Ordloc Exp-003-EDGE	14.0000	t	+	O	O	O	O	Ordloc Exp	Ordloc Exp	Ord	5	14.0000000000	14.0000000000	Ordl	P	L

Example values from field definitions

ITEMR: SAMPLE
SEQ_NORPK: 1
LOCATIONR: 1
ORDER_NORPK: 1
ORIGIN: S
COMP_ID: SAMPLE
CVB_CODE: SAMPLE
LOC_TYPE: S
COMP_RATE: 1.0000
PACK_ITEM: SAMPLE
PER_COUNT: 1.0000
COST_BASIS: S
NOM_FLAG_1: S
NOM_FLAG_2: S
NOM_FLAG_3: S
NOM_FLAG_4: S
NOM_FLAG_5: S
KEY_VALUE_1: SAMPLE
KEY_VALUE_2: SAMPLE
COMP_CURRENCY: SAM
DISPLAY_ORDER: 1
EST_EXP_VALUE: 1.0000000000
EXCHANGE_RATE: 1.0000000000
PER_COUNT_UOM: SAMP
DEFAULTED_FROM: SAMPLE
EXCHANGE_RATE_IND: S

default

ITEMR: Ordloc Exp-002-ALT
SEQ_NORPK: 4
LOCATIONR: 3
ORDER_NORPK: 4
ORIGIN: D
COMP_ID: ALT-ORDLOC
CVB_CODE: ALT-ORDLOC
LOC_TYPE: S
COMP_RATE: 12.5000
PACK_ITEM: Ordloc Exp-002-ALT
PER_COUNT: 12.5000
COST_BASIS: O
NOM_FLAG_1: -
NOM_FLAG_2: O
NOM_FLAG_3: O
NOM_FLAG_4: O
NOM_FLAG_5: O
KEY_VALUE_1: Ordloc Exp
KEY_VALUE_2: Ordloc Exp
COMP_CURRENCY: Ord
DISPLAY_ORDER: 3
EST_EXP_VALUE: 12.5000000000
EXCHANGE_RATE: 12.5000000000
PER_COUNT_UOM: Ordl
DEFAULTED_FROM: P
EXCHANGE_RATE_IND: P