Svc Fulfilordcust

In Scope

Technical: SVC_FULFILORDCUST | ID: OR-MFCS-SVC_FULFILORDCUST

This is an interface staging table that holds customer 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

Target Structure

Load Approach: Table
Target Objects: SVC_FULFILORDCUST

Field Definitions(43)

Rules & Considerations(11)

Sample Load Data(4)

_scenario	CHUNK_IDR	CREATE_IDR	PROCESS_IDR	FULFILORD_IDRPK	LAST_UPDATE_IDR	CREATE_DATETIMER	LAST_UPDATE_DATETIMER	BILL_ADD1	BILL_ADD2	BILL_ADD3	BILL_CITY	BILL_POST	ERROR_MSG	BILL_EMAIL	BILL_PHONE	BILL_STATE	BILL_COUNTY	CUSTOMER_NO	DELIVER_ADD1	DELIVER_ADD2	DELIVER_ADD3	DELIVER_CITY	DELIVER_POST	DELIVER_EMAIL	DELIVER_PHONE	DELIVER_STATE	BILL_LAST_NAME	DELIVER_COUNTY	BILL_COUNTRY_ID	BILL_FIRST_NAME	BILL_COMPANY_NAME	BILL_JURISDICTION	DELIVER_LAST_NAME	BILL_PHONETIC_LAST	DELIVER_COUNTRY_ID	DELIVER_FIRST_NAME	BILL_PHONETIC_FIRST	BILL_PREFERRED_NAME	DELIVER_COMPANY_NAME	DELIVER_JURISDICTION	DELIVER_PHONETIC_LAST	DELIVER_PHONETIC_FIRST	DELIVER_PREFERRED_NAME
default	1000000001	MIG_USER	1000000001	1000000001	MIG_USER	2026-01-01	2026-01-01	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust Primary	Svc Fulfilordcust-001	STD-SVC_FULFIL-001	Svc Fulfilordcust Primary	Svc Fulfilordcust Primary	Svc Fulfilordcust-001	Svc Fulfilordcust Primary	Svc Fulfilordcust-001	STD-SVC_FULFIL-001	Svc Fulfilordcust Primary	Svc Fulfilordcust-001	Svc Fulfilordcust Primary	Svc Fulfilordcust Primary	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust-001	Svc Fulfilordcust Primary

default

CHUNK_IDR: 1000000001
CREATE_IDR: MIG_USER
PROCESS_IDR: 1000000001
FULFILORD_IDRPK: 1000000001
LAST_UPDATE_IDR: MIG_USER
CREATE_DATETIMER: 2026-01-01
LAST_UPDATE_DATETIMER: 2026-01-01
BILL_ADD1: Svc Fulfilordcust-001
BILL_ADD2: Svc Fulfilordcust-001
BILL_ADD3: Svc Fulfilordcust-001
BILL_CITY: Svc Fulfilordcust-001
BILL_POST: Svc Fulfilordcust-001
ERROR_MSG: Svc Fulfilordcust-001
BILL_EMAIL: Svc Fulfilordcust-001
BILL_PHONE: Svc Fulfilordcust-001
BILL_STATE: Svc Fulfilordcust-001
BILL_COUNTY: Svc Fulfilordcust-001
CUSTOMER_NO: Svc Fulfilordcust-001
DELIVER_ADD1: Svc Fulfilordcust-001
DELIVER_ADD2: Svc Fulfilordcust-001
DELIVER_ADD3: Svc Fulfilordcust-001
DELIVER_CITY: Svc Fulfilordcust-001
DELIVER_POST: Svc Fulfilordcust-001
DELIVER_EMAIL: Svc Fulfilordcust-001
DELIVER_PHONE: Svc Fulfilordcust-001
DELIVER_STATE: Svc Fulfilordcust-001
BILL_LAST_NAME: Svc Fulfilordcust Primary
DELIVER_COUNTY: Svc Fulfilordcust-001
BILL_COUNTRY_ID: STD-SVC_FULFIL-001
BILL_FIRST_NAME: Svc Fulfilordcust Primary
BILL_COMPANY_NAME: Svc Fulfilordcust Primary
BILL_JURISDICTION: Svc Fulfilordcust-001
DELIVER_LAST_NAME: Svc Fulfilordcust Primary
BILL_PHONETIC_LAST: Svc Fulfilordcust-001
DELIVER_COUNTRY_ID: STD-SVC_FULFIL-001
DELIVER_FIRST_NAME: Svc Fulfilordcust Primary
BILL_PHONETIC_FIRST: Svc Fulfilordcust-001
BILL_PREFERRED_NAME: Svc Fulfilordcust Primary
DELIVER_COMPANY_NAME: Svc Fulfilordcust Primary
DELIVER_JURISDICTION: Svc Fulfilordcust-001
DELIVER_PHONETIC_LAST: Svc Fulfilordcust-001
DELIVER_PHONETIC_FIRST: Svc Fulfilordcust-001
DELIVER_PREFERRED_NAME: Svc Fulfilordcust Primary

All objects