Item HTS Assess

In Scope

Technical: ITEM_HTS_ASSESS | ID: OR-MFCS-ITEM_HTS_ASSESS

This table will store the assessments associated with a given item/hts code. These assessments are used in the compilation of Estimated and Actual Landed Cost for the item.

See how this object fits into Trade 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: ITEM_HTS_ASSESS

Field Definitions(22)

Rules & Considerations(73)

Sample Load Data(4)

_scenario	HTSR	ITEMRPK	COMP_IDRPK	CVB_CODEPK	COMP_RATER	CREATE_IDR	EFFECT_TOR	NOM_FLAG_1R	NOM_FLAG_2R	NOM_FLAG_3R	NOM_FLAG_4R	NOM_FLAG_5R	EFFECT_FROMR	DISPLAY_ORDERR	PER_COUNT_UOMPK	LAST_UPDATE_IDR	CREATE_DATETIMER	EST_ASSESS_VALUER	IMPORT_COUNTRY_IDRPK	ORIGIN_COUNTRY_IDRPK	LAST_UPDATE_DATETIMER	PER_COUNT
default	Item HTS Assess-001	Item HTS Assess-001	STD-ITEM_HTS-001	STD-ITEM_HTS-001	11.0000	USERENV	2026-01-06	Item HTS Assess-001	Item HTS Assess-001	Item HTS Assess-001	Item HTS Assess-001	Item HTS Assess-001	2026-01-06	01	Item HTS Assess-001	MIG_USER	2026-01-01	11.0000	STD-ITEM_HTS-001	STD-ITEM_HTS-001	2026-01-01	11.0000

default

HTSR: Item HTS Assess-001
ITEMRPK: Item HTS Assess-001
COMP_IDRPK: STD-ITEM_HTS-001
CVB_CODEPK: STD-ITEM_HTS-001
COMP_RATER: 11.0000
CREATE_IDR: USERENV
EFFECT_TOR: 2026-01-06
NOM_FLAG_1R: Item HTS Assess-001
NOM_FLAG_2R: Item HTS Assess-001
NOM_FLAG_3R: Item HTS Assess-001
NOM_FLAG_4R: Item HTS Assess-001
NOM_FLAG_5R: Item HTS Assess-001
EFFECT_FROMR: 2026-01-06
DISPLAY_ORDERR: 01
PER_COUNT_UOMPK: Item HTS Assess-001
LAST_UPDATE_IDR: MIG_USER
CREATE_DATETIMER: 2026-01-01
EST_ASSESS_VALUER: 11.0000
IMPORT_COUNTRY_IDRPK: STD-ITEM_HTS-001
ORIGIN_COUNTRY_IDRPK: STD-ITEM_HTS-001
LAST_UPDATE_DATETIMER: 2026-01-01
PER_COUNT: 11.0000

All objects