Item Isn

In Scope

Technical: ITEM_ISN | ID: OR-STO-ITEM_ISN-ITEM_ISN

This is the primary SCAN table containing scan data for the item.

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_ISN

Field Definitions(5)

Rules & Considerations(14)

constraint

validation

Sample Load Data(4)

_scenario	IDRPK	ISNR	ITEM_ISN_TYPE_IDR	UIN	ITEM_ID	CREATE_DATE	CREATE_USER	EXTERNAL_ID	UPDATE_DATE	UPDATE_USER
Example values from field definitions	1	SAMPLE	1	SAMPLE	SAMPLE	2026-01-01	SAMPLE	SAMPLE	2026-01-01	SAMPLE
default	3	Item Isn-002-ALT	1000000003	Item Isn-002-ALT	ALT-ITEM_ISN-002	2026-01-03	Item Isn-002-ALT	ALT-ITEM_ISN-002	2026-01-03	2026-01-02-ALT
default	5	Item Isn-003-EDGE	1000000005	Item Isn-003-EDGE	EDGE-ITEM_ISN-003	2026-01-05	Item Isn-003-EDGE	EDGE-ITEM_ISN-003	2026-01-05	2026-01-03-EDGE

Example values from field definitions

IDRPK: 1
ISNR: SAMPLE
ITEM_ISN_TYPE_IDR: 1
UIN: SAMPLE
ITEM_ID: SAMPLE
CREATE_DATE: 2026-01-01
CREATE_USER: SAMPLE
EXTERNAL_ID: SAMPLE
UPDATE_DATE: 2026-01-01
UPDATE_USER: SAMPLE

default

IDRPK: 3
ISNR: Item Isn-002-ALT
ITEM_ISN_TYPE_IDR: 1000000003
UIN: Item Isn-002-ALT
ITEM_ID: ALT-ITEM_ISN-002
CREATE_DATE: 2026-01-03
CREATE_USER: Item Isn-002-ALT
EXTERNAL_ID: ALT-ITEM_ISN-002
UPDATE_DATE: 2026-01-03
UPDATE_USER: 2026-01-02-ALT

default

IDRPK: 5
ISNR: Item Isn-003-EDGE
ITEM_ISN_TYPE_IDR: 1000000005
UIN: Item Isn-003-EDGE
ITEM_ID: EDGE-ITEM_ISN-003
CREATE_DATE: 2026-01-05
CREATE_USER: Item Isn-003-EDGE
EXTERNAL_ID: EDGE-ITEM_ISN-003
UPDATE_DATE: 2026-01-05
UPDATE_USER: 2026-01-03-EDGE

Rule Validation Summary

Source Rule Count: 22
Governed Rule Count: 14