Item Import Attr

In Scope

Technical: ITEM_IMPORT_ATTR | ID: OR-TRD-ITEM_IMPORT_ATTR-ITEM_IMPORT_ATTR

Stores the import specific attributes associated with a given item. Values in this table are stored in the Primary currency for the system.

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_IMPORT_ATTR

Field Definitions(5)

Rules & Considerations(13)

constraint

validation

Sample Load Data(4)

_scenario	ITEMRPK	TOOLING	COMMODITY	CREATE_ID	IMPORT_DESC	OPEN_BALANCE	AMORTIZE_BASE	CREATE_DATETIME	FIRST_ORDER_IND
Example values from field definitions	SAMPLE	1.0000	SAMPLE	SAMPLE	SAMPLE	1.0000	1.0000	2026-01-01	S
default	Item Import Attr-002-ALT	12.5000	Item I	C LIENT_INFO	Item Import Attr-002-ALT	12.5000	12.5000	2026-01-03	Y
default	Item Import Attr-003-EDGE	14.0000	Item I	USE RENV	Item Import Attr-003-EDGE	14.0000	14.0000	2026-01-05	Y

Example values from field definitions

ITEMRPK: SAMPLE
TOOLING: 1.0000
COMMODITY: SAMPLE
CREATE_ID: SAMPLE
IMPORT_DESC: SAMPLE
OPEN_BALANCE: 1.0000
AMORTIZE_BASE: 1.0000
CREATE_DATETIME: 2026-01-01
FIRST_ORDER_IND: S

default

ITEMRPK: Item Import Attr-002-ALT
TOOLING: 12.5000
COMMODITY: Item I
CREATE_ID: C LIENT_INFO
IMPORT_DESC: Item Import Attr-002-ALT
OPEN_BALANCE: 12.5000
AMORTIZE_BASE: 12.5000
CREATE_DATETIME: 2026-01-03
FIRST_ORDER_IND: Y

default

ITEMRPK: Item Import Attr-003-EDGE
TOOLING: 14.0000
COMMODITY: Item I
CREATE_ID: USE RENV
IMPORT_DESC: Item Import Attr-003-EDGE
OPEN_BALANCE: 14.0000
AMORTIZE_BASE: 14.0000
CREATE_DATETIME: 2026-01-05
FIRST_ORDER_IND: Y

Rule Validation Summary

Source Rule Count: 20
Governed Rule Count: 13