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(29)
Rules & Considerations(43)
constraint
validation
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDRPK | SELLABLER | STORE_IDRPK | ITEM_TYPER | DISCREPANTR | LOCATION_IDR | DEPARTMENT_IDR | MULTI_LOCATEDR | STOCK_COUNT_IDRPK | PRIMARY_LOCATIONR | BREAKABLE_COMPONENTR | STOCK_COUNT_CHILD_IDRPK | CLASS_ID | PRICE_TYPE | PRICE_VALUE | SUBCLASS_ID | COUNTED_TOTAL | COUNT_SNAPSHOT | PRICE_CURRENCY | COUNT_DATE_TIME | RECOUNTED_TOTAL | COUNTED_QUANTITY | RECOUNT_SNAPSHOT | APPROVED_QUANTITY | RECOUNT_DATE_TIME | APPROVED_DATE_TIME | RECOUNTED_QUANTITY | SNAPSHOT_DATE_TIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | S | 1 | 1 | S | SAMPLE | 1 | S | 1 | S | S | 1 | 1 | 1 | 1.0000 | 1 | 1.0000 | 1.0000 | SAM | 2026-01-01 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 2026-01-01 | 2026-01-01 | 1.0000 | 2026-01-01 |
Example values from field definitions
- IDRPK
- 1
- ITEM_IDRPK
- SAMPLE
- SELLABLER
- S
- STORE_IDRPK
- 1
- ITEM_TYPER
- 1
- DISCREPANTR
- S
- LOCATION_IDR
- SAMPLE
- DEPARTMENT_IDR
- 1
- MULTI_LOCATEDR
- S
- STOCK_COUNT_IDRPK
- 1
- PRIMARY_LOCATIONR
- S
- BREAKABLE_COMPONENTR
- S
- STOCK_COUNT_CHILD_IDRPK
- 1
- CLASS_ID
- 1
- PRICE_TYPE
- 1
- PRICE_VALUE
- 1.0000
- SUBCLASS_ID
- 1
- COUNTED_TOTAL
- 1.0000
- COUNT_SNAPSHOT
- 1.0000
- PRICE_CURRENCY
- SAM
- COUNT_DATE_TIME
- 2026-01-01
- RECOUNTED_TOTAL
- 1.0000
- COUNTED_QUANTITY
- 1.0000
- 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
Rule Validation Summary
- Source Rule Count
- 66
- Governed Rule Count
- 43