Wo Detail
In ScopeTechnical: WO_DETAIL | ID: OR-ITM-WO_DETAIL-WO_DETAIL
Stores the details for a work order associated with a PO. It will hold all item/wh/dest loc/wip code combinations.
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
- WO_DETAIL
Field Definitions(5)
Rules & Considerations(31)
validation
constraint
Sample Load Data(4)
| _scenario | WHRPK | ITEMRPK | WO_IDRPK | LOCATIONRPK | LOC_TYPERPK | SEQ_NO | WIP_CODE | CREATE_ID | PUBLISH_IND | LAST_UPDATE_ID | CREATE_DATETIME | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | S | 1 | SAMPLE | SAMPLE | S | SAMPLE | 2026-01-01 | 2026-01-01 |
| default | 9003 | Wo Detail-002-ALT | 1000000003 | 3 | S | 4 | ALT-WO | APP_USER_ID | p | APP_USER_ID | 2026-01-03 | 2026-01-03 |
| default | 9005 | Wo Detail-003-EDGE | 1000000005 | 5 | S | 6 | EDGE-W | USERENV | N | USERENV | 2026-01-05 | 2026-01-05 |
Example values from field definitions
- WHRPK
- 1
- ITEMRPK
- SAMPLE
- WO_IDRPK
- 1
- LOCATIONRPK
- 1
- LOC_TYPERPK
- S
- SEQ_NO
- 1
- WIP_CODE
- SAMPLE
- CREATE_ID
- SAMPLE
- PUBLISH_IND
- S
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- WHRPK
- 9003
- ITEMRPK
- Wo Detail-002-ALT
- WO_IDRPK
- 1000000003
- LOCATIONRPK
- 3
- LOC_TYPERPK
- S
- SEQ_NO
- 4
- WIP_CODE
- ALT-WO
- CREATE_ID
- APP_USER_ID
- PUBLISH_IND
- p
- LAST_UPDATE_ID
- APP_USER_ID
- CREATE_DATETIME
- 2026-01-03
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- WHRPK
- 9005
- ITEMRPK
- Wo Detail-003-EDGE
- WO_IDRPK
- 1000000005
- LOCATIONRPK
- 5
- LOC_TYPERPK
- S
- SEQ_NO
- 6
- WIP_CODE
- EDGE-W
- CREATE_ID
- USERENV
- PUBLISH_IND
- N
- LAST_UPDATE_ID
- USERENV
- CREATE_DATETIME
- 2026-01-05
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 45
- Governed Rule Count
- 31