Stock Count Line Item
In ScopeTechnical: STOCK_COUNT_LINE_ITEM | ID: OR-STO-STOCK_COUNT_LINE_ITEM-STOCK_COUNT_LINE_ITEM
defines the results of a stock count for each item in a stock count.
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_LINE_ITEM
Field Definitions(5)
Rules & Considerations(43)
constraint
validation
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDRPK | STORE_IDRPK | STOCK_COUNT_IDRPK | STOCK_COUNT_CHILD_IDRPK | CLASS_ID | SELLABLE | ITEM_TYPE | DISCREPANT | PRICE_TYPE | LOCATION_ID | PRICE_VALUE | SUBCLASS_ID | COUNTED_TOTAL | DEPARTMENT_ID | MULTI_LOCATED | COUNT_SNAPSHOT | PRICE_CURRENCY | COUNT_DATE_TIME | RECOUNTED_TOTAL | COUNTED_QUANTITY | PRIMARY_LOCATION | RECOUNT_SNAPSHOT | APPROVED_QUANTITY | RECOUNT_DATE_TIME | APPROVED_DATE_TIME | RECOUNTED_QUANTITY | SNAPSHOT_DATE_TIME | BREAKABLE_COMPONENT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | 1 | 1 | S | 1 | S | 1 | SAMPLE | 1.0000 | 1 | 1.0000 | 1 | S | 1.0000 | SAM | 2026-01-01 | 1.0000 | 1.0000 | S | 1.0000 | 1.0000 | 2026-01-01 | 2026-01-01 | 1.0000 | 2026-01-01 | S |
| default | 3 | ALT-STOCK_COUN-002 | 1000000003 | 1000000003 | 1000000003 | 1000000003 | S | 3 | y | 3 | ALT-STOCK_COUN-002 | 12.5000 | 1000000003 | 12.5000 | 1000000003 | y | 12.5000 | Sto | 2026-01-03 | 12.5000 | 12.5000 | Y | 12.5000 | 12.5000 | 2026-01-03 | 2026-01-03 | 12.5000 | 2026-01-03 | N |
| default | 5 | EDGE-STOCK_COUN-003 | 1000000005 | 1000000005 | 1000000005 | 1000000005 | S | 5 | y | 5 | EDGE-STOCK_COUN-003 | 14.0000 | 1000000005 | 14.0000 | 1000000005 | Y | 14.0000 | Sto | 2026-01-05 | 14.0000 | 14.0000 | Y | 14.0000 | 14.0000 | 2026-01-05 | 2026-01-05 | 14.0000 | 2026-01-05 | N |
Example values from field definitions
- IDRPK
- 1
- ITEM_IDRPK
- SAMPLE
- STORE_IDRPK
- 1
- STOCK_COUNT_IDRPK
- 1
- STOCK_COUNT_CHILD_IDRPK
- 1
- CLASS_ID
- 1
- SELLABLE
- S
- ITEM_TYPE
- 1
- DISCREPANT
- S
- PRICE_TYPE
- 1
- LOCATION_ID
- SAMPLE
- PRICE_VALUE
- 1.0000
- SUBCLASS_ID
- 1
- COUNTED_TOTAL
- 1.0000
- DEPARTMENT_ID
- 1
- MULTI_LOCATED
- S
- COUNT_SNAPSHOT
- 1.0000
- PRICE_CURRENCY
- SAM
- COUNT_DATE_TIME
- 2026-01-01
- RECOUNTED_TOTAL
- 1.0000
- COUNTED_QUANTITY
- 1.0000
- PRIMARY_LOCATION
- S
- RECOUNT_SNAPSHOT
- 1.0000
- APPROVED_QUANTITY
- 1.0000
- RECOUNT_DATE_TIME
- 2026-01-01
- APPROVED_DATE_TIME
- 2026-01-01
- RECOUNTED_QUANTITY
- 1.0000
- SNAPSHOT_DATE_TIME
- 2026-01-01
- BREAKABLE_COMPONENT
- S
default
- IDRPK
- 3
- ITEM_IDRPK
- ALT-STOCK_COUN-002
- STORE_IDRPK
- 1000000003
- STOCK_COUNT_IDRPK
- 1000000003
- STOCK_COUNT_CHILD_IDRPK
- 1000000003
- CLASS_ID
- 1000000003
- SELLABLE
- S
- ITEM_TYPE
- 3
- DISCREPANT
- y
- PRICE_TYPE
- 3
- LOCATION_ID
- ALT-STOCK_COUN-002
- PRICE_VALUE
- 12.5000
- SUBCLASS_ID
- 1000000003
- COUNTED_TOTAL
- 12.5000
- DEPARTMENT_ID
- 1000000003
- MULTI_LOCATED
- y
- COUNT_SNAPSHOT
- 12.5000
- PRICE_CURRENCY
- Sto
- COUNT_DATE_TIME
- 2026-01-03
- RECOUNTED_TOTAL
- 12.5000
- COUNTED_QUANTITY
- 12.5000
- PRIMARY_LOCATION
- Y
- RECOUNT_SNAPSHOT
- 12.5000
- APPROVED_QUANTITY
- 12.5000
- RECOUNT_DATE_TIME
- 2026-01-03
- APPROVED_DATE_TIME
- 2026-01-03
- RECOUNTED_QUANTITY
- 12.5000
- SNAPSHOT_DATE_TIME
- 2026-01-03
- BREAKABLE_COMPONENT
- N
default
- IDRPK
- 5
- ITEM_IDRPK
- EDGE-STOCK_COUN-003
- STORE_IDRPK
- 1000000005
- STOCK_COUNT_IDRPK
- 1000000005
- STOCK_COUNT_CHILD_IDRPK
- 1000000005
- CLASS_ID
- 1000000005
- SELLABLE
- S
- ITEM_TYPE
- 5
- DISCREPANT
- y
- PRICE_TYPE
- 5
- LOCATION_ID
- EDGE-STOCK_COUN-003
- PRICE_VALUE
- 14.0000
- SUBCLASS_ID
- 1000000005
- COUNTED_TOTAL
- 14.0000
- DEPARTMENT_ID
- 1000000005
- MULTI_LOCATED
- Y
- COUNT_SNAPSHOT
- 14.0000
- PRICE_CURRENCY
- Sto
- COUNT_DATE_TIME
- 2026-01-05
- RECOUNTED_TOTAL
- 14.0000
- COUNTED_QUANTITY
- 14.0000
- PRIMARY_LOCATION
- Y
- RECOUNT_SNAPSHOT
- 14.0000
- APPROVED_QUANTITY
- 14.0000
- RECOUNT_DATE_TIME
- 2026-01-05
- APPROVED_DATE_TIME
- 2026-01-05
- RECOUNTED_QUANTITY
- 14.0000
- SNAPSHOT_DATE_TIME
- 2026-01-05
- BREAKABLE_COMPONENT
- N
Rule Validation Summary
- Source Rule Count
- 66
- Governed Rule Count
- 43