Stock Count Child

In Scope

Technical: STOCK_COUNT_CHILD | ID: OR-SIOCS-STOCK_COUNT_CHILD

Stores a row for each location that is being counted for the stock count.

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
STOCK_COUNT_CHILD

Field Definitions(17)

Rules & Considerations(48)

Sample Load Data(4)

default

IDRPK
1
PHASER
0
STATUSR
01
STORE_IDRPK
1000000001
STOCK_COUNT_IDRPK
1000000001
TOTAL_ITEM_COUNTR
1
ITEMS_LEFT_TO_COUNTR
1
COUNT_USER
Stock Count Child-001
DESCRIPTION
Stock Count Child-001
LOCATION_ID
STD-STOCK_COUN-001
RECOUNT_USER
Stock Count Child-001
LOCATION_AREA
101
AUTHORIZE_DATE
2026-01-01
AUTHORIZE_USER
Stock Count Child-001
BREAKDOWN_DESCRIPTION
Stock Count Child: Baseline migration row
COUNT_SNAPSHOT_DATE_TIME
2026-01-01
RECNT_SNAPSHOT_DATE_TIME
2026-01-01
Stock Count Child | undefined | Oracle Retail