Complex Entity Order Item
In ScopeTechnical: CE_ORD_ITEM | ID: OR-ITM-CE_ORD_ITEM-COMPLEX_ENTITY_ORDER_ITEM
Stores all Item level information need in clearing customs.
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_ORD_ITEM
Field Definitions(5)
Rules & Considerations(64)
validation
constraint
Sample Load Data(4)
| _scenario | CE_IDRPK | ORDER_NORPK | VESSEL_IDRPK | VOYAGE_FLT_IDRPK | ESTIMATED_DEPART_DATERPK | ITEM | CUBIC | DO_NO | NET_WT | DO_DATE | COMMENTS | GROSS_WT | RUSH_IND | BL_AWB_ID | CUBIC_UOM | RULING_NO | ALC_STATUS | CARTON_QTY | INVOICE_ID | NET_WT_UOM | CLEARED_QTY | INVOICE_AMT | GROSS_WT_UOM | INVOICE_DATE | CURRENCY_CODE | EXCHANGE_RATE | IN_TRANSIT_NO | CARTON_QTY_UOM | CLEARED_QTY_UOM | IN_TRANSIT_DATE | TARIFF_TREATMENT | EXCHANGE_RATE_IND | MANIFEST_ITEM_QTY | MANIFEST_ITEM_QTY_UOM |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 1.0000 | SAMPLE | 1.0000 | 2026-01-01 | SAMPLE | 1.0000 | S | SAMPLE | SAMP | SAMPLE | SAMPLE | 1.0000 | SAMPLE | SAMP | 1.0000 | 1.0000 | SAMP | 2026-01-01 | SAM | 1.0000000000 | SAMPLE | SAMP | SAMP | 2026-01-01 | SAMPLE | S | 1.0000 | SAMP |
| default | 1000000003 | 4 | ALT-CE_ORD-002 | ALT-CE_ORD | 2026-01-03 | Ce Ord Item-002-ALT | 12.5000 | Ce Ord Ite | 12.5000 | 2026-01-03 | Ce Ord Item-002-ALT | 12.5000 | C | ALT-CE_ORD-002 | Ce O | Ce Ord Ite | PENDIN | 12.5000 | ALT-CE_ORD-002 | Ce O | 12.5000 | 12.5000 | Ce O | 2026-01-03 | ALT | 12.5000000000 | Ce Ord Item-002 | Ce O | Ce O | 2026-01-03 | Ce Ord Ite | P | 12.5000 | Ce O |
| default | 1000000005 | 6 | EDGE-CE_ORD-003 | EDGE-CE_OR | 2026-01-05 | Ce Ord Item-003-EDGE | 14.0000 | Ce Ord Ite | 14.0000 | 2026-01-05 | Ce Ord Item-003-EDGE | 14.0000 | C | EDGE-CE_ORD-003 | Ce O | Ce Ord Ite | ACTIVE | 14.0000 | EDGE-CE_ORD-003 | Ce O | 14.0000 | 14.0000 | Ce O | 2026-01-05 | EDG | 14.0000000000 | Ce Ord Item-003 | Ce O | Ce O | 2026-01-05 | Ce Ord Ite | L | 14.0000 | Ce O |
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
- CUBIC
- 1.0000
- DO_NO
- SAMPLE
- NET_WT
- 1.0000
- DO_DATE
- 2026-01-01
- COMMENTS
- SAMPLE
- GROSS_WT
- 1.0000
- RUSH_IND
- S
- BL_AWB_ID
- SAMPLE
- CUBIC_UOM
- SAMP
- RULING_NO
- SAMPLE
- ALC_STATUS
- SAMPLE
- CARTON_QTY
- 1.0000
- INVOICE_ID
- SAMPLE
- NET_WT_UOM
- SAMP
- CLEARED_QTY
- 1.0000
- INVOICE_AMT
- 1.0000
- GROSS_WT_UOM
- SAMP
- INVOICE_DATE
- 2026-01-01
- CURRENCY_CODE
- SAM
- EXCHANGE_RATE
- 1.0000000000
- IN_TRANSIT_NO
- SAMPLE
- CARTON_QTY_UOM
- SAMP
- CLEARED_QTY_UOM
- SAMP
- IN_TRANSIT_DATE
- 2026-01-01
- TARIFF_TREATMENT
- SAMPLE
- EXCHANGE_RATE_IND
- S
- MANIFEST_ITEM_QTY
- 1.0000
- MANIFEST_ITEM_QTY_UOM
- SAMP
default
- CE_IDRPK
- 1000000003
- ORDER_NORPK
- 4
- VESSEL_IDRPK
- ALT-CE_ORD-002
- VOYAGE_FLT_IDRPK
- ALT-CE_ORD
- ESTIMATED_DEPART_DATERPK
- 2026-01-03
- ITEM
- Ce Ord Item-002-ALT
- CUBIC
- 12.5000
- DO_NO
- Ce Ord Ite
- NET_WT
- 12.5000
- DO_DATE
- 2026-01-03
- COMMENTS
- Ce Ord Item-002-ALT
- GROSS_WT
- 12.5000
- RUSH_IND
- C
- BL_AWB_ID
- ALT-CE_ORD-002
- CUBIC_UOM
- Ce O
- RULING_NO
- Ce Ord Ite
- ALC_STATUS
- PENDIN
- CARTON_QTY
- 12.5000
- INVOICE_ID
- ALT-CE_ORD-002
- NET_WT_UOM
- Ce O
- CLEARED_QTY
- 12.5000
- INVOICE_AMT
- 12.5000
- GROSS_WT_UOM
- Ce O
- INVOICE_DATE
- 2026-01-03
- CURRENCY_CODE
- ALT
- EXCHANGE_RATE
- 12.5000000000
- IN_TRANSIT_NO
- Ce Ord Item-002
- CARTON_QTY_UOM
- Ce O
- CLEARED_QTY_UOM
- Ce O
- IN_TRANSIT_DATE
- 2026-01-03
- TARIFF_TREATMENT
- Ce Ord Ite
- EXCHANGE_RATE_IND
- P
- MANIFEST_ITEM_QTY
- 12.5000
- MANIFEST_ITEM_QTY_UOM
- Ce O
default
- CE_IDRPK
- 1000000005
- ORDER_NORPK
- 6
- VESSEL_IDRPK
- EDGE-CE_ORD-003
- VOYAGE_FLT_IDRPK
- EDGE-CE_OR
- ESTIMATED_DEPART_DATERPK
- 2026-01-05
- ITEM
- Ce Ord Item-003-EDGE
- CUBIC
- 14.0000
- DO_NO
- Ce Ord Ite
- NET_WT
- 14.0000
- DO_DATE
- 2026-01-05
- COMMENTS
- Ce Ord Item-003-EDGE
- GROSS_WT
- 14.0000
- RUSH_IND
- C
- BL_AWB_ID
- EDGE-CE_ORD-003
- CUBIC_UOM
- Ce O
- RULING_NO
- Ce Ord Ite
- ALC_STATUS
- ACTIVE
- CARTON_QTY
- 14.0000
- INVOICE_ID
- EDGE-CE_ORD-003
- NET_WT_UOM
- Ce O
- CLEARED_QTY
- 14.0000
- INVOICE_AMT
- 14.0000
- GROSS_WT_UOM
- Ce O
- INVOICE_DATE
- 2026-01-05
- CURRENCY_CODE
- EDG
- EXCHANGE_RATE
- 14.0000000000
- IN_TRANSIT_NO
- Ce Ord Item-003
- CARTON_QTY_UOM
- Ce O
- CLEARED_QTY_UOM
- Ce O
- IN_TRANSIT_DATE
- 2026-01-05
- TARIFF_TREATMENT
- Ce Ord Ite
- EXCHANGE_RATE_IND
- L
- MANIFEST_ITEM_QTY
- 14.0000
- MANIFEST_ITEM_QTY_UOM
- Ce O
Rule Validation Summary
- Source Rule Count
- 106
- Governed Rule Count
- 64