Stock Count
In ScopeTechnical: STOCK_COUNT | ID: OR-SIOCS-STOCK_COUNT
this table will hold one row for each stock count in the system. it defines the stock count instances of a stock count schedule.
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
Field Definitions(37)
Rules & Considerations(107)
Sample Load Data(4)
| _scenario | IDRPK | TYPER | PHASER | STATUSR | RECOUNTR | SOH_ZEROR | STORE_IDR | ALL_ITEMSR | DESCRIPTIONR | ACTIVE_ITEMSR | SOH_NEGATIVER | SOH_POSITIVER | DELETED_ITEMSR | AUTO_AUTHORIZER | INACTIVE_ITEMSR | ADHOC_ITEM_LOCKR | COUNTING_METHODR | TOTAL_ITEM_COUNTR | UPDATE_DATE_TIMER | DISCONTINUED_ITEMSR | PICK_LESS_SUGGESTEDR | REPL_LESS_SUGGESTEDR | REPL_NEGATIVE_AVAILABLER | START_TIME | EXPORT_USER | SCHEDULE_DATE | TRAN_EVENT_ID | BREAKDOWN_TYPE | UIN_DISCREPANT | VARIANCE_COUNT | VARIANCE_VALUE | TRAN_EVENT_DESC | PRODUCT_GROUP_ID | VARIANCE_PERCENT | BEFORE_STORE_OPEN | PRODUCT_GROUP_DESCRIPTION | PRODUCT_GROUP_SCHEDULE_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 01 | 01 | 01 | Stock Count-001 | Stock Count-001 | 1000000001 | Stock Count-001 | Stock Count-001 | Y | Stock Count-001 | Stock Count-001 | Stock Count-001 | Y | Y | N | 01 | 1 | 2026-01-01 | Y | Stock Count-001 | N | Stock Count-001 | 2026-01-06 | Stock Count-001 | 2026-01-01 | 1000000001 | 01 | Stock Count-001 | 11.0000 | 11.0000 | Stock Count-001 | 1000000001 | 11.0000 | Stock Count-001 | Stock Count: Baseline migration row | 1000000001 |
default
- IDRPK
- 1
- TYPER
- 01
- PHASER
- 01
- STATUSR
- 01
- RECOUNTR
- Stock Count-001
- SOH_ZEROR
- Stock Count-001
- STORE_IDR
- 1000000001
- ALL_ITEMSR
- Stock Count-001
- DESCRIPTIONR
- Stock Count-001
- ACTIVE_ITEMSR
- Y
- SOH_NEGATIVER
- Stock Count-001
- SOH_POSITIVER
- Stock Count-001
- DELETED_ITEMSR
- Stock Count-001
- AUTO_AUTHORIZER
- Y
- INACTIVE_ITEMSR
- Y
- ADHOC_ITEM_LOCKR
- N
- COUNTING_METHODR
- 01
- TOTAL_ITEM_COUNTR
- 1
- UPDATE_DATE_TIMER
- 2026-01-01
- DISCONTINUED_ITEMSR
- Y
- PICK_LESS_SUGGESTEDR
- Stock Count-001
- REPL_LESS_SUGGESTEDR
- N
- REPL_NEGATIVE_AVAILABLER
- Stock Count-001
- START_TIME
- 2026-01-06
- EXPORT_USER
- Stock Count-001
- SCHEDULE_DATE
- 2026-01-01
- TRAN_EVENT_ID
- 1000000001
- BREAKDOWN_TYPE
- 01
- UIN_DISCREPANT
- Stock Count-001
- VARIANCE_COUNT
- 11.0000
- VARIANCE_VALUE
- 11.0000
- TRAN_EVENT_DESC
- Stock Count-001
- PRODUCT_GROUP_ID
- 1000000001
- VARIANCE_PERCENT
- 11.0000
- BEFORE_STORE_OPEN
- Stock Count-001
- PRODUCT_GROUP_DESCRIPTION
- Stock Count: Baseline migration row
- PRODUCT_GROUP_SCHEDULE_ID
- 1000000001