Stock Count Import
In ScopeTechnical: STOCK_COUNT_IMPORT | ID: OR-STO-STOCK_COUNT_IMPORT-STOCK_COUNT_IMPORT
Stores the third party file information from a stock count. the file follows the rgis file layout definition.
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_IMPORT
Field Definitions(5)
Rules & Considerations(13)
Sample Load Data(4)
| _scenario | STORE_IDR | UIN | STATUS | ITEM_ID | EXTRACT_ID | UPDATE_DATE | BATCH_IMP_ID | EXTRACT_INFO | COUNT_QUANTITY | STOCK_COUNT_ID | STORE_SEQUENCE_AREA_ID | PHYSICAL_COUNT_DATE_TIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | SAMPLE | 1 | 2026-01-01 | 1 | SAMPLE | 1.0000 | 1 | 1 | 2026-01-01 |
| default | 1000000003 | Stock Count Import-002-ALT | 2 | ALT-STOCK_COUN-002 | 1000000003 | 2026-01-03 | 1000000003 | Stock Count Import-002-ALT | 12.5000 | 1000000003 | 1000000003 | 2026-01-03 |
| default | 1000000005 | Stock Count Import-003-EDGE | 3 | EDGE-STOCK_COUN-003 | 1000000005 | 2026-01-05 | 1000000005 | Stock Count Import-003-EDGE | 14.0000 | 1000000005 | 1000000005 | 2026-01-05 |
Example values from field definitions
- STORE_IDR
- 1
- UIN
- SAMPLE
- STATUS
- 1
- ITEM_ID
- SAMPLE
- EXTRACT_ID
- 1
- UPDATE_DATE
- 2026-01-01
- BATCH_IMP_ID
- 1
- EXTRACT_INFO
- SAMPLE
- COUNT_QUANTITY
- 1.0000
- STOCK_COUNT_ID
- 1
- STORE_SEQUENCE_AREA_ID
- 1
- PHYSICAL_COUNT_DATE_TIME
- 2026-01-01
default
- STORE_IDR
- 1000000003
- UIN
- Stock Count Import-002-ALT
- STATUS
- 2
- ITEM_ID
- ALT-STOCK_COUN-002
- EXTRACT_ID
- 1000000003
- UPDATE_DATE
- 2026-01-03
- BATCH_IMP_ID
- 1000000003
- EXTRACT_INFO
- Stock Count Import-002-ALT
- COUNT_QUANTITY
- 12.5000
- STOCK_COUNT_ID
- 1000000003
- STORE_SEQUENCE_AREA_ID
- 1000000003
- PHYSICAL_COUNT_DATE_TIME
- 2026-01-03
default
- STORE_IDR
- 1000000005
- UIN
- Stock Count Import-003-EDGE
- STATUS
- 3
- ITEM_ID
- EDGE-STOCK_COUN-003
- EXTRACT_ID
- 1000000005
- UPDATE_DATE
- 2026-01-05
- BATCH_IMP_ID
- 1000000005
- EXTRACT_INFO
- Stock Count Import-003-EDGE
- COUNT_QUANTITY
- 14.0000
- STOCK_COUNT_ID
- 1000000005
- STORE_SEQUENCE_AREA_ID
- 1000000005
- PHYSICAL_COUNT_DATE_TIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 17
- Governed Rule Count
- 13