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(34)
Rules & Considerations(54)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMRPK | CE_IDRPK | ORDER_NORPK | RUSH_INDR | CUBIC_UOMRPK | VESSEL_IDR | ALC_STATUSR | NET_WT_UOMRPK | GROSS_WT_UOMRPK | CURRENCY_CODERPK | VOYAGE_FLT_IDR | CLEARED_QTY_UOMRPK | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | S | SAMP | SAMPLE | SAMPLE | SAMP | SAMP | SAM | SAMPLE | SAMP | S | 1.0000 | 2026-01-01 | SAMP | 1.0000 | SAMPLE | 1.0000 | 2026-01-01 | SAMPLE | 1.0000 | SAMPLE | SAMPLE | 1.0000 | SAMPLE | 1.0000 | 1.0000 | 2026-01-01 | 1.0000000000 | SAMPLE | SAMP | 2026-01-01 | SAMPLE |
Example values from field definitions
- ITEMRPK
- SAMPLE
- CE_IDRPK
- 1
- ORDER_NORPK
- 1
- RUSH_INDR
- S
- CUBIC_UOMRPK
- SAMP
- VESSEL_IDR
- SAMPLE
- ALC_STATUSR
- SAMPLE
- NET_WT_UOMRPK
- SAMP
- GROSS_WT_UOMRPK
- SAMP
- CURRENCY_CODERPK
- SAM
- VOYAGE_FLT_IDR
- SAMPLE
- CLEARED_QTY_UOMRPK
- SAMP
- EXCHANGE_RATE_INDR
- S
- MANIFEST_ITEM_QTYR
- 1.0000
- ESTIMATED_DEPART_DATER
- 2026-01-01
- MANIFEST_ITEM_QTY_UOMR
- SAMP
- CUBIC
- 1.0000
- DO_NO
- SAMPLE
- NET_WT
- 1.0000
- DO_DATE
- 2026-01-01
- COMMENTS
- SAMPLE
- GROSS_WT
- 1.0000
- BL_AWB_ID
- SAMPLE
- RULING_NO
- SAMPLE
- CARTON_QTY
- 1.0000
- INVOICE_ID
- SAMPLE
- CLEARED_QTY
- 1.0000
- INVOICE_AMT
- 1.0000
- INVOICE_DATE
- 2026-01-01
- EXCHANGE_RATE
- 1.0000000000
- IN_TRANSIT_NO
- SAMPLE
- CARTON_QTY_UOM
- SAMP
- IN_TRANSIT_DATE
- 2026-01-01
- TARIFF_TREATMENT
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 96
- Governed Rule Count
- 54