...
Table | Field | Action | Comment |
|---|---|---|---|
[dbo].[InvoiceTerms] | Renamed | 12.15p2 - New name - [dbo].[Terms] | |
[FO].[JobOrderPermServices] | Renamed | 12.15p2 - New name - [FO].[JobOrderServices] | |
[dbo].[CreditNoteReason] | [ExportCode] | Added | 12.15p2 |
[dbo].[fttsheettemp] | [Username] | Added | 12.15p2 |
[dbo].[fttsheettemp] | [ExpiredDateTime] | Added | 12.15p2 |
[dbo].[TimesheetImportBatches] | [DefaultAdjustmentReasonId] | Added | 12.15p2 |
[dbo].[TimesheetImportBatchRawData] | [AdjustmentReason] | Added | 12.15p2 |
[dbo].[TimesheetImportBatchRawData] | [AdjustmentReasonImportCode] | Added | 12.15p2 |
[dbo].[TimesheetImportBatchRawData] | [ReimbursementProjectCode] | Added | 12.15p2 |
[dbo].[TimesheetImportBatchRawData] | [ReimbursementImportCode] | Added | 12.15p2 |
[dbo].[TimesheetImportBatchRawData] | [CurrencyCode] | Added | 12.15p2 |
[dbo].[TimesheetImportBatchRawData] | [CurrencyValue] | Added | 12.15p2 |
[FO].[Candidates] | [InterviewTime] | Added | 12.15p2 |
[FO].[Clients] | [InterpretedTimesheetStatusId] | Added | 12.15p2 |
[FO].[GeneralSettings] | [SMSCharacterLimit] | Added | 12.15p2 |
[FO].[PasswordPolicy] | [ForcePasswordLowercase] | Added | 12.15p2 |
[FO].[Reasons] | [ExportCode] | Added | 12.15p2 |
[FO].[Services] | [IsAutoInvoice] | Added | 12.15p2 |
[FO].[Services] | [IsCreationDateDeterminesInvoiceDate] | Added | 12.15p2 |
[rar].[PayCompanyDocumentFormat] | [TermId] | Added | 12.15p2 |
[rar].[PayeeHeaderPayroll] | [StartingProformaRemittanceId] | Added | 12.15p2 |
[rar].[PayeePayroll] | [TermId] | Added | 12.15p2 |
[rar].[PayeePayroll] | [IsProformaRemittanceEnabled] | Added | 12.15p2 |
[rar].[PayeePayroll] | [ProformaRemittanceDeliveryMethodTypeNo] | Added | 12.15p2 |
[rar].[PayeePayroll] | [ProformaRemittanceDocumentNotificationTemplateId] | Added | 12.15p2 |
[rar].[PayGroup] | [IsIncludePriorPeriodsTimesheetsInCurrentPeriod] | Added | 12.15p2 |
[rar].[TimesheetResult] | [TermId] | Added | 12.15p2 |
[rar].[TimesheetResult] | [PaymentTermDueDate] | Added | 12.15p2 |
[rar].[TimesheetResult] | [InterpretedTimesheetStatusId] | Added | 12.15p2 |
[rar].[TimesheetTransactionReportParam] | [UserName] | Added | 12.15p2 |
[dbo].[AutoInvoiceHeaders] | Added | 12.15p2 | |
[dbo].[AutoInvoiceItems] | Added | 12.15p2 | |
[dbo].[CreditNoteReasonImportCodes] | Added | 12.15p2 | |
[dbo].[ProformaRemittanceDetails] | Added | 12.15p2 | |
[dbo].[ProformaRemittanceDetailsItem] | Added | 12.15p2 | |
[dbo].[ProformaRemittanceHeaders] | Added | 12.15p2 | |
[dbo].[ProformaRemittancePayResult] | Added | 12.15p2 | |
[dbo].[ProformaRemittanceTimesheetResult] | Added | 12.15p2 | |
[dbo].[Terms] | Added | 12.15p2 | |
[FO].[JobOrderServices] | Added | 12.15p2 | |
[FO].[ServiceAutoInvoiceOptions] | Added | 12.15p2 | |
[rar].[InterpretedTimesheetStatuses] | Added | 12.15p2 | |
[rar].[TimesheetResultPaymentDueDateAudit] | Added | 12.15p2 | |
[rar].[GrossWageBatch] | AdjustmentTaxCalculationMethod | Added | 12.17 - B2 tax calculation method. 1 = Standard, 2 = Bii |
[rar].[PayCodePayrollAU] | Table Added | 12.17 - This table contains AU related configurations related to Pay code | |
[rar].[PayeeHeaderPayrollAustralia] | Table Added | 12.17 - Table contains the Australia specific Payee Payroll Information | |
[rar].[PayeePayrollAustralia] | IsSeniorsAndPensionersTaxOffsetApplied | Added | 12.17 - Flag to Identify Seniors And Pensioners Tax Offset Applied or not |
[rar].[PayeePayrollAustralia] | SeniorsAndPensionersTaxOffsetStatus | Added | 12.17 - Seniors And Pensioners TaxOffset Status Enum: 1 =Single ,2=Couple ,3= Illness Separated Couple |
[rar].[PayeePayrollAustralia] | MedicareLevySurchargeTier | Added | 12.17 - The MLS tiers that identifies the rate at which MSL will be calculated on. |
[rar].[PayeePayrollAustralia] | IsMedicareLevySurchargeApplied | Added | 12.17 - To flag a payee as being subject to a medicare levy surcharge |
[rar].[PayeePayrollAustralia] | IsSeasonalWorkerProgramme | Added | 12.17 - Flag to Identify whether the payee is working in Australia under the Seasonal Worker Programme (SWP) |
[rar].[PayeePayrollAustralia] | IsExemptFromWithholding | Added | 12.17 - Flag to identify whether the payee is exempt from withholding or not |
[rar].[PayeePayrollAustralia] | IsHorticulturalistShearersTaxRatesApply | Added | 12.17 - Indicates if payee is subject to the horticulturalist and shearers tax rates. Only applies to PAYG payees. 1 = True |
[rar].[TerminationReason] | STPCessationReasonType | Added | 12.17 - This is to map termination reasons to a cessation type code : 1 = V (Voluntary Cessation), 2 = I (Ill Health), 3 = D (Deceased), 4 = R (Redundancy), 5 = F (Dismissal), 6 = C (Contract Cessation), 7 = T (Transfer) |
[rar].[PayeePayrollAustralia] columns PayeeHeaderPayrollAustralia | IsWorkCoverPaymentsAfterTermination | Added | 12.17 - IsWorkCoverPaymentsAfterTermination Flag 0 = False,1 = True |
[rar].[PayeePayrollAustralia] columns PayeeHeaderPayrollAustralia | PayeeHeaderId | Added | 12.17 - PRIMARY KEY PayeeHeaderId |
[rar].[PayCodePayrollAU] columns PayCodePayrollAU | IsIncludeInGrossEarningsInSTPReport | Added | 12.17 - Determines if Paycode includes Gross Earnings in STP Reports |
[rar].[PayCodePayrollAU] columns PayCodePayrollAU | IsItemiseInSTPReports | Added | 12.17 - Determines if Paycode has setting for STP Reporting |
[rar].[PayCodePayrollAU] columns PayCodePayrollAU | IsReturnToWorkPayments | Added | 12.17 - Indicates if the pay code is marked as Return to Work Payments for STP |
[rar].[PayCodePayrollAU] columns PayCodePayrollAU | PayCodeId | Added | 12.17 - Indicates if the pay code is marked as Return to Work Payments for STP |