Ordsku HTS Assess

In Scope

Technical: ORDSKU_HTS_ASSESS | ID: OR-TRD-ORDSKU_HTS_ASSESS-ORDSKU_HTS_ASSESS

This table will store the assessments associated with a given order/item/hts code. These assessments are used in the compilation of Estimated and Actual Landed Cost for the item.

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_ASSESS

Field Definitions(5)

Rules & Considerations(36)

constraint

validation

Sample Load Data(4)

_scenario	SEQ_NORPK	COMP_IDRPK	ORDER_NORPK	COMP_RATER	CVB_CODE	PER_COUNT	NOM_FLAG_1	NOM_FLAG_2	NOM_FLAG_3	NOM_FLAG_4	NOM_FLAG_5	DISPLAY_ORDER	PER_COUNT_UOM	EST_ASSESS_VALUE
Example values from field definitions	1	SAMPLE	1	1.0000	SAMPLE	1.0000	S	S	S	S	S	1	SAMP	1.0000000000
default	4	ALT-ORDSKU	4	12.5000	ALT-ORDSKU	12.5000	-	O	O	O	O	3	Ords	12.5000000000
default	6	EDGE-ORDSK	6	14.0000	EDGE-ORDSK	14.0000	+	O	O	O	O	5	Ords	14.0000000000

Example values from field definitions

SEQ_NORPK: 1
COMP_IDRPK: SAMPLE
ORDER_NORPK: 1
COMP_RATER: 1.0000
CVB_CODE: SAMPLE
PER_COUNT: 1.0000
NOM_FLAG_1: S
NOM_FLAG_2: S
NOM_FLAG_3: S
NOM_FLAG_4: S
NOM_FLAG_5: S
DISPLAY_ORDER: 1
PER_COUNT_UOM: SAMP
EST_ASSESS_VALUE: 1.0000000000

default

SEQ_NORPK: 4
COMP_IDRPK: ALT-ORDSKU
ORDER_NORPK: 4
COMP_RATER: 12.5000
CVB_CODE: ALT-ORDSKU
PER_COUNT: 12.5000
NOM_FLAG_1: -
NOM_FLAG_2: O
NOM_FLAG_3: O
NOM_FLAG_4: O
NOM_FLAG_5: O
DISPLAY_ORDER: 3
PER_COUNT_UOM: Ords
EST_ASSESS_VALUE: 12.5000000000