Ordcust

In Scope

Technical: ORDCUST | ID: OR-PUR-ORDCUST-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

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: ORDCUST

Field Definitions(5)

Rules & Considerations(71)

Sample Load Data(4)

_scenario	STATUSR	ORDCUST_NORPK	TSF_NO	COMMENTS	ORDER_NO	BILL_ADD1	BILL_ADD2	BILL_ADD3	BILL_CITY	BILL_POST	CREATE_ID	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	LAST_UPDATE_ID	BILL_COUNTRY_ID	BILL_FIRST_NAME	CREATE_DATETIME	SOURCE_LOC_TYPE	FULFILL_LOC_TYPE	FULFILL_ORDER_NO	BILL_COMPANY_NAME	BILL_JURISDICTION	CUSTOMER_ORDER_NO	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	LAST_UPDATE_DATETIME	PARTIAL_DELIVERY_IND	DELIVER_PHONETIC_LAST	CONSUMER_DELIVERY_DATE	CONSUMER_DELIVERY_TIME	DELIVER_PHONETIC_FIRST	DELIVER_PREFERRED_NAME
Example values from field definitions	S	1	1	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAM	SAMPLE	SAMPLE	SAMP	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	SAM	1	SAMPLE	1.0000	SAMPLE	1	SAMPLE	SAM	SAMPLE	2026-01-01	SA	S	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAM	SAMPLE	1	SAMPLE	SAMPLE	SAM	SAMPLE	SAMPLE	SAMPLE	2026-01-01	S	SAMPLE	2026-01-01	2026-01-01	SAMPLE	SAMPLE
default	P	4	4	Ordcust-002-ALT	4	Ordcust-002-ALT	Ordcust-002-ALT	Ordcust-002-ALT	Ordcust-002-ALT	Ordcust-002-ALT	MDM_USER	Ordcust-002-ALT	Ord	Ordcust-002-ALT	Ordcust-002-AL	ALT-	Ordcust-002-ALT	Ordcust-002-ALT	Ordcust-002-ALT	Ordcust-002-ALT	Ordcust-002-ALT	S	Ordcust-002-ALT	Ord	1000000003	Ordcust Secondary	12.5000	Ordcust-002-ALT	1000000003	MDM_USER	ALT	Ordcust Secondary	2026-01-03	SU	S	Ordcust-002-ALT	Ordcust Secondary	Ordcust-00	Ordcust-002-ALT	Ordcust Secondary	Ordcust-002-ALT	ALT	Ordcust Secondary	1003	Ordcust-002-ALT	Ordcust Secondary	Ord	codes	Ordcust Secondary	Ordcust-00	2026-01-03	N	Ordcust-002-ALT	2026-01-03	2026-02-09	Ordcust-002-ALT	Ordcust Secondary
default	C	6	6	Ordcust-003-EDGE	6	Ordcust-003-EDGE	Ordcust-003-EDGE	Ordcust-003-EDGE	Ordcust-003-EDGE	Ordcust-003-EDGE	BATCH_USER	Ordcust-003-EDGE	Ord	Ordcust-003-EDGE	Ordcust-003-ED	EDGE	Ordcust-003-EDGE	Ordcust-003-EDGE	Ordcust-003-EDGE	Ordcust-003-EDGE	Ordcust-003-EDGE	S	Ordcust-003-EDGE	Ord	1000000005	Ordcust Core	14.0000	Ordcust-003-EDGE	1000000005	BATCH_USER	EDG	Ordcust Core	2026-01-05	ST	S	Ordcust-003-EDGE	Ordcust Core	Ordcust-00	Ordcust-003-EDGE	Ordcust Core	Ordcust-003-EDGE	EDG	Ordcust Core	1005	Ordcust-003-EDGE	Ordcust Core	Ord	codes	Ordcust Core	Ordcust-00	2026-01-05	Y	Ordcust-003-EDGE	2026-01-05	2026-03-12	Ordcust-003-EDGE	Ordcust Core

Example values from field definitions

STATUSR: S
ORDCUST_NORPK: 1
TSF_NO: 1
COMMENTS: SAMPLE
ORDER_NO: 1
BILL_ADD1: SAMPLE
BILL_ADD2: SAMPLE
BILL_ADD3: SAMPLE
BILL_CITY: SAMPLE
BILL_POST: SAMPLE
CREATE_ID: SAMPLE
BILL_PHONE: SAMPLE
BILL_STATE: SAM
BILL_COUNTY: SAMPLE
CUSTOMER_NO: SAMPLE
CARRIER_CODE: SAMP
DELIVER_ADD1: SAMPLE
DELIVER_ADD2: SAMPLE
DELIVER_ADD3: SAMPLE
DELIVER_CITY: SAMPLE
DELIVER_POST: SAMPLE
DELIVERY_TYPE: S
DELIVER_PHONE: SAMPLE
DELIVER_STATE: SAM
SOURCE_LOC_ID: 1
BILL_LAST_NAME: SAMPLE
DELIVER_CHARGE: 1.0000
DELIVER_COUNTY: SAMPLE
FULFILL_LOC_ID: 1
LAST_UPDATE_ID: SAMPLE
BILL_COUNTRY_ID: SAM
BILL_FIRST_NAME: SAMPLE
CREATE_DATETIME: 2026-01-01
SOURCE_LOC_TYPE: SA
FULFILL_LOC_TYPE: S
FULFILL_ORDER_NO: SAMPLE
BILL_COMPANY_NAME: SAMPLE
BILL_JURISDICTION: SAMPLE
CUSTOMER_ORDER_NO: SAMPLE
DELIVER_LAST_NAME: SAMPLE
BILL_PHONETIC_LAST: SAMPLE
DELIVER_COUNTRY_ID: SAM
DELIVER_FIRST_NAME: SAMPLE
ORDER_PLACED_STORE: 1
BILL_PHONETIC_FIRST: SAMPLE
BILL_PREFERRED_NAME: SAMPLE
DELIVER_CHARGE_CURR: SAM
CARRIER_SERVICE_CODE: SAMPLE
DELIVER_COMPANY_NAME: SAMPLE
DELIVER_JURISDICTION: SAMPLE
LAST_UPDATE_DATETIME: 2026-01-01
PARTIAL_DELIVERY_IND: S
DELIVER_PHONETIC_LAST: SAMPLE
CONSUMER_DELIVERY_DATE: 2026-01-01
CONSUMER_DELIVERY_TIME: 2026-01-01
DELIVER_PHONETIC_FIRST: SAMPLE
DELIVER_PREFERRED_NAME: SAMPLE

default

STATUSR: P
ORDCUST_NORPK: 4
TSF_NO: 4
COMMENTS: Ordcust-002-ALT
ORDER_NO: 4
BILL_ADD1: Ordcust-002-ALT
BILL_ADD2: Ordcust-002-ALT
BILL_ADD3: Ordcust-002-ALT
BILL_CITY: Ordcust-002-ALT
BILL_POST: Ordcust-002-ALT
CREATE_ID: MDM_USER
BILL_PHONE: Ordcust-002-ALT
BILL_STATE: Ord
BILL_COUNTY: Ordcust-002-ALT
CUSTOMER_NO: Ordcust-002-AL
CARRIER_CODE: ALT-
DELIVER_ADD1: Ordcust-002-ALT
DELIVER_ADD2: Ordcust-002-ALT
DELIVER_ADD3: Ordcust-002-ALT
DELIVER_CITY: Ordcust-002-ALT
DELIVER_POST: Ordcust-002-ALT
DELIVERY_TYPE: S
DELIVER_PHONE: Ordcust-002-ALT
DELIVER_STATE: Ord
SOURCE_LOC_ID: 1000000003
BILL_LAST_NAME: Ordcust Secondary
DELIVER_CHARGE: 12.5000
DELIVER_COUNTY: Ordcust-002-ALT
FULFILL_LOC_ID: 1000000003
LAST_UPDATE_ID: MDM_USER
BILL_COUNTRY_ID: ALT
BILL_FIRST_NAME: Ordcust Secondary
CREATE_DATETIME: 2026-01-03
SOURCE_LOC_TYPE: SU
FULFILL_LOC_TYPE: S
FULFILL_ORDER_NO: Ordcust-002-ALT
BILL_COMPANY_NAME: Ordcust Secondary
BILL_JURISDICTION: Ordcust-00
CUSTOMER_ORDER_NO: Ordcust-002-ALT
DELIVER_LAST_NAME: Ordcust Secondary
BILL_PHONETIC_LAST: Ordcust-002-ALT
DELIVER_COUNTRY_ID: ALT
DELIVER_FIRST_NAME: Ordcust Secondary
ORDER_PLACED_STORE: 1003
BILL_PHONETIC_FIRST: Ordcust-002-ALT
BILL_PREFERRED_NAME: Ordcust Secondary
DELIVER_CHARGE_CURR: Ord
CARRIER_SERVICE_CODE: codes
DELIVER_COMPANY_NAME: Ordcust Secondary
DELIVER_JURISDICTION: Ordcust-00
LAST_UPDATE_DATETIME: 2026-01-03
PARTIAL_DELIVERY_IND: N
DELIVER_PHONETIC_LAST: Ordcust-002-ALT
CONSUMER_DELIVERY_DATE: 2026-01-03
CONSUMER_DELIVERY_TIME: 2026-02-09
DELIVER_PHONETIC_FIRST: Ordcust-002-ALT
DELIVER_PREFERRED_NAME: Ordcust Secondary

default

STATUSR: C
ORDCUST_NORPK: 6
TSF_NO: 6
COMMENTS: Ordcust-003-EDGE
ORDER_NO: 6
BILL_ADD1: Ordcust-003-EDGE
BILL_ADD2: Ordcust-003-EDGE
BILL_ADD3: Ordcust-003-EDGE
BILL_CITY: Ordcust-003-EDGE
BILL_POST: Ordcust-003-EDGE
CREATE_ID: BATCH_USER
BILL_PHONE: Ordcust-003-EDGE
BILL_STATE: Ord
BILL_COUNTY: Ordcust-003-EDGE
CUSTOMER_NO: Ordcust-003-ED
CARRIER_CODE: EDGE
DELIVER_ADD1: Ordcust-003-EDGE
DELIVER_ADD2: Ordcust-003-EDGE
DELIVER_ADD3: Ordcust-003-EDGE
DELIVER_CITY: Ordcust-003-EDGE
DELIVER_POST: Ordcust-003-EDGE
DELIVERY_TYPE: S
DELIVER_PHONE: Ordcust-003-EDGE
DELIVER_STATE: Ord
SOURCE_LOC_ID: 1000000005
BILL_LAST_NAME: Ordcust Core
DELIVER_CHARGE: 14.0000
DELIVER_COUNTY: Ordcust-003-EDGE
FULFILL_LOC_ID: 1000000005
LAST_UPDATE_ID: BATCH_USER
BILL_COUNTRY_ID: EDG
BILL_FIRST_NAME: Ordcust Core
CREATE_DATETIME: 2026-01-05
SOURCE_LOC_TYPE: ST
FULFILL_LOC_TYPE: S
FULFILL_ORDER_NO: Ordcust-003-EDGE
BILL_COMPANY_NAME: Ordcust Core
BILL_JURISDICTION: Ordcust-00
CUSTOMER_ORDER_NO: Ordcust-003-EDGE
DELIVER_LAST_NAME: Ordcust Core
BILL_PHONETIC_LAST: Ordcust-003-EDGE
DELIVER_COUNTRY_ID: EDG
DELIVER_FIRST_NAME: Ordcust Core
ORDER_PLACED_STORE: 1005
BILL_PHONETIC_FIRST: Ordcust-003-EDGE
BILL_PREFERRED_NAME: Ordcust Core
DELIVER_CHARGE_CURR: Ord
CARRIER_SERVICE_CODE: codes
DELIVER_COMPANY_NAME: Ordcust Core
DELIVER_JURISDICTION: Ordcust-00
LAST_UPDATE_DATETIME: 2026-01-05
PARTIAL_DELIVERY_IND: Y
DELIVER_PHONETIC_LAST: Ordcust-003-EDGE
CONSUMER_DELIVERY_DATE: 2026-01-05
CONSUMER_DELIVERY_TIME: 2026-03-12
DELIVER_PHONETIC_FIRST: Ordcust-003-EDGE
DELIVER_PREFERRED_NAME: Ordcust Core

Rule Validation Summary

Source Rule Count: 91
Governed Rule Count: 71

All objects