Transportation

In Scope

Technical: TRANSPORTATION | ID: OR-MFCS-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

Target Structure

Load Approach: Table
Target Objects: TRANSPORTATION

Field Definitions(55)

Rules & Considerations(46)

Sample Load Data(4)

_scenario	ORDER_NOPK	RUSH_INDR	CUBIC_UOMPK	CARTON_UOMPK	NET_WT_UOMPK	FREIGHT_SIZEPK	FREIGHT_TYPEPK	GROSS_WT_UOMPK	ITEM_QTY_UOMPK	CANDIDATE_INDR	VESSEL_SCAC_CODEPK	EXCHANGE_RATE_INDR	EXPORT_COUNTRY_IDPK	ORIGIN_COUNTRY_IDPK	TRANSPORTATION_IDRPK	CONTAINER_SCAC_CODEPK	CONSOLIDATION_COUNTRY_IDPK	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
default	2	Transportation-001	Transportation-001	Transportation-001	Transportation-001	Transportation-001	Transportation-001	Transportation-001	Transportation-001	2026-01-01	STD-TRANSPORTA-001	L	STD-TRANSPORTA-001	STD-TRANSPORTA-001	1000000001	STD-TRANSPORTA-001	STD-TRANSPORTA-001	Transportation-001	11.0000	STD-TRANSPORTA-001	Transportation-001	11.0000	ACTIVE	STD-TRANSPORTA-001	Transportation-001	2026-01-01	11.0000	11.0000	STD-TRANSPORTA-001	STD-TRANSPORTA-001	11.0000	STD-TRANSPORTA-001	STD-TRANSPORTA-001	11.0000	Transportation-001	Transportation-001	STD-TRANSPORTA-001	2026-01-01	Transportation-001	10	STD-TRANSPORTA-001	2026-01-01	11.0000	Transportation-001	STD-TRANSPORTA-001	Transportation-001	Transportation-001	2026-01-01	STD-TRANSPORTA-001	2026-01-01	Transportation-001	2026-01-01	Transportation-001	2026-01-01	2026-01-01

default

ORDER_NOPK: 2
RUSH_INDR: Transportation-001
CUBIC_UOMPK: Transportation-001
CARTON_UOMPK: Transportation-001
NET_WT_UOMPK: Transportation-001
FREIGHT_SIZEPK: Transportation-001
FREIGHT_TYPEPK: Transportation-001
GROSS_WT_UOMPK: Transportation-001
ITEM_QTY_UOMPK: Transportation-001
CANDIDATE_INDR: 2026-01-01
VESSEL_SCAC_CODEPK: STD-TRANSPORTA-001
EXCHANGE_RATE_INDR: L
EXPORT_COUNTRY_IDPK: STD-TRANSPORTA-001
ORIGIN_COUNTRY_IDPK: STD-TRANSPORTA-001
TRANSPORTATION_IDRPK: 1000000001
CONTAINER_SCAC_CODEPK: STD-TRANSPORTA-001
CONSOLIDATION_COUNTRY_IDPK: STD-TRANSPORTA-001
ITEM: Transportation-001
CUBIC: 11.0000
FCR_ID: STD-TRANSPORTA-001
LOT_NO: Transportation-001
NET_WT: 11.0000
STATUS: ACTIVE
SEAL_ID: STD-TRANSPORTA-001
COMMENTS: Transportation-001
FCR_DATE: 2026-01-01
GROSS_WT: 11.0000
ITEM_QTY: 11.0000
BL_AWB_ID: STD-TRANSPORTA-001
VESSEL_ID: STD-TRANSPORTA-001
CARTON_QTY: 11.0000
INVOICE_ID: STD-TRANSPORTA-001
RECEIPT_ID: STD-TRANSPORTA-001
INVOICE_AMT: 11.0000
LADING_PORT: Transportation-001
SHIPMENT_NO: Transportation-001
CONTAINER_ID: STD-TRANSPORTA-001
INVOICE_DATE: 2026-01-01
SELECTED_IND: Transportation-001
TRAN_MODE_ID: 10
CURRENCY_CODE: STD-TRANSPORTA-001
DELIVERY_DATE: 2026-01-01
EXCHANGE_RATE: 11.0000
IN_TRANSIT_NO: Transportation-001
VOYAGE_FLT_ID: STD-TRANSPORTA-001
DISCHARGE_PORT: Transportation-001
PACKING_METHOD: Transportation-001
IN_TRANSIT_DATE: 2026-01-01
TRANS_PARTNER_ID: STD-TRANSPORTA-001
ACTUAL_DEPART_DATE: 2026-01-01
TRANS_PARTNER_TYPE: Transportation-001
ACTUAL_ARRIVAL_DATE: 2026-01-01
SERVICE_CONTRACT_NO: Transportation-001
ESTIMATED_DEPART_DATE: 2026-01-01
ESTIMATED_ARRIVAL_DATE: 2026-01-01

All objects