Database Schema Changes (12.16P1)

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

Table	Field	Action	Comment
DocumentNotificationTemplate	FromEmail	Changed	Length increased to 255
fttsheettemp	Username	Added
fttsheettemp	ExpiredDateTime	Added
FO.Candidates	InterviewTime	Added
FO.GeneralSettings	SMSCharacterLimit	Added
FO.JobOrders	PayeeTaxTypeId	Renamed to [PayeeTypeTaxTypeNo]
rar.GrossWageBatchPayee	ConsumptionTaxAdjustment	Added
rar.GrossWageBatchPayee	ConsumptionTaxAdjustmentReason	Added
rar.GrossWageBatchPayee_History	ConsumptionTaxAdjustment	Added
rar.GrossWageBatchPayee_History	ConsumptionTaxAdjustmentReason	Added
rar.GrossWageBatchPayslipPayee	SelfBillInvoiceType	Added
rar.GrossWageBatchPayslipPayee	ConsumptionTaxAdjustmentYTD	Added
rar.NationalInsuranceRatesUK	NationalInsurancePeriodUKId	Added
rar.PayCompany	IsConsumptionTaxAdjustmentsOnSeparatePayslip	Added
rar.PayeeHeaderPayroll	PayeeTypeNZNo	Added
rar.PayeeHeaderPayroll	GrossPayPayeeTypeNo	Added
rar.PayeePayrollAustralia	GSTRegistrationDate	Added
rar.PayeePayrollAustralia	GSTDeRegistrationDate	Added
rar.PayeePayrollGrossPay	TaxRegistrationDate	Added
rar.PayeePayrollGrossPay	TaxDeRegistrationDate	Added
rar.PayeePayrollNewZealand	GSTRegistrationDate	Added
rar.PayeePayrollNewZealand	GSTDeRegistrationDate	Added
rar.PayeePayrollUK	VATRegistrationDate	Added
rar.PayeePayrollUK	VATDeRegistrationDate	Added
rar.Suppliers	ProformaRemittanceDocumentNotificationTemplateId	Added

FastTrack360 Online Help

Database Schema Changes (12.16P1)

Analytics

Related content