Ordsku HTS
In ScopeTechnical: ORDSKU_HTS | ID: OR-TRD-ORDSKU_HTS-ORDSKU_HTS
This table will hold the Harmonized Tariff Schedule (HTS) codes that have associated with a given item on a particular purchase order.
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
- ORDSKU_HTS
Field Definitions(5)
Rules & Considerations(30)
constraint
validation
Sample Load Data(4)
| _scenario | HTSR | ITEMR | SEQ_NORPK | ORDER_NORPK | STATUS | EFFECT_TO | PACK_ITEM | EFFECT_FROM | IMPORT_COUNTRY_ID | ORIGIN_COUNTRY_ID |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | 1 | 1 | S | 2026-01-01 | SAMPLE | 2026-01-01 | SAM | SAM |
| default | Ordsku HTS-002-ALT | Ordsku HTS-002-ALT | 4 | 4 | A | 2026-02-09 | Ordsku HTS-002-ALT | 2026-02-09 | ALT | ALT |
| default | Ordsku HTS-003-EDGE | Ordsku HTS-003-EDGE | 6 | 6 | A | 2026-03-12 | Ordsku HTS-003-EDGE | 2026-03-12 | EDG | EDG |
Example values from field definitions
- HTSR
- SAMPLE
- ITEMR
- SAMPLE
- SEQ_NORPK
- 1
- ORDER_NORPK
- 1
- STATUS
- S
- EFFECT_TO
- 2026-01-01
- PACK_ITEM
- SAMPLE
- EFFECT_FROM
- 2026-01-01
- IMPORT_COUNTRY_ID
- SAM
- ORIGIN_COUNTRY_ID
- SAM
default
- HTSR
- Ordsku HTS-002-ALT
- ITEMR
- Ordsku HTS-002-ALT
- SEQ_NORPK
- 4
- ORDER_NORPK
- 4
- STATUS
- A
- EFFECT_TO
- 2026-02-09
- PACK_ITEM
- Ordsku HTS-002-ALT
- EFFECT_FROM
- 2026-02-09
- IMPORT_COUNTRY_ID
- ALT
- ORIGIN_COUNTRY_ID
- ALT
default
- HTSR
- Ordsku HTS-003-EDGE
- ITEMR
- Ordsku HTS-003-EDGE
- SEQ_NORPK
- 6
- ORDER_NORPK
- 6
- STATUS
- A
- EFFECT_TO
- 2026-03-12
- PACK_ITEM
- Ordsku HTS-003-EDGE
- EFFECT_FROM
- 2026-03-12
- IMPORT_COUNTRY_ID
- EDG
- ORIGIN_COUNTRY_ID
- EDG
Rule Validation Summary
- Source Rule Count
- 46
- Governed Rule Count
- 30