Item Master Translations

In Scope

Technical: ITEM_MASTER_TL | ID: OR-ITM-ITEM_MASTER_TL-ITEM_MASTER_TRANSLATIONS

This is the translation table for ITEM_MASTER table. The data in the base table is held in data integration langauge configured in SYSTEM_CONFIG_OPTIONS.

See how this object fits into Item 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_MASTER_TL

Field Definitions(5)

Rules & Considerations(20)

validation

constraint

Sample Load Data(4)

_scenario	ITEMRPK	LANGRPK	ITEM_DESCR	SHORT_DESCR	CREATE_ID	LONG_DESC	LAST_UPDATE_ID	CREATE_DATETIME	ITEM_DESC_SECONDARY	LAST_UPDATE_DATETIME
Example values from field definitions	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	SAMPLE	2026-01-01
default	Item Master TL-002-ALT	3	Item Master TL-002-ALT	Item Master TL-002-ALT	MDM_USER	Item Master TL-002-ALT	MDM_USER	2026-01-03	Item Master TL-002-ALT	2026-01-03
default	Item Master TL-003-EDGE	5	Item Master TL-003-EDGE	Item Master TL-003-EDGE	BATCH_USER	Item Master TL-003-EDGE	BATCH_USER	2026-01-05	Item Master TL-003-EDGE	2026-01-05

Example values from field definitions

ITEMRPK: SAMPLE
LANGRPK: 1
ITEM_DESCR: SAMPLE
SHORT_DESCR: SAMPLE
CREATE_ID: SAMPLE
LONG_DESC: SAMPLE
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
ITEM_DESC_SECONDARY: SAMPLE
LAST_UPDATE_DATETIME: 2026-01-01

default

ITEMRPK: Item Master TL-002-ALT
LANGRPK: 3
ITEM_DESCR: Item Master TL-002-ALT
SHORT_DESCR: Item Master TL-002-ALT
CREATE_ID: MDM_USER
LONG_DESC: Item Master TL-002-ALT
LAST_UPDATE_ID: MDM_USER
CREATE_DATETIME: 2026-01-03
ITEM_DESC_SECONDARY: Item Master TL-002-ALT
LAST_UPDATE_DATETIME: 2026-01-03