2021 - March Release

The next Data Direct release is scheduled for the end of March. Below is the list of updates.

 Features and improvements

All changes in this release are additive. We are not removing any columns or tables, so there should be minimal impact on your side.

  1. Invoicing fields: Below invoice fields that have long been available on the platform are now coming to Data Direct to give you greater control over your data. Note that the format below is: existing table name "." the new field name.
    • workorders.glCode - gl Code or Approval code can be available before the invoice is created, we're adding it to the work order as well.
    • invoices.approvedBy - User that approved the invoice, as can be see on the platform UI.
    • invoices.approvedDate - Date when the invoice was approved, as seen on the platform UI.
    • invoices.approvedDateDto - Date when the invoice was approved with date time offset.
    • invoices.lastPaymentDate - When the invoice was paid, as seen on the platform UI.
    • invoices.lastPaymentDateDto - When the invoice was paid with the date time offset.
    • invoices.postedDateDto - When the invoice was posted, as seen on the platform UI.
    • invoices.createdDateDto -When the invoice was posted with date time offset.
    • invoices.transferredDateDto - When the invoice was transferred with date time offset.

The above changes are described in the latest ERD diagram.