Svc Ordloc Exp
In ScopeTechnical: SVC_ORDLOC_EXP | ID: OR-MFCS-SVC_ORDLOC_EXP
This is the staging table for PO Induction module which is used to temporarily hold data before it is uploaded in the ORDLOC_EXP table.
See how this object fits into Foundation Data
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_ORDLOC_EXP
Field Definitions(32)
Rules & Considerations(15)
Sample Load Data(4)
| _scenario | ROW_SEQR | CHUNK_IDR | PROCESS_IDRPK | ITEM | ACTION | ORIGIN | COMP_ID | CVB_CODE | LOCATION | LOC_TYPE | ORDER_NO | COMP_RATE | CREATE_ID | PACK_ITEM | PER_COUNT | COST_BASIS | NOM_FLAG_1 | NOM_FLAG_2 | NOM_FLAG_3 | NOM_FLAG_4 | NOM_FLAG_5 | KEY_VALUE_1 | KEY_VALUE_2 | LAST_UPD_ID | COMP_CURRENCY | EST_EXP_VALUE | EXCHANGE_RATE | PER_COUNT_UOM | DEFAULTED_FROM | PROCESS$STATUS | CREATE_DATETIME | LAST_UPD_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 1000000001 | 1000000001 | Svc Ordloc Exp-001 | Svc Ordloc Exp-001 | M | STD-SVC_ORDLOC-001 | STD-SVC_ORDLOC-001 | 1 | S | 2 | 11.0000 | USER | Svc Ordloc Exp-001 | 11.0000 | Supplier | + | Svc Ordloc Exp-001 | Svc Ordloc Exp-001 | Svc Ordloc Exp-001 | Svc Ordloc Exp-001 | Svc Ordloc Exp-001 | Svc Ordloc Exp-001 | USER | Svc Ordloc Exp-001 | 11.0000 | 11.0000 | Svc Ordloc Exp-001 | P | N | 2026-01-01 | 2026-01-01 |
default
- ROW_SEQR
- 1
- CHUNK_IDR
- 1000000001
- PROCESS_IDRPK
- 1000000001
- ITEM
- Svc Ordloc Exp-001
- ACTION
- Svc Ordloc Exp-001
- ORIGIN
- M
- COMP_ID
- STD-SVC_ORDLOC-001
- CVB_CODE
- STD-SVC_ORDLOC-001
- LOCATION
- 1
- LOC_TYPE
- S
- ORDER_NO
- 2
- COMP_RATE
- 11.0000
- CREATE_ID
- USER
- PACK_ITEM
- Svc Ordloc Exp-001
- PER_COUNT
- 11.0000
- COST_BASIS
- Supplier
- NOM_FLAG_1
- +
- NOM_FLAG_2
- Svc Ordloc Exp-001
- NOM_FLAG_3
- Svc Ordloc Exp-001
- NOM_FLAG_4
- Svc Ordloc Exp-001
- NOM_FLAG_5
- Svc Ordloc Exp-001
- KEY_VALUE_1
- Svc Ordloc Exp-001
- KEY_VALUE_2
- Svc Ordloc Exp-001
- LAST_UPD_ID
- USER
- COMP_CURRENCY
- Svc Ordloc Exp-001
- EST_EXP_VALUE
- 11.0000
- EXCHANGE_RATE
- 11.0000
- PER_COUNT_UOM
- Svc Ordloc Exp-001
- DEFAULTED_FROM
- P
- PROCESS$STATUS
- N
- CREATE_DATETIME
- 2026-01-01
- LAST_UPD_DATETIME
- 2026-01-01