Transportation
In ScopeTechnical: TRANSPORTATION | ID: OR-ITM-TRANSPORTATION-TRANSPORTATION
This table is used to store multiple details about a Transportation header record. These records are the basis for creating the Pro- Forma customs entry form that is sent to…
See how this object fits into Item Management
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
- TRANSPORTATION
Field Definitions(55)
Rules & Considerations(78)
constraint
validation
Sample Load Data(4)
| _scenario | ORDER_NORPK | RUSH_INDR | CUBIC_UOMRPK | CARTON_UOMRPK | NET_WT_UOMRPK | FREIGHT_SIZERPK | FREIGHT_TYPERPK | GROSS_WT_UOMRPK | ITEM_QTY_UOMRPK | CANDIDATE_INDR | VESSEL_SCAC_CODERPK | EXCHANGE_RATE_INDR | EXPORT_COUNTRY_IDRPK | ORIGIN_COUNTRY_IDRPK | TRANSPORTATION_IDRPK | CONTAINER_SCAC_CODERPK | CONSOLIDATION_COUNTRY_IDRPK | ITEM | CUBIC | FCR_ID | LOT_NO | NET_WT | STATUS | SEAL_ID | COMMENTS | FCR_DATE | GROSS_WT | ITEM_QTY | BL_AWB_ID | VESSEL_ID | CARTON_QTY | INVOICE_ID | RECEIPT_ID | INVOICE_AMT | LADING_PORT | SHIPMENT_NO | CONTAINER_ID | INVOICE_DATE | SELECTED_IND | TRAN_MODE_ID | CURRENCY_CODE | DELIVERY_DATE | EXCHANGE_RATE | IN_TRANSIT_NO | VOYAGE_FLT_ID | DISCHARGE_PORT | PACKING_METHOD | IN_TRANSIT_DATE | TRANS_PARTNER_ID | ACTUAL_DEPART_DATE | TRANS_PARTNER_TYPE | ACTUAL_ARRIVAL_DATE | SERVICE_CONTRACT_NO | ESTIMATED_DEPART_DATE | ESTIMATED_ARRIVAL_DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | S | SAMP | SAMP | SAMP | SAMPLE | SAMPLE | SAMP | SAMP | S | SAMPLE | S | SAM | SAM | 1 | SAMPLE | SAM | SAMPLE | 1.0000 | SAMPLE | SAMPLE | 1.0000 | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | 1.0000 | 1.0000 | SAMPLE | SAMPLE | 1.0000 | SAMPLE | SAMPLE | 1.0000 | SAMPL | SAMPLE | SAMPLE | 2026-01-01 | S | SAMPLE | SAM | 2026-01-01 | 1.0000000000 | SAMPLE | SAMPLE | SAMPL | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | 2026-01-01 |
Example values from field definitions
- ORDER_NORPK
- 1
- RUSH_INDR
- S
- CUBIC_UOMRPK
- SAMP
- CARTON_UOMRPK
- SAMP
- NET_WT_UOMRPK
- SAMP
- FREIGHT_SIZERPK
- SAMPLE
- FREIGHT_TYPERPK
- SAMPLE
- GROSS_WT_UOMRPK
- SAMP
- ITEM_QTY_UOMRPK
- SAMP
- CANDIDATE_INDR
- S
- VESSEL_SCAC_CODERPK
- SAMPLE
- EXCHANGE_RATE_INDR
- S
- EXPORT_COUNTRY_IDRPK
- SAM
- ORIGIN_COUNTRY_IDRPK
- SAM
- TRANSPORTATION_IDRPK
- 1
- CONTAINER_SCAC_CODERPK
- SAMPLE
- CONSOLIDATION_COUNTRY_IDRPK
- SAM
- ITEM
- SAMPLE
- CUBIC
- 1.0000
- FCR_ID
- SAMPLE
- LOT_NO
- SAMPLE
- NET_WT
- 1.0000
- STATUS
- SAMPLE
- SEAL_ID
- SAMPLE
- COMMENTS
- SAMPLE
- FCR_DATE
- 2026-01-01
- GROSS_WT
- 1.0000
- ITEM_QTY
- 1.0000
- BL_AWB_ID
- SAMPLE
- VESSEL_ID
- SAMPLE
- CARTON_QTY
- 1.0000
- INVOICE_ID
- SAMPLE
- RECEIPT_ID
- SAMPLE
- INVOICE_AMT
- 1.0000
- LADING_PORT
- SAMPL
- SHIPMENT_NO
- SAMPLE
- CONTAINER_ID
- SAMPLE
- INVOICE_DATE
- 2026-01-01
- SELECTED_IND
- S
- TRAN_MODE_ID
- SAMPLE
- CURRENCY_CODE
- SAM
- DELIVERY_DATE
- 2026-01-01
- EXCHANGE_RATE
- 1.0000000000
- IN_TRANSIT_NO
- SAMPLE
- VOYAGE_FLT_ID
- SAMPLE
- DISCHARGE_PORT
- SAMPL
- PACKING_METHOD
- SAMPLE
- IN_TRANSIT_DATE
- 2026-01-01
- TRANS_PARTNER_ID
- SAMPLE
- ACTUAL_DEPART_DATE
- 2026-01-01
- TRANS_PARTNER_TYPE
- SAMPLE
- ACTUAL_ARRIVAL_DATE
- 2026-01-01
- SERVICE_CONTRACT_NO
- SAMPLE
- ESTIMATED_DEPART_DATE
- 2026-01-01
- ESTIMATED_ARRIVAL_DATE
- 2026-01-01
Rule Validation Summary
- Source Rule Count
- 98
- Governed Rule Count
- 78