Transaction Delivery
In ScopeTechnical: TRANS_DELIVERY | ID: OR-FND-TRANS_DELIVERY-TRANSACTION_DELIVERY
This table is used to store delivery information at the destination level for a specific Transportation record.
See how this object fits into Foundation Data
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
- TRANS_DELIVERY
Field Definitions(10)
Rules & Considerations(18)
constraint
validation
Sample Load Data(4)
| _scenario | ITEM_QTY_UOMRPK | CARTON_QTY_UOMRPK | DELIVERY_LOCATIONR | DELIVERY_LOC_TYPER | TRANSPORTATION_IDRPK | ESTIMATED_DELIVERY_DATER | COMMENTS | ITEM_QTY | CARTON_QTY | VENDOR_ORDER_NO |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMP | SAMP | SAMPLE | SAMPLE | 1 | 2026-01-01 | SAMPLE | 1.0000 | 1.0000 | SAMPLE |
Example values from field definitions
- ITEM_QTY_UOMRPK
- SAMP
- CARTON_QTY_UOMRPK
- SAMP
- DELIVERY_LOCATIONR
- SAMPLE
- DELIVERY_LOC_TYPER
- SAMPLE
- TRANSPORTATION_IDRPK
- 1
- ESTIMATED_DELIVERY_DATER
- 2026-01-01
- COMMENTS
- SAMPLE
- ITEM_QTY
- 1.0000
- CARTON_QTY
- 1.0000
- VENDOR_ORDER_NO
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 23
- Governed Rule Count
- 18
