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(5)
Rules & Considerations(21)
constraint
validation
Sample Load Data(4)
| _scenario | DELIVERY_LOCATIONRPK | DELIVERY_LOC_TYPERPK | TRANSPORTATION_IDRPK | ESTIMATED_DELIVERY_DATER | COMMENTS | ITEM_QTY | CARTON_QTY | ITEM_QTY_UOM | CARTON_QTY_UOM | VENDOR_ORDER_NO |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | 1 | 2026-01-01 | SAMPLE | 1.0000 | 1.0000 | SAMP | SAMP | SAMPLE |
| default | Trans Deli | Trans | 1000000003 | 2026-01-03 | Trans Delivery-002-ALT | 12.5000 | 12.5000 | Tran | Tran | Trans Delivery- |
| default | Trans Deli | Trans | 1000000005 | 2026-01-05 | Trans Delivery-003-EDGE | 14.0000 | 14.0000 | Tran | Tran | Trans Delivery- |
Example values from field definitions
- DELIVERY_LOCATIONRPK
- SAMPLE
- DELIVERY_LOC_TYPERPK
- SAMPLE
- TRANSPORTATION_IDRPK
- 1
- ESTIMATED_DELIVERY_DATER
- 2026-01-01
- COMMENTS
- SAMPLE
- ITEM_QTY
- 1.0000
- CARTON_QTY
- 1.0000
- ITEM_QTY_UOM
- SAMP
- CARTON_QTY_UOM
- SAMP
- VENDOR_ORDER_NO
- SAMPLE
default
- DELIVERY_LOCATIONRPK
- Trans Deli
- DELIVERY_LOC_TYPERPK
- Trans
- TRANSPORTATION_IDRPK
- 1000000003
- ESTIMATED_DELIVERY_DATER
- 2026-01-03
- COMMENTS
- Trans Delivery-002-ALT
- ITEM_QTY
- 12.5000
- CARTON_QTY
- 12.5000
- ITEM_QTY_UOM
- Tran
- CARTON_QTY_UOM
- Tran
- VENDOR_ORDER_NO
- Trans Delivery-
default
- DELIVERY_LOCATIONRPK
- Trans Deli
- DELIVERY_LOC_TYPERPK
- Trans
- TRANSPORTATION_IDRPK
- 1000000005
- ESTIMATED_DELIVERY_DATER
- 2026-01-05
- COMMENTS
- Trans Delivery-003-EDGE
- ITEM_QTY
- 14.0000
- CARTON_QTY
- 14.0000
- ITEM_QTY_UOM
- Tran
- CARTON_QTY_UOM
- Tran
- VENDOR_ORDER_NO
- Trans Delivery-
Rule Validation Summary
- Source Rule Count
- 26
- Governed Rule Count
- 21