/
Database Schema Changes - VAT/GST Adjustments

FastTrack360 Version 12 Online Help

Database Schema Changes - VAT/GST Adjustments

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.

Database

Table

Field

Action

Comment

Release

Database

Table

Field

Action

Comment

Release

FastTrack_Audit

[rar].[PayCompany]

IsConsumptionTaxAdjustmentsOnSeparatePayslip

Field Added

 

 

FastTrack

[rar].[PayCompany]

IsConsumptionTaxAdjustmentsOnSeparatePayslip

Field Added

 

 

FastTrack

[rar].[PayeePayrollAustralia]

GSTRegistrationDate

Field Added

 

 

FastTrack

[rar].[PayeePayrollAustralia]

GSTDeRegistrationDate

Field Added

 

 

FastTrack

[rar].[PayeePayrollNewZealand]

GSTRegistrationDate

Field Added

 

 

FastTrack

[rar].[PayeePayrollNewZealand]

GSTDeRegistrationDate

Field Added

 

 

FastTrack

[rar].[PayeePayrollUK]

GSTRegistrationDate

Field Added

 

 

FastTrack

[rar].[PayeePayrollUK]

GSTDeRegistrationDate

Field Added

 

 

FastTrack

[rar].[PayeePayrollGrossPay]

GSTRegistrationDate

Field Added

 

 

FastTrack

[rar].[PayeePayrollGrossPay]

GSTDeRegistrationDate

Field Added

 

 

FastTrack

[rar].[GrossWageBatchPayee_History]

ConsumptionTaxAdjustment

Field Added

 

 

FastTrack

[rar].[GrossWageBatchPayee_History]

ConsumptionTaxAdjustmentReason

Field Added

 

 

FastTrack

[rar].[GrossWageBatchPayslipPayee]

SelfBillInvoiceType

Field Added

 

 

FastTrack

[rar].[GrossWageBatchPayee]

ConsumptionTaxAdjustment

Field Added

 

 

FastTrack

[rar].[GrossWageBatchPayee]

ConsumptionTaxAdjustmentReason

Field Added

 

 

Classification-Public