Ordcust Detail
In ScopeTechnical: ORDCUST_DETAIL | ID: OR-PUR-ORDCUST_DETAIL-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- ORDCUST_DETAIL
Field Definitions(5)
Rules & Considerations(34)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMRPK | ORDCUST_NORPK | QTY_ORDERED_SUOMR | TSF_NO | COMMENTS | ORDER_NO | REF_ITEM | CREATE_ID | UNIT_RETAIL | ITEM_LINE_NO | STANDARD_UOM | ORIGINAL_ITEM | LAST_UPDATE_ID | CREATE_DATETIME | TRANSACTION_UOM | QTY_RESERVED_SUOM | QTY_CANCELLED_SUOM | LAST_UPDATE_DATETIME | RETAIL_CURRENCY_CODE | SUBSTITUTE_ALLOWED_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1.0000 | 1 | SAMPLE | 1 | SAMPLE | SAMPLE | 1.0000 | 1 | SAMP | SAMPLE | SAMPLE | 2026-01-01 | SAMP | 1.0000 | 1.0000 | 2026-01-01 | SAM | S |
| default | Ordcust Detail-002-ALT | 4 | 12.5000 | 4 | Ordcust Detail-002-ALT | 4 | Ordcust Detail-002-ALT | MDM_USER | 12.5000 | 4 | Ordc | Ordcust Detail-002-ALT | MDM_USER | 2026-01-03 | Ordc | 12.5000 | 12.5000 | 2026-01-03 | ALT | N |
| default | Ordcust Detail-003-EDGE | 6 | 14.0000 | 6 | Ordcust Detail-003-EDGE | 6 | Ordcust Detail-003-EDGE | BATCH_USER | 14.0000 | 6 | Ordc | Ordcust Detail-003-EDGE | BATCH_USER | 2026-01-05 | Ordc | 14.0000 | 14.0000 | 2026-01-05 | EDG | Y |
Example values from field definitions
- ITEMRPK
- SAMPLE
- ORDCUST_NORPK
- 1
- QTY_ORDERED_SUOMR
- 1.0000
- TSF_NO
- 1
- COMMENTS
- SAMPLE
- ORDER_NO
- 1
- REF_ITEM
- SAMPLE
- CREATE_ID
- SAMPLE
- UNIT_RETAIL
- 1.0000
- ITEM_LINE_NO
- 1
- STANDARD_UOM
- SAMP
- ORIGINAL_ITEM
- SAMPLE
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- TRANSACTION_UOM
- SAMP
- QTY_RESERVED_SUOM
- 1.0000
- QTY_CANCELLED_SUOM
- 1.0000
- LAST_UPDATE_DATETIME
- 2026-01-01
- RETAIL_CURRENCY_CODE
- SAM
- SUBSTITUTE_ALLOWED_IND
- S
default
- ITEMRPK
- Ordcust Detail-002-ALT
- ORDCUST_NORPK
- 4
- QTY_ORDERED_SUOMR
- 12.5000
- TSF_NO
- 4
- COMMENTS
- Ordcust Detail-002-ALT
- ORDER_NO
- 4
- REF_ITEM
- Ordcust Detail-002-ALT
- CREATE_ID
- MDM_USER
- UNIT_RETAIL
- 12.5000
- ITEM_LINE_NO
- 4
- STANDARD_UOM
- Ordc
- ORIGINAL_ITEM
- Ordcust Detail-002-ALT
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- TRANSACTION_UOM
- Ordc
- QTY_RESERVED_SUOM
- 12.5000
- QTY_CANCELLED_SUOM
- 12.5000
- LAST_UPDATE_DATETIME
- 2026-01-03
- RETAIL_CURRENCY_CODE
- ALT
- SUBSTITUTE_ALLOWED_IND
- N
default
- ITEMRPK
- Ordcust Detail-003-EDGE
- ORDCUST_NORPK
- 6
- QTY_ORDERED_SUOMR
- 14.0000
- TSF_NO
- 6
- COMMENTS
- Ordcust Detail-003-EDGE
- ORDER_NO
- 6
- REF_ITEM
- Ordcust Detail-003-EDGE
- CREATE_ID
- BATCH_USER
- UNIT_RETAIL
- 14.0000
- ITEM_LINE_NO
- 6
- STANDARD_UOM
- Ordc
- ORIGINAL_ITEM
- Ordcust Detail-003-EDGE
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- TRANSACTION_UOM
- Ordc
- QTY_RESERVED_SUOM
- 14.0000
- QTY_CANCELLED_SUOM
- 14.0000
- LAST_UPDATE_DATETIME
- 2026-01-05
- RETAIL_CURRENCY_CODE
- EDG
- SUBSTITUTE_ALLOWED_IND
- Y
Rule Validation Summary
- Source Rule Count
- 42
- Governed Rule Count
- 34