Item HTS Assess

In Scope

Technical: ITEM_HTS_ASSESS | ID: OR-TRD-ITEM_HTS_ASSESS-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

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: ITEM_HTS_ASSESS

Field Definitions(5)

Rules & Considerations(56)

constraint

validation

Sample Load Data(4)

_scenario	HTSRPK	ITEMRPK	EFFECT_FROMRPK	IMPORT_COUNTRY_IDRPK	ORIGIN_COUNTRY_IDRPK	COMP_ID	CVB_CODE	COMP_RATE	CREATE_ID	EFFECT_TO	PER_COUNT	NOM_FLAG_1	NOM_FLAG_2	NOM_FLAG_3	NOM_FLAG_4	NOM_FLAG_5	DISPLAY_ORDER	PER_COUNT_UOM	LAST_UPDATE_ID	CREATE_DATETIME	EST_ASSESS_VALUE	LAST_UPDATE_DATETIME
Example values from field definitions	SAMPLE	SAMPLE	2026-01-01	SAM	SAM	SAMPLE	SAMPLE	1.0000	SAMPLE	2026-01-01	1.0000	S	S	S	S	S	1	SAMP	SAMPLE	2026-01-01	1.0000000000	2026-01-01
default	Item HTS Assess-002-ALT	Item HTS Assess-002-ALT	2026-02-09	ALT	ALT	ALT-ITEM_H	ALT-ITEM_H	12.5000	C LIENT_INFO	2026-02-09	12.5000	I	I	I	I	I	3	Item	MDM_USER	2026-01-03	12.5000000000	2026-01-03
default	Item HTS Assess-003-EDGE	Item HTS Assess-003-EDGE	2026-03-12	EDG	EDG	EDGE-ITEM_	EDGE-ITEM_	14.0000	USE RENV	2026-03-12	14.0000	I	I	I	I	I	5	Item	BATCH_USER	2026-01-05	14.0000000000	2026-01-05

Example values from field definitions

HTSRPK: SAMPLE
ITEMRPK: SAMPLE
EFFECT_FROMRPK: 2026-01-01
IMPORT_COUNTRY_IDRPK: SAM
ORIGIN_COUNTRY_IDRPK: SAM
COMP_ID: SAMPLE
CVB_CODE: SAMPLE
COMP_RATE: 1.0000
CREATE_ID: SAMPLE
EFFECT_TO: 2026-01-01
PER_COUNT: 1.0000
NOM_FLAG_1: S
NOM_FLAG_2: S
NOM_FLAG_3: S
NOM_FLAG_4: S
NOM_FLAG_5: S
DISPLAY_ORDER: 1
PER_COUNT_UOM: SAMP
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
EST_ASSESS_VALUE: 1.0000000000
LAST_UPDATE_DATETIME: 2026-01-01

default

HTSRPK: Item HTS Assess-002-ALT
ITEMRPK: Item HTS Assess-002-ALT
EFFECT_FROMRPK: 2026-02-09
IMPORT_COUNTRY_IDRPK: ALT
ORIGIN_COUNTRY_IDRPK: ALT
COMP_ID: ALT-ITEM_H
CVB_CODE: ALT-ITEM_H
COMP_RATE: 12.5000
CREATE_ID: C LIENT_INFO
EFFECT_TO: 2026-02-09
PER_COUNT: 12.5000
NOM_FLAG_1: I
NOM_FLAG_2: I
NOM_FLAG_3: I
NOM_FLAG_4: I
NOM_FLAG_5: I
DISPLAY_ORDER: 3
PER_COUNT_UOM: Item
LAST_UPDATE_ID: MDM_USER
CREATE_DATETIME: 2026-01-03
EST_ASSESS_VALUE: 12.5000000000
LAST_UPDATE_DATETIME: 2026-01-03