Windsor brings all your Linnworks data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

Linnworks Field Reference

Fields

ID	Type	Name	Description	Report
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
processed_order_details__customerinfo	OBJECT	processed_order_details.CustomerInfo	processed_order_details.CustomerInfo	processed_order_details
processed_order_details__extendedproperties	OBJECT	processed_order_details.ExtendedProperties	processed_order_details.ExtendedProperties	processed_order_details
processed_order_details__foldername	OBJECT	processed_order_details.FolderName	processed_order_details.FolderName	processed_order_details
processed_order_details__fulfilmentlocationid	TEXT	processed_order_details.FulfilmentLocationId	processed_order_details.FulfilmentLocationId	processed_order_details
processed_order_details__generalinfo	OBJECT	processed_order_details.GeneralInfo	processed_order_details.GeneralInfo	processed_order_details
processed_order_details__items	OBJECT	processed_order_details.Items	processed_order_details.Items	processed_order_details
processed_order_details__notes	OBJECT	processed_order_details.Notes	processed_order_details.Notes	processed_order_details
processed_order_details__numorderid	NUMERIC	processed_order_details.NumOrderId	processed_order_details.NumOrderId	processed_order_details
processed_order_details__orderid	TEXT	processed_order_details.OrderId	processed_order_details.OrderId	processed_order_details
processed_order_details__paiddatetime	DATE	processed_order_details.PaidDateTime	processed_order_details.PaidDateTime	processed_order_details
processed_order_details__processed	BOOLEAN	processed_order_details.Processed	processed_order_details.Processed	processed_order_details
processed_order_details__processeddatetime	DATE	processed_order_details.ProcessedDateTime	processed_order_details.ProcessedDateTime	processed_order_details
processed_order_details__shippinginfo	OBJECT	processed_order_details.ShippingInfo	processed_order_details.ShippingInfo	processed_order_details
processed_order_details__taxid	TEXT	processed_order_details.TaxId	processed_order_details.TaxId	processed_order_details
processed_order_details__totalsinfo	OBJECT	processed_order_details.TotalsInfo	processed_order_details.TotalsInfo	processed_order_details
processed_orders__accountname	TEXT	processed_orders.AccountName	processed_orders.AccountName	processed_orders
processed_orders__address1	TEXT	processed_orders.Address1	processed_orders.Address1	processed_orders
processed_orders__address2	TEXT	processed_orders.Address2	processed_orders.Address2	processed_orders
processed_orders__address3	TEXT	processed_orders.Address3	processed_orders.Address3	processed_orders
processed_orders__billingaddress1	TEXT	processed_orders.BillingAddress1	processed_orders.BillingAddress1	processed_orders
processed_orders__billingaddress2	TEXT	processed_orders.BillingAddress2	processed_orders.BillingAddress2	processed_orders
processed_orders__billingaddress3	TEXT	processed_orders.BillingAddress3	processed_orders.BillingAddress3	processed_orders
processed_orders__billingcompany	TEXT	processed_orders.BillingCompany	processed_orders.BillingCompany	processed_orders
processed_orders__billingcountryname	TEXT	processed_orders.BillingCountryName	processed_orders.BillingCountryName	processed_orders
processed_orders__billingemailaddress	TEXT	processed_orders.BillingEmailAddress	processed_orders.BillingEmailAddress	processed_orders
processed_orders__billingname	TEXT	processed_orders.BillingName	processed_orders.BillingName	processed_orders
processed_orders__billingphonenumber	TEXT	processed_orders.BillingPhoneNumber	processed_orders.BillingPhoneNumber	processed_orders
processed_orders__billingpostcode	TEXT	processed_orders.BillingPostCode	processed_orders.BillingPostCode	processed_orders
processed_orders__billingregion	TEXT	processed_orders.BillingRegion	processed_orders.BillingRegion	processed_orders
processed_orders__billingtown	TEXT	processed_orders.BillingTown	processed_orders.BillingTown	processed_orders
processed_orders__buyerphonenumber	TEXT	processed_orders.BuyerPhoneNumber	processed_orders.BuyerPhoneNumber	processed_orders
processed_orders__cbillingaddress	TEXT	processed_orders.cBillingAddress	processed_orders.cBillingAddress	processed_orders
processed_orders__ccountry	TEXT	processed_orders.cCountry	processed_orders.cCountry	processed_orders
processed_orders__ccurrency	TEXT	processed_orders.cCurrency	processed_orders.cCurrency	processed_orders
processed_orders__cemailaddress	TEXT	processed_orders.cEmailAddress	processed_orders.cEmailAddress	processed_orders
processed_orders__cfullname	TEXT	processed_orders.cFullName	processed_orders.cFullName	processed_orders
processed_orders__channelbuyername	TEXT	processed_orders.ChannelBuyerName	processed_orders.ChannelBuyerName	processed_orders
processed_orders__company	TEXT	processed_orders.Company	processed_orders.Company	processed_orders
processed_orders__countrytaxrate	NUMERIC	processed_orders.CountryTaxRate	processed_orders.CountryTaxRate	processed_orders
processed_orders__cpostcode	TEXT	processed_orders.cPostCode	processed_orders.cPostCode	processed_orders
processed_orders__cshippingaddress	TEXT	processed_orders.cShippingAddress	processed_orders.cShippingAddress	processed_orders
processed_orders__dcancelledon	TEXT	processed_orders.dCancelledOn	processed_orders.dCancelledOn	processed_orders
processed_orders__dpaidon	TEXT	processed_orders.dPaidOn	processed_orders.dPaidOn	processed_orders
processed_orders__dprocessedon	TEXT	processed_orders.dProcessedOn	processed_orders.dProcessedOn	processed_orders
processed_orders__dreceiveddate	DATE	processed_orders.dReceivedDate	processed_orders.dReceivedDate	processed_orders
processed_orders__externalreference	TEXT	processed_orders.ExternalReference	processed_orders.ExternalReference	processed_orders
processed_orders__foldercollection	TEXT	processed_orders.FolderCollection	processed_orders.FolderCollection	processed_orders
processed_orders__fpostagecost	NUMERIC	processed_orders.fPostageCost	processed_orders.fPostageCost	processed_orders
processed_orders__ftax	NUMERIC	processed_orders.fTax	processed_orders.fTax	processed_orders
processed_orders__ftotalcharge	NUMERIC	processed_orders.fTotalCharge	processed_orders.fTotalCharge	processed_orders
processed_orders__fulfilmentlocationname	TEXT	processed_orders.FulfilmentLocationName	processed_orders.FulfilmentLocationName	processed_orders
processed_orders__holdorcancel	BOOLEAN	processed_orders.HoldOrCancel	processed_orders.HoldOrCancel	processed_orders
processed_orders__isexchange	BOOLEAN	processed_orders.IsExchange	processed_orders.IsExchange	processed_orders
processed_orders__isresend	BOOLEAN	processed_orders.IsResend	processed_orders.IsResend	processed_orders
processed_orders__itemweight	NUMERIC	processed_orders.ItemWeight	processed_orders.ItemWeight	processed_orders
processed_orders__norderid	NUMERIC	processed_orders.nOrderId	processed_orders.nOrderId	processed_orders
processed_orders__nstatus	NUMERIC	processed_orders.nStatus	processed_orders.nStatus	processed_orders
processed_orders__packagecategory	TEXT	processed_orders.PackageCategory	processed_orders.PackageCategory	processed_orders
processed_orders__packagetitle	TEXT	processed_orders.PackageTitle	processed_orders.PackageTitle	processed_orders
processed_orders__pkorderid	TEXT	processed_orders.pkOrderID	processed_orders.pkOrderID	processed_orders
processed_orders__postagecostextax	NUMERIC	processed_orders.PostageCostExTax	processed_orders.PostageCostExTax	processed_orders
processed_orders__postalservicecode	TEXT	processed_orders.PostalServiceCode	processed_orders.PostalServiceCode	processed_orders
processed_orders__postalservicename	TEXT	processed_orders.PostalServiceName	processed_orders.PostalServiceName	processed_orders
processed_orders__postaltrackingnumber	TEXT	processed_orders.PostalTrackingNumber	processed_orders.PostalTrackingNumber	processed_orders
processed_orders__profitmargin	NUMERIC	processed_orders.ProfitMargin	processed_orders.ProfitMargin	processed_orders
processed_orders__referencenum	TEXT	processed_orders.ReferenceNum	processed_orders.ReferenceNum	processed_orders
processed_orders__region	TEXT	processed_orders.Region	processed_orders.Region	processed_orders
processed_orders__secondaryreference	TEXT	processed_orders.SecondaryReference	processed_orders.SecondaryReference	processed_orders
processed_orders__source	TEXT	processed_orders.Source	processed_orders.Source	processed_orders
processed_orders__subsource	TEXT	processed_orders.SubSource	processed_orders.SubSource	processed_orders
processed_orders__subtotal	NUMERIC	processed_orders.Subtotal	processed_orders.Subtotal	processed_orders
processed_orders__taxid	TEXT	processed_orders.TaxId	processed_orders.TaxId	processed_orders
processed_orders__timediff	NUMERIC	processed_orders.timeDiff	processed_orders.timeDiff	processed_orders
processed_orders__totaldiscount	NUMERIC	processed_orders.TotalDiscount	processed_orders.TotalDiscount	processed_orders
processed_orders__totalweight	NUMERIC	processed_orders.TotalWeight	processed_orders.TotalWeight	processed_orders
processed_orders__town	TEXT	processed_orders.Town	processed_orders.Town	processed_orders
processed_orders__vendor	TEXT	processed_orders.Vendor	processed_orders.Vendor	processed_orders
source	TEXT	Source	The name of the Windsor connector returning the row
stock_items__barcodenumber	TEXT	stock_items.BarcodeNumber	stock_items.BarcodeNumber	stock_items
stock_items__batchnumberscanrequired	BOOLEAN	stock_items.BatchNumberScanRequired	stock_items.BatchNumberScanRequired	stock_items
stock_items__categoryid	TEXT	stock_items.CategoryId	stock_items.CategoryId	stock_items
stock_items__categoryname	TEXT	stock_items.CategoryName	stock_items.CategoryName	stock_items
stock_items__creationdate	DATE	stock_items.CreationDate	stock_items.CreationDate	stock_items
stock_items__depth	NUMERIC	stock_items.Depth	stock_items.Depth	stock_items
stock_items__height	NUMERIC	stock_items.Height	stock_items.Height	stock_items
stock_items__images	OBJECT	stock_items.Images	stock_items.Images	stock_items
stock_items__inventorytrackingtype	NUMERIC	stock_items.InventoryTrackingType	stock_items.InventoryTrackingType	stock_items
stock_items__isbatchedstocktype	BOOLEAN	stock_items.isBatchedStockType	stock_items.isBatchedStockType	stock_items
stock_items__itemchanneldescriptions	OBJECT	stock_items.ItemChannelDescriptions	stock_items.ItemChannelDescriptions	stock_items
stock_items__itemchannelprices	OBJECT	stock_items.ItemChannelPrices	stock_items.ItemChannelPrices	stock_items
stock_items__itemchanneltitles	OBJECT	stock_items.ItemChannelTitles	stock_items.ItemChannelTitles	stock_items
stock_items__itemextendedproperties	OBJECT	stock_items.ItemExtendedProperties	stock_items.ItemExtendedProperties	stock_items
stock_items__itemnumber	TEXT	stock_items.ItemNumber	stock_items.ItemNumber	stock_items
stock_items__itemtitle	TEXT	stock_items.ItemTitle	stock_items.ItemTitle	stock_items
stock_items__metadata	TEXT	stock_items.MetaData	stock_items.MetaData	stock_items
stock_items__packagegroupid	TEXT	stock_items.PackageGroupId	stock_items.PackageGroupId	stock_items
stock_items__packagegroupname	TEXT	stock_items.PackageGroupName	stock_items.PackageGroupName	stock_items
stock_items__postalserviceid	TEXT	stock_items.PostalServiceId	stock_items.PostalServiceId	stock_items
stock_items__postalservicename	TEXT	stock_items.PostalServiceName	stock_items.PostalServiceName	stock_items
stock_items__purchaseprice	NUMERIC	stock_items.PurchasePrice	stock_items.PurchasePrice	stock_items
stock_items__retailprice	NUMERIC	stock_items.RetailPrice	stock_items.RetailPrice	stock_items
stock_items__serialnumberscanrequired	BOOLEAN	stock_items.SerialNumberScanRequired	stock_items.SerialNumberScanRequired	stock_items
stock_items__stockitemid	TEXT	stock_items.StockItemId	stock_items.StockItemId	stock_items
stock_items__stockitemintid	NUMERIC	stock_items.StockItemIntId	stock_items.StockItemIntId	stock_items
stock_items__stocklevels	OBJECT	stock_items.StockLevels	stock_items.StockLevels	stock_items
stock_items__suppliers	OBJECT	stock_items.Suppliers	stock_items.Suppliers	stock_items
stock_items__taxrate	NUMERIC	stock_items.TaxRate	stock_items.TaxRate	stock_items
stock_items__weight	NUMERIC	stock_items.Weight	stock_items.Weight	stock_items
stock_items__width	NUMERIC	stock_items.Width	stock_items.Width	stock_items
stock_location_details__address1	TEXT	stock_location_details.Address1	stock_location_details.Address1	stock_location_details
stock_location_details__address2	TEXT	stock_location_details.Address2	stock_location_details.Address2	stock_location_details
stock_location_details__city	TEXT	stock_location_details.City	stock_location_details.City	stock_location_details
stock_location_details__countinorderuntilacknowledgement	BOOLEAN	stock_location_details.CountInOrderUntilAcknowledgement	stock_location_details.CountInOrderUntilAcknowledgement	stock_location_details
stock_location_details__country	TEXT	stock_location_details.Country	stock_location_details.Country	stock_location_details
stock_location_details__county	TEXT	stock_location_details.County	stock_location_details.County	stock_location_details
stock_location_details__fulfilmentcenterdeductstockwhenprocessed	BOOLEAN	stock_location_details.FulfilmentCenterDeductStockWhenProcessed	stock_location_details.FulfilmentCenterDeductStockWhenProcessed	stock_location_details
stock_location_details__isfulfillmentcenter	BOOLEAN	stock_location_details.IsFulfillmentCenter	stock_location_details.IsFulfillmentCenter	stock_location_details
stock_location_details__isnottrackable	BOOLEAN	stock_location_details.IsNotTrackable	stock_location_details.IsNotTrackable	stock_location_details
stock_location_details__iswarehousemanaged	BOOLEAN	stock_location_details.IsWarehouseManaged	stock_location_details.IsWarehouseManaged	stock_location_details
stock_location_details__locationname	TEXT	stock_location_details.LocationName	stock_location_details.LocationName	stock_location_details
stock_location_details__locationtag	TEXT	stock_location_details.LocationTag	stock_location_details.LocationTag	stock_location_details
stock_location_details__stocklocationid	TEXT	stock_location_details.StockLocationId	stock_location_details.StockLocationId	stock_location_details
stock_location_details__stocklocationintid	NUMERIC	stock_location_details.StockLocationIntId	stock_location_details.StockLocationIntId	stock_location_details
stock_location_details__zipcode	TEXT	stock_location_details.ZipCode	stock_location_details.ZipCode	stock_location_details
stock_locations__address1	TEXT	stock_locations.Address1	stock_locations.Address1	stock_locations
stock_locations__address2	TEXT	stock_locations.Address2	stock_locations.Address2	stock_locations
stock_locations__binrack	TEXT	stock_locations.BinRack	stock_locations.BinRack	stock_locations
stock_locations__city	TEXT	stock_locations.City	stock_locations.City	stock_locations
stock_locations__countinorderuntilacknowledgement	BOOLEAN	stock_locations.CountInOrderUntilAcknowledgement	stock_locations.CountInOrderUntilAcknowledgement	stock_locations
stock_locations__country	TEXT	stock_locations.Country	stock_locations.Country	stock_locations
stock_locations__county	TEXT	stock_locations.County	stock_locations.County	stock_locations
stock_locations__fulfilmentcenterdeductstockwhenprocessed	BOOLEAN	stock_locations.FulfilmentCenterDeductStockWhenProcessed	stock_locations.FulfilmentCenterDeductStockWhenProcessed	stock_locations
stock_locations__isfulfillmentcenter	BOOLEAN	stock_locations.IsFulfillmentCenter	stock_locations.IsFulfillmentCenter	stock_locations
stock_locations__isnottrackable	BOOLEAN	stock_locations.IsNotTrackable	stock_locations.IsNotTrackable	stock_locations
stock_locations__iswarehousemanaged	BOOLEAN	stock_locations.IsWarehouseManaged	stock_locations.IsWarehouseManaged	stock_locations
stock_locations__locationname	TEXT	stock_locations.LocationName	stock_locations.LocationName	stock_locations
stock_locations__locationtag	TEXT	stock_locations.LocationTag	stock_locations.LocationTag	stock_locations
stock_locations__stocklocationid	TEXT	stock_locations.StockLocationId	stock_locations.StockLocationId	stock_locations
stock_locations__stocklocationintid	NUMERIC	stock_locations.StockLocationIntId	stock_locations.StockLocationIntId	stock_locations
stock_locations__zipcode	TEXT	stock_locations.ZipCode	stock_locations.ZipCode	stock_locations
today	DATE	Today	Today's date