Item HTS
In ScopeTechnical: ITEM_HTS | ID: OR-TRD-ITEM_HTS-ITEM_HTS
Stores the Harmonized Tariff Schedule (HTS) codes that are associated with a given item and associated details.
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
Field Definitions(5)
Rules & Considerations(31)
constraint
validation
Sample Load Data(4)
| _scenario | HTSRPK | ITEMRPK | EFFECT_FROMRPK | IMPORT_COUNTRY_IDRPK | ORIGIN_COUNTRY_IDRPK | STATUS | CREATE_ID | EFFECT_TO | LAST_UPDATE_ID | CREATE_DATETIME | CLEARING_ZONE_ID | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | 2026-01-01 | SAM | SAM | S | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPL | 2026-01-01 |
| default | Item HTS-002-ALT | Item HTS-002-ALT | 2026-02-09 | ALT | ALT | A | C LIENT_INFO | 2026-02-09 | MDM_USER | 2026-01-03 | ALT-I | 2026-01-03 |
| default | Item HTS-003-EDGE | Item HTS-003-EDGE | 2026-03-12 | EDG | EDG | A | USE RENV | 2026-03-12 | BATCH_USER | 2026-01-05 | EDGE- | 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
- STATUS
- S
- CREATE_ID
- SAMPLE
- EFFECT_TO
- 2026-01-01
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- CLEARING_ZONE_ID
- SAMPL
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- HTSRPK
- Item HTS-002-ALT
- ITEMRPK
- Item HTS-002-ALT
- EFFECT_FROMRPK
- 2026-02-09
- IMPORT_COUNTRY_IDRPK
- ALT
- ORIGIN_COUNTRY_IDRPK
- ALT
- STATUS
- A
- CREATE_ID
- C LIENT_INFO
- EFFECT_TO
- 2026-02-09
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- CLEARING_ZONE_ID
- ALT-I
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- HTSRPK
- Item HTS-003-EDGE
- ITEMRPK
- Item HTS-003-EDGE
- EFFECT_FROMRPK
- 2026-03-12
- IMPORT_COUNTRY_IDRPK
- EDG
- ORIGIN_COUNTRY_IDRPK
- EDG
- STATUS
- A
- CREATE_ID
- USE RENV
- EFFECT_TO
- 2026-03-12
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- CLEARING_ZONE_ID
- EDGE-
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 51
- Governed Rule Count
- 31