BMS Reports | Column values in Exago

Introduction

The following are the column values that you find in Exago reports. This includes values from release notes dating from Oct 2021.

Column Values

Included From Category Entity Name Column Name Description
  HR Employees UserID  
Created On  
Modified On  
  HR Employee Skills UserID  
  HR Employee Shifts UserID  
Modified On  
Created On  
  Service Desk Tickets TicketID  
Due Date  
Open Date  
Completed Date  
Created On  
Open Date Time  
TTR  
Last Update  
  Service Desk Ticket Time Entries Entry Id  
Modified On  
Created On  
  Service Desk Ticket Notes Entry ID  
Created On  
  Service Desk Ticket Expenses EntryID  
Modified On  
Created On  
Release Notes BMS & Vorex 5.11.0 Apr 2022 Service Desk Hardware Asset Last Updated This data relates to Service Desk > Asset Management > Hardware asset > Last update column in the UI.
  Projects Projects ProjectID  
Created On  
Modified On  
  Projects Tasks TaskID  
Created On  
Modified On  
End Date  
Start Date  
  Projects Task Members TaskID  
UserID  
Modified On  
Created On  
  Projects Task timeentries EntryId  
Created On  
Modified On  
  Timesheets Timesheets TimesheetId  
Modified On  
  Timesheets Timeentries EntryId  
Created On  
Modified On  
  Timesheets Timesheets Approval History History  
  Expenses Expensesheets ExpenseSheetId  
Modified On  
Created On  
  Expenses Expense Entries EntryId  
Created On  
Modified On  
  Projects Project Expenses EntryId  
Modified On  
Created On  
  Finance Invoices InvoiceId  
Created On  
Modified On  
  Finance Invoice Details InvoiceDetailsId  
  Finance Invoice Discounts InvoiceDiscountId  
  CRM Accounts AccoundId  
Created On  
Modified On  
  CRM Contacts AccountContactId  
Created On  
Modified On  
  CRM Contact Emails EmailID  
  CRM Contact Phones PhoneId  
  CRM Account Locations AccountLocationId  
Modified On  
  CRM Opportunities OpportunityID  
Modified On  
Created On  
  CRM Activities ActivityID  
Modified On  
Created On  
  CRM Product Quotations SO ID  
Created On  
Modified On  
PO Date  
  CRM Product Quotations Free Items SO Free Item Id  
  CRM Service Quotations QuotationId  
Created On  
Expiry Date  
Modified On  
Sent On  
  CRM Service Quotation Items Quotation Item Id  
  CRM Product Quotation Items SO Item Id  
  Projects Task Member Periods TaskHourId  
Created On  
Modified On  
To Date  
  Service Desk Ticket Status Changes pkTicketStatusChangeId  
Created Date  
  Finance Vendor Bills pkBillId  
Modified On  
Created On  
  Finance Vendor Bill Items pkBillExpenseItemId  
Created On  
Modified On  
  Finance Vendor Bill Timeentries pkBillTimeItemId  
  Finance Vendor Bill Expense Entries pkBillExpenseItemId  
  Finance Contracts ContractID  
Created On  
Modified On  
  Finance Time and Material Contract Details ClientContractRateId  
Modified On  
Created On  
  Finance Fixed Price Contract Details ClientContractMilestoneId  
CreatedOn  
ModifiedOn  
Due Date  
  Finance Recurring Services Contract Details ClientContractServiceId  
CreatedOn  
ModifiedOn  
  Finance Recurring Services Billing History PeriodId  
CreatedOn  
ModifiedOn  
  Finance Retainer By Hours Billing History PeriodId  
ModifiedOn  
CreatedOn  
  Finance Retainer By Amount Billing History PeriodId  
ModifiedOn  
CreatedOn  
  Finance Retainer By Hours Contract Details ContractId  
Created On  
Modified On  
  CRM Account Notes ClientID  
Created On  
Modified On  
  CRM Contact Notes ClientContactID  
Created On  
Modified On  
  CRM Activity Notes Id  
Modified On  
Created On  
  CRM Opportunity Notes Id  
Modified On  
Created On  
  CRM Sites pkSiteID  
  HR User Activities UserId  
  CRM Linked Accounts AccountId  
fkLinkedAccountId  
  Service Desk KnowledgeBase ArticleId  
Modified On  
Created On  
  HR Employee Address UserId  
  Inventory Products ProductIndexId  
Modified On  
Created On  
  Inventory Product Supplier Product Supplier ID  
Modified On  
Created On  
  Inventory Product Components pkProductIndex  
  Inventory Product Location pkProductIndexLocationId  
  Inventory Purchase Order PO ID  
Modified On  
Created On  
PO Date  
Expected Date  
  Inventory Purchase Order charges PO Charge Id  
Modified On  
Created On  
Applied Date  
  Inventory Purchase Order Items PO Item Id  
Modified On  
Created On  
  Inventory Receiving Order RO ID  
Modified On  
Created On  
  Inventory Receiving Order Items RO Item Id  
Modified On  
Expiry Date  
  Inventory Receiving Order Notes pkRemarkId  
Modified On  
Created On  
  Inventory Sales Order SO ID  
PO Date  
Created On  
Modified On  
  Inventory Sales Order Items SO Item ID  
Modified On  
Created On  
  Inventory Sales Order Inventory Items SO Item Id  
Created On  
Modified On  
  Inventory Sales Order Notes pkRemarkId  
Modified On  
Created On  
Release Notes BMS & Vorex 5.6.0 Oct 2021 Inventory Delivery Product Charge Asset Type  
  Finance Payments Details Payment Details ID  
Modified On  
Created On  
  Finance Payments PaymentId  
Created On  
Modified On  
  Inventory Delivery Product Charge Product Charge ID  
Created On  
Modified On  
  Projects Project Charge Product Charge ID  
Modified On  
Created On  
  Service Desk Ticket Charge Product Charge ID  
Created On  
Modified On  
  Service Desk Hardware Assets PhysicalId  
Modified On  
Created On  
  Service Desk Tickets Hardware Assets PhysicalId  
Created On  
Modified On  
  Service Desk Software Assets SoftwareId  
Modified On  
Created On  
  Service Desk Tickets Software Assets SoftwareId  
Created On  
Modified On  
  Service Desk TO DO ToDoId  
Created On  
Modified On  
Due Date  
  Expenses Expense Sheet Approval History HistoryId  
  Service Desk Service Calls ServiceCallID  
Modified On  
Created On  
  Projects Project Charge Delivery Details ProductChargeDeliveryHistory ID  
Created On  
  Service Desk Ticket Charge Delivery Details ProductChargeDeliveryHistory ID  
Created On  
  Inventory Product Availability pkProductIndexId  
  Finance Recurring Services Contract P&L ContractId  
FromDate  
ToDate  
  Service Desk Ticket Survey Scores pkTicketScoreHistoryId  
  Finance Invoice Design Header InvoiceId  
  Finance Invoice Design Detail DetailId  
  CRM Service Quotation Design Header QuotationId  
  CRM Service Quotation Design Detail LineItemId  
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us