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(5)
Rules & Considerations(58)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | STORE_IDR | DESCRIPTIONR | TYPE | PHASE | STATUS | RECOUNT | SOH_ZERO | ALL_ITEMS | START_TIME | EXPORT_USER | ACTIVE_ITEMS | SOH_NEGATIVE | SOH_POSITIVE | DELETED_ITEMS | SCHEDULE_DATE | TRAN_EVENT_ID | AUTO_AUTHORIZE | BREAKDOWN_TYPE | INACTIVE_ITEMS | UIN_DISCREPANT | VARIANCE_COUNT | VARIANCE_VALUE | ADHOC_ITEM_LOCK | COUNTING_METHOD | TRAN_EVENT_DESC | PRODUCT_GROUP_ID | TOTAL_ITEM_COUNT | UPDATE_DATE_TIME | VARIANCE_PERCENT | BEFORE_STORE_OPEN | DISCONTINUED_ITEMS | PICK_LESS_SUGGESTED | REPL_LESS_SUGGESTED | REPL_NEGATIVE_AVAILABLE | PRODUCT_GROUP_DESCRIPTION | PRODUCT_GROUP_SCHEDULE_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 1 | 1 | 1 | S | S | S | 2026-01-01 | SAMPLE | S | S | S | S | 2026-01-01 | 1 | S | 1 | S | S | 1.0000 | 1.0000 | S | 1 | SAMPLE | 1 | 1 | 2026-01-01 | 1.0000 | S | S | S | S | S | SAMPLE | 1 |
| default | 3 | 1000000003 | Stock Count-002-ALT | 3 | 3 | 3 | S | S | S | 2026-02-09 | Stock Count-002-ALT | N | S | S | S | 2026-01-03 | 1000000003 | N | 3 | N | S | 12.5000 | 12.5000 | Y | 3 | Stock Count-002-ALT | 1000000003 | 3 | 2026-01-03 | 12.5000 | S | N | S | N | S | Stock Count: Alternate source profile | 1000000003 |
| default | 5 | 1000000005 | Stock Count-003-EDGE | 5 | 5 | 5 | S | S | S | 2026-03-12 | Stock Count-003-EDGE | Y | S | S | S | 2026-01-05 | 1000000005 | Y | 5 | Y | S | 14.0000 | 14.0000 | N | 5 | Stock Count-003-EDGE | 1000000005 | 5 | 2026-01-05 | 14.0000 | S | Y | S | N | S | — | 1000000005 |
Example values from field definitions
- IDRPK
- 1
- STORE_IDR
- 1
- DESCRIPTIONR
- SAMPLE
- TYPE
- 1
- PHASE
- 1
- STATUS
- 1
- RECOUNT
- S
- SOH_ZERO
- S
- ALL_ITEMS
- S
- START_TIME
- 2026-01-01
- EXPORT_USER
- SAMPLE
- ACTIVE_ITEMS
- S
- SOH_NEGATIVE
- S
- SOH_POSITIVE
- S
- DELETED_ITEMS
- S
- SCHEDULE_DATE
- 2026-01-01
- TRAN_EVENT_ID
- 1
- AUTO_AUTHORIZE
- S
- BREAKDOWN_TYPE
- 1
- INACTIVE_ITEMS
- S
- UIN_DISCREPANT
- S
- VARIANCE_COUNT
- 1.0000
- VARIANCE_VALUE
- 1.0000
- ADHOC_ITEM_LOCK
- S
- COUNTING_METHOD
- 1
- TRAN_EVENT_DESC
- SAMPLE
- PRODUCT_GROUP_ID
- 1
- TOTAL_ITEM_COUNT
- 1
- UPDATE_DATE_TIME
- 2026-01-01
- VARIANCE_PERCENT
- 1.0000
- BEFORE_STORE_OPEN
- S
- DISCONTINUED_ITEMS
- S
- PICK_LESS_SUGGESTED
- S
- REPL_LESS_SUGGESTED
- S
- REPL_NEGATIVE_AVAILABLE
- S
- PRODUCT_GROUP_DESCRIPTION
- SAMPLE
- PRODUCT_GROUP_SCHEDULE_ID
- 1
default
- IDRPK
- 3
- STORE_IDR
- 1000000003
- DESCRIPTIONR
- Stock Count-002-ALT
- TYPE
- 3
- PHASE
- 3
- STATUS
- 3
- RECOUNT
- S
- SOH_ZERO
- S
- ALL_ITEMS
- S
- START_TIME
- 2026-02-09
- EXPORT_USER
- Stock Count-002-ALT
- ACTIVE_ITEMS
- N
- SOH_NEGATIVE
- S
- SOH_POSITIVE
- S
- DELETED_ITEMS
- S
- SCHEDULE_DATE
- 2026-01-03
- TRAN_EVENT_ID
- 1000000003
- AUTO_AUTHORIZE
- N
- BREAKDOWN_TYPE
- 3
- INACTIVE_ITEMS
- N
- UIN_DISCREPANT
- S
- VARIANCE_COUNT
- 12.5000
- VARIANCE_VALUE
- 12.5000
- ADHOC_ITEM_LOCK
- Y
- COUNTING_METHOD
- 3
- TRAN_EVENT_DESC
- Stock Count-002-ALT
- PRODUCT_GROUP_ID
- 1000000003
- TOTAL_ITEM_COUNT
- 3
- UPDATE_DATE_TIME
- 2026-01-03
- VARIANCE_PERCENT
- 12.5000
- BEFORE_STORE_OPEN
- S
- DISCONTINUED_ITEMS
- N
- PICK_LESS_SUGGESTED
- S
- REPL_LESS_SUGGESTED
- N
- REPL_NEGATIVE_AVAILABLE
- S
- PRODUCT_GROUP_DESCRIPTION
- Stock Count: Alternate source profile
- PRODUCT_GROUP_SCHEDULE_ID
- 1000000003
default
- IDRPK
- 5
- STORE_IDR
- 1000000005
- DESCRIPTIONR
- Stock Count-003-EDGE
- TYPE
- 5
- PHASE
- 5
- STATUS
- 5
- RECOUNT
- S
- SOH_ZERO
- S
- ALL_ITEMS
- S
- START_TIME
- 2026-03-12
- EXPORT_USER
- Stock Count-003-EDGE
- ACTIVE_ITEMS
- Y
- SOH_NEGATIVE
- S
- SOH_POSITIVE
- S
- DELETED_ITEMS
- S
- SCHEDULE_DATE
- 2026-01-05
- TRAN_EVENT_ID
- 1000000005
- AUTO_AUTHORIZE
- Y
- BREAKDOWN_TYPE
- 5
- INACTIVE_ITEMS
- Y
- UIN_DISCREPANT
- S
- VARIANCE_COUNT
- 14.0000
- VARIANCE_VALUE
- 14.0000
- ADHOC_ITEM_LOCK
- N
- COUNTING_METHOD
- 5
- TRAN_EVENT_DESC
- Stock Count-003-EDGE
- PRODUCT_GROUP_ID
- 1000000005
- TOTAL_ITEM_COUNT
- 5
- UPDATE_DATE_TIME
- 2026-01-05
- VARIANCE_PERCENT
- 14.0000
- BEFORE_STORE_OPEN
- S
- DISCONTINUED_ITEMS
- Y
- PICK_LESS_SUGGESTED
- S
- REPL_LESS_SUGGESTED
- N
- REPL_NEGATIVE_AVAILABLE
- S
- PRODUCT_GROUP_DESCRIPTION
- —
- PRODUCT_GROUP_SCHEDULE_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 89
- Governed Rule Count
- 58