Open Transfer Orders

In Scope

Technical: InventTransferTable | ID: D365FO-INV-INVENTTRANSFERTABLE-OPEN_TRANSFER_ORDERS

See how this object fits into Inventory Warehouse

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: High
Sequencing: Stage 3 - Open Transactions
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: InventTransferTable

This object has high complexity or dependency level

Review sequencing requirements before loading

Field Definitions(5)

Rules & Considerations(40)

constraint

validation

Sample Load Data(4)

_scenario	TOSITEIDR	FROMSITEIDR	TOWAREHOUSEIDR	FROMWAREHOUSEIDR	ToSiteId	DataAreaId	FromSiteId	TransferType	ToWarehouseId	CREATEDDATETIME	CreatedDateTime	FromWarehouseId	RequestedShipDate	TransferOrderNumber	TransferOrderStatus	RequestedReceiptDate	TransferOrderDescription	DefaultDimensionDisplayValue	WorkerResponsiblePersonnelNumber	ShipmentDate	ExternalReference	ShippingCarrierId	ShippingCarrierServiceId	ReasonCode	IntercompanyCompanyId	IntercompanyTransferOrder
Example values from field definitions	USMF	USMF	WH02	WH01	USMF	USMF	USMF	TransferOrder	WH02	2023-10-30T09:00:00Z	2023-10-30T09:00:00Z	WH01	2023-11-01	TO-001001	Created	2023-11-03	Inter-warehouse replenishment	Department-022:CostCenter-007	000001	—	—	—	—	—	—	—
Open Transfer - Shipped Status (In Transit)	—	—	—	—	USRT	USMF	USMF	TransferOrder	RTWH	—	2023-10-20T14:15:00Z	WH01	2023-10-25	TO-001002	Shipped	2023-11-05	Items in transit to store	—	—	2023-10-26	FEDEX-TRK-98765	FEDEX	GROUND	—	—	—
Intercompany Transfer - Created Status	—	—	—	—	USPI	USMF	USMF	TransferOrder	MFWH	—	2023-11-01T11:00:00Z	WH03	2023-11-10	TO-001003	Created	2023-11-15	IC transfer to manufacturing plant	—	—	—	—	—	—	ICPRODUCTION	USPI	Yes

Example values from field definitions

TOSITEIDR: USMF
FROMSITEIDR: USMF
TOWAREHOUSEIDR: WH02
FROMWAREHOUSEIDR: WH01
ToSiteId: USMF
DataAreaId: USMF
FromSiteId: USMF
TransferType: TransferOrder
ToWarehouseId: WH02
CREATEDDATETIME: 2023-10-30T09:00:00Z
CreatedDateTime: 2023-10-30T09:00:00Z
FromWarehouseId: WH01
RequestedShipDate: 2023-11-01
TransferOrderNumber: TO-001001
TransferOrderStatus: Created
RequestedReceiptDate: 2023-11-03
TransferOrderDescription: Inter-warehouse replenishment
DefaultDimensionDisplayValue: Department-022:CostCenter-007
WorkerResponsiblePersonnelNumber: 000001
ShipmentDate: —
ExternalReference: —
ShippingCarrierId: —
ShippingCarrierServiceId: —
ReasonCode: —
IntercompanyCompanyId: —
IntercompanyTransferOrder: —

Open Transfer - Shipped Status (In Transit)

TOSITEIDR: —
FROMSITEIDR: —
TOWAREHOUSEIDR: —
FROMWAREHOUSEIDR: —
ToSiteId: USRT
DataAreaId: USMF
FromSiteId: USMF
TransferType: TransferOrder
ToWarehouseId: RTWH
CREATEDDATETIME: —
CreatedDateTime: 2023-10-20T14:15:00Z
FromWarehouseId: WH01
RequestedShipDate: 2023-10-25
TransferOrderNumber: TO-001002
TransferOrderStatus: Shipped
RequestedReceiptDate: 2023-11-05
TransferOrderDescription: Items in transit to store
DefaultDimensionDisplayValue: —
WorkerResponsiblePersonnelNumber: —
ShipmentDate: 2023-10-26
ExternalReference: FEDEX-TRK-98765
ShippingCarrierId: FEDEX
ShippingCarrierServiceId: GROUND
ReasonCode: —
IntercompanyCompanyId: —
IntercompanyTransferOrder: —

Intercompany Transfer - Created Status

TOSITEIDR: —
FROMSITEIDR: —
TOWAREHOUSEIDR: —
FROMWAREHOUSEIDR: —
ToSiteId: USPI
DataAreaId: USMF
FromSiteId: USMF
TransferType: TransferOrder
ToWarehouseId: MFWH
CREATEDDATETIME: —
CreatedDateTime: 2023-11-01T11:00:00Z
FromWarehouseId: WH03
RequestedShipDate: 2023-11-10
TransferOrderNumber: TO-001003
TransferOrderStatus: Created
RequestedReceiptDate: 2023-11-15
TransferOrderDescription: IC transfer to manufacturing plant
DefaultDimensionDisplayValue: —
WorkerResponsiblePersonnelNumber: —
ShipmentDate: —
ExternalReference: —
ShippingCarrierId: —
ShippingCarrierServiceId: —
ReasonCode: ICPRODUCTION
IntercompanyCompanyId: USPI
IntercompanyTransferOrder: Yes

Rule Validation Summary

Source Rule Count: 40
Governed Rule Count: 40