Wf Order Expense

In Scope

Technical: WF_ORDER_EXP | ID: OR-ITM-WF_ORDER_EXP-WF_ORDER_EXPENSE

Stores the details of expenses associated with item/location on a Franchise order and are defaulted from the applicable cost template. The expenses will be related to the items by WF_ORDER_LINE_NO...

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

Field Definitions(5)

Rules & Considerations(30)

validation

constraint

Sample Load Data(4)

_scenario	SEQ_NORPK	COMP_IDR	CALC_BASISR	WF_ORDER_NORPK	WF_ORDER_LINE_NOR	CVB_CODE	COMP_RATE	PER_COUNT	COST_BASIS	COMP_CURRENCY	EXCHANGE_RATE	PER_COUNT_UOM	EST_UPCHARGE_AMT
Example values from field definitions	1	SAMPLE	S	1	1	SAMPLE	1.0000	1.0000	SAMPLE	SAM	1.0000000000	SAMP	1.0000
default	4	ALT-WF_ORD	W	4	4	ALT-WF_ORD	12.5000	12.5000	W	Wf	12.5000000000	Wf O	12.5000
default	6	EDGE-WF_OR	W	6	6	EDGE-WF_OR	14.0000	14.0000	S	Wf	14.0000000000	Wf O	14.0000

Example values from field definitions

SEQ_NORPK: 1
COMP_IDR: SAMPLE
CALC_BASISR: S
WF_ORDER_NORPK: 1
WF_ORDER_LINE_NOR: 1
CVB_CODE: SAMPLE
COMP_RATE: 1.0000
PER_COUNT: 1.0000
COST_BASIS: SAMPLE
COMP_CURRENCY: SAM
EXCHANGE_RATE: 1.0000000000
PER_COUNT_UOM: SAMP
EST_UPCHARGE_AMT: 1.0000

default

SEQ_NORPK: 4
COMP_IDR: ALT-WF_ORD
CALC_BASISR: W
WF_ORDER_NORPK: 4
WF_ORDER_LINE_NOR: 4
CVB_CODE: ALT-WF_ORD
COMP_RATE: 12.5000
PER_COUNT: 12.5000
COST_BASIS: W
COMP_CURRENCY: Wf
EXCHANGE_RATE: 12.5000000000
PER_COUNT_UOM: Wf O
EST_UPCHARGE_AMT: 12.5000