Skip to main content

Warehouse Transfers

Written by Nick Maxwell

Data Dictionary

Internal movements of stock between your own warehouses — e.g., transferring goods from a central warehouse to a regional distribution center.Useful for understanding inventory distribution across locations, tracking transfer lead times, and ensuring each warehouse has adequate stock levels — e.g., identifying which transfers took longer than expected or how much product is currently in transit.

Field

Type

Notes

Available Quantity

Number

API: Transfer Detail.AvailableQuantity

Average Landed Price At Time Of Transfer

Number

API: Transfer Detail.AverageLandedPriceAtTimeOfTransfer

Comment

Text

API: Warehouse Stock Transfer.Comments

Connection ID

Integer

The Connectorly Connection ID. If you group Connectorly's together, then you will see a Connection ID for each one. Organisations has the corresponding Connection Name for each Connection ID.

Created

Datetime

Derived from datetime with timezone conversion of Created

Created By

Text

API: Transfer Detail.CreatedBy

Data current as of

Datetime

Gives the date and time that this record was taken from Unleashed.

Delivery Date

Datetime

Derived from datetime with timezone conversion of Delivery Date

Destination Warehouse GUID

Text

API: Destination Warehouse Stub.Guid

Destination Warehouse Name

Text

API: Destination Warehouse Stub.WarehouseName

Destination Warehouse Stock On Hand Before Transfer

Number

API: Transfer Detail.DestinateWarehouseStockOnHandBeforeTransfer

Line Number

Integer

API: Transfer Detail.LineNumber

Order Date

Date

Derived from date conversion of Order Date

Product Code

Text

API: Transfer Detail.WarehouseProductCode

Product Description

Text

Derived from cleaning Product Description

Product GUID

Text

The Unique ID of a Product, API: Product.Guid

Receipt FIFO Date

Date

Receipt Fifo Date, Derived from date conversion of Receipt FIFO Date

Source Warehouse GUID

Text

API: Source Warehouse Stub.Guid

Source Warehouse Name

Text

API: Source Warehouse Stub.WarehouseName

Source Warehouse Stock On Hand Before Transfer

Number

API: Transfer Detail.SourceWarehouseStockOnHandBeforeTransfer

Transfer Detail Comment

Text

API: Transfer Detail.Comments

Transfer Detail GUID

Text

API: Transfer Detail.Guid

Transfer Order Number

Text

API: Warehouse Stock Transfer.TransferOrderNumber

Transfer Quantity

Number

API: Transfer Detail.TransferQuantity

Transfer Status

Text

API: Warehouse Stock Transfer.TransferStatus

Updated

Datetime

Derived from datetime with timezone conversion of Updated

Updated By

Text

API: Transfer Detail.LastModifiedBy

Warehouse Stock Transfer GUID

Text

API: Warehouse Stock Transfer.Guid

Did this answer your question?