Complex Entity Header

In Scope

Technical: CE_HEAD | ID: OR-FND-CE_HEAD-COMPLEX_ENTITY_HEADER

This table will hold the header level information in the Customs Entry dialog. The CE_ID will be the primary key since entry details might show up before the Customs assigned...

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_HEAD

Field Definitions(5)

Rules & Considerations(48)

Sample Load Data(4)

_scenario	CE_IDRPK	STATUSR	PAYEE	BOND_NO	FILE_NO	BATCH_NO	COMMENTS	ENTRY_NO	LIVE_IND	BOND_TYPE	BROKER_ID	ENTRY_DATE	ENTRY_PORT	ENTRY_TEAM	ENTRY_TYPE	PAYEE_TYPE	IMPORTER_ID	SURETY_CODE	CONSIGNEE_ID	ENTRY_STATUS	RELEASE_DATE	SUMMARY_DATE	BROKER_REF_ID	CURRENCY_CODE	EXCHANGE_RATE	LOCATION_CODE	DOWNLOADED_IND	LIQUIDATION_AMT	MERCHANDISE_LOC	LIQUIDATION_DATE	EXCHANGE_RATE_IND	IMPORT_COUNTRY_ID	RELIQUIDATION_AMT	RELIQUIDATION_DATE
Example values from field definitions	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	2026-01-01	SAMPL	SAM	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	2026-01-01	SAMPLE	SAM	1.0000000000	SAMP	S	1.0000	SAMPLE	2026-01-01	S	SAM	1.0000	2026-01-01
default	1000000003	PENDIN	Ce Head-00	Ce Head-002-ALT	Ce Head-002-ALT	Ce Head-002-ALT	Ce Head-002-ALT	Ce Head-002-ALT	N	Ce Hea	ALT-CE_HEA	2026-01-03	Ce He	Ce	Ce Hea	IA	ALT-CE_HEA	ALT-CE	ALT-CE_HEA	PENDIN	2026-01-03	2026-01-03	ALT-CE_HEAD-002	ALT	12.5000000000	ALT-	N	12.5000	Ce Head-002-ALT	2026-01-03	P	ALT	12.5000	2026-01-03
default	1000000005	ACTIVE	Ce Head-00	Ce Head-003-EDGE	Ce Head-003-EDGE	Ce Head-003-EDGE	Ce Head-003-EDGE	Ce Head-003-EDGE	Y	Ce Hea	EDGE-CE_HE	2026-01-05	Ce He	Ce	Ce Hea	IA	EDGE-CE_HE	EDGE-C	EDGE-CE_HE	ACTIVE	2026-01-05	2026-01-05	EDGE-CE_HEAD-003	EDG	14.0000000000	EDGE	N	14.0000	Ce Head-003-EDGE	2026-01-05	L	EDG	14.0000	2026-01-05

Example values from field definitions

CE_IDRPK: 1
STATUSR: SAMPLE
PAYEE: SAMPLE
BOND_NO: SAMPLE
FILE_NO: SAMPLE
BATCH_NO: SAMPLE
COMMENTS: SAMPLE
ENTRY_NO: SAMPLE
LIVE_IND: S
BOND_TYPE: SAMPLE
BROKER_ID: SAMPLE
ENTRY_DATE: 2026-01-01
ENTRY_PORT: SAMPL
ENTRY_TEAM: SAM
ENTRY_TYPE: SAMPLE
PAYEE_TYPE: SAMPLE
IMPORTER_ID: SAMPLE
SURETY_CODE: SAMPLE
CONSIGNEE_ID: SAMPLE
ENTRY_STATUS: SAMPLE
RELEASE_DATE: 2026-01-01
SUMMARY_DATE: 2026-01-01
BROKER_REF_ID: SAMPLE
CURRENCY_CODE: SAM
EXCHANGE_RATE: 1.0000000000
LOCATION_CODE: SAMP
DOWNLOADED_IND: S
LIQUIDATION_AMT: 1.0000
MERCHANDISE_LOC: SAMPLE
LIQUIDATION_DATE: 2026-01-01
EXCHANGE_RATE_IND: S
IMPORT_COUNTRY_ID: SAM
RELIQUIDATION_AMT: 1.0000
RELIQUIDATION_DATE: 2026-01-01

default

CE_IDRPK: 1000000003
STATUSR: PENDIN
PAYEE: Ce Head-00
BOND_NO: Ce Head-002-ALT
FILE_NO: Ce Head-002-ALT
BATCH_NO: Ce Head-002-ALT
COMMENTS: Ce Head-002-ALT
ENTRY_NO: Ce Head-002-ALT
LIVE_IND: N
BOND_TYPE: Ce Hea
BROKER_ID: ALT-CE_HEA
ENTRY_DATE: 2026-01-03
ENTRY_PORT: Ce He
ENTRY_TEAM: Ce
ENTRY_TYPE: Ce Hea
PAYEE_TYPE: IA
IMPORTER_ID: ALT-CE_HEA
SURETY_CODE: ALT-CE
CONSIGNEE_ID: ALT-CE_HEA
ENTRY_STATUS: PENDIN
RELEASE_DATE: 2026-01-03
SUMMARY_DATE: 2026-01-03
BROKER_REF_ID: ALT-CE_HEAD-002
CURRENCY_CODE: ALT
EXCHANGE_RATE: 12.5000000000
LOCATION_CODE: ALT-
DOWNLOADED_IND: N
LIQUIDATION_AMT: 12.5000
MERCHANDISE_LOC: Ce Head-002-ALT
LIQUIDATION_DATE: 2026-01-03
EXCHANGE_RATE_IND: P
IMPORT_COUNTRY_ID: ALT
RELIQUIDATION_AMT: 12.5000
RELIQUIDATION_DATE: 2026-01-03

default

CE_IDRPK: 1000000005
STATUSR: ACTIVE
PAYEE: Ce Head-00
BOND_NO: Ce Head-003-EDGE
FILE_NO: Ce Head-003-EDGE
BATCH_NO: Ce Head-003-EDGE
COMMENTS: Ce Head-003-EDGE
ENTRY_NO: Ce Head-003-EDGE
LIVE_IND: Y
BOND_TYPE: Ce Hea
BROKER_ID: EDGE-CE_HE
ENTRY_DATE: 2026-01-05
ENTRY_PORT: Ce He
ENTRY_TEAM: Ce
ENTRY_TYPE: Ce Hea
PAYEE_TYPE: IA
IMPORTER_ID: EDGE-CE_HE
SURETY_CODE: EDGE-C
CONSIGNEE_ID: EDGE-CE_HE
ENTRY_STATUS: ACTIVE
RELEASE_DATE: 2026-01-05
SUMMARY_DATE: 2026-01-05
BROKER_REF_ID: EDGE-CE_HEAD-003
CURRENCY_CODE: EDG
EXCHANGE_RATE: 14.0000000000
LOCATION_CODE: EDGE
DOWNLOADED_IND: N
LIQUIDATION_AMT: 14.0000
MERCHANDISE_LOC: Ce Head-003-EDGE
LIQUIDATION_DATE: 2026-01-05
EXCHANGE_RATE_IND: L
IMPORT_COUNTRY_ID: EDG
RELIQUIDATION_AMT: 14.0000
RELIQUIDATION_DATE: 2026-01-05

Rule Validation Summary

Source Rule Count: 57
Governed Rule Count: 48

All objects