Linnworks Field Reference


Fields

IDTypeNameDescriptionReport
datasourceTEXTData SourceThe name of the Windsor connector returning the row
processed_order_details__customerinfoOBJECTprocessed_order_details.CustomerInfoprocessed_order_details.CustomerInfoprocessed_order_details
processed_order_details__extendedpropertiesOBJECTprocessed_order_details.ExtendedPropertiesprocessed_order_details.ExtendedPropertiesprocessed_order_details
processed_order_details__foldernameOBJECTprocessed_order_details.FolderNameprocessed_order_details.FolderNameprocessed_order_details
processed_order_details__fulfilmentlocationidTEXTprocessed_order_details.FulfilmentLocationIdprocessed_order_details.FulfilmentLocationIdprocessed_order_details
processed_order_details__generalinfoOBJECTprocessed_order_details.GeneralInfoprocessed_order_details.GeneralInfoprocessed_order_details
processed_order_details__itemsOBJECTprocessed_order_details.Itemsprocessed_order_details.Itemsprocessed_order_details
processed_order_details__notesOBJECTprocessed_order_details.Notesprocessed_order_details.Notesprocessed_order_details
processed_order_details__numorderidNUMERICprocessed_order_details.NumOrderIdprocessed_order_details.NumOrderIdprocessed_order_details
processed_order_details__orderidTEXTprocessed_order_details.OrderIdprocessed_order_details.OrderIdprocessed_order_details
processed_order_details__paiddatetimeDATEprocessed_order_details.PaidDateTimeprocessed_order_details.PaidDateTimeprocessed_order_details
processed_order_details__processedBOOLEANprocessed_order_details.Processedprocessed_order_details.Processedprocessed_order_details
processed_order_details__processeddatetimeDATEprocessed_order_details.ProcessedDateTimeprocessed_order_details.ProcessedDateTimeprocessed_order_details
processed_order_details__shippinginfoOBJECTprocessed_order_details.ShippingInfoprocessed_order_details.ShippingInfoprocessed_order_details
processed_order_details__taxidTEXTprocessed_order_details.TaxIdprocessed_order_details.TaxIdprocessed_order_details
processed_order_details__totalsinfoOBJECTprocessed_order_details.TotalsInfoprocessed_order_details.TotalsInfoprocessed_order_details
processed_orders__accountnameTEXTprocessed_orders.AccountNameprocessed_orders.AccountNameprocessed_orders
processed_orders__address1TEXTprocessed_orders.Address1processed_orders.Address1processed_orders
processed_orders__address2TEXTprocessed_orders.Address2processed_orders.Address2processed_orders
processed_orders__address3TEXTprocessed_orders.Address3processed_orders.Address3processed_orders
processed_orders__billingaddress1TEXTprocessed_orders.BillingAddress1processed_orders.BillingAddress1processed_orders
processed_orders__billingaddress2TEXTprocessed_orders.BillingAddress2processed_orders.BillingAddress2processed_orders
processed_orders__billingaddress3TEXTprocessed_orders.BillingAddress3processed_orders.BillingAddress3processed_orders
processed_orders__billingcompanyTEXTprocessed_orders.BillingCompanyprocessed_orders.BillingCompanyprocessed_orders
processed_orders__billingcountrynameTEXTprocessed_orders.BillingCountryNameprocessed_orders.BillingCountryNameprocessed_orders
processed_orders__billingemailaddressTEXTprocessed_orders.BillingEmailAddressprocessed_orders.BillingEmailAddressprocessed_orders
processed_orders__billingnameTEXTprocessed_orders.BillingNameprocessed_orders.BillingNameprocessed_orders
processed_orders__billingphonenumberTEXTprocessed_orders.BillingPhoneNumberprocessed_orders.BillingPhoneNumberprocessed_orders
processed_orders__billingpostcodeTEXTprocessed_orders.BillingPostCodeprocessed_orders.BillingPostCodeprocessed_orders
processed_orders__billingregionTEXTprocessed_orders.BillingRegionprocessed_orders.BillingRegionprocessed_orders
processed_orders__billingtownTEXTprocessed_orders.BillingTownprocessed_orders.BillingTownprocessed_orders
processed_orders__buyerphonenumberTEXTprocessed_orders.BuyerPhoneNumberprocessed_orders.BuyerPhoneNumberprocessed_orders
processed_orders__cbillingaddressTEXTprocessed_orders.cBillingAddressprocessed_orders.cBillingAddressprocessed_orders
processed_orders__ccountryTEXTprocessed_orders.cCountryprocessed_orders.cCountryprocessed_orders
processed_orders__ccurrencyTEXTprocessed_orders.cCurrencyprocessed_orders.cCurrencyprocessed_orders
processed_orders__cemailaddressTEXTprocessed_orders.cEmailAddressprocessed_orders.cEmailAddressprocessed_orders
processed_orders__cfullnameTEXTprocessed_orders.cFullNameprocessed_orders.cFullNameprocessed_orders
processed_orders__channelbuyernameTEXTprocessed_orders.ChannelBuyerNameprocessed_orders.ChannelBuyerNameprocessed_orders
processed_orders__companyTEXTprocessed_orders.Companyprocessed_orders.Companyprocessed_orders
processed_orders__countrytaxrateNUMERICprocessed_orders.CountryTaxRateprocessed_orders.CountryTaxRateprocessed_orders
processed_orders__cpostcodeTEXTprocessed_orders.cPostCodeprocessed_orders.cPostCodeprocessed_orders
processed_orders__cshippingaddressTEXTprocessed_orders.cShippingAddressprocessed_orders.cShippingAddressprocessed_orders
processed_orders__dcancelledonTEXTprocessed_orders.dCancelledOnprocessed_orders.dCancelledOnprocessed_orders
processed_orders__dpaidonTEXTprocessed_orders.dPaidOnprocessed_orders.dPaidOnprocessed_orders
processed_orders__dprocessedonTEXTprocessed_orders.dProcessedOnprocessed_orders.dProcessedOnprocessed_orders
processed_orders__dreceiveddateDATEprocessed_orders.dReceivedDateprocessed_orders.dReceivedDateprocessed_orders
processed_orders__externalreferenceTEXTprocessed_orders.ExternalReferenceprocessed_orders.ExternalReferenceprocessed_orders
processed_orders__foldercollectionTEXTprocessed_orders.FolderCollectionprocessed_orders.FolderCollectionprocessed_orders
processed_orders__fpostagecostNUMERICprocessed_orders.fPostageCostprocessed_orders.fPostageCostprocessed_orders
processed_orders__ftaxNUMERICprocessed_orders.fTaxprocessed_orders.fTaxprocessed_orders
processed_orders__ftotalchargeNUMERICprocessed_orders.fTotalChargeprocessed_orders.fTotalChargeprocessed_orders
processed_orders__fulfilmentlocationnameTEXTprocessed_orders.FulfilmentLocationNameprocessed_orders.FulfilmentLocationNameprocessed_orders
processed_orders__holdorcancelBOOLEANprocessed_orders.HoldOrCancelprocessed_orders.HoldOrCancelprocessed_orders
processed_orders__isexchangeBOOLEANprocessed_orders.IsExchangeprocessed_orders.IsExchangeprocessed_orders
processed_orders__isresendBOOLEANprocessed_orders.IsResendprocessed_orders.IsResendprocessed_orders
processed_orders__itemweightNUMERICprocessed_orders.ItemWeightprocessed_orders.ItemWeightprocessed_orders
processed_orders__norderidNUMERICprocessed_orders.nOrderIdprocessed_orders.nOrderIdprocessed_orders
processed_orders__nstatusNUMERICprocessed_orders.nStatusprocessed_orders.nStatusprocessed_orders
processed_orders__packagecategoryTEXTprocessed_orders.PackageCategoryprocessed_orders.PackageCategoryprocessed_orders
processed_orders__packagetitleTEXTprocessed_orders.PackageTitleprocessed_orders.PackageTitleprocessed_orders
processed_orders__pkorderidTEXTprocessed_orders.pkOrderIDprocessed_orders.pkOrderIDprocessed_orders
processed_orders__postagecostextaxNUMERICprocessed_orders.PostageCostExTaxprocessed_orders.PostageCostExTaxprocessed_orders
processed_orders__postalservicecodeTEXTprocessed_orders.PostalServiceCodeprocessed_orders.PostalServiceCodeprocessed_orders
processed_orders__postalservicenameTEXTprocessed_orders.PostalServiceNameprocessed_orders.PostalServiceNameprocessed_orders
processed_orders__postaltrackingnumberTEXTprocessed_orders.PostalTrackingNumberprocessed_orders.PostalTrackingNumberprocessed_orders
processed_orders__profitmarginNUMERICprocessed_orders.ProfitMarginprocessed_orders.ProfitMarginprocessed_orders
processed_orders__referencenumTEXTprocessed_orders.ReferenceNumprocessed_orders.ReferenceNumprocessed_orders
processed_orders__regionTEXTprocessed_orders.Regionprocessed_orders.Regionprocessed_orders
processed_orders__secondaryreferenceTEXTprocessed_orders.SecondaryReferenceprocessed_orders.SecondaryReferenceprocessed_orders
processed_orders__sourceTEXTprocessed_orders.Sourceprocessed_orders.Sourceprocessed_orders
processed_orders__subsourceTEXTprocessed_orders.SubSourceprocessed_orders.SubSourceprocessed_orders
processed_orders__subtotalNUMERICprocessed_orders.Subtotalprocessed_orders.Subtotalprocessed_orders
processed_orders__taxidTEXTprocessed_orders.TaxIdprocessed_orders.TaxIdprocessed_orders
processed_orders__timediffNUMERICprocessed_orders.timeDiffprocessed_orders.timeDiffprocessed_orders
processed_orders__totaldiscountNUMERICprocessed_orders.TotalDiscountprocessed_orders.TotalDiscountprocessed_orders
processed_orders__totalweightNUMERICprocessed_orders.TotalWeightprocessed_orders.TotalWeightprocessed_orders
processed_orders__townTEXTprocessed_orders.Townprocessed_orders.Townprocessed_orders
processed_orders__vendorTEXTprocessed_orders.Vendorprocessed_orders.Vendorprocessed_orders
sourceTEXTSourceThe name of the Windsor connector returning the row
stock_items__barcodenumberTEXTstock_items.BarcodeNumberstock_items.BarcodeNumberstock_items
stock_items__batchnumberscanrequiredBOOLEANstock_items.BatchNumberScanRequiredstock_items.BatchNumberScanRequiredstock_items
stock_items__categoryidTEXTstock_items.CategoryIdstock_items.CategoryIdstock_items
stock_items__categorynameTEXTstock_items.CategoryNamestock_items.CategoryNamestock_items
stock_items__creationdateDATEstock_items.CreationDatestock_items.CreationDatestock_items
stock_items__depthNUMERICstock_items.Depthstock_items.Depthstock_items
stock_items__heightNUMERICstock_items.Heightstock_items.Heightstock_items
stock_items__imagesOBJECTstock_items.Imagesstock_items.Imagesstock_items
stock_items__inventorytrackingtypeNUMERICstock_items.InventoryTrackingTypestock_items.InventoryTrackingTypestock_items
stock_items__isbatchedstocktypeBOOLEANstock_items.isBatchedStockTypestock_items.isBatchedStockTypestock_items
stock_items__itemchanneldescriptionsOBJECTstock_items.ItemChannelDescriptionsstock_items.ItemChannelDescriptionsstock_items
stock_items__itemchannelpricesOBJECTstock_items.ItemChannelPricesstock_items.ItemChannelPricesstock_items
stock_items__itemchanneltitlesOBJECTstock_items.ItemChannelTitlesstock_items.ItemChannelTitlesstock_items
stock_items__itemextendedpropertiesOBJECTstock_items.ItemExtendedPropertiesstock_items.ItemExtendedPropertiesstock_items
stock_items__itemnumberTEXTstock_items.ItemNumberstock_items.ItemNumberstock_items
stock_items__itemtitleTEXTstock_items.ItemTitlestock_items.ItemTitlestock_items
stock_items__metadataTEXTstock_items.MetaDatastock_items.MetaDatastock_items
stock_items__packagegroupidTEXTstock_items.PackageGroupIdstock_items.PackageGroupIdstock_items
stock_items__packagegroupnameTEXTstock_items.PackageGroupNamestock_items.PackageGroupNamestock_items
stock_items__postalserviceidTEXTstock_items.PostalServiceIdstock_items.PostalServiceIdstock_items
stock_items__postalservicenameTEXTstock_items.PostalServiceNamestock_items.PostalServiceNamestock_items
stock_items__purchasepriceNUMERICstock_items.PurchasePricestock_items.PurchasePricestock_items
stock_items__retailpriceNUMERICstock_items.RetailPricestock_items.RetailPricestock_items
stock_items__serialnumberscanrequiredBOOLEANstock_items.SerialNumberScanRequiredstock_items.SerialNumberScanRequiredstock_items
stock_items__stockitemidTEXTstock_items.StockItemIdstock_items.StockItemIdstock_items
stock_items__stockitemintidNUMERICstock_items.StockItemIntIdstock_items.StockItemIntIdstock_items
stock_items__stocklevelsOBJECTstock_items.StockLevelsstock_items.StockLevelsstock_items
stock_items__suppliersOBJECTstock_items.Suppliersstock_items.Suppliersstock_items
stock_items__taxrateNUMERICstock_items.TaxRatestock_items.TaxRatestock_items
stock_items__weightNUMERICstock_items.Weightstock_items.Weightstock_items
stock_items__widthNUMERICstock_items.Widthstock_items.Widthstock_items
stock_location_details__address1TEXTstock_location_details.Address1stock_location_details.Address1stock_location_details
stock_location_details__address2TEXTstock_location_details.Address2stock_location_details.Address2stock_location_details
stock_location_details__cityTEXTstock_location_details.Citystock_location_details.Citystock_location_details
stock_location_details__countinorderuntilacknowledgementBOOLEANstock_location_details.CountInOrderUntilAcknowledgementstock_location_details.CountInOrderUntilAcknowledgementstock_location_details
stock_location_details__countryTEXTstock_location_details.Countrystock_location_details.Countrystock_location_details
stock_location_details__countyTEXTstock_location_details.Countystock_location_details.Countystock_location_details
stock_location_details__fulfilmentcenterdeductstockwhenprocessedBOOLEANstock_location_details.FulfilmentCenterDeductStockWhenProcessedstock_location_details.FulfilmentCenterDeductStockWhenProcessedstock_location_details
stock_location_details__isfulfillmentcenterBOOLEANstock_location_details.IsFulfillmentCenterstock_location_details.IsFulfillmentCenterstock_location_details
stock_location_details__isnottrackableBOOLEANstock_location_details.IsNotTrackablestock_location_details.IsNotTrackablestock_location_details
stock_location_details__iswarehousemanagedBOOLEANstock_location_details.IsWarehouseManagedstock_location_details.IsWarehouseManagedstock_location_details
stock_location_details__locationnameTEXTstock_location_details.LocationNamestock_location_details.LocationNamestock_location_details
stock_location_details__locationtagTEXTstock_location_details.LocationTagstock_location_details.LocationTagstock_location_details
stock_location_details__stocklocationidTEXTstock_location_details.StockLocationIdstock_location_details.StockLocationIdstock_location_details
stock_location_details__stocklocationintidNUMERICstock_location_details.StockLocationIntIdstock_location_details.StockLocationIntIdstock_location_details
stock_location_details__zipcodeTEXTstock_location_details.ZipCodestock_location_details.ZipCodestock_location_details
stock_locations__address1TEXTstock_locations.Address1stock_locations.Address1stock_locations
stock_locations__address2TEXTstock_locations.Address2stock_locations.Address2stock_locations
stock_locations__binrackTEXTstock_locations.BinRackstock_locations.BinRackstock_locations
stock_locations__cityTEXTstock_locations.Citystock_locations.Citystock_locations
stock_locations__countinorderuntilacknowledgementBOOLEANstock_locations.CountInOrderUntilAcknowledgementstock_locations.CountInOrderUntilAcknowledgementstock_locations
stock_locations__countryTEXTstock_locations.Countrystock_locations.Countrystock_locations
stock_locations__countyTEXTstock_locations.Countystock_locations.Countystock_locations
stock_locations__fulfilmentcenterdeductstockwhenprocessedBOOLEANstock_locations.FulfilmentCenterDeductStockWhenProcessedstock_locations.FulfilmentCenterDeductStockWhenProcessedstock_locations
stock_locations__isfulfillmentcenterBOOLEANstock_locations.IsFulfillmentCenterstock_locations.IsFulfillmentCenterstock_locations
stock_locations__isnottrackableBOOLEANstock_locations.IsNotTrackablestock_locations.IsNotTrackablestock_locations
stock_locations__iswarehousemanagedBOOLEANstock_locations.IsWarehouseManagedstock_locations.IsWarehouseManagedstock_locations
stock_locations__locationnameTEXTstock_locations.LocationNamestock_locations.LocationNamestock_locations
stock_locations__locationtagTEXTstock_locations.LocationTagstock_locations.LocationTagstock_locations
stock_locations__stocklocationidTEXTstock_locations.StockLocationIdstock_locations.StockLocationIdstock_locations
stock_locations__stocklocationintidNUMERICstock_locations.StockLocationIntIdstock_locations.StockLocationIntIdstock_locations
stock_locations__zipcodeTEXTstock_locations.ZipCodestock_locations.ZipCodestock_locations
todayDATETodayToday's date