Flexible Count Location Item Data
In ScopeTechnical: FLEXIBLE_COUNT_LINE_ITEM | ID: OR-STO-FLEXIBLE_COUNT_LINE_ITEM-FLEXIBLE_COUNT_LINE_ITEM
Stores flexible count location item 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_LINE_ITEM
Field Definitions(5)
Rules & Considerations(24)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDR | STORE_IDRPK | STOCK_COUNT_IDRPK | FLEXIBLE_COUNT_IDRPK | DISCREPANT | CREATE_DATE | CREATE_USER | UPDATE_DATE | UPDATE_USER | QUANTITY_COUNT | COUNT_DATE_TIME | QUANTITY_RECOUNT | RECOUNT_DATE_TIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | 1 | S | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 1.0000 | 2026-01-01 | 1.0000 | 2026-01-01 |
| default | 3 | ALT-FLEXIBLE_C-002 | 1000000003 | 1000000003 | 1000000003 | F | 2026-01-03 | Flexible Count Line Item-002-ALT | 2026-01-03 | 2026-01-02-ALT | 12.5000 | 2026-01-03 | 12.5000 | 2026-01-03 |
| default | 5 | EDGE-FLEXIBLE_C-003 | 1000000005 | 1000000005 | 1000000005 | F | 2026-01-05 | Flexible Count Line Item-003-EDGE | 2026-01-05 | 2026-01-03-EDGE | 14.0000 | 2026-01-05 | 14.0000 | 2026-01-05 |
Example values from field definitions
- IDRPK
- 1
- ITEM_IDR
- SAMPLE
- STORE_IDRPK
- 1
- STOCK_COUNT_IDRPK
- 1
- FLEXIBLE_COUNT_IDRPK
- 1
- DISCREPANT
- S
- CREATE_DATE
- 2026-01-01
- CREATE_USER
- SAMPLE
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- QUANTITY_COUNT
- 1.0000
- COUNT_DATE_TIME
- 2026-01-01
- QUANTITY_RECOUNT
- 1.0000
- RECOUNT_DATE_TIME
- 2026-01-01
default
- IDRPK
- 3
- ITEM_IDR
- ALT-FLEXIBLE_C-002
- STORE_IDRPK
- 1000000003
- STOCK_COUNT_IDRPK
- 1000000003
- FLEXIBLE_COUNT_IDRPK
- 1000000003
- DISCREPANT
- F
- CREATE_DATE
- 2026-01-03
- CREATE_USER
- Flexible Count Line Item-002-ALT
- UPDATE_DATE
- 2026-01-03
- UPDATE_USER
- 2026-01-02-ALT
- QUANTITY_COUNT
- 12.5000
- COUNT_DATE_TIME
- 2026-01-03
- QUANTITY_RECOUNT
- 12.5000
- RECOUNT_DATE_TIME
- 2026-01-03
default
- IDRPK
- 5
- ITEM_IDR
- EDGE-FLEXIBLE_C-003
- STORE_IDRPK
- 1000000005
- STOCK_COUNT_IDRPK
- 1000000005
- FLEXIBLE_COUNT_IDRPK
- 1000000005
- DISCREPANT
- F
- CREATE_DATE
- 2026-01-05
- CREATE_USER
- Flexible Count Line Item-003-EDGE
- UPDATE_DATE
- 2026-01-05
- UPDATE_USER
- 2026-01-03-EDGE
- QUANTITY_COUNT
- 14.0000
- COUNT_DATE_TIME
- 2026-01-05
- QUANTITY_RECOUNT
- 14.0000
- RECOUNT_DATE_TIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 39
- Governed Rule Count
- 24