Item Description
In ScopeTechnical: ITEM_DESCRIPTION | ID: OR-STO-ITEM_DESCRIPTION-ITEM_DESCRIPTION
TABLE NAME ITEM_DESCRIPTION DESCRIPTION This table contains item descriptions and their associated locales.Item description for system integration locale is maintained in item table.
See how this object fits into Store Operations
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_DESCRIPTION
Field Definitions(5)
Rules & Considerations(21)
validation
constraint
Sample Load Data(4)
| _scenario | ITEM_IDRPK | LOCALE_IDRPK | DESCRIPTIONR | SHORT_DESCRIPTIONR | CREATE_USER | UPDATE_USER | LANG_ISO_CODE | CREATE_DATE_TIME | LANG_DESCRIPTION | UPDATE_DATE_TIME | SECONDARY_DESCRIPTION |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE |
| default | ALT-ITEM_DESCR-002 | 1000000003 | Item Description-002-ALT | Item Description: Alternate source profile | Item Description-002-ALT | 2026-01-02-ALT | ALT-IT | 2026-01-03 | Item Description: Alternate source profile | 2026-01-03 | Item Description: Alternate source profile |
| default | EDGE-ITEM_DESCR-003 | 1000000005 | Item Description-003-EDGE | Item Description: Edge-case optional attributes | Item Description-003-EDGE | 2026-01-03-EDGE | EDGE-I | 2026-01-05 | — | 2026-01-05 | — |
Example values from field definitions
- ITEM_IDRPK
- SAMPLE
- LOCALE_IDRPK
- 1
- DESCRIPTIONR
- SAMPLE
- SHORT_DESCRIPTIONR
- SAMPLE
- CREATE_USER
- SAMPLE
- UPDATE_USER
- SAMPLE
- LANG_ISO_CODE
- SAMPLE
- CREATE_DATE_TIME
- 2026-01-01
- LANG_DESCRIPTION
- SAMPLE
- UPDATE_DATE_TIME
- 2026-01-01
- SECONDARY_DESCRIPTION
- SAMPLE
default
- ITEM_IDRPK
- ALT-ITEM_DESCR-002
- LOCALE_IDRPK
- 1000000003
- DESCRIPTIONR
- Item Description-002-ALT
- SHORT_DESCRIPTIONR
- Item Description: Alternate source profile
- CREATE_USER
- Item Description-002-ALT
- UPDATE_USER
- 2026-01-02-ALT
- LANG_ISO_CODE
- ALT-IT
- CREATE_DATE_TIME
- 2026-01-03
- LANG_DESCRIPTION
- Item Description: Alternate source profile
- UPDATE_DATE_TIME
- 2026-01-03
- SECONDARY_DESCRIPTION
- Item Description: Alternate source profile
default
- ITEM_IDRPK
- EDGE-ITEM_DESCR-003
- LOCALE_IDRPK
- 1000000005
- DESCRIPTIONR
- Item Description-003-EDGE
- SHORT_DESCRIPTIONR
- Item Description: Edge-case optional attributes
- CREATE_USER
- Item Description-003-EDGE
- UPDATE_USER
- 2026-01-03-EDGE
- LANG_ISO_CODE
- EDGE-I
- CREATE_DATE_TIME
- 2026-01-05
- LANG_DESCRIPTION
- —
- UPDATE_DATE_TIME
- 2026-01-05
- SECONDARY_DESCRIPTION
- —
Rule Validation Summary
- Source Rule Count
- 34
- Governed Rule Count
- 21