Ful Ord

In Scope

Technical: FUL_ORD | ID: OR-SIOCS-FUL_ORD

Stores store fulfillment orders.

See how this object fits into Store Operations

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

Field Definitions(27)

Rules & Considerations(78)

Sample Load Data(4)

_scenario	IDRPK	STATUSR	STORE_IDRPK	FLOW_TYPER	ORDER_TYPER	CREATE_DATER	UPDATE_DATER	UNDER_REVIEWR	CUST_ORDER_IDR	DELIVERY_TYPER	SHIP_CARRIER_IDPK	INTEGRATION_TYPER	ALLOW_PARTIAL_DELIVERYR	SHIP_CARRIER_SERVICE_IDPK	COMMENTS	CUSTOMER_ID	EXTERNAL_ID	RELEASE_DATE	DELIVERY_DATE	HOLD_LOCATION	CUST_ORDER_DATE	SHIP_COST_VALUE	CUST_ARRIVE_DATE	SHIP_COST_CURRENCY	DELIVERY_COMMENTS_1	DELIVERY_COMMENTS_2	DELIVERY_COMMENTS_3
default	1	1	1000000001	1	1	2026-01-01	2026-01-01	N	STD-FUL_ORD-001	1	1000000001	0001	Ful Ord-001	1000000001	Ful Ord-001	STD-FUL_ORD-001	STD-FUL_ORD-001	2026-01-01	2026-01-01	Ful Ord-001	2026-01-01	11.0000	2026-01-01	Ful Ord-001	Ful Ord-001	Ful Ord-001	Ful Ord-001

default

IDRPK: 1
STATUSR: 1
STORE_IDRPK: 1000000001
FLOW_TYPER: 1
ORDER_TYPER: 1
CREATE_DATER: 2026-01-01
UPDATE_DATER: 2026-01-01
UNDER_REVIEWR: N
CUST_ORDER_IDR: STD-FUL_ORD-001
DELIVERY_TYPER: 1
SHIP_CARRIER_IDPK: 1000000001
INTEGRATION_TYPER: 0001
ALLOW_PARTIAL_DELIVERYR: Ful Ord-001
SHIP_CARRIER_SERVICE_IDPK: 1000000001
COMMENTS: Ful Ord-001
CUSTOMER_ID: STD-FUL_ORD-001
EXTERNAL_ID: STD-FUL_ORD-001
RELEASE_DATE: 2026-01-01
DELIVERY_DATE: 2026-01-01
HOLD_LOCATION: Ful Ord-001
CUST_ORDER_DATE: 2026-01-01
SHIP_COST_VALUE: 11.0000
CUST_ARRIVE_DATE: 2026-01-01
SHIP_COST_CURRENCY: Ful Ord-001
DELIVERY_COMMENTS_1: Ful Ord-001
DELIVERY_COMMENTS_2: Ful Ord-001
DELIVERY_COMMENTS_3: Ful Ord-001