Stock Count Cancel
In ScopeTechnical: STOCK_COUNT_CANCEL | ID: OR-STO-STOCK_COUNT_CANCEL-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- STOCK_COUNT_CANCEL
Field Definitions(5)
Rules & Considerations(22)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | SCHEDULE_DATER | STOCK_COUNT_IDR | STOCK_COUNT_SCHEDULE_IDR | STORE_ID | CREATE_ID | PROCESS_IND | OPEN_COUNT_IND | PROCESS_MESSAGE | STOCK_COUNT_TYPE | SCHEDULE_DESCRIPTION | LAST_UPDATE_DATETIMEYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE13PUBLISH | CREATE_DATETIMEYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE11LAST_UPDATE_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 2026-01-01 | 1 | 1 | 1 | SAMPLE | S | S | Sample text | 1 | SAMPLE | S | SAMPLE |
| default | 3 | 2026-01-03 | 1000000003 | 1000000003 | 1000000003 | C LIENT_INFO | N | N | Stock Count Cancel-002-ALT | 3 | Stock Count Cancel: Alternate source profile | 2 | C LIENT_INFO |
| default | 5 | 2026-01-05 | 1000000005 | 1000000005 | 1000000005 | USE RENV | N | N | Stock Count Cancel-003-EDGE | 5 | — | 2 | USE RENV |
Example values from field definitions
- IDRPK
- 1
- SCHEDULE_DATER
- 2026-01-01
- STOCK_COUNT_IDR
- 1
- STOCK_COUNT_SCHEDULE_IDR
- 1
- STORE_ID
- 1
- CREATE_ID
- SAMPLE
- PROCESS_IND
- S
- OPEN_COUNT_IND
- S
- PROCESS_MESSAGE
- Sample text
- STOCK_COUNT_TYPE
- 1
- SCHEDULE_DESCRIPTION
- SAMPLE
- LAST_UPDATE_DATETIMEYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE13PUBLISH
- S
- CREATE_DATETIMEYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE11LAST_UPDATE_ID
- SAMPLE
default
- IDRPK
- 3
- SCHEDULE_DATER
- 2026-01-03
- STOCK_COUNT_IDR
- 1000000003
- STOCK_COUNT_SCHEDULE_IDR
- 1000000003
- STORE_ID
- 1000000003
- CREATE_ID
- C LIENT_INFO
- PROCESS_IND
- N
- OPEN_COUNT_IND
- N
- PROCESS_MESSAGE
- Stock Count Cancel-002-ALT
- STOCK_COUNT_TYPE
- 3
- SCHEDULE_DESCRIPTION
- Stock Count Cancel: Alternate source profile
- LAST_UPDATE_DATETIMEYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE13PUBLISH
- 2
- CREATE_DATETIMEYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE11LAST_UPDATE_ID
- C LIENT_INFO
default
- IDRPK
- 5
- SCHEDULE_DATER
- 2026-01-05
- STOCK_COUNT_IDR
- 1000000005
- STOCK_COUNT_SCHEDULE_IDR
- 1000000005
- STORE_ID
- 1000000005
- CREATE_ID
- USE RENV
- PROCESS_IND
- N
- OPEN_COUNT_IND
- N
- PROCESS_MESSAGE
- Stock Count Cancel-003-EDGE
- STOCK_COUNT_TYPE
- 5
- SCHEDULE_DESCRIPTION
- —
- LAST_UPDATE_DATETIMEYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE13PUBLISH
- 2
- CREATE_DATETIMEYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE11LAST_UPDATE_ID
- USE RENV
Rule Validation Summary
- Source Rule Count
- 37
- Governed Rule Count
- 22