Items HTS Assess

Out of Scope

Technical: GTT_FC_ITEM_HTS_ASSESS | ID: OR-TRD-GTT_FC_ITEM_HTS_ASSESS-GTT_FC_ITEM_HTS_ASSESS

This is a global temporary table that is used to store the items HTS Assess.

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_FC_ITEM_HTS_ASSESS

Field Definitions(5)

Rules & Considerations(37)

validation

constraint

Sample Load Data(4)

_scenario	HTSR	ITEMR	EFFECT_FROMR	IMPORT_COUNTRY_IDR	ORIGIN_COUNTRY_IDR	COMP_ID	CVB_CODE	SUPPLIER	COMP_RATE	EFFECT_TO	PER_COUNT	NOM_FLAG_1	NOM_FLAG_2	NOM_FLAG_3	NOM_FLAG_4	NOM_FLAG_5	ACTIVE_DATE	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	SAMPLE	1.0000	2026-01-01	1.0000	S	S	S	S	S	2026-01-01	1	SAMPLE	SAMPLE	2026-01-01	1.0000	2026-01-01
default	Gtt Fc Item HTS Assess-00	Gtt Fc Item HTS Assess-00	2026-02-09	ALT	ALT	ALT-GTT_FC	ALT-GTT_FC	Gtt Fc Ite	12.5000	2026-02-09	12.5000	G	G	G	G	G	2026-01-03	3	Gtt Fc Ite	MDM_USER	2026-01-03	12.5000	2026-01-03
default	Gtt Fc Item HTS Assess-00	Gtt Fc Item HTS Assess-00	2026-03-12	EDG	EDG	EDGE-GTT_F	EDGE-GTT_F	Gtt Fc Ite	14.0000	2026-03-12	14.0000	G	G	G	G	G	2026-01-05	5	Gtt Fc Ite	BATCH_USER	2026-01-05	14.0000	2026-01-05

Example values from field definitions

HTSR: SAMPLE
ITEMR: SAMPLE
EFFECT_FROMR: 2026-01-01
IMPORT_COUNTRY_IDR: SAM
ORIGIN_COUNTRY_IDR: SAM
COMP_ID: SAMPLE
CVB_CODE: SAMPLE
SUPPLIER: SAMPLE
COMP_RATE: 1.0000
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
ACTIVE_DATE: 2026-01-01
DISPLAY_ORDER: 1
PER_COUNT_UOM: SAMPLE
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
EST_ASSESS_VALUE: 1.0000
LAST_UPDATE_DATETIME: 2026-01-01

default

HTSR: Gtt Fc Item HTS Assess-00
ITEMR: Gtt Fc Item HTS Assess-00
EFFECT_FROMR: 2026-02-09
IMPORT_COUNTRY_IDR: ALT
ORIGIN_COUNTRY_IDR: ALT
COMP_ID: ALT-GTT_FC
CVB_CODE: ALT-GTT_FC
SUPPLIER: Gtt Fc Ite
COMP_RATE: 12.5000
EFFECT_TO: 2026-02-09
PER_COUNT: 12.5000
NOM_FLAG_1: G
NOM_FLAG_2: G
NOM_FLAG_3: G
NOM_FLAG_4: G
NOM_FLAG_5: G
ACTIVE_DATE: 2026-01-03
DISPLAY_ORDER: 3
PER_COUNT_UOM: Gtt Fc Ite
LAST_UPDATE_ID: MDM_USER
CREATE_DATETIME: 2026-01-03
EST_ASSESS_VALUE: 12.5000
LAST_UPDATE_DATETIME: 2026-01-03

default

HTSR: Gtt Fc Item HTS Assess-00
ITEMR: Gtt Fc Item HTS Assess-00
EFFECT_FROMR: 2026-03-12
IMPORT_COUNTRY_IDR: EDG
ORIGIN_COUNTRY_IDR: EDG
COMP_ID: EDGE-GTT_F
CVB_CODE: EDGE-GTT_F
SUPPLIER: Gtt Fc Ite
COMP_RATE: 14.0000
EFFECT_TO: 2026-03-12
PER_COUNT: 14.0000
NOM_FLAG_1: G
NOM_FLAG_2: G
NOM_FLAG_3: G
NOM_FLAG_4: G
NOM_FLAG_5: G
ACTIVE_DATE: 2026-01-05
DISPLAY_ORDER: 5
PER_COUNT_UOM: Gtt Fc Ite
LAST_UPDATE_ID: BATCH_USER
CREATE_DATETIME: 2026-01-05
EST_ASSESS_VALUE: 14.0000
LAST_UPDATE_DATETIME: 2026-01-05

Rule Validation Summary

Source Rule Count: 59
Governed Rule Count: 37