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 |