Field Report

bigint

• LatestRecordedPopulation (Application.Cities)
• LatestRecordedPopulation (Application.Countries)
• LatestRecordedPopulation (Application.StateProvinces)
• ColdRoomTemperatureID (Warehouse.ColdRoomTemperatures)
• VehicleTemperatureID (Warehouse.VehicleTemperatures)

bit

• IsPermittedToLogon (Application.People)
• IsExternalLogonProvider (Application.People)
• IsSystemUser (Application.People)
• IsEmployee (Application.People)
• IsSalesperson (Application.People)
• IsOrderLineFinalized (Purchasing.PurchaseOrderLines)
• IsOrderFinalized (Purchasing.PurchaseOrders)
• IsFinalized (Purchasing.SupplierTransactions)
• IsStatementSent (Sales.Customers)
• IsOnCreditHold (Sales.Customers)
• IsFinalized (Sales.CustomerTransactions)
• IsCreditNote (Sales.Invoices)
• IsUndersupplyBackordered (Sales.Orders)
• IsChillerStock (Warehouse.StockItems)
• IsCompressed (Warehouse.VehicleTemperatures)

date

• LastReceiptDate (Purchasing.PurchaseOrderLines)
• OrderDate (Purchasing.PurchaseOrders)
• ExpectedDeliveryDate (Purchasing.PurchaseOrders)
• TransactionDate (Purchasing.SupplierTransactions)
• FinalizationDate (Purchasing.SupplierTransactions)
• AccountOpenedDate (Sales.Customers)
• TransactionDate (Sales.CustomerTransactions)
• FinalizationDate (Sales.CustomerTransactions)
• InvoiceDate (Sales.Invoices)
• OrderDate (Sales.Orders)
• ExpectedDeliveryDate (Sales.Orders)
• StartDate (Sales.SpecialDeals)
• EndDate (Sales.SpecialDeals)

datetime2

• ValidFrom (Application.Cities)
• ValidTo (Application.Cities)
• ValidFrom (Application.Countries)
• ValidTo (Application.Countries)
• ValidFrom (Application.DeliveryMethods)
• ValidTo (Application.DeliveryMethods)
• ValidFrom (Application.PaymentMethods)
• ValidTo (Application.PaymentMethods)
• ValidFrom (Application.People)
• ValidTo (Application.People)
• ValidFrom (Application.StateProvinces)
• ValidTo (Application.StateProvinces)
• LastEditedWhen (Application.SystemParameters)
• ValidFrom (Application.TransactionTypes)
• ValidTo (Application.TransactionTypes)
• LastEditedWhen (Purchasing.PurchaseOrderLines)
• LastEditedWhen (Purchasing.PurchaseOrders)
• ValidFrom (Purchasing.SupplierCategories)
• ValidTo (Purchasing.SupplierCategories)
• ValidFrom (Purchasing.Suppliers)
• ValidTo (Purchasing.Suppliers)
• LastEditedWhen (Purchasing.SupplierTransactions)
• ValidFrom (Sales.BuyingGroups)
• ValidTo (Sales.BuyingGroups)
• ValidFrom (Sales.CustomerCategories)
• ValidTo (Sales.CustomerCategories)
• ValidFrom (Sales.Customers)
• ValidTo (Sales.Customers)
• LastEditedWhen (Sales.CustomerTransactions)
• LastEditedWhen (Sales.InvoiceLines)
• ConfirmedDeliveryTime (Sales.Invoices)
• LastEditedWhen (Sales.Invoices)
• PickingCompletedWhen (Sales.OrderLines)
• LastEditedWhen (Sales.OrderLines)
• PickingCompletedWhen (Sales.Orders)
• LastEditedWhen (Sales.Orders)
• LastEditedWhen (Sales.SpecialDeals)
• RecordedWhen (Warehouse.ColdRoomTemperatures)
• ValidFrom (Warehouse.ColdRoomTemperatures)
• ValidTo (Warehouse.ColdRoomTemperatures)
• ValidFrom (Warehouse.Colors)
• ValidTo (Warehouse.Colors)
• ValidFrom (Warehouse.PackageTypes)
• ValidTo (Warehouse.PackageTypes)
• ValidFrom (Warehouse.StockGroups)
• ValidTo (Warehouse.StockGroups)
• LastEditedWhen (Warehouse.StockItemHoldings)
• ValidFrom (Warehouse.StockItems)
• ValidTo (Warehouse.StockItems)
• LastEditedWhen (Warehouse.StockItemStockGroups)
• TransactionOccurredWhen (Warehouse.StockItemTransactions)
• LastEditedWhen (Warehouse.StockItemTransactions)
• RecordedWhen (Warehouse.VehicleTemperatures)

decimal

• ExpectedUnitPricePerOuter (Purchasing.PurchaseOrderLines)
• AmountExcludingTax (Purchasing.SupplierTransactions)
• TaxAmount (Purchasing.SupplierTransactions)
• TransactionAmount (Purchasing.SupplierTransactions)
• OutstandingBalance (Purchasing.SupplierTransactions)
• CreditLimit (Sales.Customers)
• StandardDiscountPercentage (Sales.Customers)
• AmountExcludingTax (Sales.CustomerTransactions)
• TaxAmount (Sales.CustomerTransactions)
• TransactionAmount (Sales.CustomerTransactions)
• OutstandingBalance (Sales.CustomerTransactions)
• UnitPrice (Sales.InvoiceLines)
• TaxRate (Sales.InvoiceLines)
• TaxAmount (Sales.InvoiceLines)
• LineProfit (Sales.InvoiceLines)
• ExtendedPrice (Sales.InvoiceLines)
• UnitPrice (Sales.OrderLines)
• TaxRate (Sales.OrderLines)
• DiscountAmount (Sales.SpecialDeals)
• DiscountPercentage (Sales.SpecialDeals)
• UnitPrice (Sales.SpecialDeals)
• Temperature (Warehouse.ColdRoomTemperatures)
• LastCostPrice (Warehouse.StockItemHoldings)
• TaxRate (Warehouse.StockItems)
• UnitPrice (Warehouse.StockItems)
• RecommendedRetailPrice (Warehouse.StockItems)
• TypicalWeightPerUnit (Warehouse.StockItems)
• Quantity (Warehouse.StockItemTransactions)
• Temperature (Warehouse.VehicleTemperatures)

geography

• Location (Application.Cities)
• Border (Application.Countries)
• Border (Application.StateProvinces)
• DeliveryLocation (Application.SystemParameters)
• DeliveryLocation (Purchasing.Suppliers)
• DeliveryLocation (Sales.Customers)

int

• CityID (Application.Cities)
• StateProvinceID (Application.Cities)
• LastEditedBy (Application.Cities)
• CountryID (Application.Countries)
• IsoNumericCode (Application.Countries)
• LastEditedBy (Application.Countries)
• DeliveryMethodID (Application.DeliveryMethods)
• LastEditedBy (Application.DeliveryMethods)
• PaymentMethodID (Application.PaymentMethods)
• LastEditedBy (Application.PaymentMethods)
• PersonID (Application.People)
• LastEditedBy (Application.People)
• StateProvinceID (Application.StateProvinces)
• CountryID (Application.StateProvinces)
• LastEditedBy (Application.StateProvinces)
• SystemParameterID (Application.SystemParameters)
• DeliveryCityID (Application.SystemParameters)
• PostalCityID (Application.SystemParameters)
• LastEditedBy (Application.SystemParameters)
• TransactionTypeID (Application.TransactionTypes)
• LastEditedBy (Application.TransactionTypes)
• PurchaseOrderLineID (Purchasing.PurchaseOrderLines)
• PurchaseOrderID (Purchasing.PurchaseOrderLines)
• StockItemID (Purchasing.PurchaseOrderLines)
• OrderedOuters (Purchasing.PurchaseOrderLines)
• ReceivedOuters (Purchasing.PurchaseOrderLines)
• PackageTypeID (Purchasing.PurchaseOrderLines)
• LastEditedBy (Purchasing.PurchaseOrderLines)
• PurchaseOrderID (Purchasing.PurchaseOrders)
• SupplierID (Purchasing.PurchaseOrders)
• DeliveryMethodID (Purchasing.PurchaseOrders)
• ContactPersonID (Purchasing.PurchaseOrders)
• LastEditedBy (Purchasing.PurchaseOrders)
• SupplierCategoryID (Purchasing.SupplierCategories)
• LastEditedBy (Purchasing.SupplierCategories)
• SupplierID (Purchasing.Suppliers)
• SupplierCategoryID (Purchasing.Suppliers)
• PrimaryContactPersonID (Purchasing.Suppliers)
• AlternateContactPersonID (Purchasing.Suppliers)
• DeliveryMethodID (Purchasing.Suppliers)
• DeliveryCityID (Purchasing.Suppliers)
• PostalCityID (Purchasing.Suppliers)
• PaymentDays (Purchasing.Suppliers)
• LastEditedBy (Purchasing.Suppliers)
• SupplierTransactionID (Purchasing.SupplierTransactions)
• SupplierID (Purchasing.SupplierTransactions)
• TransactionTypeID (Purchasing.SupplierTransactions)
• PurchaseOrderID (Purchasing.SupplierTransactions)
• PaymentMethodID (Purchasing.SupplierTransactions)
• LastEditedBy (Purchasing.SupplierTransactions)
• BuyingGroupID (Sales.BuyingGroups)
• LastEditedBy (Sales.BuyingGroups)
• CustomerCategoryID (Sales.CustomerCategories)
• LastEditedBy (Sales.CustomerCategories)
• CustomerID (Sales.Customers)
• BillToCustomerID (Sales.Customers)
• CustomerCategoryID (Sales.Customers)
• BuyingGroupID (Sales.Customers)
• PrimaryContactPersonID (Sales.Customers)
• AlternateContactPersonID (Sales.Customers)
• DeliveryMethodID (Sales.Customers)
• DeliveryCityID (Sales.Customers)
• PostalCityID (Sales.Customers)
• PaymentDays (Sales.Customers)
• LastEditedBy (Sales.Customers)
• CustomerTransactionID (Sales.CustomerTransactions)
• CustomerID (Sales.CustomerTransactions)
• TransactionTypeID (Sales.CustomerTransactions)
• InvoiceID (Sales.CustomerTransactions)
• PaymentMethodID (Sales.CustomerTransactions)
• LastEditedBy (Sales.CustomerTransactions)
• InvoiceLineID (Sales.InvoiceLines)
• InvoiceID (Sales.InvoiceLines)
• StockItemID (Sales.InvoiceLines)
• PackageTypeID (Sales.InvoiceLines)
• Quantity (Sales.InvoiceLines)
• LastEditedBy (Sales.InvoiceLines)
• InvoiceID (Sales.Invoices)
• CustomerID (Sales.Invoices)
• BillToCustomerID (Sales.Invoices)
• OrderID (Sales.Invoices)
• DeliveryMethodID (Sales.Invoices)
• ContactPersonID (Sales.Invoices)
• AccountsPersonID (Sales.Invoices)
• SalespersonPersonID (Sales.Invoices)
• PackedByPersonID (Sales.Invoices)
• TotalDryItems (Sales.Invoices)
• TotalChillerItems (Sales.Invoices)
• LastEditedBy (Sales.Invoices)
• OrderLineID (Sales.OrderLines)
• OrderID (Sales.OrderLines)
• StockItemID (Sales.OrderLines)
• PackageTypeID (Sales.OrderLines)
• Quantity (Sales.OrderLines)
• PickedQuantity (Sales.OrderLines)
• LastEditedBy (Sales.OrderLines)
• OrderID (Sales.Orders)
• CustomerID (Sales.Orders)
• SalespersonPersonID (Sales.Orders)
• PickedByPersonID (Sales.Orders)
• ContactPersonID (Sales.Orders)
• BackorderOrderID (Sales.Orders)
• LastEditedBy (Sales.Orders)
• SpecialDealID (Sales.SpecialDeals)
• StockItemID (Sales.SpecialDeals)
• CustomerID (Sales.SpecialDeals)
• BuyingGroupID (Sales.SpecialDeals)
• CustomerCategoryID (Sales.SpecialDeals)
• StockGroupID (Sales.SpecialDeals)
• LastEditedBy (Sales.SpecialDeals)
• ColdRoomSensorNumber (Warehouse.ColdRoomTemperatures)
• ColorID (Warehouse.Colors)
• LastEditedBy (Warehouse.Colors)
• PackageTypeID (Warehouse.PackageTypes)
• LastEditedBy (Warehouse.PackageTypes)
• StockGroupID (Warehouse.StockGroups)
• LastEditedBy (Warehouse.StockGroups)
• StockItemID (Warehouse.StockItemHoldings)
• QuantityOnHand (Warehouse.StockItemHoldings)
• LastStocktakeQuantity (Warehouse.StockItemHoldings)
• ReorderLevel (Warehouse.StockItemHoldings)
• TargetStockLevel (Warehouse.StockItemHoldings)
• LastEditedBy (Warehouse.StockItemHoldings)
• StockItemID (Warehouse.StockItems)
• SupplierID (Warehouse.StockItems)
• ColorID (Warehouse.StockItems)
• UnitPackageID (Warehouse.StockItems)
• OuterPackageID (Warehouse.StockItems)
• LeadTimeDays (Warehouse.StockItems)
• QuantityPerOuter (Warehouse.StockItems)
• LastEditedBy (Warehouse.StockItems)
• StockItemStockGroupID (Warehouse.StockItemStockGroups)
• StockItemID (Warehouse.StockItemStockGroups)
• StockGroupID (Warehouse.StockItemStockGroups)
• LastEditedBy (Warehouse.StockItemStockGroups)
• StockItemTransactionID (Warehouse.StockItemTransactions)
• StockItemID (Warehouse.StockItemTransactions)
• TransactionTypeID (Warehouse.StockItemTransactions)
• CustomerID (Warehouse.StockItemTransactions)
• InvoiceID (Warehouse.StockItemTransactions)
• SupplierID (Warehouse.StockItemTransactions)
• PurchaseOrderID (Warehouse.StockItemTransactions)
• LastEditedBy (Warehouse.StockItemTransactions)
• ChillerSensorNumber (Warehouse.VehicleTemperatures)

nvarchar

• CityName (Application.Cities)
• CountryName (Application.Countries)
• FormalName (Application.Countries)
• IsoAlpha3Code (Application.Countries)
• CountryType (Application.Countries)
• Continent (Application.Countries)
• Region (Application.Countries)
• Subregion (Application.Countries)
• DeliveryMethodName (Application.DeliveryMethods)
• PaymentMethodName (Application.PaymentMethods)
• FullName (Application.People)
• PreferredName (Application.People)
• SearchName (Application.People)
• LogonName (Application.People)
• PhoneNumber (Application.People)
• FaxNumber (Application.People)
• EmailAddress (Application.People)
• StateProvinceCode (Application.StateProvinces)
• StateProvinceName (Application.StateProvinces)
• SalesTerritory (Application.StateProvinces)
• DeliveryAddressLine1 (Application.SystemParameters)
• DeliveryAddressLine2 (Application.SystemParameters)
• DeliveryPostalCode (Application.SystemParameters)
• PostalAddressLine1 (Application.SystemParameters)
• PostalAddressLine2 (Application.SystemParameters)
• PostalPostalCode (Application.SystemParameters)
• TransactionTypeName (Application.TransactionTypes)
• Description (Purchasing.PurchaseOrderLines)
• SupplierReference (Purchasing.PurchaseOrders)
• SupplierCategoryName (Purchasing.SupplierCategories)
• SupplierName (Purchasing.Suppliers)
• SupplierReference (Purchasing.Suppliers)
• BankAccountName (Purchasing.Suppliers)
• BankAccountBranch (Purchasing.Suppliers)
• BankAccountCode (Purchasing.Suppliers)
• BankAccountNumber (Purchasing.Suppliers)
• BankInternationalCode (Purchasing.Suppliers)
• PhoneNumber (Purchasing.Suppliers)
• FaxNumber (Purchasing.Suppliers)
• WebsiteURL (Purchasing.Suppliers)
• DeliveryAddressLine1 (Purchasing.Suppliers)
• DeliveryAddressLine2 (Purchasing.Suppliers)
• DeliveryPostalCode (Purchasing.Suppliers)
• PostalAddressLine1 (Purchasing.Suppliers)
• PostalAddressLine2 (Purchasing.Suppliers)
• PostalPostalCode (Purchasing.Suppliers)
• SupplierInvoiceNumber (Purchasing.SupplierTransactions)
• BuyingGroupName (Sales.BuyingGroups)
• CustomerCategoryName (Sales.CustomerCategories)
• CustomerName (Sales.Customers)
• PhoneNumber (Sales.Customers)
• FaxNumber (Sales.Customers)
• DeliveryRun (Sales.Customers)
• RunPosition (Sales.Customers)
• WebsiteURL (Sales.Customers)
• DeliveryAddressLine1 (Sales.Customers)
• DeliveryAddressLine2 (Sales.Customers)
• DeliveryPostalCode (Sales.Customers)
• PostalAddressLine1 (Sales.Customers)
• PostalAddressLine2 (Sales.Customers)
• PostalPostalCode (Sales.Customers)
• Description (Sales.InvoiceLines)
• CustomerPurchaseOrderNumber (Sales.Invoices)
• DeliveryRun (Sales.Invoices)
• RunPosition (Sales.Invoices)
• ConfirmedReceivedBy (Sales.Invoices)
• Description (Sales.OrderLines)
• CustomerPurchaseOrderNumber (Sales.Orders)
• DealDescription (Sales.SpecialDeals)
• ColorName (Warehouse.Colors)
• PackageTypeName (Warehouse.PackageTypes)
• StockGroupName (Warehouse.StockGroups)
• BinLocation (Warehouse.StockItemHoldings)
• StockItemName (Warehouse.StockItems)
• Brand (Warehouse.StockItems)
• Size (Warehouse.StockItems)
• Barcode (Warehouse.StockItems)
• VehicleRegistration (Warehouse.VehicleTemperatures)
• FullSensorData (Warehouse.VehicleTemperatures)

nvarchar (MAX)

• UserPreferences (Application.People)
• CustomFields (Application.People)
• OtherLanguages (Application.People)
• ApplicationSettings (Application.SystemParameters)
• Comments (Purchasing.PurchaseOrders)
• InternalComments (Purchasing.PurchaseOrders)
• InternalComments (Purchasing.Suppliers)
• CreditNoteReason (Sales.Invoices)
• Comments (Sales.Invoices)
• DeliveryInstructions (Sales.Invoices)
• InternalComments (Sales.Invoices)
• ReturnedDeliveryData (Sales.Invoices)
• Comments (Sales.Orders)
• DeliveryInstructions (Sales.Orders)
• InternalComments (Sales.Orders)
• MarketingComments (Warehouse.StockItems)
• InternalComments (Warehouse.StockItems)
• CustomFields (Warehouse.StockItems)
• Tags (Warehouse.StockItems)
• SearchDetails (Warehouse.StockItems)

varbinary (MAX)

• HashedPassword (Application.People)
• Photo (Application.People)
• Photo (Warehouse.StockItems)
• CompressedSensorData (Warehouse.VehicleTemperatures)