Stock Count
In ScopeTechnical: STOCK_COUNT | ID: OR-STO-STOCK_COUNT-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- STOCK_COUNT
Field Definitions(37)
Rules & Considerations(58)
validation
constraint
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | S | S | 1 | S | SAMPLE | S | S | S | S | S | S | S | 1 | 1 | 2026-01-01 | S | S | S | S | 2026-01-01 | SAMPLE | 2026-01-01 | 1 | 1 | S | 1.0000 | 1.0000 | SAMPLE | 1 | 1.0000 | S | SAMPLE | 1 |
Example values from field definitions
- IDRPK
- 1
- TYPER
- 1
- PHASER
- 1
- STATUSR
- 1
- RECOUNTR
- S
- SOH_ZEROR
- S
- STORE_IDR
- 1
- ALL_ITEMSR
- S
- DESCRIPTIONR
- SAMPLE
- ACTIVE_ITEMSR
- S
- SOH_NEGATIVER
- S
- SOH_POSITIVER
- S
- DELETED_ITEMSR
- S
- AUTO_AUTHORIZER
- S
- INACTIVE_ITEMSR
- S
- ADHOC_ITEM_LOCKR
- S
- COUNTING_METHODR
- 1
- TOTAL_ITEM_COUNTR
- 1
- UPDATE_DATE_TIMER
- 2026-01-01
- DISCONTINUED_ITEMSR
- S
- PICK_LESS_SUGGESTEDR
- S
- REPL_LESS_SUGGESTEDR
- S
- REPL_NEGATIVE_AVAILABLER
- S
- START_TIME
- 2026-01-01
- EXPORT_USER
- SAMPLE
- SCHEDULE_DATE
- 2026-01-01
- TRAN_EVENT_ID
- 1
- BREAKDOWN_TYPE
- 1
- UIN_DISCREPANT
- S
- VARIANCE_COUNT
- 1.0000
- VARIANCE_VALUE
- 1.0000
- TRAN_EVENT_DESC
- SAMPLE
- PRODUCT_GROUP_ID
- 1
- VARIANCE_PERCENT
- 1.0000
- BEFORE_STORE_OPEN
- S
- PRODUCT_GROUP_DESCRIPTION
- SAMPLE
- PRODUCT_GROUP_SCHEDULE_ID
- 1
Rule Validation Summary
- Source Rule Count
- 89
- Governed Rule Count
- 58