Shipment

In Scope

Technical: SHIPMENT | ID: OR-MFCS-SHIPMENT

Stores one row for each shipment within the system. Base information about each shipment for each order is held in this table for as long as its associated order header…

See how this object fits into Inventory Management

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

Field Definitions(29)

Rules & Considerations(84)

Sample Load Data(4)

_scenario	TO_LOCR	ORDER_NOPK	SHIPMENTRPK	CREATE_IDR	SHIP_DATER	SHIP_ORIGINR	STATUS_CODER	TO_LOC_TYPER	LAST_UPDATE_IDR	CREATE_DATETIMER	PARENT_SHIPMENTPK	LAST_UPDATE_DATETIMER	ASN	BOL_NO	COURIER	COMMENTS	FROM_LOC	NO_BOXES	REF_DOC_NO	BILL_TO_LOC	EST_ARR_DATE	RECEIVE_DATE	EXCHANGE_RATE	EXT_REF_NO_IN	FROM_LOC_TYPE	EXT_REF_NO_OUT	INVC_MATCH_DATE	BILL_TO_LOC_TYPE	INVC_MATCH_STATUS
default	1	2	1	USERENV	2026-01-01	0	R	Shipment-001	USERENV	2026-01-01	1	2026-01-01	Shipment-001	Shipment-001	Shipment-001	Shipment-001	1	000001	Shipment-001	1	2026-01-01	2026-01-01	11.0000	Shipment-001	Shipment-001	Shipment-001	2026-01-01	Shipment-001	U

default

TO_LOCR: 1
ORDER_NOPK: 2
SHIPMENTRPK: 1
CREATE_IDR: USERENV
SHIP_DATER: 2026-01-01
SHIP_ORIGINR: 0
STATUS_CODER: R
TO_LOC_TYPER: Shipment-001
LAST_UPDATE_IDR: USERENV
CREATE_DATETIMER: 2026-01-01
PARENT_SHIPMENTPK: 1
LAST_UPDATE_DATETIMER: 2026-01-01
ASN: Shipment-001
BOL_NO: Shipment-001
COURIER: Shipment-001
COMMENTS: Shipment-001
FROM_LOC: 1
NO_BOXES: 000001
REF_DOC_NO: Shipment-001
BILL_TO_LOC: 1
EST_ARR_DATE: 2026-01-01
RECEIVE_DATE: 2026-01-01
EXCHANGE_RATE: 11.0000
EXT_REF_NO_IN: Shipment-001
FROM_LOC_TYPE: Shipment-001
EXT_REF_NO_OUT: Shipment-001
INVC_MATCH_DATE: 2026-01-01
BILL_TO_LOC_TYPE: Shipment-001
INVC_MATCH_STATUS: U

All objects