Complex Entity Component Minimum Maximum

In Scope

Technical: CE_COMP_MIN_MAX | ID: OR-FND-CE_COMP_MIN_MAX-COMPLEX_ENTITY_COMPONENT_MINIMUM_MAXIMUM

This table should only contain assessment components for which a minimum and maximum range is required for a given Customs Entry. For the US this is only MPF (Merchandise Processing...

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_COMP_MIN_MAX

Field Definitions(5)

Rules & Considerations(12)

constraint

validation

Sample Load Data(4)

_scenario	COMP_IDRPK	MAX_AMTR	MIN_AMTR	CURRENCY_CODER	IMPORT_COUNTRY_IDRPK
Example values from field definitions	SAMPLE	1.0000	1.0000	SAM	SAM
default	ALT-CE_COM	12.5000	12.5000	ALT	ALT
default	EDGE-CE_CO	14.0000	14.0000	EDG	EDG

Example values from field definitions

COMP_IDRPK: SAMPLE
MAX_AMTR: 1.0000
MIN_AMTR: 1.0000
CURRENCY_CODER: SAM
IMPORT_COUNTRY_IDRPK: SAM

default

COMP_IDRPK: ALT-CE_COM
MAX_AMTR: 12.5000
MIN_AMTR: 12.5000
CURRENCY_CODER: ALT
IMPORT_COUNTRY_IDRPK: ALT