Item-Related Information For A Stock Count
In ScopeTechnical: SVC_STKUPLD_FDETL | ID: OR-ITM-SVC_STKUPLD_FDETL-STKUPLD_FDETL_SERVICE_LAYER
This table is an interface tables in the stock upload process. It holds item-related information for a stock count.
See how this object fits into Item Management
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
- SVC_STKUPLD_FDETL
Field Definitions(5)
Rules & Considerations(14)
Sample Load Data(4)
| _scenario | STATUS | CHUNK_ID | ERROR_MSG | ITEM_TYPE | ITEM_VALUE | PROCESS_ID | FILE_LINE_ID | INVENTORY_ID | INVENTORY_QUANTITY | LOCATION_DESCRIPTION | FILE_RECORD_DESCRIPTOR | INVENTORY_IDENTIFIER_TYPE | SIM_RMS_STOCK_COUNT_RESULT_ID | SIM_RMS_STOCK_COUNT_RESULT_DETAIL_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | S | 1 | SAMPLE | SAM | SAMPLE | 1 | 1 | SAMPLE | 1 | SAMPLE | SAMPL | SAMPLE | 1 | 1 |
| default | E | 1000000003 | Svc Stkupld Fdetl-002-ALT | Svc | Svc Stkupld Fdetl-002-ALT | 1000000003 | 1000000003 | ALT-SVC_STKUPL-002 | 3 | Svc Stkupld Fdetl: Alternate source profile | Svc S | L | 1000000003 | 1000000003 |
| default | R | 1000000005 | Svc Stkupld Fdetl-003-EDGE | Svc | Svc Stkupld Fdetl-003-EDG | 1000000005 | 1000000005 | EDGE-SVC_STKUPL-003 | 5 | — | Svc S | E | 1000000005 | 1000000005 |
Example values from field definitions
- STATUS
- S
- CHUNK_ID
- 1
- ERROR_MSG
- SAMPLE
- ITEM_TYPE
- SAM
- ITEM_VALUE
- SAMPLE
- PROCESS_ID
- 1
- FILE_LINE_ID
- 1
- INVENTORY_ID
- SAMPLE
- INVENTORY_QUANTITY
- 1
- LOCATION_DESCRIPTION
- SAMPLE
- FILE_RECORD_DESCRIPTOR
- SAMPL
- INVENTORY_IDENTIFIER_TYPE
- SAMPLE
- SIM_RMS_STOCK_COUNT_RESULT_ID
- 1
- SIM_RMS_STOCK_COUNT_RESULT_DETAIL_ID
- 1
default
- STATUS
- E
- CHUNK_ID
- 1000000003
- ERROR_MSG
- Svc Stkupld Fdetl-002-ALT
- ITEM_TYPE
- Svc
- ITEM_VALUE
- Svc Stkupld Fdetl-002-ALT
- PROCESS_ID
- 1000000003
- FILE_LINE_ID
- 1000000003
- INVENTORY_ID
- ALT-SVC_STKUPL-002
- INVENTORY_QUANTITY
- 3
- LOCATION_DESCRIPTION
- Svc Stkupld Fdetl: Alternate source profile
- FILE_RECORD_DESCRIPTOR
- Svc S
- INVENTORY_IDENTIFIER_TYPE
- L
- SIM_RMS_STOCK_COUNT_RESULT_ID
- 1000000003
- SIM_RMS_STOCK_COUNT_RESULT_DETAIL_ID
- 1000000003
default
- STATUS
- R
- CHUNK_ID
- 1000000005
- ERROR_MSG
- Svc Stkupld Fdetl-003-EDGE
- ITEM_TYPE
- Svc
- ITEM_VALUE
- Svc Stkupld Fdetl-003-EDG
- PROCESS_ID
- 1000000005
- FILE_LINE_ID
- 1000000005
- INVENTORY_ID
- EDGE-SVC_STKUPL-003
- INVENTORY_QUANTITY
- 5
- LOCATION_DESCRIPTION
- —
- FILE_RECORD_DESCRIPTOR
- Svc S
- INVENTORY_IDENTIFIER_TYPE
- E
- SIM_RMS_STOCK_COUNT_RESULT_ID
- 1000000005
- SIM_RMS_STOCK_COUNT_RESULT_DETAIL_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 24
- Governed Rule Count
- 14