Stock Count Line Item
In ScopeTechnical: STOCK_COUNT_LINE_ITEM | ID: OR-SIOCS-STOCK_COUNT_LINE_ITEM
defines the results of a stock count for each item in a 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_LINE_ITEM
Field Definitions(29)
Rules & Considerations(83)
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDRPK | SELLABLER | STORE_IDRPK | ITEM_TYPER | DISCREPANTR | LOCATION_IDR | DEPARTMENT_IDR | MULTI_LOCATEDR | STOCK_COUNT_IDRPK | PRIMARY_LOCATIONR | BREAKABLE_COMPONENTR | STOCK_COUNT_CHILD_IDRPK | CLASS_ID | PRICE_TYPE | PRICE_VALUE | SUBCLASS_ID | COUNTED_TOTAL | COUNT_SNAPSHOT | PRICE_CURRENCY | COUNT_DATE_TIME | RECOUNTED_TOTAL | COUNTED_QUANTITY | RECOUNT_SNAPSHOT | APPROVED_QUANTITY | RECOUNT_DATE_TIME | APPROVED_DATE_TIME | RECOUNTED_QUANTITY | SNAPSHOT_DATE_TIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | STD-STOCK_COUN-001 | Stock Count Line Item-001 | 1000000001 | 01 | y | STD-STOCK_COUN-001 | 1000000001 | Y | 1000000001 | Y | N | 1000000001 | 1000000001 | 001 | 11.0000 | 1000000001 | 11.0000 | 11.0000 | Stock Count Line Item-001 | 2026-01-01 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 2026-01-01 | 2026-01-01 | 11.0000 | 2026-01-01 |
default
- IDRPK
- 1
- ITEM_IDRPK
- STD-STOCK_COUN-001
- SELLABLER
- Stock Count Line Item-001
- STORE_IDRPK
- 1000000001
- ITEM_TYPER
- 01
- DISCREPANTR
- y
- LOCATION_IDR
- STD-STOCK_COUN-001
- DEPARTMENT_IDR
- 1000000001
- MULTI_LOCATEDR
- Y
- STOCK_COUNT_IDRPK
- 1000000001
- PRIMARY_LOCATIONR
- Y
- BREAKABLE_COMPONENTR
- N
- STOCK_COUNT_CHILD_IDRPK
- 1000000001
- CLASS_ID
- 1000000001
- PRICE_TYPE
- 001
- PRICE_VALUE
- 11.0000
- SUBCLASS_ID
- 1000000001
- COUNTED_TOTAL
- 11.0000
- COUNT_SNAPSHOT
- 11.0000
- PRICE_CURRENCY
- Stock Count Line Item-001
- COUNT_DATE_TIME
- 2026-01-01
- RECOUNTED_TOTAL
- 11.0000
- COUNTED_QUANTITY
- 11.0000
- RECOUNT_SNAPSHOT
- 11.0000
- APPROVED_QUANTITY
- 11.0000
- RECOUNT_DATE_TIME
- 2026-01-01
- APPROVED_DATE_TIME
- 2026-01-01
- RECOUNTED_QUANTITY
- 11.0000
- SNAPSHOT_DATE_TIME
- 2026-01-01