Flexible Count Location Data
In ScopeTechnical: FLEXIBLE_COUNT | ID: OR-STO-FLEXIBLE_COUNT-FLEXIBLE_COUNT
Stores flexible count location data.
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
- FLEXIBLE_COUNT
Field Definitions(5)
Rules & Considerations(27)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | STATUSR | BARCODER | STORE_IDR | STOCK_COUNT_IDR | PHASE | DISCREPANT | CREATE_DATE | CREATE_USER | UPDATE_DATE | UPDATE_USER | TOTAL_QUANTITY | COMPLETE_COUNT_DATE | COMPLETE_COUNT_USER | COMPLETE_RECOUNT_DATE | COMPLETE_RECOUNT_USER |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 1 | 1 | 1 | S | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 1.0000 | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE |
| default | 3 | 3 | Flexible Count-002-ALT | 1000000003 | 1000000003 | 3 | F | 2026-01-03 | Flexible Count-002-ALT | 2026-01-03 | 2026-01-02-ALT | 12.5000 | 2026-01-03 | Flexible Count-002-ALT | 2026-01-03 | Flexible Count-002-ALT |
| default | 5 | 5 | Flexible Count-003-EDGE | 1000000005 | 1000000005 | 5 | F | 2026-01-05 | Flexible Count-003-EDGE | 2026-01-05 | 2026-01-03-EDGE | 14.0000 | 2026-01-05 | Flexible Count-003-EDGE | 2026-01-05 | Flexible Count-003-EDGE |
Example values from field definitions
- IDRPK
- 1
- STATUSR
- 1
- BARCODER
- SAMPLE
- STORE_IDR
- 1
- STOCK_COUNT_IDR
- 1
- PHASE
- 1
- DISCREPANT
- S
- CREATE_DATE
- 2026-01-01
- CREATE_USER
- SAMPLE
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- TOTAL_QUANTITY
- 1.0000
- COMPLETE_COUNT_DATE
- 2026-01-01
- COMPLETE_COUNT_USER
- SAMPLE
- COMPLETE_RECOUNT_DATE
- 2026-01-01
- COMPLETE_RECOUNT_USER
- SAMPLE
default
- IDRPK
- 3
- STATUSR
- 3
- BARCODER
- Flexible Count-002-ALT
- STORE_IDR
- 1000000003
- STOCK_COUNT_IDR
- 1000000003
- PHASE
- 3
- DISCREPANT
- F
- CREATE_DATE
- 2026-01-03
- CREATE_USER
- Flexible Count-002-ALT
- UPDATE_DATE
- 2026-01-03
- UPDATE_USER
- 2026-01-02-ALT
- TOTAL_QUANTITY
- 12.5000
- COMPLETE_COUNT_DATE
- 2026-01-03
- COMPLETE_COUNT_USER
- Flexible Count-002-ALT
- COMPLETE_RECOUNT_DATE
- 2026-01-03
- COMPLETE_RECOUNT_USER
- Flexible Count-002-ALT
default
- IDRPK
- 5
- STATUSR
- 5
- BARCODER
- Flexible Count-003-EDGE
- STORE_IDR
- 1000000005
- STOCK_COUNT_IDR
- 1000000005
- PHASE
- 5
- DISCREPANT
- F
- CREATE_DATE
- 2026-01-05
- CREATE_USER
- Flexible Count-003-EDGE
- UPDATE_DATE
- 2026-01-05
- UPDATE_USER
- 2026-01-03-EDGE
- TOTAL_QUANTITY
- 14.0000
- COMPLETE_COUNT_DATE
- 2026-01-05
- COMPLETE_COUNT_USER
- Flexible Count-003-EDGE
- COMPLETE_RECOUNT_DATE
- 2026-01-05
- COMPLETE_RECOUNT_USER
- Flexible Count-003-EDGE
Rule Validation Summary
- Source Rule Count
- 42
- Governed Rule Count
- 27