Transportation

In Scope

Technical: 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(5)

Rules & Considerations(85)

constraint

validation

Sample Load Data(4)

_scenario	TRANSPORTATION_IDRPK	ITEM	CUBIC	FCR_ID	LOT_NO	NET_WT	STATUS	SEAL_ID	COMMENTS	FCR_DATE	GROSS_WT	ITEM_QTY	ORDER_NO	RUSH_IND	BL_AWB_ID	CUBIC_UOM	VESSEL_ID	CARTON_QTY	CARTON_UOM	INVOICE_ID	NET_WT_UOM	RECEIPT_ID	INVOICE_AMT	LADING_PORT	SHIPMENT_NO	CONTAINER_ID	FREIGHT_SIZE	FREIGHT_TYPE	GROSS_WT_UOM	INVOICE_DATE	ITEM_QTY_UOM	SELECTED_IND	TRAN_MODE_ID	CANDIDATE_IND	CURRENCY_CODE	DELIVERY_DATE	EXCHANGE_RATE	IN_TRANSIT_NO	VOYAGE_FLT_ID	DISCHARGE_PORT	PACKING_METHOD	IN_TRANSIT_DATE	TRANS_PARTNER_ID	VESSEL_SCAC_CODE	EXCHANGE_RATE_IND	EXPORT_COUNTRY_ID	ORIGIN_COUNTRY_ID	ACTUAL_DEPART_DATE	TRANS_PARTNER_TYPE	ACTUAL_ARRIVAL_DATE	CONTAINER_SCAC_CODE	SERVICE_CONTRACT_NO	ESTIMATED_DEPART_DATE	ESTIMATED_ARRIVAL_DATE	CONSOLIDATION_COUNTRY_ID
Example values from field definitions	1	SAMPLE	1.0000	SAMPLE	SAMPLE	1.0000	SAMPLE	SAMPLE	SAMPLE	2026-01-01	1.0000	1.0000	1	S	SAMPLE	SAMP	SAMPLE	1.0000	SAMP	SAMPLE	SAMP	SAMPLE	1.0000	SAMPL	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMP	2026-01-01	SAMP	S	SAMPLE	S	SAM	2026-01-01	1.0000000000	SAMPLE	SAMPLE	SAMPL	SAMPLE	2026-01-01	SAMPLE	SAMPLE	S	SAM	SAM	2026-01-01	SAMPLE	2026-01-01	SAMPLE	SAMPLE	2026-01-01	2026-01-01	SAM
default	1000000003	Transportation-002-ALT	12.5000	ALT-TRANSPORTA-	Transportation-	12.5000	PENDIN	ALT-TRANSPORTA-	Transportation-002-ALT	2026-01-03	12.5000	12.5000	4	T	ALT-TRANSPORTA-002	Tran	ALT-TRANSPORTA-002	12.5000	Tran	ALT-TRANSPORTA-002	Tran	ALT-TRANSPORTA-002	12.5000	Trans	Transportation-002-A	ALT-TRANSPORTA-002	Transp	Transp	Tran	2026-01-03	Tran	T	Non	2	ALT	2026-01-03	12.5000000000	Transportation-	ALT-TRANSP	Trans	Transp	2026-01-03	ALT-TRANSP	ALT-TR	P	ALT	ALT	2026-01-03	Transp	2026-01-03	ALT-TR	Transportation-	2026-01-03	2026-01-03	ALT
default	1000000005	Transportation-003-EDGE	14.0000	EDGE-TRANSPORTA	Transportation-	14.0000	ACTIVE	EDGE-TRANSPORTA	Transportation-003-EDGE	2026-01-05	14.0000	14.0000	6	T	EDGE-TRANSPORTA-003	Tran	EDGE-TRANSPORTA-003	14.0000	Tran	EDGE-TRANSPORTA-003	Tran	EDGE-TRANSPORTA-003	14.0000	Trans	Transportation-003-E	EDGE-TRANSPORTA-003	Transp	Transp	Tran	2026-01-05	Tran	T	12	2	EDG	2026-01-05	14.0000000000	Transportation-	EDGE-TRANS	Trans	Transp	2026-01-05	EDGE-TRANS	EDGE-T	L	EDG	EDG	2026-01-05	Transp	2026-01-05	EDGE-T	Transportation-	2026-01-05	2026-01-05	EDG

Example values from field definitions

TRANSPORTATION_IDRPK: 1
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
ORDER_NO: 1
RUSH_IND: S
BL_AWB_ID: SAMPLE
CUBIC_UOM: SAMP
VESSEL_ID: SAMPLE
CARTON_QTY: 1.0000
CARTON_UOM: SAMP
INVOICE_ID: SAMPLE
NET_WT_UOM: SAMP
RECEIPT_ID: SAMPLE
INVOICE_AMT: 1.0000
LADING_PORT: SAMPL
SHIPMENT_NO: SAMPLE
CONTAINER_ID: SAMPLE
FREIGHT_SIZE: SAMPLE
FREIGHT_TYPE: SAMPLE
GROSS_WT_UOM: SAMP
INVOICE_DATE: 2026-01-01
ITEM_QTY_UOM: SAMP
SELECTED_IND: S
TRAN_MODE_ID: SAMPLE
CANDIDATE_IND: S
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
VESSEL_SCAC_CODE: SAMPLE
EXCHANGE_RATE_IND: S
EXPORT_COUNTRY_ID: SAM
ORIGIN_COUNTRY_ID: SAM
ACTUAL_DEPART_DATE: 2026-01-01
TRANS_PARTNER_TYPE: SAMPLE
ACTUAL_ARRIVAL_DATE: 2026-01-01
CONTAINER_SCAC_CODE: SAMPLE
SERVICE_CONTRACT_NO: SAMPLE
ESTIMATED_DEPART_DATE: 2026-01-01
ESTIMATED_ARRIVAL_DATE: 2026-01-01
CONSOLIDATION_COUNTRY_ID: SAM

default

TRANSPORTATION_IDRPK: 1000000003
ITEM: Transportation-002-ALT
CUBIC: 12.5000
FCR_ID: ALT-TRANSPORTA-
LOT_NO: Transportation-
NET_WT: 12.5000
STATUS: PENDIN
SEAL_ID: ALT-TRANSPORTA-
COMMENTS: Transportation-002-ALT
FCR_DATE: 2026-01-03
GROSS_WT: 12.5000
ITEM_QTY: 12.5000
ORDER_NO: 4
RUSH_IND: T
BL_AWB_ID: ALT-TRANSPORTA-002
CUBIC_UOM: Tran
VESSEL_ID: ALT-TRANSPORTA-002
CARTON_QTY: 12.5000
CARTON_UOM: Tran
INVOICE_ID: ALT-TRANSPORTA-002
NET_WT_UOM: Tran
RECEIPT_ID: ALT-TRANSPORTA-002
INVOICE_AMT: 12.5000
LADING_PORT: Trans
SHIPMENT_NO: Transportation-002-A
CONTAINER_ID: ALT-TRANSPORTA-002
FREIGHT_SIZE: Transp
FREIGHT_TYPE: Transp
GROSS_WT_UOM: Tran
INVOICE_DATE: 2026-01-03
ITEM_QTY_UOM: Tran
SELECTED_IND: T
TRAN_MODE_ID: Non
CANDIDATE_IND: 2
CURRENCY_CODE: ALT
DELIVERY_DATE: 2026-01-03
EXCHANGE_RATE: 12.5000000000
IN_TRANSIT_NO: Transportation-
VOYAGE_FLT_ID: ALT-TRANSP
DISCHARGE_PORT: Trans
PACKING_METHOD: Transp
IN_TRANSIT_DATE: 2026-01-03
TRANS_PARTNER_ID: ALT-TRANSP
VESSEL_SCAC_CODE: ALT-TR
EXCHANGE_RATE_IND: P
EXPORT_COUNTRY_ID: ALT
ORIGIN_COUNTRY_ID: ALT
ACTUAL_DEPART_DATE: 2026-01-03
TRANS_PARTNER_TYPE: Transp
ACTUAL_ARRIVAL_DATE: 2026-01-03
CONTAINER_SCAC_CODE: ALT-TR
SERVICE_CONTRACT_NO: Transportation-
ESTIMATED_DEPART_DATE: 2026-01-03
ESTIMATED_ARRIVAL_DATE: 2026-01-03
CONSOLIDATION_COUNTRY_ID: ALT