Ordcust

In Scope

Technical: ORDCUST | ID: OR-MFCS-ORDCUST

Stores the customer order information associated to with a Customer Order fulfilled through a purchase order or a transfer or inventory reservation at a store.

See how this object fits into Purchasing

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: ORDCUST

Field Definitions(57)

Rules & Considerations(135)

Sample Load Data(4)

_scenario	STATUSR	TSF_NOPK	ORDER_NOPK	CREATE_IDR	ORDCUST_NORPK	LAST_UPDATE_IDR	CREATE_DATETIMER	FULFILL_ORDER_NOR	CUSTOMER_ORDER_NOR	LAST_UPDATE_DATETIMER	PARTIAL_DELIVERY_INDR	COMMENTS	BILL_ADD1	BILL_ADD2	BILL_ADD3	BILL_CITY	BILL_POST	BILL_PHONE	BILL_STATE	BILL_COUNTY	CUSTOMER_NO	CARRIER_CODE	DELIVER_ADD1	DELIVER_ADD2	DELIVER_ADD3	DELIVER_CITY	DELIVER_POST	DELIVERY_TYPE	DELIVER_PHONE	DELIVER_STATE	SOURCE_LOC_ID	BILL_LAST_NAME	DELIVER_CHARGE	DELIVER_COUNTY	FULFILL_LOC_ID	BILL_COUNTRY_ID	BILL_FIRST_NAME	SOURCE_LOC_TYPE	FULFILL_LOC_TYPE	BILL_COMPANY_NAME	BILL_JURISDICTION	DELIVER_LAST_NAME	BILL_PHONETIC_LAST	DELIVER_COUNTRY_ID	DELIVER_FIRST_NAME	ORDER_PLACED_STORE	BILL_PHONETIC_FIRST	BILL_PREFERRED_NAME	DELIVER_CHARGE_CURR	CARRIER_SERVICE_CODE	DELIVER_COMPANY_NAME	DELIVER_JURISDICTION	DELIVER_PHONETIC_LAST	CONSUMER_DELIVERY_DATE	CONSUMER_DELIVERY_TIME	DELIVER_PHONETIC_FIRST	DELIVER_PREFERRED_NAME
default	C	2	2	MIG_USER	2	MIG_USER	2026-01-01	Ordcust-001	Ordcust-001	2026-01-01	Y	Ordcust-001	Ordcust-001	Ordcust-001	Ordcust-001	Ordcust-001	Ordcust-001	Ordcust-001	Ordcust-001	Ordcust-001	Ordcust-001	STD-ORDCUST-001	Ordcust-001	Ordcust-001	Ordcust-001	Ordcust-001	Ordcust-001	S	Ordcust-001	Ordcust-001	1000000001	Ordcust Primary	11.0000	Ordcust-001	1000000001	STD-ORDCUST-001	Ordcust Primary	multi	S	Ordcust Primary	Ordcust-001	Ordcust Primary	Ordcust-001	STD-ORDCUST-001	Ordcust Primary	1001	Ordcust-001	Ordcust Primary	Ordcust-001	codes	Ordcust Primary	Ordcust-001	Ordcust-001	2026-01-01	2026-01-06	Ordcust-001	Ordcust Primary

default

STATUSR: C
TSF_NOPK: 2
ORDER_NOPK: 2
CREATE_IDR: MIG_USER
ORDCUST_NORPK: 2
LAST_UPDATE_IDR: MIG_USER
CREATE_DATETIMER: 2026-01-01
FULFILL_ORDER_NOR: Ordcust-001
CUSTOMER_ORDER_NOR: Ordcust-001
LAST_UPDATE_DATETIMER: 2026-01-01
PARTIAL_DELIVERY_INDR: Y
COMMENTS: Ordcust-001
BILL_ADD1: Ordcust-001
BILL_ADD2: Ordcust-001
BILL_ADD3: Ordcust-001
BILL_CITY: Ordcust-001
BILL_POST: Ordcust-001
BILL_PHONE: Ordcust-001
BILL_STATE: Ordcust-001
BILL_COUNTY: Ordcust-001
CUSTOMER_NO: Ordcust-001
CARRIER_CODE: STD-ORDCUST-001
DELIVER_ADD1: Ordcust-001
DELIVER_ADD2: Ordcust-001
DELIVER_ADD3: Ordcust-001
DELIVER_CITY: Ordcust-001
DELIVER_POST: Ordcust-001
DELIVERY_TYPE: S
DELIVER_PHONE: Ordcust-001
DELIVER_STATE: Ordcust-001
SOURCE_LOC_ID: 1000000001
BILL_LAST_NAME: Ordcust Primary
DELIVER_CHARGE: 11.0000
DELIVER_COUNTY: Ordcust-001
FULFILL_LOC_ID: 1000000001
BILL_COUNTRY_ID: STD-ORDCUST-001
BILL_FIRST_NAME: Ordcust Primary
SOURCE_LOC_TYPE: multi
FULFILL_LOC_TYPE: S
BILL_COMPANY_NAME: Ordcust Primary
BILL_JURISDICTION: Ordcust-001
DELIVER_LAST_NAME: Ordcust Primary
BILL_PHONETIC_LAST: Ordcust-001
DELIVER_COUNTRY_ID: STD-ORDCUST-001
DELIVER_FIRST_NAME: Ordcust Primary
ORDER_PLACED_STORE: 1001
BILL_PHONETIC_FIRST: Ordcust-001
BILL_PREFERRED_NAME: Ordcust Primary
DELIVER_CHARGE_CURR: Ordcust-001
CARRIER_SERVICE_CODE: codes
DELIVER_COMPANY_NAME: Ordcust Primary
DELIVER_JURISDICTION: Ordcust-001
DELIVER_PHONETIC_LAST: Ordcust-001
CONSUMER_DELIVERY_DATE: 2026-01-01
CONSUMER_DELIVERY_TIME: 2026-01-06
DELIVER_PHONETIC_FIRST: Ordcust-001
DELIVER_PREFERRED_NAME: Ordcust Primary

All objects