UDA Item Date
In ScopeTechnical: UDA_ITEM_DATE | ID: OR-ITM-UDA_ITEM_DATE-UDA_ITEM_DATE
Stores one row for each item/attribute combination for UDAs with display type of date (DT) and contains the information about item attribute relationship, create date, update date, etc.
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
- UDA_ITEM_DATE
Field Definitions(5)
Rules & Considerations(15)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMRPK | UDA_IDRPK | UDA_DATERPK | CREATE_DATETIMER | LAST_UPDATE_DATETIMER | CREATE_ID | LAST_UPDATE_ID |
|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 2026-01-01 | 2026-01-01 | 2026-01-01 | SAMPLE | SAMPLE |
| default | UDA Item Date-002-ALT | 100003 | 2026-01-03 | 2026-01-03 | 2026-01-03 | C LIENT_INFO | MDM_USER |
| default | UDA Item Date-003-EDGE | 100005 | 2026-01-05 | 2026-01-05 | 2026-01-05 | USE RENV | BATCH_USER |
Example values from field definitions
- ITEMRPK
- SAMPLE
- UDA_IDRPK
- 1
- UDA_DATERPK
- 2026-01-01
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- CREATE_ID
- SAMPLE
- LAST_UPDATE_ID
- SAMPLE
default
- ITEMRPK
- UDA Item Date-002-ALT
- UDA_IDRPK
- 100003
- UDA_DATERPK
- 2026-01-03
- CREATE_DATETIMER
- 2026-01-03
- LAST_UPDATE_DATETIMER
- 2026-01-03
- CREATE_ID
- C LIENT_INFO
- LAST_UPDATE_ID
- MDM_USER
default
- ITEMRPK
- UDA Item Date-003-EDGE
- UDA_IDRPK
- 100005
- UDA_DATERPK
- 2026-01-05
- CREATE_DATETIMER
- 2026-01-05
- LAST_UPDATE_DATETIMER
- 2026-01-05
- CREATE_ID
- USE RENV
- LAST_UPDATE_ID
- BATCH_USER
Rule Validation Summary
- Source Rule Count
- 37
- Governed Rule Count
- 15