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