Ordloc Expense (Service Layer)

In Scope

Technical: SVC_ORDLOC_EXP | ID: OR-FND-SVC_ORDLOC_EXP-ORDLOC_EXPENSE_SERVICE_LAYER

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

Classification

Object Type
dictionary

Target Structure

Load Approach
Table
Target Objects
SVC_ORDLOC_EXP

Field Definitions(5)

Rules & Considerations(35)

constraint

validation

Sample Load Data(4)

Example values from field definitions

ROW_SEQRPK
1
CHUNK_IDR
1
PROCESS_IDRPK
1
ITEM
SAMPLE
ACTION
SAMPLE
ORIGIN
S
COMP_ID
SAMPLE
CVB_CODE
SAMPLE
LOCATION
1
LOC_TYPE
S
ORDER_NO
1
COMP_RATE
1.0000
CREATE_ID
SAMPLE
PACK_ITEM
SAMPLE
PER_COUNT
1.0000
COST_BASIS
S
NOM_FLAG_1
S
NOM_FLAG_2
S
NOM_FLAG_3
S
NOM_FLAG_4
S
NOM_FLAG_5
S
KEY_VALUE_1
SAMPLE
KEY_VALUE_2
SAMPLE
LAST_UPD_ID
SAMPLE
COMP_CURRENCY
SAM
EST_EXP_VALUE
1.0000000000
EXCHANGE_RATE
1.0000000000
PER_COUNT_UOM
SAMP
DEFAULTED_FROM
SAMPLE
PROCESS$STATUS
SAMPLE
CREATE_DATETIME
2026-01-01
LAST_UPD_DATETIME
2026-01-01

default

ROW_SEQRPK
3
CHUNK_IDR
1000000003
PROCESS_IDRPK
1000000003
ITEM
Svc Ordloc Exp-002-ALT
ACTION
Svc Ordloc
ORIGIN
M
COMP_ID
ALT-SVC_OR
CVB_CODE
ALT-SVC_OR
LOCATION
3
LOC_TYPE
W
ORDER_NO
4
COMP_RATE
12.5000
CREATE_ID
USER
PACK_ITEM
Svc Ordloc Exp-002-ALT
PER_COUNT
12.5000
COST_BASIS
O
NOM_FLAG_1
-
NOM_FLAG_2
S
NOM_FLAG_3
S
NOM_FLAG_4
S
NOM_FLAG_5
S
KEY_VALUE_1
Svc Ordloc
KEY_VALUE_2
Svc Ordloc
LAST_UPD_ID
USER
COMP_CURRENCY
Svc
EST_EXP_VALUE
12.5000000000
EXCHANGE_RATE
12.5000000000
PER_COUNT_UOM
Svc
DEFAULTED_FROM
S
PROCESS$STATUS
N
CREATE_DATETIME
2026-01-03
LAST_UPD_DATETIME
2026-01-03

default

ROW_SEQRPK
5
CHUNK_IDR
1000000005
PROCESS_IDRPK
1000000005
ITEM
Svc Ordloc Exp-003-EDGE
ACTION
Svc Ordloc
ORIGIN
M
COMP_ID
EDGE-SVC_O
CVB_CODE
EDGE-SVC_O
LOCATION
5
LOC_TYPE
S
ORDER_NO
6
COMP_RATE
14.0000
CREATE_ID
USER
PACK_ITEM
Svc Ordloc Exp-003-EDGE
PER_COUNT
14.0000
COST_BASIS
t
NOM_FLAG_1
+
NOM_FLAG_2
S
NOM_FLAG_3
S
NOM_FLAG_4
S
NOM_FLAG_5
S
KEY_VALUE_1
Svc Ordloc
KEY_VALUE_2
Svc Ordloc
LAST_UPD_ID
USER
COMP_CURRENCY
Svc
EST_EXP_VALUE
14.0000000000
EXCHANGE_RATE
14.0000000000
PER_COUNT_UOM
Svc
DEFAULTED_FROM
C
PROCESS$STATUS
N
CREATE_DATETIME
2026-01-05
LAST_UPD_DATETIME
2026-01-05

Rule Validation Summary

Source Rule Count
46
Governed Rule Count
35