Vessel/Voyage/Est
In ScopeTechnical: CE_SHIPMENT | ID: OR-FND-CE_SHIPMENT-COMPLEX_ENTITY_SHIPMENT
Stores the Vessel/Voyage/Est. Depart Date level information for the Customs Entry module.
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
- CE_SHIPMENT
Field Definitions(5)
Rules & Considerations(25)
constraint
validation
Sample Load Data(4)
| _scenario | CE_IDRPK | VESSEL_IDRPK | VOYAGE_FLT_IDRPK | ESTIMATED_DEPART_DATERPK | COMMENTS | EXPORT_DATE | IMPORT_DATE | LADING_PORT | SHIPMENT_NO | ARRIVAL_DATE | TRAN_MODE_ID | DISCHARGE_PORT | VESSEL_SCAC_CODE | EXPORT_COUNTRY_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPL | SAMPLE | 2026-01-01 | SAMPLE | SAMPL | SAMPLE | SAM |
| default | 1000000003 | ALT-CE_SHIPMEN-002 | ALT-CE_SHI | 2026-01-03 | Ce Shipment-002-ALT | 2026-01-03 | 2026-01-03 | Ce Sh | Ce Shipment-002-ALT | 2026-01-03 | Non | Ce Sh | ALT-CE | ALT |
| default | 1000000005 | EDGE-CE_SHIPMEN-003 | EDGE-CE_SH | 2026-01-05 | Ce Shipment-003-EDGE | 2026-01-05 | 2026-01-05 | Ce Sh | Ce Shipment-003-EDGE | 2026-01-05 | 11 | Ce Sh | EDGE-C | EDG |
Example values from field definitions
- CE_IDRPK
- 1
- VESSEL_IDRPK
- SAMPLE
- VOYAGE_FLT_IDRPK
- SAMPLE
- ESTIMATED_DEPART_DATERPK
- 2026-01-01
- COMMENTS
- SAMPLE
- EXPORT_DATE
- 2026-01-01
- IMPORT_DATE
- 2026-01-01
- LADING_PORT
- SAMPL
- SHIPMENT_NO
- SAMPLE
- ARRIVAL_DATE
- 2026-01-01
- TRAN_MODE_ID
- SAMPLE
- DISCHARGE_PORT
- SAMPL
- VESSEL_SCAC_CODE
- SAMPLE
- EXPORT_COUNTRY_ID
- SAM
default
- CE_IDRPK
- 1000000003
- VESSEL_IDRPK
- ALT-CE_SHIPMEN-002
- VOYAGE_FLT_IDRPK
- ALT-CE_SHI
- ESTIMATED_DEPART_DATERPK
- 2026-01-03
- COMMENTS
- Ce Shipment-002-ALT
- EXPORT_DATE
- 2026-01-03
- IMPORT_DATE
- 2026-01-03
- LADING_PORT
- Ce Sh
- SHIPMENT_NO
- Ce Shipment-002-ALT
- ARRIVAL_DATE
- 2026-01-03
- TRAN_MODE_ID
- Non
- DISCHARGE_PORT
- Ce Sh
- VESSEL_SCAC_CODE
- ALT-CE
- EXPORT_COUNTRY_ID
- ALT
default
- CE_IDRPK
- 1000000005
- VESSEL_IDRPK
- EDGE-CE_SHIPMEN-003
- VOYAGE_FLT_IDRPK
- EDGE-CE_SH
- ESTIMATED_DEPART_DATERPK
- 2026-01-05
- COMMENTS
- Ce Shipment-003-EDGE
- EXPORT_DATE
- 2026-01-05
- IMPORT_DATE
- 2026-01-05
- LADING_PORT
- Ce Sh
- SHIPMENT_NO
- Ce Shipment-003-EDGE
- ARRIVAL_DATE
- 2026-01-05
- TRAN_MODE_ID
- 11
- DISCHARGE_PORT
- Ce Sh
- VESSEL_SCAC_CODE
- EDGE-C
- EXPORT_COUNTRY_ID
- EDG
Rule Validation Summary
- Source Rule Count
- 29
- Governed Rule Count
- 25