The next Data Direct release is scheduled for the end of June 2021. Below is the list of updates.
Features and improvements
- Data Direct Homepage! As we continue to enhance our product, please keep an eye for the latest changes to the ERD and data dictionary on our new Data Direct homepage.
- Completion Date Field (workorders.completiondate) - The completion date field will only be populated once the work order is in completed status, previously it could also have a work date before completion. This is aligned with the analytics platform and simplifies the logic.
- Invoices Table Enhancements. Additional data fields will now be available.
- invoices.comments - comments that are currently available on the invoiced WO data download
- invoices.lastPaymentNumber - The last payment number on this invoice
- Invoices.paymentAmount - Payment amount
- invoices.paymentDate - The last payment date
- invoices.paymentBy - Who is on record for payment
- invoices.postedBy - Who is on record for posting this invoice
- wo_history_change_status Table Enhancements. CreatedbyUserID column will now be available which allows you to more reliably determine who introduced the status change.
- workorders Table Enhancements. UseridUpdatedBy column has been added, which can be joined with the users' table to determine who made the last work order change.
- proposal_status_history additional historical data. Previously Open Status was not made available in this table for newly created proposals, now it is added at creation along with all other status changes.
The above changes are described in the latest ERD diagram.