...
Table | Field | Action | Comment / Extended Property Description | Release | ||||||
[FO].[JobOrders] | [JobOrderDescription] | Updated | NVARCHAR (3000) -> NVARCHAR (MAX) | V12.22rar].[NationalMinimumWagePeriodsUK] | Deleted | This table has been renamed to be generic for all countries to [rar].[NationalMinimumWagePeriods] | ||||
[rar].[NationalMinimumWageRatesUK] | Deleted | This table has been renamed to be generic for all countries to [rar].[NationalMinimumWageRates] | ||||||||
[dbo].[CreditRebill] | Status_no | Changed | Extended property description changed to include new enum values | |||||||
[dbo].[ManualItem] | BillRate | Added | ||||||||
[dbo].[ManualItem] | IsSupersededRate | Added | ||||||||
[dbo].[PortalTokenParameter] | ParameterValue | Changed | Increased length from 2,000 to 4,000 | |||||||
[dbo].[ProcessVerificationReasonCodes] | SubProcessTypeNo | Changed | Extended property description changed to include new enum values | |||||||
[dbo].[TimesheetHeader] | AltTimesheetId | Added | ||||||||
[dbo].[TimesheetImportBatches] | GroupField | Added | ||||||||
[dbo].[TimesheetImportBatchRawData] | TimesheetAltNo | Added | ||||||||
[dbo].[TimesheetImportBatchRawData] | BillCodeImportCode | Added | ||||||||
[dbo].[TimesheetImportBatchRawData] | BillRate | Added | ||||||||
[dbo].[TimesheetImportBatchRawData] | BillCodeName | Added | ||||||||
[dbo].[TimesheetImportTemplates] | GroupField | Added | ||||||||
[FO].[Clients] | IsAdjustmentOnly | Added | ||||||||
[FO].[Countries] | IsNationalMinimumWageEnabled | Added | ||||||||
[FO].[Countries] | NMWLabel | Added | ||||||||
[FO].[Countries] | NMWExcludedPayeeTypes | Added | ||||||||
[FO].[GeneralSettings] | FrontOfficeIntegrationType | Added | ||||||||
[FO].[JobOrders] | IsAdjustmentOnly | Added | ||||||||
[FO].[JobOrders] | AdvertiseDescription] | Updated | NVARCHAR (3000) -> NVARCHAR (MAX) | V12.22Changed | Increased length from 3,000 to MAX | |||||
[FO].[JobOrders] | JobOrderDescription | Changed | Increased length from 3,000 to MAX | |||||||
[FO].[JobTemplates] | [JobOrderDescription] | Updated | NVARCHAR (3000) -> NVARCHAR (MAX) | V12.22Changed | Increased length from 3,000 to MAX | |||||
[FO].[JobTemplates] | AdvertiseDescription | Changed | Increased length from 3,000 to MAX | |||||||
[FO].[JobTemplates] | IsAdjustmentOnly | [AdvertiseDescriptionAdded | ||||||||
[rar].[BillResult] | Updated | NVARCHAR (3000) -> NVARCHAR (MAX) | V12.22IsSupersededRate | Added | ||||||
[rar].[DeductionHeader] | IsAffectsNMW | Added | ||||||||
[rar].[GrossWageBatchPayslipDeduction] | AccountReference | [AccountReference] | Added | NVARCHAR (50) NULL | V12.22Added | |||||
[rar].[LeaveAccrualRule] | LeaveRateType_Id | Added | ||||||||
[rar].[LeaveTransaction] | RateTotalPay | Added | ||||||||
[rar].[LeaveTransaction] | RateTotalQuantity | Added | ||||||||
[rar].[LeaveTransactionGrossWageBatch] | RateTotalPay | Added | ||||||||
[rar].[LeaveTransactionGrossWageBatch] | RateTotalQuantity | Added | ||||||||
[rar].[PayCodePayroll] | IsNMWBaseRate | Added | ||||||||
[rar].[PayCodePayroll] | IsIncludedInNMWDetermination | Added | ||||||||
[rar].[PayCodePayrollAU] | STPPaidLeaveType | Changed | Extended property description changed to include new enum values | |||||||
[rar].[PayCodePayrollUK] | IsSalarySacrifice | Added | ||||||||
[rar].[PayeePayrollAustralia] | FlatRateCIRValue | Changed | Extended property description changed | |||||||
[rar].[PayeePayrollAustralia] | IsCIRApplied | Changed | Extended property description changed | |||||||
[rar].[PayResult] | IsSupersededRate | Added | ||||||||
[rar].[PensionManagementBatch] | DataRetrievalFromDate | Added | ||||||||
[rar].[PensionManagementBatch] | DataRetrievalToDate | Added | ||||||||
[rar].[PensionProviderOutputTypes] | PensionProviderOutputTypeFormat | Changed | Extended property description changed | |||||||
[dbo].[ProcessVerificationReasonsHistory] | Table Added | |||||||||
[FI].[ExportFileFormats] | Table Added | |||||||||
[FI].[GenericAccessFinancialsSaleExports] | Table Added | |||||||||
[FI].[GenericAccessFinancialsWageExports] | Table Added | |||||||||
[FI].[GenericAccountMaintenanceOptions] | Table Added | |||||||||
[FI].[GenericAccountMaintenanceTemplates] | Table Added | |||||||||
[FI].[GenericFieldMaintenanceOptions] | Table Added | |||||||||
[FI].[GenericFieldMaintenanceTemplates] | Table Added | |||||||||
[FI].[GenericFISystems] | Table Added | |||||||||
[FI].[GenericMasterSettings] | Table Added | |||||||||
[FI].[GenericMYOBDebtorExports] | Table Added | |||||||||
[FI].[GenericMYOBSaleExports] | Table Added | |||||||||
[FI].[GenericMYOBWageExports] | Table Added | |||||||||
[FI].[GenericPerformanceLogs] | Table Added | |||||||||
[FI].[GenericSageSaleExports] | Table Added | |||||||||
[FI].[GenericSageWageExports] | Table Added | |||||||||
[FI].[GenericTemplates] | Table Added | |||||||||
[FI].[GenericWageGroupingTemplates] | Table Added | |||||||||
[FI].[GenericWageItemTypeTemplates] | Table Added | |||||||||
[FI].[GenericXERODebtorExports] | Table Added | |||||||||
[FI].[GenericXEROSaleExports] | Table Added | |||||||||
[FI].[GenericXEROWageExports] | Table Added | |||||||||
[FO].[VincereIntegrationSettings] | Table Added | |||||||||
[FO].[VincereIntegrationTenant] | Table Added | |||||||||
[rar].[NationalMinimumWageGrossWageBatch] | Table Added | |||||||||
[rar].[NationalMinimumWageGrossWageBatchHistory] | Table Added | |||||||||
[rar].[NationalMinimumWagePeriods] | Table Added | This table was originally named [rar].[NationalMinimumWagePeriodsUK] | ||||||||
[rar].[NationalMinimumWageRates] | Table Added | This table was originally named [rar].[NationalMinimumWageRatesUK] | ||||||||
[rar].[PensionManagementBatchItemImports] | Table Added |