Service Order Parameter Configuration (Service Layer)

In Scope

Technical: SVC_SVC_ORDER_PARAMETER_CONFIG | ID: OR-ITM-SVC_SVC_ORDER_PARAMETER_CONFIG-SERVICE_ORDER_PARAMETER_CONFIGURATION_SERVICE_LAYER

This is a staging table used for Admin API spreadsheet upload process.It is used to temporarily hold data before it is uploaded/updated in SVC_CORESVC_ITEM_CONFIG.

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
SVC_SVC_ORDER_PARAMETER_CONFIG

Field Definitions(5)

Rules & Considerations(24)

Sample Load Data(4)

Example values from field definitions

ROW_SEQR
1
CHUNK_IDR
1
PROCESS_IDRPK
1
ACTION
SAMPLE
CREATE_ID
SAMPLE
APPLY_DEALS
S
LAST_UPD_ID
SAMPLE
MAX_THREADS
1
CANCEL_ALLOC
S
OTB_OVERRIDE
S
APPLY_SCALING
S
APPLY_BRACKETS
S
MAX_CHUNK_SIZE
1
PROCESS$STATUS
SAMPLE
CREATE_DATETIME
2026-01-01
MAX_ORDER_NO_QTY
1
LAST_UPD_DATETIME
2026-01-01
WAIT_BTWN_THREADS
1
SKIP_OPEN_SHIPMENT
S
RECALC_REPLENISHMENT
S
MAX_ORDER_EXPIRY_DAYS
1
OVERRIDE_MANL_COST_SRC
S

default

ROW_SEQR
3
CHUNK_IDR
1000000003
PROCESS_IDRPK
1000000003
ACTION
Svc Svc Or
CREATE_ID
USER
APPLY_DEALS
N
LAST_UPD_ID
USER
MAX_THREADS
3
CANCEL_ALLOC
S
OTB_OVERRIDE
N
APPLY_SCALING
N
APPLY_BRACKETS
N
MAX_CHUNK_SIZE
3
PROCESS$STATUS
N
CREATE_DATETIME
2026-01-03
MAX_ORDER_NO_QTY
3
LAST_UPD_DATETIME
2026-01-03
WAIT_BTWN_THREADS
3
SKIP_OPEN_SHIPMENT
N
RECALC_REPLENISHMENT
N
MAX_ORDER_EXPIRY_DAYS
3
OVERRIDE_MANL_COST_SRC
N

default

ROW_SEQR
5
CHUNK_IDR
1000000005
PROCESS_IDRPK
1000000005
ACTION
Svc Svc Or
CREATE_ID
USER
APPLY_DEALS
Y
LAST_UPD_ID
USER
MAX_THREADS
5
CANCEL_ALLOC
S
OTB_OVERRIDE
Y
APPLY_SCALING
Y
APPLY_BRACKETS
Y
MAX_CHUNK_SIZE
5
PROCESS$STATUS
N
CREATE_DATETIME
2026-01-05
MAX_ORDER_NO_QTY
5
LAST_UPD_DATETIME
2026-01-05
WAIT_BTWN_THREADS
5
SKIP_OPEN_SHIPMENT
Y
RECALC_REPLENISHMENT
Y
MAX_ORDER_EXPIRY_DAYS
5
OVERRIDE_MANL_COST_SRC
Y

Rule Validation Summary

Source Rule Count
50
Governed Rule Count
24