HTS Chapter Restraints (Service Layer)

In Scope

Technical: SVC_HTS_CHAPTER_RESTRAINTS | ID: OR-TRD-SVC_HTS_CHAPTER_RESTRAINTS-HTS_CHAPTER_RESTRAINTS_SERVICE_LAYER

This is a staging table used for Admin API spreadsheet upload process.It is used to temporarily hold data before it is uploaded/updated in HTS_CHAPTER_RESTRAINTS.

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

Field Definitions(5)

Rules & Considerations(21)

constraint

validation

Sample Load Data(4)

_scenario	ROW_SEQR	CHUNK_IDR	PROCESS_IDRPK	UOM	ACTION	CHAPTER	CREATE_ID	QUOTA_CAT	LAST_UPD_ID	CLOSING_DATE	RESTRAINT_QTY	PROCESS$STATUS	RESTRAINT_DESC	RESTRAINT_TYPE	CREATE_DATETIME	RESTRAINT_SUFFIX	IMPORT_COUNTRY_ID	LAST_UPD_DATETIME	ORIGIN_COUNTRY_ID	RESTRAINT_TYPE_UPD
Example values from field definitions	1	1	1	SAMP	SAMPLE	SAMP	SAMPLE	SAMPLE	SAMPLE	2026-01-01	1.0000	SAMPLE	SAMPLE	SAMPLE	2026-01-01	SAMPLE	SAM	2026-01-01	SAM	SAMPLE
default	3	1000000003	1000000003	Svc	Svc HTS Ch	Svc	USER	Svc HT	USER	2026-01-03	12.5000	N	Svc HTS Chapter Restraints-002-ALT	Svc HT	2026-01-03	Svc HT	ALT	2026-01-03	ALT	Svc HT
default	5	1000000005	1000000005	Svc	Svc HTS Ch	Svc	USER	Svc HT	USER	2026-01-05	14.0000	N	Svc HTS Chapter Restraints-003-EDGE	Svc HT	2026-01-05	Svc HT	EDG	2026-01-05	EDG	Svc HT

Example values from field definitions

ROW_SEQR: 1
CHUNK_IDR: 1
PROCESS_IDRPK: 1
UOM: SAMP
ACTION: SAMPLE
CHAPTER: SAMP
CREATE_ID: SAMPLE
QUOTA_CAT: SAMPLE
LAST_UPD_ID: SAMPLE
CLOSING_DATE: 2026-01-01
RESTRAINT_QTY: 1.0000
PROCESS$STATUS: SAMPLE
RESTRAINT_DESC: SAMPLE
RESTRAINT_TYPE: SAMPLE
CREATE_DATETIME: 2026-01-01
RESTRAINT_SUFFIX: SAMPLE
IMPORT_COUNTRY_ID: SAM
LAST_UPD_DATETIME: 2026-01-01
ORIGIN_COUNTRY_ID: SAM
RESTRAINT_TYPE_UPD: SAMPLE

default

ROW_SEQR: 3
CHUNK_IDR: 1000000003
PROCESS_IDRPK: 1000000003
UOM: Svc
ACTION: Svc HTS Ch
CHAPTER: Svc
CREATE_ID: USER
QUOTA_CAT: Svc HT
LAST_UPD_ID: USER
CLOSING_DATE: 2026-01-03
RESTRAINT_QTY: 12.5000
PROCESS$STATUS: N
RESTRAINT_DESC: Svc HTS Chapter Restraints-002-ALT
RESTRAINT_TYPE: Svc HT
CREATE_DATETIME: 2026-01-03
RESTRAINT_SUFFIX: Svc HT
IMPORT_COUNTRY_ID: ALT
LAST_UPD_DATETIME: 2026-01-03
ORIGIN_COUNTRY_ID: ALT
RESTRAINT_TYPE_UPD: Svc HT