Svc HTS Ad

Uniquely identifies a process in SVC_PROCESS_TRACKER.

Uniquely identifies a chunk. The value will always be 1.

The rows sequence. Should be unique within a Process-ID.

Describes type of action i.e. NEW, MOD or DEL.

Status of current row. Could be N - New, P-Processed, E-Error.

Contains the unique HTS item classification number. This number is standard for the importing country.

Contains the country id of the importing country.

Denotes the beginning of the time period that the HTS classification is valid.

Denotes the end of the time period that the HTS classification is valid.

Contains the manufacturers identification number. Anti-Dumping cases are manufacturer specific and are not imposed at just the country level.

Origin_country_id Oracle Retail target column ORIGIN_COUNTRY_ID on SVC_HTS_AD.

Contains the case number assigned to the AD by a customs agency.

Contains the shipper identification for the situation in which a AD rate is applied only to specific shippers, when the shipper is different from the manufacturer for the entry.

Contains the supplier identification number of the items.

Contains the rate of duty to be added upon the base rate of the item.

Contains a related case identification of the AD instance.

Contains the effective entry date which is used to establish the start date on which the AD becomes effective for that particular case number.

Contains the effective export date which is used to establish the start date on which the AD becomes effective for that particular case number.

User who created the record. Oracle Retail target column CREATE_ID on SVC_HTS_AD.

Date time when record was inserted.

User who last updated the record.

Date time when record was last updated.