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 |