FastTrack360 Version 12 Online Help

Database Schema Changes V12.20p2

Owned by Fiona Sims
Last updated: 12 January 2024
1 min read

To support this release changes have been made to the database schema. These changes may have an impact on reports that have been created using custom queries.

It is important to check your custom reports prior to upgrade to ensure they are working as expected. If you find any issues with data, the information below should assist you to make any changes required.

Table

Field

Action

Comment/Extended Property Description

[FO].[CacheReportDesigner]

ReportString

Data Type Change

Changed from VARBINARY (MAX) NOT NULL to VARBINARY (MAX) NULL

[dbo].[DebtorInvoiceLinkOrderReference]

 

Table Added

 

[dbo].[InvoiceHeader]

CustomerName

Length Change

Increased length from NVARCHAR (50)  to NVARCHAR (100)

Classification-Public