Item Source Details For A Worksheet
In ScopeTechnical: ALC_WORK_ITEM_SOURCE | ID: OR-ALLOC-ALC_WORK_ITEM_SOURCE-ALLOCATION_WORK_ITEM_SOURCE
This tables holds item source details for a worksheet.
See how this object fits into Allocations
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
- ALC_WORK_ITEM_SOURCE
Field Definitions(23)
Rules & Considerations(32)
Sample Load Data(4)
| _scenario | ITEMR | ITEM_TYPER | CREATED_BYR | UPDATED_BYR | REFRESH_INDR | CREATED_DATER | UPDATED_DATER | WORK_HEADER_IDRPK | ITEM_SOURCE_DESCR | WORK_ITEM_SOURCE_IDRPK | WH | DIFF_1 | DIFF_2 | DIFF_3 | DOC_NO | ITEM_ID | ANCESTOR_ID | DELETED_IND | DISABLE_IND | SOURCE_TYPE | BACKORDER_QTY | EXPECTED_TO_DATE | AVAILABLE_QUANTITY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPL | 2026-01-01 | 2026-01-01 | 1 | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | S | S | SAMPL | 1.0000 | 2026-01-01 | 1 |
Example values from field definitions
- ITEMR
- SAMPLE
- ITEM_TYPER
- SAMPLE
- CREATED_BYR
- SAMPLE
- UPDATED_BYR
- SAMPLE
- REFRESH_INDR
- SAMPL
- CREATED_DATER
- 2026-01-01
- UPDATED_DATER
- 2026-01-01
- WORK_HEADER_IDRPK
- 1
- ITEM_SOURCE_DESCR
- SAMPLE
- WORK_ITEM_SOURCE_IDRPK
- 1
- WH
- 1
- DIFF_1
- SAMPLE
- DIFF_2
- SAMPLE
- DIFF_3
- SAMPLE
- DOC_NO
- SAMPLE
- ITEM_ID
- SAMPLE
- ANCESTOR_ID
- 1
- DELETED_IND
- S
- DISABLE_IND
- S
- SOURCE_TYPE
- SAMPL
- BACKORDER_QTY
- 1.0000
- EXPECTED_TO_DATE
- 2026-01-01
- AVAILABLE_QUANTITY
- 1
Rule Validation Summary
- Source Rule Count
- 60
- Governed Rule Count
- 32