Ordloc Expense
In ScopeTechnical: 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(26)
Rules & Considerations(52)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMRPK | ORIGINR | SEQ_NOR | COMP_IDRPK | CVB_CODERPK | 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_UOMRPK | EXCHANGE_RATE_INDR | PACK_ITEM | PER_COUNT | COST_BASIS | KEY_VALUE_1 | KEY_VALUE_2 | DEFAULTED_FROM |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | S | 1 | SAMPLE | SAMPLE | 1 | S | 1 | 1.0000 | S | S | S | S | S | SAM | 1 | 1.0000000000 | 1.0000000000 | SAMP | S | SAMPLE | 1.0000 | S | SAMPLE | SAMPLE | SAMPLE |
Example values from field definitions
- ITEMRPK
- SAMPLE
- ORIGINR
- S
- SEQ_NOR
- 1
- COMP_IDRPK
- SAMPLE
- CVB_CODERPK
- SAMPLE
- LOCATIONR
- 1
- LOC_TYPER
- S
- ORDER_NORPK
- 1
- COMP_RATER
- 1.0000
- NOM_FLAG_1R
- S
- NOM_FLAG_2R
- S
- NOM_FLAG_3R
- S
- NOM_FLAG_4R
- S
- NOM_FLAG_5R
- S
- COMP_CURRENCYRPK
- SAM
- DISPLAY_ORDERR
- 1
- EST_EXP_VALUER
- 1.0000000000
- EXCHANGE_RATER
- 1.0000000000
- PER_COUNT_UOMRPK
- SAMP
- EXCHANGE_RATE_INDR
- S
- PACK_ITEM
- SAMPLE
- PER_COUNT
- 1.0000
- COST_BASIS
- S
- KEY_VALUE_1
- SAMPLE
- KEY_VALUE_2
- SAMPLE
- DEFAULTED_FROM
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 74
- Governed Rule Count
- 52