Item UIN Problem

In Scope

Technical: ITEM_UIN_PROBLEM | ID: OR-STO-ITEM_UIN_PROBLEM-ITEM_UIN_PROBLEM

Stores a list of uin state transformations that failed for some reason. there is an old and new status to help determine what the issue is.

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_UIN_PROBLEM

Field Definitions(5)

Rules & Considerations(16)

constraint

validation

Sample Load Data(4)

_scenario	IDRPK	UINR	ITEM_IDR	TYPE	ACTION	QUANTITY	RESOLVED	STORE_ID	STATUS_NEW	STATUS_OLD	UPDATE_DATE	UPDATE_USER	FUNCTIONAL_ID
Example values from field definitions	1	SAMPLE	SAMPLE	1	1	1	S	1	1	1	2026-01-01	SAMPLE	SAMPLE
default	3	Item UIN Problem-002-ALT	ALT-ITEM_UIN-002	2	3	3	I	1000000003	1	1	2026-01-03	2026-01-02-ALT	ALT-ITEM_UIN-002
default	5	Item UIN Problem-003-EDGE	EDGE-ITEM_UIN-003	1	5	5	I	1000000005	2	2	2026-01-05	2026-01-03-EDGE	EDGE-ITEM_UIN-003

Example values from field definitions

IDRPK: 1
UINR: SAMPLE
ITEM_IDR: SAMPLE
TYPE: 1
ACTION: 1
QUANTITY: 1
RESOLVED: S
STORE_ID: 1
STATUS_NEW: 1
STATUS_OLD: 1
UPDATE_DATE: 2026-01-01
UPDATE_USER: SAMPLE
FUNCTIONAL_ID: SAMPLE

default

IDRPK: 3
UINR: Item UIN Problem-002-ALT
ITEM_IDR: ALT-ITEM_UIN-002
TYPE: 2
ACTION: 3
QUANTITY: 3
RESOLVED: I
STORE_ID: 1000000003
STATUS_NEW: 1
STATUS_OLD: 1
UPDATE_DATE: 2026-01-03
UPDATE_USER: 2026-01-02-ALT
FUNCTIONAL_ID: ALT-ITEM_UIN-002

default

IDRPK: 5
UINR: Item UIN Problem-003-EDGE
ITEM_IDR: EDGE-ITEM_UIN-003
TYPE: 1
ACTION: 5
QUANTITY: 5
RESOLVED: I
STORE_ID: 1000000005
STATUS_NEW: 2
STATUS_OLD: 2
UPDATE_DATE: 2026-01-05
UPDATE_USER: 2026-01-03-EDGE
FUNCTIONAL_ID: EDGE-ITEM_UIN-003

Rule Validation Summary

Source Rule Count: 26
Governed Rule Count: 16