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:

BRANCHES:

ADD X_TT_IsActive char(1) NOT NULL DEFAULT (‘Y’)

JOBCOST_HDR:

ADD X_TT_ProjectGroup nvarchar(100) NULL
ADD X_TT_AllowTimeEntries char(1) NOT NULL DEFAULT (‘Y’)
ADD X_TT_AllowDisbursements char(1) NOT NULL DEFAULT (‘Y’)
ADD X_TT_AllowTravelFees char(1) NOT NULL DEFAULT (‘Y’)
ADD X_TT_AllowAllowances char(1) NOT NULL DEFAULT (‘Y’)
ADD X_TT_AllowPurchaseOrders char(1) NOT NULL DEFAULT (‘Y’)
ADD X_TT_AllowEquipmentTimeEntries char(1) NOT NULL DEFAULT (‘Y’)

TimeTrak database changes in 25.1:

Attachments:

ADD [LinkGuid] UNIQUEIDENTIFIER NULL;

Tasks:

ADD [AllowDisbursements] bit NOT NULL DEFAULT (1)
ADD [AllowTravelFees] bit NOT NULL DEFAULT (1)
ADD [AllowAllowances] bit NOT NULL DEFAULT (1)
ADD [AllowPurchaseOrders] bit NOT NULL DEFAULT (1)
ADD [AllowEquipmentTimeEntries] bit NOT NULL DEFAULT (1)
ADD [TemplateId] int NOT NULL DEFAULT (0)

Activities:

ADD [SourceGuid] UNIQUEIDENTIFIER NULL
ADD [LinkGuid] UNIQUEIDENTIFIER NUL

Users:

ADD [LastLoginUtc] DATETIME2(0) NULL

Notifications:

ADD [LinkGuid] UNIQUEIDENTIFIER NULL