Item UIN History
In ScopeTechnical: ITEM_UIN_HISTORY | ID: OR-SIOCS-ITEM_UIN_HISTORY
a record of each alteration or action taken upon the uin_detail table with basic auditing information added.
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
Target Structure
- Load Approach
- Table
- Target Objects
- ITEM_UIN_HISTORY
Field Definitions(15)
Rules & Considerations(40)
Sample Load Data(4)
| _scenario | IDRPK | UINR | TYPER | ITEM_IDR | FUNCTIONAL_AREAR | STATUS | STORE_ID | CARTON_ID | DB_ACTION | CREATE_DATE | CREATE_USER | UPDATE_DATE | UPDATE_USER | FUNCTIONAL_ID | NONSELLABLE_TYPE_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | Item UIN History-001 | 1 | STD-ITEM_UIN-001 | 101 | 01 | 1000000001 | STD-ITEM_UIN-001 | Item UIN History-001 | 2026-01-01 | Item UIN History-001 | 2026-01-01 | 2026-01-01 | STD-ITEM_UIN-001 | 1000000001 |
default
- IDRPK
- 1
- UINR
- Item UIN History-001
- TYPER
- 1
- ITEM_IDR
- STD-ITEM_UIN-001
- FUNCTIONAL_AREAR
- 101
- STATUS
- 01
- STORE_ID
- 1000000001
- CARTON_ID
- STD-ITEM_UIN-001
- DB_ACTION
- Item UIN History-001
- CREATE_DATE
- 2026-01-01
- CREATE_USER
- Item UIN History-001
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- 2026-01-01
- FUNCTIONAL_ID
- STD-ITEM_UIN-001
- NONSELLABLE_TYPE_ID
- 1000000001