Gtt Item HTS Assess

Out of Scope

Technical: GTT_ITEM_HTS_ASSESS | ID: OR-TRD-GTT_ITEM_HTS_ASSESS-GTT_ITEM_HTS_ASSESS

This table is a Global temporary table that will hold the original ITEM_HTS_ASSESS records for a given item/hts code. This temporary table will be used to determine if a cost...

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: gtt

Target Structure

Load Approach: Table
Target Objects: GTT_ITEM_HTS_ASSESS

Field Definitions(5)

Rules & Considerations(17)

Sample Load Data(4)

_scenario	HTS	ITEM	COMP_ID	CVB_CODE	COMP_RATE	PER_COUNT	NOM_FLAG_1	NOM_FLAG_2	NOM_FLAG_3	NOM_FLAG_4	NOM_FLAG_5	DISPLAY_ORDER	PER_COUNT_UOM	EFFECT_TO_DATE	LAST_UPDATE_ID	CREATE_DATETIME	EFFECT_FROM_DATE	EST_ASSESS_VALUE	IMPORT_COUNTRY_ID	ORIGIN_COUNTRY_ID	LAST_UPDATE_DATETIME
Example values from field definitions	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1.0000	1.0000	S	S	S	S	S	1	SAMP	2026-01-01	SAMPLE	2026-01-01	2026-01-01	1.0000	SAM	SAM	2026-01-01
default	Gtt Item HTS Assess-002-A	Gtt Item HTS Assess-002-A	ALT-GTT_IT	ALT-GTT_IT	12.5000	12.5000	G	G	G	G	G	3	Gtt	2026-01-03	MDM_USER	2026-01-03	2026-01-03	12.5000	ALT	ALT	2026-01-03
default	Gtt Item HTS Assess-003-E	Gtt Item HTS Assess-003-E	EDGE-GTT_I	EDGE-GTT_I	14.0000	14.0000	G	G	G	G	G	5	Gtt	2026-01-05	BATCH_USER	2026-01-05	2026-01-05	14.0000	EDG	EDG	2026-01-05

Example values from field definitions

HTS: SAMPLE
ITEM: SAMPLE
COMP_ID: SAMPLE
CVB_CODE: SAMPLE
COMP_RATE: 1.0000
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
EFFECT_TO_DATE: 2026-01-01
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
EFFECT_FROM_DATE: 2026-01-01
EST_ASSESS_VALUE: 1.0000
IMPORT_COUNTRY_ID: SAM
ORIGIN_COUNTRY_ID: SAM
LAST_UPDATE_DATETIME: 2026-01-01

default

HTS: Gtt Item HTS Assess-002-A
ITEM: Gtt Item HTS Assess-002-A
COMP_ID: ALT-GTT_IT
CVB_CODE: ALT-GTT_IT
COMP_RATE: 12.5000
PER_COUNT: 12.5000
NOM_FLAG_1: G
NOM_FLAG_2: G
NOM_FLAG_3: G
NOM_FLAG_4: G
NOM_FLAG_5: G
DISPLAY_ORDER: 3
PER_COUNT_UOM: Gtt
EFFECT_TO_DATE: 2026-01-03
LAST_UPDATE_ID: MDM_USER
CREATE_DATETIME: 2026-01-03
EFFECT_FROM_DATE: 2026-01-03
EST_ASSESS_VALUE: 12.5000
IMPORT_COUNTRY_ID: ALT
ORIGIN_COUNTRY_ID: ALT
LAST_UPDATE_DATETIME: 2026-01-03

default

HTS: Gtt Item HTS Assess-003-E
ITEM: Gtt Item HTS Assess-003-E
COMP_ID: EDGE-GTT_I
CVB_CODE: EDGE-GTT_I
COMP_RATE: 14.0000
PER_COUNT: 14.0000
NOM_FLAG_1: G
NOM_FLAG_2: G
NOM_FLAG_3: G
NOM_FLAG_4: G
NOM_FLAG_5: G
DISPLAY_ORDER: 5
PER_COUNT_UOM: Gtt
EFFECT_TO_DATE: 2026-01-05
LAST_UPDATE_ID: BATCH_USER
CREATE_DATETIME: 2026-01-05
EFFECT_FROM_DATE: 2026-01-05
EST_ASSESS_VALUE: 14.0000
IMPORT_COUNTRY_ID: EDG
ORIGIN_COUNTRY_ID: EDG
LAST_UPDATE_DATETIME: 2026-01-05

Rule Validation Summary

Source Rule Count: 20
Governed Rule Count: 17

All objects