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 PSA 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 PSA 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?