...
Table | Field | Action | Comment | Release |
|---|---|---|---|---|
[dbo].[Address] | PostCode | Field Changed | Field Length changed to 50 | 12.10 |
[dbo].[Address] | AddressLine3 | Field Added | 12.10 | |
[dbo].[AlertTemplate] | AlertType | Field Changed | Field Name changed from AlertTypeId | 12.10 |
[dbo].[AlertTemplate] | DeliveryMethodType | Field Changed | Field Name changed from DeliveryMethodTypeId | 12.10 |
[dbo].[AlertTemplateStaff] | AlertStaffType | Field Changed | Field Name changed fom AlertStaffTypeId | 12.10 |
[dbo].[AQLog] | Table Deleted | Table Deleted | 12.10 | |
[dbo].[BillingCompany] | ContactPhone | Field Changed | Field Length changed to 50 | 12.10 |
[dbo].[BillingCompanyOfficeLink] | BillingCompanyOfficeLink_id | Field Added | 12.10 | |
[dbo].[CIS300Headers] | Table Added | Table Added | 12.10 | |
[dbo].[CIS300Subcontractors] | Table Added | Table Added | 12.10 | |
[dbo].[CISVerifications] | Table Added | Table Added | 12.10 | |
[dbo].[Debtor] | CorporateIdentityNumber | Field Changed | Changed from Not Null to Null | 12.10 |
[dbo].[DebtorInvoiceLink] | InvoiceBillCodeGroupId | Field Added | 12.10 | |
[dbo].[DocumentFormat] | EffectiveFromDate | Field Added | 12.10 | |
[dbo].[DocumentFormatComponentDataItem] | RoundingItem | Field Changed | Changed from Null to Not Null | 12.10 |
[dbo].[DocumentFormatComponentDataItem] | IsMultiCurrencyField | Field Added | 12.10 | |
[dbo].[DocumentFormatComponentDataItem_History] | RoundingItem | Field Changed | Changed from Null to Not Null | 12.10 |
[dbo].[DocumentFormatComponentDataItem_History] | IsMultiCurrencyField | Field Added | 12.10 | |
[dbo].[DocumentFormatComponentTableItem] | Type_no | Field Deleted | Field Deleted | 12.10 |
[dbo].[DocumentFormatComponentTableItem_History] | Type_no | Field Deleted | Field Deleted | 12.10 |
[dbo].[DocumentNotificationTemplate] | PayslipTypeNo | Field Added | 12.10 | |
[dbo].[EmailTemplate] | OfficeCode | Field Changed | Field Name changed from Office_id | 12.10 |
[dbo].[EPSBatchChildRelatedPaymentDetailIs] | Table Added | Table Added | 12.10 | |
[dbo].[EPSBatches] | Table Added | Table Added | 12.10 | |
[dbo].[EPSStateAidSectorsUK] | Table Added | Table Added | 12.10 | |
[dbo].[FPSHeaders] | Table Added | Table Added | 12.10 | |
[dbo].[FPSPayeeCars] | Table Added | Table Added | 12.10 | |
[dbo].[FPSPayees] | Table Added | Table Added | 12.10 | |
[dbo].[FPSPayeesNationalInsurance] | Table Added | Table Added | 12.10 | |
[dbo].[HMRCEventValidations] | Table Added | Table Added | 12.10 | |
[dbo].[HMRCFormsAudit] | Table Added | Table Added | 12.10 | |
[dbo].[HMRCFormsAuditDetails] | Table Added | Table Added | 12.10 | |
[dbo].[HMRCFormsAuditFieldMappings] | Table Added | Table Added | 12.10 | |
[dbo].[HMRCFormsEntityAudit] | Table Added | Table Added | 12.10 | |
[dbo].[HMRCFormsEntityAuditDetails] | Table Added | Table Added | 12.10 | |
[dbo].[HMRCIncomingMessages] | Table Added | Table Added | 12.10 | |
[dbo].[HMRCIncomingMessagesCISVerfications] | Table Added | Table Added | 12.10 | |
[dbo].[HMRCOutgoingMessagePolling] | Table Added | Table Added | 12.10 | |
[dbo].[HMRCOutgoingMessages] | Table Added | Table Added | 12.10 | |
[dbo].[IncomingGovernmentFormsBatches] | Table Added | Table Added | 12.10 | |
[dbo].[IncomingGovernmentFormsWaterMarksUK] | Table Added | Table Added | 12.10 | |
[dbo].[InvoiceBillCodeGroup] | Table Added | Table Added | 12.10 | |
[dbo].[InvoiceBillCodeGroupGrouping] | Table Added | Table Added | 12.10 | |
[dbo].[InvoiceBillCodeGroupGroupingBillCode] | Table Added | Table Added | 12.10 | |
[dbo].[InvoiceHeader] | DebtorCurrencyCodeId | Field Added | 12.10 | |
[dbo].[InvoiceHeader] | CurrencyConversionRate | Field Added | 12.10 | |
[dbo].[InvoiceHeader] | CurrencyConversionDate | Field Added | 12.10 | |
[dbo].[InvoiceHeader] | InvoiceSubTotalInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceHeader] | InvoiceTotalInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceHeader] | BalanceDueInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceHeader] | InvoiceFeeInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceHeader] | DebtorCorporateIdentityNumber | Field Changed | Changed from Not Null to Null | 12.10 |
[dbo].[InvoiceHeaderTaxation] | TotalInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceItem] | CostInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceItem] | RateInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceItem] | ItemSubTotalInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceItem] | ItemTaxTotalInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceItem] | ItemBillingFeeTotalInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceItem] | ItemTotalInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceItem] | ItemBillingFeeTaxTotalInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceItem] | ItemSubTaxTotalInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceItemBillingFee] | TotalInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceItemBillingFeeTaxation] | TotalInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceItemTaxation] | TotalInDebtorCurrency | Field Added | 12.10 | |
[dbo].[InvoiceTaxation] | TotalInDebtorCurrency | Field Added | 12.10 | |
[dbo].[ManageGridLayout] | Table Added | Table Added | 12.10 | |
[dbo].[ManualItem] | OriginCurrencyCodeId | Field Added | Field Added | 12.10 |
[dbo].[ManualItem] | OriginRate | Field Added | Field Added | 12.10 |
[dbo].[ManualItem] | CurrencyConversionRate | Field Added | Field Added | 12.10 |
[dbo].[PlugInConfiguration] | Table Added | Table Added | 12.10 | |
[dbo].[PlugInConfigurationEFT] | Table Added | Table Added | 12.10 | |
[dbo].[PortalCountrySetting] | Table Deleted | Table Deleted | 12.10 | |
[dbo].[PortalCountrySettingStandardRateBillType] | Table Deleted | Table Deleted | 12.10 | |
[dbo].[PortalMessage] | Table Deleted | Table Deleted | 12.10 | |
[dbo].[ProcessVerificationReasonCodes] | Table Added | Table Added | 12.10 | |
[dbo].[ProcessVerificationReasons] | Table Added | Table Added | 12.10 | |
[dbo].[ThirdPartyCommunicationLogs] | HTTPRequestText | Field Added | Field Added | 12.10 |
[dbo].[ThirdPartyCommunicationLogs] | HTTPResponseText | Field Added | Field Added | 12.10 |
[dbo].[TimesheetImportBatch] | Table Deleted | Table Deleted | 12.10 | |
[dbo].[TimesheetImportBatchRawData] | ProjectCode1 | Field Changed | Changed from Varchar to Nvarchar | 12.10 |
[FI].[DebtorsExports] | DebtorCurrencyCode | Table Added | Table Added | 12.10 |
[FI].[SalesExports] | DebtorCurrencyCode | Field Added | Field Added | 12.10 |
[FI].[SalesExports] | ExchangeRate | Field Added | Field Added | 12.10 |
[FI].[SalesExports] | CurrencyInvoiceTotal | Field Added | Field Added | 12.10 |
[FI].[SalesExports] | CurrencyInvoiceTotalIncTax | Field Added | Field Added | 12.10 |
[FI].[SalesExports] | CurrencyTaxTotal | Field Added | Field Added | 12.10 |
[FI].[SalesExports] | CurrencyBillAmount | Field Added | Field Added | 12.10 |
[FI].[SalesExports] | CurrencyTaxAmount | Field Added | Field Added | 12.10 |
[FO].[Addresses] | AddressLineThree | Field Added | Field Added | 12.10 |
[FO].[Addresses] | LegacySystemId | Field Changed | Changed from LegacySystemID | 12.10 |
[FO].[ApiUserDomains] | Table Deleted | Table Deleted | 12.10 | |
[FO].[ApplicationRules] | Table Deleted | Table Deleted | 12.10 | |
[FO].[ApplicationTimezones] | SortOrder | Field Added | Field Added | 12.10 |
[FO].[Attachments] | Table Deleted | Table Deleted | 12.10 | |
[FO].[CacheKeys] | Table Added | Table Added | 12.10 | |
[FO].[Candidates] | PassportNumber | Field Added | Field Added | 12.10 |
[FO].[CandidateWorkReferences] | LegacySystemId | Field Changed | Change from LegacySystemID | 12.10 |
[FO].[Countries] | Currency | Field Deleted | Field Deleted | 12.10 |
[FO].[Countries] | CurrencySymbol | Field Deleted | Field Deleted | 12.10 |
[FO].[Countries] | CurrencySample | Field Deleted | Field Deleted | 12.10 |
[FO].[Countries] | DisplayPayeeMailingAddress | Field Added | Field Added | 12.10 |
[FO].[Countries] | SocialSecurityNumberLabel | Field Added | Field Added | 12.10 |
[FO].[Countries] | SocialSecurityNumberFormat | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsReimbursement | Field Added | Field Added | 12.10 |
[FO].[Countries] | GstLabel | Field Added | Field Added | 12.10 |
[FO].[Countries] | OnlyIncludeTimesheetsWithinCurrentPeriod | Field Added | Field Added | 12.10 |
[FO].[Countries] | MarginMarkupType | Field Added | Field Added | 12.10 |
[FO].[Countries] | PayOncostsEnabled | Field Added | Field Added | 12.10 |
[FO].[Countries] | StandardRateRoundingType | Field Added | Field Added | 12.10 |
[FO].[Countries] | StandardRateRoundingPrecision | Field Added | Field Added | 12.10 |
[FO].[Countries] | MarginOncostType | Field Added | Field Added | 12.10 |
[FO].[Countries] | InterpreterReviewSearchLimit | Field Added | Field Added | 12.10 |
[FO].[Countries] | SuperStreamEnabled | Field Added | Field Added | 12.10 |
[FO].[Countries] | DefaultPayeeTaxType | Field Added | Field Added | 12.10 |
[FO].[Countries] | LastLeaveService_date | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsLeaveOccurrenceBasedAvailable | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsLeaveCalculateWithSpecificFormulaAvailable | Field Added | Field Added | 12.10 |
[FO].[Countries] | GenerateEOFYStatementForPaymentSummaryType | Field Added | Field Added | 12.10 |
[FO].[Countries] | BillRateType | Field Added | Field Added | 12.10 |
[FO].[Countries] | BackOfficeId | Field Added | Field Added | 12.10 |
[FO].[Countries] | PayDocumentDeliveryType | Field Added | Field Added | 12.10 |
[FO].[Countries] | CurrencyCodeId | Field Added | Field Added | 12.10 |
[FO].[Countries] | EnableMultiCurrency | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsGrossPayPayroll | Field Added | Field Added | 12.10 |
[FO].[Countries] | EarningsYearEndDateMonth | Field Added | Field Added | 12.10 |
[FO].[Countries] | EarningsYearEndDateDay | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsReimbursementTaxHiddenOnTimesheets | Field Added | Field Added | 12.10 |
[FO].[Countries] | ReimbursementNetLabel | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsDeductionNetComponentEnabled | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsEnforceOnDebtorCorporateIdentityNumberFormat | Field Added | Field Added | 12.10 |
[FO].[Countries] | AdditionalRARGroupingName | Field Added | Field Added | 12.10 |
[FO].[Countries] | RateMinimumLabel | Field Added | Field Added | 12.10 |
[FO].[Countries] | EnableRateMinimum | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsCustomLeaveBalanceOnPayslip | Field Added | Field Added | 12.10 |
[FO].[Countries] | EnableAdditionalRARGrouping | Field Added | Field Added | 12.10 |
[FO].[CountryGenderTypeMappings] | Table Added | Table Added | 12.10 | |
[FO].[CountryLabelMaster] | Address3Label | Field Added | Field Added | 12.10 |
[FO].[CountryLabelMaster] | DisplayAddress3 | Field Added | Field Added | 12.10 |
[FO].[CustomFieldMappings] | IsForInvoice | Field Added | Field Added | 12.10 |
[FO].[CustomFields] | CountryId | Field Added | Field Added | 12.10 |
[FO].[CustomFields] | IsMandatory | Field Added | Field Added | 12.10 |
[FO].[CustomFields] | BackOfficeId | Field Added | Field Added | 12.10 |
[FO].[CustomFields] | IsLocked | Field Added | Field Added | 12.10 |
[FO].[EntityLocks] | UserId | Field Changed | Changed from Null to Not Null | 12.10 |
[FO].[GeneralSettings] | IntegrationUserId | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | IntegrationUserPassword | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | IntegrationNotificationEmailAddress | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | IntegrationNotificationFromEmailAddress | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | BackOfficeId | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckSuburb | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckCity | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckState | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckCountry | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckEmail | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckMobilePhone | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckFirstName | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckSurName | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckSocialSecurityNumber | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | LastKeywordUploadDateTime | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | DuplicateCandidateOptions | Field Added | Field Added | 12.10 |
[FO].[IntegrationCentres] | Table Deleted | Table Deleted | 12.10 | |
[FO].[LayoutFieldSettings] | Table Deleted | Table Deleted | 12.10 | |
[FO].[ObjectTranslations] | Table Deleted | Table Deleted | 12.10 | |
[FO].[Offices] | PayslipMessage | Field Added | Field Added | 12.10 |
[FO].[PasswordPolicy] | ForcePasswordUppercase | Field Added | Field Added | 12.10 |
[FO].[PasswordPolicy] | ForcePasswordSymbol | Field Added | Field Added | 12.10 |
[FO].[PasswordPolicy] | UniquePasswordLimit | Field Added | Field Added | 12.10 |
[FO].[Permissions] | ModuleId | Field Added | Field Added | 12.10 |
[FO].[Permissions] | PermissionItemId | Field Added | Field Added | 12.10 |
[FO].[Reasons] | Description | Field Added | Field Added | 12.10 |
[FO].[Reasons] | Country_id | Field Added | Field Added | 12.10 |
[FO].[Reasons] | ValidityStart_date | Field Added | Field Added | 12.10 |
[FO].[Reasons] | Default_flag | Field Added | Field Added | 12.10 |
[FO].[Reasons] | ValidityEnd_date | Field Added | Field Added | 12.10 |
[FO].[Reasons] | BackOfficeId | Field Added | Field Added | 12.10 |
[FO].[SystemCountries] | CurrencyCodeId | Field Added | Field Added | 12.10 |
[FO].[SystemCountries] | Currency | Field Deleted | Field Deleted | 12.10 |
[FO].[SystemCountries] | CurrencySymbol | Field Deleted | Field Deleted | 12.10 |
[FO].[SystemCountries] | CurrencySample | Field Deleted | Field Deleted | 12.10 |
[FO].[UserNetworkPerformance] | Table Added | Table Added | 12.10 | |
[FO].[UserPasswordHistory] | Table Added | Table Added | 12.10 | |
[FO].[Users] | MoBoExperienceId | Field Added | Field Added | 12.10 |
[FO].[UserSettings] | DefaultPayCountryId | Field Added | Field Added | 12.10 |
[rar].[AEODeductionRatesUK] | Table Added | Table Added | 12.10 | |
[rar].[AEODeductionRateTypesUK] | Table Added | Table Added | 12.10 | |
[rar].[ApprenticeshipLevyTransactions] | Table Added | Table Added | 12.10 | |
[rar].[ApprenticeshipLevyTransactionsGrossWageBatch] | Table Added | Table Added | 12.10 | |
[rar].[BankAccount] | BSBNumber | Field Changed | Field Length Change from 7 to 10 and Data Type changed from NVARCHAR to VARCHAR | 12.10 |
[rar].[BankAccount] | PlugInConfigurationEFTId | Field Added | Field Added | 12.10 |
[rar].[BankAccount] | SelfBalancingFileFlag | Field Added | Field Added | 12.10 |
[rar].[BankAccount] | AccountSuffix | Field Added | Field Added | 12.10 |
[rar].[BankAccount] | BACSUserNumber | Field Added | Field Added | 12.10 |
[rar].[BankAccount] | IdentificationNo | Field Added | Field Added | 12.10 |
[rar].[BankAccount] | BankIdentifierCode | Field Added | Field Added | 12.10 |
[rar].[BankAccount] | IBAN | Field Added | Field Added | 12.10 |
[rar].[ChildRelatedPaymentNotPaidReasonsUK] | Table Added | Table Added | 12.10 | |
[rar].[ChildRelatedPaymentPeriodsUK] | Table Added | Table Added | 12.10 | |
[rar].[CurrencyCodes] | Table Added | Table Added | 12.10 | |
[rar].[DeductionHeader] | ApplyToTypeNo | Field Added | Field Added | 12.10 |
[rar].[DeductionHeader] | AllowApplyToTypeOverrideOnPayee | Field Added | Field Added | 12.10 |
[rar].[DeductionHeader] | DeductionNetComponentHeaderId | Field Added | Field Added | 12.10 |
[rar].[DeductionHeaderValiditiesUK] | Table Added | Table Added | 12.10 | |
[rar].[DeductionNetComponentHeaders] | Table Added | Table Added | 12.10 | |
[rar].[DeductionNetComponentHeaderValidities] | Table Added | Table Added | 12.10 | |
[rar].[DeductionNetComponentHeaderValidityDeductions] | Table Added | Table Added | 12.10 | |
[rar].[DeductionNetComponentHeaderValidityPayCodes] | Table Added | Table Added | 12.10 | |
[rar].[DeductionNetComponentHeaderValidityPayCodeTypes] | Table Added | Table Added | 12.10 | |
[rar].[DeductionRule] | ApplyOrder | Field Added | Field Added | 12.10 |
[rar].[DeductionRulesUK] | Table Added | Table Added | 12.10 | |
[rar].[EFTFileGenerationLog] | Table Added | Table Added | 12.10 | |
[rar].[EftTransaction] | BuildingSocietyReference | Field Added | Field Added | 12.10 |
[rar].[EftTransaction] | AmountInPaymentCurrency | Field Added | Field Added | 12.10 |
[rar].[EftTransaction] | BankIdentifierCode | Field Added | Field Added | 12.10 |
[rar].[EftTransaction] | IsDeafultAccount | Field Added | Field Added | 12.10 |
[rar].[EftTransactionHeader] | PayCompanyBankAbbreviation | Field Changed | Field Chagned from Not Null to Null | 12.10 |
[rar].[EftTransactionHeader] | PayCompanyBranchNumber | Field Chagned | Field Length Chagned from 7 to 10 | 12.10 |
[rar].[EftTransactionHeader] | IdentificationNo | Field Added | Field Added | 12.10 |
[rar].[EftTransactionHeader] | BankIdentifierCode | Field Added | Field Added | 12.10 |
[rar].[EftTransactionHeader] | IBAN | Field Added | Field Added | 12.10 |
[rar].[EmployerPensionContributionsGrossWageBatchHistoryUK] | Table Added | Table Added | 12.10 | |
[rar].[EmployerPensionContributionsGrossWageBatchUK] | Table Added | Table Added | 12.10 | |
[rar].[EmploymentIntermediaryReportDetails] | Table Added | Table Added | 12.10 | |
[rar].[EmploymentIntermediaryReportHeader] | Table Added | Table Added | 12.10 | |
[rar].[EmploymentTypeSweden] | Table Deleted | Table Deleted | 12.10 | |
[rar].[ExchangeRateImportAudit] | Table Added | Table Added | 12.10 | |
[rar].[ExchangeRates] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatch] | IsIncludePayeesWithYTDadjustmentOnly | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchChildRelatedPaymentRecoveriesHistoryUK] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchChildRelatedPaymentRecoveriesUK] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchItem] | PayeePayrollChildRelatedPaymentsId | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchItem] | IsSystemCalculatedGST | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchItem_History] | PayeePayrollChildRelatedPaymentsId | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchItem_History] | IsSystemCalculatedGST | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayee] | PaymentCurrencyCodeId | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayee] | PaymentCurrencyConversionRate | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayee] | PaymentCurrencyConversionDate | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayee_History] | PaymentCurrencyCodeId | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayee_History] | PaymentCurrencyConversionRate | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayee_History] | PaymentCurrencyConversionDate | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayeeDeduction] | IsManuallyAdded | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayeeDeductionsHistoryUK] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchPayeeDeductionsUK] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchPayeeHistoryUK] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchPayeePensionableEarningsHistoryUK] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchPayeePensionableEarningsUK] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchPayeeTaxP45] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchPayeeTaxUk] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchPayeeTaxUk_History] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchPayeeUK] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchPayslipOffice] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchPayslipPayCompany] | UmbrellaCompanyId | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayslipPayCompanyUK] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchPayslipPayee] | PaymentCurrencyCodeId | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayslipPayee] | PaymentCurrencyConversionRate | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayslipPayee] | PaymentCurrencyConversionDate | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayslipPayee] | GrossWageBatchPayslipOffice_id | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayslipPayeeGrossPay] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchPayslipPayeePensionUK] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchPayslipPayeeUK] | Table Added | Table Added | 12.10 | |
[rar].[GrossWageBatchStages] | Table Added | Table Added | 12.10 | |
[rar].[GuaranteeSalaryBlueCollar] | Table Deleted | Table Deleted | 12.10 | |
[rar].[GuaranteeSalaryWhiteCollar] | Table Deleted | Table Deleted | 12.10 | |
[rar].[HoursWorkedCategories] | Table Added | Table Added | 12.10 | |
[rar].[IRElectronicReportHistory] | Table Deleted | Table Deleted | 12.10 | |
[rar].[LeaveQualifyingWeekCondition] | Table Added | Table Added | 12.10 | |
[rar].[LeaveRateTypeValue] | IsBasedOnWorkedDaysOnly | Field Added | Field Added | 12.10 |
[rar].[LeaveRequestTime] | GrossWageBatch_id | Field Added | Field Added | 12.10 |
[rar].[LeaveTakenConditions] | Table Added | Table Added | 12.10 | |
[rar].[LeaveType] | LeaveTypeConfiguration | Field Added | Field Added | 12.10 |
[rar].[LeaveType] | IsLeaveRequestForWeekdaysOnly | Field Added | Field Added | 12.10 |
[rar].[LeaveTypeConditionEvaluationCommencingDates] | Table Deleted | Table Deleted | 12.10 | |
[rar].[NationalInsuranceAdjustment] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceAdjustmentHistory] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceBandsUK] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceCategoriesUK] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceContributionsByJobOrderGrossWageBatch] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceContributionsByJobOrderGrossWageBatchHistory] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceContributionsByNationalInsuranceBandGrossWageBatch] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceContributionsByNationalInsuranceBandGrossWageBatchHistory] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceContributionsGrossWageBatch] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceContributionsGrossWageBatchHistory] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceEarningsByBandYTDGrossWageBatchHistory] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceContributionsGrossWageBatch] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceContributionsGrossWageBatchHistory] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceEarningsByBandYTDGrossWageBatchHistory] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceRatesUK] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceThresholdsUK] | Table Added | Table Added | 12.10 | |
[rar].[NationalInsuranceYTDGrossWageBatchHistory] | Table Added | Table Added | 12.10 | |
[rar].[P60BatchesUK] | Table Added | Table Added | 12.10 | |
[rar].[P60BatchPayeesUK] | Table Added | Table Added | 12.10 | |
[rar].[PayCodeCalculationGroup] | Table Deleted | Table Deleted | 12.10 | |
[rar].[PayCodePayroll] | Description | Field Changed | Change from Not Null to Null | 12.10 |
[rar].[PayCodePayrollUK] | Table Added | Table Added | 12.10 | |
[rar].[PayCompany] | ContactPhone | Field Chagned | Field Length chagned from 25 to 50 | 12.10 |
[rar].[PayCompany] | ContactFax | Field Chagned | Field Length chagned from 25 to 50 | 12.10 |
[rar].[PayCompany] | AccountName | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompany] | AccountNumber | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompany] | AccountReference | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompany] | ContactMobile | Field Chagned | Field Length chagned from 25 to 50 | 12.10 |
[rar].[PayCompany] | BankAccountId | Field Added | Field Added | 12.10 |
[rar].[PayCompany] | ReimbursementCurrencyConversionDateType | Field Added | Field Added | 12.10 |
[rar].[PayCompany] | NetPayCurrencyConversionDateType | Field Added | Field Added | 12.10 |
[rar].[PayCompanyAustralia] | BankAbbreviation | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyAustralia] | BSBNumber | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyAustralia] | BankUserId | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyAustralia] | EFTFileTypeNo | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyAustralia] | SelfBalancingFileFlag | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyAustralia] | IntermediaryBHPhone | Field Changed | Field Length chagned from 15 to 50 | 12.10 |
[rar].[PayCompanyDefaultsUK] | Table Added | Table Added | 12.10 | |
[rar].[PayCompanyDocumentFormat] | PayCompanyDefaultUKId | Field Added | Field Added | 12.10 |
[rar].[PayCompanyNewZealand] | BankAbbreviation | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyNewZealand] | BSBNumber | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyNewZealand] | EFTFileTypeNo | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyNewZealand] | SelfBalancingFileFlag | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyNewZealand] | AccountSuffix | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyStateAidSectorsUK] | Table Added | Table Added | 12.10 | |
[rar].[PayCompanyUK] | Table Added | Table Added | 12.10 | |
[rar].[Payee] | LegacySystemId | Field Changed | Changed from LegacySystemID | 12.10 |
[rar].[PayeeBankAccount] | AccountName | Field Changed | Changed from Not Null to Null | 12.10 |
[rar].[PayeeBankAccount] | AccountNumber | Field Changed | Changed from Not Null to Null | 12.10 |
[rar].[PayeeBankAccount] | BuildingSocietyReference | Field Added | Field Added | 12.10 |
[rar].[PayeeBankAccount] | BankIdentifierCode | Field Added | Field Added | 12.10 |
[rar].[PayeeCarBenefitsUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeeChildRelatedPaymentsYTDUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeeContract] | Table Deleted | Table Deleted | 12.10 | |
[rar].[PayeeHeader] | PayeeMigrationId | Field Added | Field Added | 12.10 |
[rar].[PayeeHeaderPayroll] | TaxTypeUK_no | Field Added | Field Added | 12.10 |
[rar].[PayeeHeaderPayroll] | UmbrellaCompanyId | Field Added | Field Added | 12.10 |
[rar].[PayeeHeaderPayroll] | PayeeTypeUk | Field Added | Field Added | 12.10 |
[rar].[PayeeHeaderPayroll] | GrossPayTaxTypeNo | Field Added | Field Added | 12.10 |
[rar].[PayeeHeaderPayrollUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeeNationalInsuranceContributionsYTDUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeeNiableEarningsByBandYTDUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeePayroll] | CurrencyCodeId | Field Added | Field Added | 12.10 |
[rar].[PayeePayrollChildRelatedPaymentBlocksUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeePayrollChildRelatedPaymentEpisodeNotPaidReasonsUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeePayrollChildRelatedPaymentEpisodePartnerDetailsUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeePayrollChildRelatedPaymentEpisodesUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeePayrollChildRelatedPaymentsUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeePayrollChildRelatedPaymentsWeeklyBreakupUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeePayrollGrossPay] | Table Added | Table Added | 12.10 | |
[rar].[PayeePayrollHMRCUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeePayrollNewZealandKiwiSaverOptInDate] | Table Deleted | Table Deleted | 12.10 | |
[rar].[PayeePayrollNewZealandKiwiSaverOptInDateHoliday] | Table Deleted | Table Deleted | 12.10 | |
[rar].[PayeePayrollPensionEnrolmentPostponementsUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeePayrollPensionEnrolmentsUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeePayrollUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeePensionYTDUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeeSickPeriodOfIncapcityToWorkDetailGrossWageBatchUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeeSickPeriodOfIncapcityToWorkDetailsGrossWageBatchHistoryUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeeSickPeriodOfIncapcityToWorkHeaderGrossWageBatchUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeeSickPeriodOfIncapcityToWorkHeaderUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeeTaxYTDUK] | Table Added | Table Added | 12.10 | |
[rar].[PayeeTerminationsUK] | Table Added | Table Added | 12.10 | |
[rar].[PayGroup] | ContractorOnly | Field Added | Field Added | 12.10 |
[rar].[PayGroup] | PortalPayslipReleaseTypeNo | Field Added | Field Added | 12.10 |
[rar].[PayGroup] | TimesheetWarningTimeZoneId | Field Changed | Field Name and Datatype Changed | 12.10 |
[rar].[PayGroupSweden] | Table Deleted | Table Deleted | 12.10 | |
[rar].[PayPeriodSweden] | Table Deleted | Table Deleted | 12.10 | |
[rar].[PayPeriodUK] | Table Added | Table Added | 12.10 | |
[rar].[PensionAutoEnrolmentPostponementsGrossWageBatchUK] | Table Added | Table Added | 12.10 | |
[rar].[PensionAutoEnrolmentsGrossWageBatchHistoryUK] | Table Added | Table Added | 12.10 | |
[rar].[PensionAutoEnrolmentsGrossWageBatchUK] | Table Added | Table Added | 12.10 | |
[rar].[PensionPeriodsUK] | Table Added | Table Added | 12.10 | |
[rar].[PensionProviders] | Table Added | Table Added | 12.10 | |
[rar].[PensionRateRule] | Table Added | Table Added | 12.10 | |
[rar].[PensionRateRuleValidity] | Table Added | Table Added | 12.10 | |
[rar].[PensionSchemes] | Table Added | Table Added | 12.10 | |
[rar].[PensionSchemeValidity] | Table Added | Table Added | 12.10 | |
[rar].[PensionThresholdsUK] | Table Added | Table Added | 12.10 | |
[rar].[PerformancePay] | Table Deleted | Table Deleted | 12.10 | |
[rar].[PostGraduateLoanThresholdsUK] | Table Added | Table Added | 12.10 | |
[rar].[PostgraduateLoanTransactionsGrossWageBatch] | Table Added | Table Added | 12.10 | |
[rar].[PostgraduateLoanTransactionsHistory] | Table Added | Table Added | 12.10 | |
[rar].[PublicHolidayPaymentHeader] | ConditionalVariableComparisonType | Field Changed | Field Name changed from PayeeConditionalVariableComparisonType | 12.10 |
[rar].[StatePensionAgeRulesUK] | Table Added | Table Added | 12.10 | |
[rar].[StudentLoanThresholdsUK] | Table Added | Table Added | 12.10 | |
[rar].[StudentLoanTransactions_History] | Table Added | Table Added | 12.10 | |
[rar].[StudentLoanTransactionsGrossWageBatch] | Table Added | Table Added | 12.10 | |
[rar].[SuperStreamServiceProvider] | ContactPhone | Field Chagned | Field Length changed from 10 to 50 | 12.10 |
[rar].[TaxCodeUpdateDetailsUK] | Table Added | Table Added | 12.10 | |
[rar].[TaxCodeUpdateHeaderUK] | Table Added | Table Added | 12.10 | |
[rar].[TaxCodeUpdatePayGroupsUK] | Table Added | Table Added | 12.10 | |
[rar].[TaxMonthsUK] | Table Added | Table Added | 12.10 | |
[rar].[TaxPeriodsScotland] | Table Added | Table Added | 12.10 | |
[rar].[TaxPeriodsUK] | Table Added | Table Added | 12.10 | |
[rar].[TaxPeriodsWales] | Table Added | Table Added | 12.10 | |
[rar].[TaxRatesCISUK] | Table Added | Table Added | 12.10 | |
[rar].[TaxRatesScotland] | Table Added | Table Added | 12.10 | |
[rar].[TaxRatesUK] | Table Added | Table Added | 12.10 | |
[rar].[TaxRatesWales] | Table Added | Table Added | 12.10 | |
[rar].[UKTaxCodesInfo] | Table Added | Table Added | 12.10 | |
[rar].[UmbrellaCompany] | Table Added | Table Added | 12.10 | |
[FI].[FinanceIntegrationBatches] | IsDownloaded | Field Added | Field Added | 12.10 Patch 1 |
[FO].[CandidateWorkReferences] | EmailAddress | Field Added | Field Added | 12.10 Patch 1 |
[FO].[JobOrders] | TotalPackage | Field Length changed | Field Length changed from Decimal(38, 6) to (38,2) | 12.10 Patch 1 |
[FO].[JobOrders] | BaseSalary | Field Length changed | Field Length changed from Decimal(38, 6) to (38,2) | 12.10 Patch 1 |
[FO].[Reports] | DisabledByFastTrack | Field Added | Field Added | 12.10 Patch 1 |
[FO].[Candidates] | PassportCountryId | Field Added | Field Added | 12.10 Patch 3 |
[rar].[LeaveType] | PaidLeaveType | Field Added | Field Added | 12.10 Patch 3 |
[rar].[MedicareLevySurchargeTierRate] | Table Added | Table Added | 12.10 Patch 3 | |
[rar].[NationalInsurancePeriodsUK] | Table Added | Table Added | 12.10 Patch 3 | |
[rar].[NationalInsuranceThresholdsUK] | Column Renamed | TaxPeriodId renamed to NationalInsurancePeriodUKId | 12.10 Patch 3 | |
[rar].[PayCode] | IsBonusCommissionPayments | Field Added | Field Added | 12.10 Patch 3 |
[rar].[PayeePayrollAustralia] | IsRegisteredWHMEmployer | Field Added | Field Added | 12.10 Patch 3 |
[rar].[PayeePayrollAustralia] | WithholdingVariationType | Field Added | Field Added | 12.10 Patch 3 |
[rar].[PayeePayrollAustralia] | IsCIRApplied | Field Added | Field Added | 12.10 Patch 3 |