FastTrack360 Version 12 Online Help
Database Schema Changes V12.23
- Fiona Sims
The table below identifies all other database schema changes that have been made to support this release. 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/Extendend Property Description |
[dbo].[InvoiceItemBillingFee] | [PayResultId] | Added | INTÂ Â Â Â Â Â Â Â Â Â Â Â NULL |
[dbo].[InvoiceItemBillingFee] | [PayTotal] | Added | NUMERIC (38, 6) NULL |
[FI].[GenericMYOBDebtorExports] | CardStatus | Updated | NVARCHAR (1) -> NVARCHAR (255) |
[FI].[GenericMYOBSaleExports] | [Inclusive] | Updated | NVARCHAR (1) -> NVARCHAR (255) |
[FI].[GenericMYOBSaleExports] | [DeliveryStatus] | Updated | NVARCHAR (1) -> NVARCHAR (255) |
[FI].[GenericMYOBSaleExports] | [Description] | Updated | NVARCHAR (255) -> NVARCHAR (1000) |
[FI].[GenericMYOBSaleExports] | [AccountNo] | Updated | NVARCHAR (6) -> NVARCHAR (10) |
[FI].[GenericMYOBWageExports] | [AccountNumber] | Updated | NVARCHAR (6) -> NVARCHAR (50) |
[FI].[GenericMYOBWageExports] | [Job] | Updated | NVARCHAR (1) -> NVARCHAR (255) |
[FI].[GenericMYOBWageExports] | [Category] | Updated | NVARCHAR (1) -> NVARCHAR (255) |
[FI].[GenericMYOBWageExports] | [IsYearEndAdjustment] | Updated | NVARCHAR (1) -> NVARCHAR (255) |
[FO].[Candidates] | [IsPIIDataAnonymised]Â Â | Added | BITÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â NULL |
[FO].[Comments] | CommentTypeId | Updated | Extended proprty updated |
[dbo].[ProcessQueue] | ProcessStatus | Updated | Extended proprty updated |
[dbo].[ProcessQueue] | QueueItemType | Updated | Extended proprty updated |
[FO].[CustomExitPoints] | [URL] | Updated | NVARCHAR (255) -> NVARCHAR (2000) |
[FO].[GeneralSettings] | [FrontOfficeIntegrationType] | Added | TINYINTÂ Â Â Â Â Â Â Â NULL |
[FO].[MasterConfigurations] | MasterCode | Updated | Extended proprty updated |
[FO].[AnonymisationBatchCandidates] | Â | New Table Added | Â |
[FO].[AnonymisationBatches] | Â | New Table Added | Â |
[FO].[Marketplaces] | Â | New Table Added | Â |
[FO].[VincereIntegrationSettings] | Â | New Table Added | Â |
[FO].[VincereIntegrationTenant] | Â | New Table Added | Â |
Classification-Public