Store Item Stock

In Scope

Technical: STORE_ITEM_STOCK | ID: OR-STO-STORE_ITEM_STOCK-STORE_ITEM_STOCK

defines the current inventory numbers for items on a location bases. the types of inventory buckets that are held include available for sale, unavailable for sale, in transit, and reserved...

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: STORE_ITEM_STOCK

Field Definitions(5)

Rules & Considerations(35)

constraint

validation

Sample Load Data(4)

_scenario	ITEM_IDRPK	STORE_IDRPK	QUANTITY_TOTALR	QUANTITY_RESERVEDR	QUANTITY_CUSTOMER_RESERVER	UPDATE_DATE	UIN_PROBLEM_LINE	LAST_RECEIVED_DAY	LAST_STK_CNT_TYPE	OPEN_STOCK_COUNTS	DAY_REQUESTED_LAST	FIRST_RECEIVED_DAY	QUANTITY_IN_TRANSIT	QUANTITY_SHOP_FLOOR	QUANTITY_DELIVERY_BAY	QUANTITY_NON_SELLABLE	LAST_RECEIVED_QUANTITY	LAST_STK_CNT_TIMEFRAME	QUANTITY_VENDOR_RETURN	QUANTITY_REQUESTED_LAST	QUANTITY_REQUESTED_TODAY	LAST_STK_CNT_APPROVE_DATE
Example values from field definitions	SAMPLE	1	1.0000	1.0000	1.0000	2026-01-01	S	2026-01-01	1	1	2026-01-01	2026-01-01	1.0000	1.0000	1.0000	1.0000	1.0000	S	1.0000	1.0000	1.0000	2026-01-01
default	ALT-STORE_ITEM-002	1000000003	12.5000	12.5000	12.5000	2026-01-03	S	2026-02-09	3	3	2026-02-09	2026-02-09	12.5000	12.5000	12.5000	12.5000	12.5000	A	12.5000	12.5000	12.5000	2026-01-03
default	EDGE-STORE_ITEM-003	1000000005	14.0000	14.0000	14.0000	2026-01-05	S	2026-03-12	5	5	2026-03-12	2026-03-12	14.0000	14.0000	14.0000	14.0000	14.0000	N	14.0000	14.0000	14.0000	2026-01-05

Example values from field definitions

ITEM_IDRPK: SAMPLE
STORE_IDRPK: 1
QUANTITY_TOTALR: 1.0000
QUANTITY_RESERVEDR: 1.0000
QUANTITY_CUSTOMER_RESERVER: 1.0000
UPDATE_DATE: 2026-01-01
UIN_PROBLEM_LINE: S
LAST_RECEIVED_DAY: 2026-01-01
LAST_STK_CNT_TYPE: 1
OPEN_STOCK_COUNTS: 1
DAY_REQUESTED_LAST: 2026-01-01
FIRST_RECEIVED_DAY: 2026-01-01
QUANTITY_IN_TRANSIT: 1.0000
QUANTITY_SHOP_FLOOR: 1.0000
QUANTITY_DELIVERY_BAY: 1.0000
QUANTITY_NON_SELLABLE: 1.0000
LAST_RECEIVED_QUANTITY: 1.0000
LAST_STK_CNT_TIMEFRAME: S
QUANTITY_VENDOR_RETURN: 1.0000
QUANTITY_REQUESTED_LAST: 1.0000
QUANTITY_REQUESTED_TODAY: 1.0000
LAST_STK_CNT_APPROVE_DATE: 2026-01-01

default

ITEM_IDRPK: ALT-STORE_ITEM-002
STORE_IDRPK: 1000000003
QUANTITY_TOTALR: 12.5000
QUANTITY_RESERVEDR: 12.5000
QUANTITY_CUSTOMER_RESERVER: 12.5000
UPDATE_DATE: 2026-01-03
UIN_PROBLEM_LINE: S
LAST_RECEIVED_DAY: 2026-02-09
LAST_STK_CNT_TYPE: 3
OPEN_STOCK_COUNTS: 3
DAY_REQUESTED_LAST: 2026-02-09
FIRST_RECEIVED_DAY: 2026-02-09
QUANTITY_IN_TRANSIT: 12.5000
QUANTITY_SHOP_FLOOR: 12.5000
QUANTITY_DELIVERY_BAY: 12.5000
QUANTITY_NON_SELLABLE: 12.5000
LAST_RECEIVED_QUANTITY: 12.5000
LAST_STK_CNT_TIMEFRAME: A
QUANTITY_VENDOR_RETURN: 12.5000
QUANTITY_REQUESTED_LAST: 12.5000
QUANTITY_REQUESTED_TODAY: 12.5000
LAST_STK_CNT_APPROVE_DATE: 2026-01-03