Ce Ord Item
In ScopeTechnical: CE_ORD_ITEM | ID: OR-MFCS-CE_ORD_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
Target Structure
- Load Approach
- Table
- Target Objects
- CE_ORD_ITEM
Field Definitions(34)
Rules & Considerations(46)
Sample Load Data(4)
| _scenario | ITEMRPK | CE_IDRPK | ORDER_NORPK | RUSH_INDR | CUBIC_UOMPK | VESSEL_IDR | ALC_STATUSR | NET_WT_UOMPK | GROSS_WT_UOMPK | CURRENCY_CODEPK | VOYAGE_FLT_IDR | CLEARED_QTY_UOMPK | EXCHANGE_RATE_INDR | MANIFEST_ITEM_QTYR | ESTIMATED_DEPART_DATER | MANIFEST_ITEM_QTY_UOMR | CUBIC | DO_NO | NET_WT | DO_DATE | COMMENTS | GROSS_WT | BL_AWB_ID | RULING_NO | CARTON_QTY | INVOICE_ID | CLEARED_QTY | INVOICE_AMT | INVOICE_DATE | EXCHANGE_RATE | IN_TRANSIT_NO | CARTON_QTY_UOM | IN_TRANSIT_DATE | TARIFF_TREATMENT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Ce Ord Item-001 | 1000000001 | 2 | Ce Ord Item-001 | Ce Ord Item-001 | STD-CE_ORD-001 | ACTIVE | Ce Ord Item-001 | Ce Ord Item-001 | STD-CE_ORD-001 | STD-CE_ORD-001 | Ce Ord Item-001 | L | 11.0000 | 2026-01-01 | Ce Ord Item-001 | 11.0000 | Ce Ord Item-001 | 11.0000 | 2026-01-01 | Ce Ord Item-001 | 11.0000 | STD-CE_ORD-001 | Ce Ord Item-001 | 11.0000 | STD-CE_ORD-001 | 11.0000 | 11.0000 | 2026-01-01 | 11.0000 | Ce Ord Item-001 | Ce Ord Item-001 | 2026-01-01 | Ce Ord Item-001 |
default
- ITEMRPK
- Ce Ord Item-001
- CE_IDRPK
- 1000000001
- ORDER_NORPK
- 2
- RUSH_INDR
- Ce Ord Item-001
- CUBIC_UOMPK
- Ce Ord Item-001
- VESSEL_IDR
- STD-CE_ORD-001
- ALC_STATUSR
- ACTIVE
- NET_WT_UOMPK
- Ce Ord Item-001
- GROSS_WT_UOMPK
- Ce Ord Item-001
- CURRENCY_CODEPK
- STD-CE_ORD-001
- VOYAGE_FLT_IDR
- STD-CE_ORD-001
- CLEARED_QTY_UOMPK
- Ce Ord Item-001
- EXCHANGE_RATE_INDR
- L
- MANIFEST_ITEM_QTYR
- 11.0000
- ESTIMATED_DEPART_DATER
- 2026-01-01
- MANIFEST_ITEM_QTY_UOMR
- Ce Ord Item-001
- CUBIC
- 11.0000
- DO_NO
- Ce Ord Item-001
- NET_WT
- 11.0000
- DO_DATE
- 2026-01-01
- COMMENTS
- Ce Ord Item-001
- GROSS_WT
- 11.0000
- BL_AWB_ID
- STD-CE_ORD-001
- RULING_NO
- Ce Ord Item-001
- CARTON_QTY
- 11.0000
- INVOICE_ID
- STD-CE_ORD-001
- CLEARED_QTY
- 11.0000
- INVOICE_AMT
- 11.0000
- INVOICE_DATE
- 2026-01-01
- EXCHANGE_RATE
- 11.0000
- IN_TRANSIT_NO
- Ce Ord Item-001
- CARTON_QTY_UOM
- Ce Ord Item-001
- IN_TRANSIT_DATE
- 2026-01-01
- TARIFF_TREATMENT
- Ce Ord Item-001