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 |