Module Order Item HTS

In Scope

Technical: MOD_ORDER_ITEM_HTS | ID: OR-TRD-MOD_ORDER_ITEM_HTS-MODULE_ORDER_ITEM_HTS

This table is used for reporting purposes to show which items and order/items are impacted after HTS upload program has been processed. It will be purged prior to HTS upload...

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

Field Definitions(5)

Rules & Considerations(9)

constraint

validation

Sample Load Data(4)

_scenario	HTS	ITEM	ORDER_NO	PGM_NAME	EFFECT_TO	EFFECT_FROM	UNAPPROVE_IND	UPDATED_DATETIME	IMPORT_COUNTRY_ID
Example values from field definitions	SAMPLE	SAMPLE	1	SAMPLE	2026-01-01	2026-01-01	S	2026-01-01	SAM
default	Mod Order Item HTS-002-AL	Mod Order Item HTS-002-AL	4	UPGRADE	2026-02-09	2026-02-09	M	2026-01-03	ALT
default	Mod Order Item HTS-003-ED	Mod Order Item HTS-003-ED	6	UPGRADE	2026-03-12	2026-03-12	M	2026-01-05	EDG

Example values from field definitions

HTS: SAMPLE
ITEM: SAMPLE
ORDER_NO: 1
PGM_NAME: SAMPLE
EFFECT_TO: 2026-01-01
EFFECT_FROM: 2026-01-01
UNAPPROVE_IND: S
UPDATED_DATETIME: 2026-01-01
IMPORT_COUNTRY_ID: SAM

default

HTS: Mod Order Item HTS-002-AL
ITEM: Mod Order Item HTS-002-AL
ORDER_NO: 4
PGM_NAME: UPGRADE
EFFECT_TO: 2026-02-09
EFFECT_FROM: 2026-02-09
UNAPPROVE_IND: M
UPDATED_DATETIME: 2026-01-03
IMPORT_COUNTRY_ID: ALT