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 |