Ordcust Detail
In ScopeTechnical: ORDCUST_DETAIL | ID: OR-MFCS-ORDCUST_DETAIL
Stores customer order details for each customer order that has been placed.
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
- ORDCUST_DETAIL
Field Definitions(20)
Rules & Considerations(58)
Sample Load Data(4)
| _scenario | ITEMRPK | CREATE_IDR | ORDCUST_NORPK | STANDARD_UOMRPK | LAST_UPDATE_IDR | CREATE_DATETIMER | TRANSACTION_UOMRPK | QTY_ORDERED_SUOMR | LAST_UPDATE_DATETIMER | SUBSTITUTE_ALLOWED_INDR | TSF_NO | COMMENTS | ORDER_NO | REF_ITEM | UNIT_RETAIL | ITEM_LINE_NO | ORIGINAL_ITEM | QTY_RESERVED_SUOM | QTY_CANCELLED_SUOM | RETAIL_CURRENCY_CODE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Ordcust Detail-001 | MIG_USER | 2 | Ordcust Detail-001 | MIG_USER | 2026-01-01 | Ordcust Detail-001 | 11.0000 | 2026-01-01 | Y | 2 | Ordcust Detail-001 | 2 | Ordcust Detail-001 | 11.0000 | 2 | Ordcust Detail-001 | 11.0000 | 11.0000 | STD-ORDCUST_DE-001 |
default
- ITEMRPK
- Ordcust Detail-001
- CREATE_IDR
- MIG_USER
- ORDCUST_NORPK
- 2
- STANDARD_UOMRPK
- Ordcust Detail-001
- LAST_UPDATE_IDR
- MIG_USER
- CREATE_DATETIMER
- 2026-01-01
- TRANSACTION_UOMRPK
- Ordcust Detail-001
- QTY_ORDERED_SUOMR
- 11.0000
- LAST_UPDATE_DATETIMER
- 2026-01-01
- SUBSTITUTE_ALLOWED_INDR
- Y
- TSF_NO
- 2
- COMMENTS
- Ordcust Detail-001
- ORDER_NO
- 2
- REF_ITEM
- Ordcust Detail-001
- UNIT_RETAIL
- 11.0000
- ITEM_LINE_NO
- 2
- ORIGINAL_ITEM
- Ordcust Detail-001
- QTY_RESERVED_SUOM
- 11.0000
- QTY_CANCELLED_SUOM
- 11.0000
- RETAIL_CURRENCY_CODE
- STD-ORDCUST_DE-001