Fulfilordref (Service Layer)

In Scope

Technical: SVC_FULFILORDREF | ID: OR-FND-SVC_FULFILORDREF-FULFILORDREF_SERVICE_LAYER

This is an interface staging table that holds header level information related to a customer order fulfillment cancellation request from an external order management system (OMS) to RMS.

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_FULFILORDREF

Field Definitions(5)

Rules & Considerations(29)

validation

constraint

Sample Load Data(4)

_scenario	CHUNK_IDR	TRAN_TYPER	PROCESS_IDR	ACTION_TYPER	PROCESS_STATUSR	CREATE_ID	ERROR_MSG	SOURCE_LOC_ID	FULFILL_LOC_ID	LAST_UPDATE_ID	CREATE_DATETIME	FULFILORDREF_ID	SOURCE_LOC_TYPE	FULFILL_LOC_TYPE	FULFILL_ORDER_NO	CUSTOMER_ORDER_NO	LAST_UPDATE_DATETIME
Example values from field definitions	1	S	1	SAMPLE	S	SAMPLE	SAMPLE	1	1	SAMPLE	2026-01-01	1	SA	S	SAMPLE	SAMPLE	2026-01-01
default	1000000003	S	1000000003	Svc Fulfil	P	MDM_USER	Svc Fulfilordref-002-ALT	1000000003	1000000003	MDM_USER	2026-01-03	1000000003	po	S	Svc Fulfilordref-002-ALT	Svc Fulfilordref-002-ALT	2026-01-03
default	1000000005	S	1000000005	Svc Fulfil	A	BATCH_USER	Svc Fulfilordref-003-EDGE	1000000005	1000000005	BATCH_USER	2026-01-05	1000000005	mu	S	Svc Fulfilordref-003-EDGE	Svc Fulfilordref-003-EDGE	2026-01-05

Example values from field definitions

CHUNK_IDR: 1
TRAN_TYPER: S
PROCESS_IDR: 1
ACTION_TYPER: SAMPLE
PROCESS_STATUSR: S
CREATE_ID: SAMPLE
ERROR_MSG: SAMPLE
SOURCE_LOC_ID: 1
FULFILL_LOC_ID: 1
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
FULFILORDREF_ID: 1
SOURCE_LOC_TYPE: SA
FULFILL_LOC_TYPE: S
FULFILL_ORDER_NO: SAMPLE
CUSTOMER_ORDER_NO: SAMPLE
LAST_UPDATE_DATETIME: 2026-01-01

default

CHUNK_IDR: 1000000003
TRAN_TYPER: S
PROCESS_IDR: 1000000003
ACTION_TYPER: Svc Fulfil
PROCESS_STATUSR: P
CREATE_ID: MDM_USER
ERROR_MSG: Svc Fulfilordref-002-ALT
SOURCE_LOC_ID: 1000000003
FULFILL_LOC_ID: 1000000003
LAST_UPDATE_ID: MDM_USER
CREATE_DATETIME: 2026-01-03
FULFILORDREF_ID: 1000000003
SOURCE_LOC_TYPE: po
FULFILL_LOC_TYPE: S
FULFILL_ORDER_NO: Svc Fulfilordref-002-ALT
CUSTOMER_ORDER_NO: Svc Fulfilordref-002-ALT
LAST_UPDATE_DATETIME: 2026-01-03