Stock Count Cancel
In ScopeTechnical: STOCK_COUNT_CANCEL | ID: OR-SIOCS-STOCK_COUNT_CANCEL
Supports Oracle Retail Stock Count Cancel processing in STOCK_COUNT_CANCEL.
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
Target Structure
- Load Approach
- Table
- Target Objects
- STOCK_COUNT_CANCEL
Field Definitions(13)
Rules & Considerations(43)
Sample Load Data(4)
| _scenario | IDRPK | STORE_IDR | CREATE_IDR | PROCESS_INDR | SCHEDULE_DATER | OPEN_COUNT_INDR | STOCK_COUNT_IDR | STOCK_COUNT_SCHEDULE_IDR | CREATE_DATETIMEYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE11LAST_UPDATE_IDR | PROCESS_MESSAGE | STOCK_COUNT_TYPE | SCHEDULE_DESCRIPTION | LAST_UPDATE_DATETIMEYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE13PUBLISH |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 1000000001 | USERENV | N | 2026-01-01 | N | 1000000001 | 1000000001 | USERENV | Stock Count Cancel-001 | 01 | Stock Count Cancel: Baseline migration row | 2026-01-01 |
default
- IDRPK
- 1
- STORE_IDR
- 1000000001
- CREATE_IDR
- USERENV
- PROCESS_INDR
- N
- SCHEDULE_DATER
- 2026-01-01
- OPEN_COUNT_INDR
- N
- STOCK_COUNT_IDR
- 1000000001
- STOCK_COUNT_SCHEDULE_IDR
- 1000000001
- CREATE_DATETIMEYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE11LAST_UPDATE_IDR
- USERENV
- PROCESS_MESSAGE
- Stock Count Cancel-001
- STOCK_COUNT_TYPE
- 01
- SCHEDULE_DESCRIPTION
- Stock Count Cancel: Baseline migration row
- LAST_UPDATE_DATETIMEYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE13PUBLISH
- 2026-01-01