Database Schemas

Appointments

Attachments

Checklists

Custom Fields

Device Logins

Disbursements

Knowledge Base

Measurable Transaction

Narrations

Portal

Queues

Reports

Rosters

Scheduled Events

Tasks

Time Entries

Users

Work Groups

MYOB Exo database changes in 25.1:

DR_ACCS:

ADD X_TT_State nvarchar(100) NULL
ADD X_TT_DelState nvarchar(100) NULL
ADD X_TT_Country nvarchar(100) NULL
ADD X_TT_DelCountry nvarchar(100) NULL

CONTACTS:

ADD X_TT_State nvarchar(100) NULL
ADD X_TT_DelState nvarchar(100) NULL
ADD X_TT_Country nvarchar(100) NULL
ADD X_TT_DelCountry nvarchar(100) NULL

JOBCOST_HDR:

ADD X_TT_DelState nvarchar(100) NULL
ADD X_TT_DelCountry nvarchar(100) NULL

SU_MAIN:

ADD X_TT_DefaultLocation nvarchar(50) NULL
ADD X_TT_State nvarchar(100) NULL
ADD X_TT_Country nvarchar(100) NULL
ADD X_TT_BarCode nvarchar(200) NULL
ADD X_TT_SupplierWarranty int NOT NULL DEFAULT (0)
ADD X_TT_SupplierWarrantyType nvarchar(50) NOT NULL DEFAULT (‘Months’)

TimeTrak database changes in 25.1:

KbArticles:

ADD [Markdown] NVARCHAR(MAX) NULL

Time Analyses:

ADD [EntitlementId] nvarchar(50) NOT NULL CONSTRAINT [DF_TimeAnalyses_EntitlementId] DEFAULT (”)

Activities:

ADD [SmsMessageId] [uniqueidentifier] NULL

Appointments:

ADD [ConfirmationId] [uniqueidentifier] NULL