Item Source Details For A Worksheet
In ScopeTechnical: ALC_WORK_ITEM_SOURCE | ID: OR-ALLOC-ALC_WORK_ITEM_SOURCE-ACTUAL_LANDED_COST_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(5)
Rules & Considerations(33)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMR | ITEM_TYPER | WORK_HEADER_IDRPK | WORK_ITEM_SOURCE_IDRPK | WH | DIFF_1 | DIFF_2 | DIFF_3 | DOC_NO | ITEM_ID | CREATED_BY | UPDATED_BY | ANCESTOR_ID | DELETED_IND | DISABLE_IND | REFRESH_IND | SOURCE_TYPE | CREATED_DATE | UPDATED_DATE | BACKORDER_QTY | EXPECTED_TO_DATE | ITEM_SOURCE_DESC | AVAILABLE_QUANTITY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | 1 | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | S | S | SAMPL | SAMPL | 2026-01-01 | 2026-01-01 | 1.0000 | 2026-01-01 | SAMPLE | 1 |
| default | Alc Work Item Source-002-ALT | Alc Work I | 1000000003 | 1000000003 | 9003 | Alc Work I | Alc Work I | Alc Work I | Alc Work Item Source-002-ALT | ALT-ALC_WORK-002 | Alc Work Item Source-002-ALT | 2026-01-02-ALT | 1000000003 | A | A | Alc W | Alc W | 2026-01-03 | 2026-01-03 | 12.5000 | 2026-01-03 | Alc Work Item Source-002-ALT | 3 |
| default | Alc Work Item Source-003-EDGE | Alc Work I | 1000000005 | 1000000005 | 9005 | Alc Work I | Alc Work I | Alc Work I | Alc Work Item Source-003-EDGE | EDGE-ALC_WORK-003 | Alc Work Item Source-003-EDGE | 2026-01-03-EDGE | 1000000005 | A | A | Alc W | Alc W | 2026-01-05 | 2026-01-05 | 14.0000 | 2026-01-05 | Alc Work Item Source-003-EDGE | 5 |
Example values from field definitions
- ITEMR
- SAMPLE
- ITEM_TYPER
- SAMPLE
- WORK_HEADER_IDRPK
- 1
- WORK_ITEM_SOURCE_IDRPK
- 1
- WH
- 1
- DIFF_1
- SAMPLE
- DIFF_2
- SAMPLE
- DIFF_3
- SAMPLE
- DOC_NO
- SAMPLE
- ITEM_ID
- SAMPLE
- CREATED_BY
- SAMPLE
- UPDATED_BY
- SAMPLE
- ANCESTOR_ID
- 1
- DELETED_IND
- S
- DISABLE_IND
- S
- REFRESH_IND
- SAMPL
- SOURCE_TYPE
- SAMPL
- CREATED_DATE
- 2026-01-01
- UPDATED_DATE
- 2026-01-01
- BACKORDER_QTY
- 1.0000
- EXPECTED_TO_DATE
- 2026-01-01
- ITEM_SOURCE_DESC
- SAMPLE
- AVAILABLE_QUANTITY
- 1
default
- ITEMR
- Alc Work Item Source-002-ALT
- ITEM_TYPER
- Alc Work I
- WORK_HEADER_IDRPK
- 1000000003
- WORK_ITEM_SOURCE_IDRPK
- 1000000003
- WH
- 9003
- DIFF_1
- Alc Work I
- DIFF_2
- Alc Work I
- DIFF_3
- Alc Work I
- DOC_NO
- Alc Work Item Source-002-ALT
- ITEM_ID
- ALT-ALC_WORK-002
- CREATED_BY
- Alc Work Item Source-002-ALT
- UPDATED_BY
- 2026-01-02-ALT
- ANCESTOR_ID
- 1000000003
- DELETED_IND
- A
- DISABLE_IND
- A
- REFRESH_IND
- Alc W
- SOURCE_TYPE
- Alc W
- CREATED_DATE
- 2026-01-03
- UPDATED_DATE
- 2026-01-03
- BACKORDER_QTY
- 12.5000
- EXPECTED_TO_DATE
- 2026-01-03
- ITEM_SOURCE_DESC
- Alc Work Item Source-002-ALT
- AVAILABLE_QUANTITY
- 3
default
- ITEMR
- Alc Work Item Source-003-EDGE
- ITEM_TYPER
- Alc Work I
- WORK_HEADER_IDRPK
- 1000000005
- WORK_ITEM_SOURCE_IDRPK
- 1000000005
- WH
- 9005
- DIFF_1
- Alc Work I
- DIFF_2
- Alc Work I
- DIFF_3
- Alc Work I
- DOC_NO
- Alc Work Item Source-003-EDGE
- ITEM_ID
- EDGE-ALC_WORK-003
- CREATED_BY
- Alc Work Item Source-003-EDGE
- UPDATED_BY
- 2026-01-03-EDGE
- ANCESTOR_ID
- 1000000005
- DELETED_IND
- A
- DISABLE_IND
- A
- REFRESH_IND
- Alc W
- SOURCE_TYPE
- Alc W
- CREATED_DATE
- 2026-01-05
- UPDATED_DATE
- 2026-01-05
- BACKORDER_QTY
- 14.0000
- EXPECTED_TO_DATE
- 2026-01-05
- ITEM_SOURCE_DESC
- Alc Work Item Source-003-EDGE
- AVAILABLE_QUANTITY
- 5
Rule Validation Summary
- Source Rule Count
- 61
- Governed Rule Count
- 33