Complex Entity Lic Visa

In Scope

Technical: CE_LIC_VISA | ID: OR-ITM-CE_LIC_VISA-COMPLEX_ENTITY_LIC_VISA

This table is used to store license and visa information for the Customs Entry item.

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
CE_LIC_VISA

Field Definitions(5)

Rules & Considerations(36)

constraint

validation

Sample Load Data(4)

Example values from field definitions

CE_IDRPK
1
ORDER_NORPK
1
VESSEL_IDRPK
SAMPLE
VOYAGE_FLT_IDRPK
SAMPLE
ESTIMATED_DEPART_DATERPK
2026-01-01
ITEM
SAMPLE
COMMENTS
SAMPLE
HOLDER_ID
SAMPLE
QUOTA_CAT
SAMPLE
NET_WEIGHT
1.0000
NET_WEIGHT_UOM
SAMP
LICENSE_VISA_ID
SAMPLE
LICENSE_VISA_QTY
1.0000
LICENSE_VISA_TYPE
SAMPLE
LICENSE_VISA_QTY_UOM
SAMP

default

CE_IDRPK
1000000003
ORDER_NORPK
4
VESSEL_IDRPK
ALT-CE_LIC-002
VOYAGE_FLT_IDRPK
ALT-CE_LIC
ESTIMATED_DEPART_DATERPK
2026-01-03
ITEM
Ce Lic Visa-002-ALT
COMMENTS
Ce Lic Visa-002-ALT
HOLDER_ID
ALT-CE_LIC-002
QUOTA_CAT
Ce Lic
NET_WEIGHT
12.5000
NET_WEIGHT_UOM
Ce L
LICENSE_VISA_ID
ALT-CE_LIC-002
LICENSE_VISA_QTY
12.5000
LICENSE_VISA_TYPE
Ce Lic
LICENSE_VISA_QTY_UOM
Ce L

default

CE_IDRPK
1000000005
ORDER_NORPK
6
VESSEL_IDRPK
EDGE-CE_LIC-003
VOYAGE_FLT_IDRPK
EDGE-CE_LI
ESTIMATED_DEPART_DATERPK
2026-01-05
ITEM
Ce Lic Visa-003-EDGE
COMMENTS
Ce Lic Visa-003-EDGE
HOLDER_ID
EDGE-CE_LIC-003
QUOTA_CAT
Ce Lic
NET_WEIGHT
14.0000
NET_WEIGHT_UOM
Ce L
LICENSE_VISA_ID
EDGE-CE_LIC-003
LICENSE_VISA_QTY
14.0000
LICENSE_VISA_TYPE
Ce Lic
LICENSE_VISA_QTY_UOM
Ce L

Rule Validation Summary

Source Rule Count
42
Governed Rule Count
36