Fulfilord (Service Layer)

In Scope

Technical: SVC_FULFILORD | ID: OR-FND-SVC_FULFILORD-FULFILORD_SERVICE_LAYER

This is an interface staging table that holds header level information related to a customer order fulfillment 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_FULFILORD

Field Definitions(5)

Rules & Considerations(38)

validation

constraint

Sample Load Data(4)

_scenario	CHUNK_IDR	TRAN_TYPER	PROCESS_IDR	ACTION_TYPER	PROCESS_STATUSR	COMMENTS	CREATE_ID	ERROR_MSG	CARRIER_CODE	FULFILORD_ID	DELIVERY_TYPE	SOURCE_LOC_ID	FULFILL_LOC_ID	LAST_UPDATE_ID	CREATE_DATETIME	SOURCE_LOC_TYPE	DELIVERY_CHARGES	FULFILL_LOC_TYPE	FULFILL_ORDER_NO	CUSTOMER_ORDER_NO	ORDER_PLACED_STORE	CARRIER_SERVICE_CODE	LAST_UPDATE_DATETIME	PARTIAL_DELIVERY_IND	DELIVERY_CHARGES_CURR	CONSUMER_DELIVERY_DATE	CONSUMER_DELIVERY_TIME
Example values from field definitions	1	S	1	SAMPLE	S	SAMPLE	SAMPLE	SAMPLE	SAMP	1	S	1	1	SAMPLE	2026-01-01	SA	1.0000	S	SAMPLE	SAMPLE	1	SAMPLE	2026-01-01	S	SAM	2026-01-01	2026-01-01
default	1000000003	S	1000000003	Svc Fulfil	s	Svc Fulfilord-002-ALT	MDM_USER	Svc Fulfilord-002-ALT	ALT-	1000000003	S	1000000003	1000000003	MDM_USER	2026-01-03	po	12.5000	S	Svc Fulfilord-002-ALT	Svc Fulfilord-002-ALT	1003	ALT-SV	2026-01-03	S	Svc	2026-01-03	2026-02-09
default	1000000005	S	1000000005	Svc Fulfil	s	Svc Fulfilord-003-EDGE	BATCH_USER	Svc Fulfilord-003-EDGE	EDGE	1000000005	S	1000000005	1000000005	BATCH_USER	2026-01-05	mu	14.0000	S	Svc Fulfilord-003-EDGE	Svc Fulfilord-003-EDGE	1005	EDGE-S	2026-01-05	S	Svc	2026-01-05	2026-03-12

Example values from field definitions

CHUNK_IDR: 1
TRAN_TYPER: S
PROCESS_IDR: 1
ACTION_TYPER: SAMPLE
PROCESS_STATUSR: S
COMMENTS: SAMPLE
CREATE_ID: SAMPLE
ERROR_MSG: SAMPLE
CARRIER_CODE: SAMP
FULFILORD_ID: 1
DELIVERY_TYPE: S
SOURCE_LOC_ID: 1
FULFILL_LOC_ID: 1
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
SOURCE_LOC_TYPE: SA
DELIVERY_CHARGES: 1.0000
FULFILL_LOC_TYPE: S
FULFILL_ORDER_NO: SAMPLE
CUSTOMER_ORDER_NO: SAMPLE
ORDER_PLACED_STORE: 1
CARRIER_SERVICE_CODE: SAMPLE
LAST_UPDATE_DATETIME: 2026-01-01
PARTIAL_DELIVERY_IND: S
DELIVERY_CHARGES_CURR: SAM
CONSUMER_DELIVERY_DATE: 2026-01-01
CONSUMER_DELIVERY_TIME: 2026-01-01

default

CHUNK_IDR: 1000000003
TRAN_TYPER: S
PROCESS_IDR: 1000000003
ACTION_TYPER: Svc Fulfil
PROCESS_STATUSR: s
COMMENTS: Svc Fulfilord-002-ALT
CREATE_ID: MDM_USER
ERROR_MSG: Svc Fulfilord-002-ALT
CARRIER_CODE: ALT-
FULFILORD_ID: 1000000003
DELIVERY_TYPE: S
SOURCE_LOC_ID: 1000000003
FULFILL_LOC_ID: 1000000003
LAST_UPDATE_ID: MDM_USER
CREATE_DATETIME: 2026-01-03
SOURCE_LOC_TYPE: po
DELIVERY_CHARGES: 12.5000
FULFILL_LOC_TYPE: S
FULFILL_ORDER_NO: Svc Fulfilord-002-ALT
CUSTOMER_ORDER_NO: Svc Fulfilord-002-ALT
ORDER_PLACED_STORE: 1003
CARRIER_SERVICE_CODE: ALT-SV
LAST_UPDATE_DATETIME: 2026-01-03
PARTIAL_DELIVERY_IND: S
DELIVERY_CHARGES_CURR: Svc
CONSUMER_DELIVERY_DATE: 2026-01-03
CONSUMER_DELIVERY_TIME: 2026-02-09