Svc Orddetail
In ScopeTechnical: SVC_ORDDETAIL | ID: OR-MFCS-SVC_ORDDETAIL
This is the staging table for PO Induction module which is used to temporarily hold data before it is uploaded in the ORDSKU, ORDLOC, ALLOC_HEADER, and ALLOC_DETAIL tables.
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
Target Structure
- Load Approach
- Table
- Target Objects
- SVC_ORDDETAIL
Field Definitions(41)
Rules & Considerations(28)
Sample Load Data(4)
| _scenario | ROW_SEQR | CHUNK_IDR | PROCESS_IDRPK | VPN | ITEM | ACTION | DIFF_1 | DIFF_2 | DIFF_3 | DIFF_4 | ALLOC_NO | LOCATION | LOC_TYPE | ORDER_NO | REF_ITEM | CREATE_ID | ITEM_DESC | UNIT_COST | RE_APPROVE | CANCEL_CODE | ITEM_PARENT | LAST_UPD_ID | QTY_ORDERED | RELEASE_DATE | DELIVERY_DATE | IN_STORE_DATE | LOCATION_DESC | NON_SCALE_IND | PROCESSING_WH | QTY_CANCELLED | PROCESS$STATUS | SUPP_PACK_SIZE | CREATE_DATETIME | PROCESSING_TYPE | QTY_TRANSFERRED | LATEST_SHIP_DATE | SET_TO_WORKSHEET | LAST_UPD_DATETIME | ORIGIN_COUNTRY_ID | EARLIEST_SHIP_DATE | ESTIMATED_INSTOCK_DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 1000000001 | 1000000001 | Svc Orddetail-001 | Svc Orddetail-001 | Svc Orddetail-001 | Svc Orddetail-001 | Svc Orddetail-001 | Svc Orddetail-001 | Svc Orddetail-001 | 2 | 1 | S | 2 | Svc Orddetail-001 | USER | Svc Orddetail-001 | 11.0000 | N | STD-SVC_ORDDET-001 | Svc Orddetail-001 | USER | 11.0000 | 2026-01-01 | 2026-01-01 | 2026-01-01 | Svc Orddetail-001 | Y | 9001 | 11.0000 | N | 11.0000 | 2026-01-01 | Svc Orddetail-001 | 11.0000 | 2026-01-01 | N | 2026-01-01 | STD-SVC_ORDDET-001 | 2026-01-01 | 2026-01-01 |
default
- ROW_SEQR
- 1
- CHUNK_IDR
- 1000000001
- PROCESS_IDRPK
- 1000000001
- VPN
- Svc Orddetail-001
- ITEM
- Svc Orddetail-001
- ACTION
- Svc Orddetail-001
- DIFF_1
- Svc Orddetail-001
- DIFF_2
- Svc Orddetail-001
- DIFF_3
- Svc Orddetail-001
- DIFF_4
- Svc Orddetail-001
- ALLOC_NO
- 2
- LOCATION
- 1
- LOC_TYPE
- S
- ORDER_NO
- 2
- REF_ITEM
- Svc Orddetail-001
- CREATE_ID
- USER
- ITEM_DESC
- Svc Orddetail-001
- UNIT_COST
- 11.0000
- RE_APPROVE
- N
- CANCEL_CODE
- STD-SVC_ORDDET-001
- ITEM_PARENT
- Svc Orddetail-001
- LAST_UPD_ID
- USER
- QTY_ORDERED
- 11.0000
- RELEASE_DATE
- 2026-01-01
- DELIVERY_DATE
- 2026-01-01
- IN_STORE_DATE
- 2026-01-01
- LOCATION_DESC
- Svc Orddetail-001
- NON_SCALE_IND
- Y
- PROCESSING_WH
- 9001
- QTY_CANCELLED
- 11.0000
- PROCESS$STATUS
- N
- SUPP_PACK_SIZE
- 11.0000
- CREATE_DATETIME
- 2026-01-01
- PROCESSING_TYPE
- Svc Orddetail-001
- QTY_TRANSFERRED
- 11.0000
- LATEST_SHIP_DATE
- 2026-01-01
- SET_TO_WORKSHEET
- N
- LAST_UPD_DATETIME
- 2026-01-01
- ORIGIN_COUNTRY_ID
- STD-SVC_ORDDET-001
- EARLIEST_SHIP_DATE
- 2026-01-01
- ESTIMATED_INSTOCK_DATE
- 2026-01-01