Skip to main content
PP

MPCurrentPay

MYOB.AdvancedLive.People.Objects.PPScreensMPPP3130MPPP3131MPPP3140Release 2025.2

No summary is documented for this DAC in the release source.

Field NameTypeDisplay NameForeign Key
AcctReferenceNbr
nvarchar(255)Employee Ref. No.-
Description:No description available
Adjusted
bitAdjusted-
Description:No description available
AnnualisedIncome
decimalAnnualised Income-
Description:No description available
AnnualisedIncomeLabelNonexistent in DB
stringFor information about calculating annualised income, go to-
Description:No description available
ApprenticeStatus
bitApprentice / Trainee-
Description:No description available
BAccountDefAddressID
intDef Address ID-
Description:No description available
BAccountDefContactID
intDef Contact ID-
Description:No description available
BAccountID
intBAccountID-
Description:No description available
BAccountParentBAccountID
intParent BAccount ID-
Description:No description available
BAccountParentDefAddressID
intParent Def Address ID-
Description:No description available
BAccountParentDefContactID
intParent Def Contact ID-
Description:No description available
BaseNZTimesheetDayLeaveConversionOption
nvarchar(2)-
Description:No description available
CRContactAddressLine1
nvarchar(50)Address Line1-
Description:No description available
CRContactAddressLine2
nvarchar(50)Address Line2-
Description:No description available
CRContactAddressLine3
nvarchar(50)Address Line3-
Description:No description available
CRContactAddressType
nvarchar(2)Address Type-
Description:No description available
CRContactCity
nvarchar(50)City-
Description:No description available
CRContactCountryID
nvarchar(2)Country ID-
Description:No description available
CRContactDefAddressID
intDefault AddressID-
Description:No description available
CRContactDisplayName
nvarchar(255)Display Name-
Description:No description available
CRContactEmail
nvarchar(255)Email-
Description:No description available
CRContactFirstName
nvarchar(50)First Name-
Description:No description available
CRContactFullName
nvarchar(255)Full Name-
Description:No description available
CRContactIsValidated
bitIsValidated-
Description:No description available
CRContactLastName
nvarchar(100)Last Name-
Description:No description available
CRContactMidName
nvarchar(50)Mid Name-
Description:No description available
CRContactPhone1
nvarchar(50)Phone1-
Description:No description available
CRContactPhone1AndTypeNonexistent in DB
stringPhone 1-
Description:No description available
CRContactPhone1Type
nvarchar(30)Phone1 Type-
Description:No description available
CRContactPhone2
nvarchar(50)Phone2-
Description:No description available
CRContactPhone2AndTypeNonexistent in DB
stringPhone 2-
Description:No description available
CRContactPhone2Type
nvarchar(30)Phone2 Type-
Description:No description available
CRContactPhone3
nvarchar(50)Phone3-
Description:No description available
CRContactPhone3AndTypeNonexistent in DB
stringPhone 3-
Description:No description available
CRContactPhone3Type
nvarchar(30)CRContact Phone3 Type-
Description:No description available
CRContactPostalCode
nvarchar(20)Postal Code-
Description:No description available
CRContactSalutation
nvarchar(255)Salutation-
Description:No description available
CRContactState
nvarchar(50)State-
Description:No description available
CRContactTitle
nvarchar(50)Title-
Description:No description available
CRContactWebSite
nvarchar(255)Web Site-
Description:No description available
CalendarID
nvarchar(10)Calendar-
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
nvarchar(8)Created By Screen ID-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
EmployeeAcctCD
nvarchar(30)Employee ID-
Description:No description available
EmployeeDateOfBirth
datetimeEmployee Date of Birth-
Description:No description available
EmployeeEndDate
datetimeEmployee End Date-
Description:No description available
EmployeeHasPayRunErrorNonexistent in DB
stringAlert-
Description:No description available
EmployeeID
intEmployee ID-
Description:No description available
EmployeeName
nvarchar(255)Name-
Description:No description available
EmployeeStartDate
datetimeEmployee Start Date-
Description:No description available
EmployeeStatus
nvarchar(60)Status-
Description:No description available
EmployeeSuperNonexistent in DB
decimal?EmployeeSuper-
Description:No description available
EmployeeSuperPayNonTaxableNonexistent in DB
decimal?EmployeeSuperPayNonTaxable-
Description:No description available
ExcludeFromLeaveReduction
bit-
Description:No description available
GeneralLedgerPostingClassCD
nvarchar(15)-
Description:No description available
HasLeaveLoading
bitEntitled to Leave Loading-
Description:No description available
IsAUFlatTax
bit-
Description:No description available
IsAUJurisdictionNonexistent in DB
bool?-
Description:No description available
IsAdjustedNonexistent in DB
stringAdjusted-
Description:No description available
IsAnnualisedIncomeOverriden
bitOverride Annualised Income-
Description:No description available
IsImportedPayHistory
bitIs Imported Pay History-
Description:No description available
IsNZJurisdictionNonexistent in DB
bool?-
Description:No description available
IsPayrollTaxLiableNonexistent in DB
stringExempt from Payroll Tax-
Description:No description available
IsPensionAgeMet
bit-
Description:No description available
IsPreservationAgeMet
bit-
Description:No description available
IsResetNonexistent in DB
bool?-
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
nvarchar(8)Last Modified By Screen ID-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
LeavePayRateType
nvarchar(2)Ordinary Pay-
Description:No description available
LeavePayRateTypeDescriptionNonexistent in DB
stringOrdinary Pay-
Description:No description available
LevyRate
decimalLevyRate-
Description:No description available
MarginalRate
decimalMarginalRate-
Description:No description available
MarginalRateBasis
nvarchar(1)MarginalRateBasis-
Description:No description available
MidnightShiftHandling
nvarchar(2)-
Description:No description available
NonWorkingDayBasedOnTimesheet
bit-
Description:No description available
NoteID
uniqueidentifierNote ID-
Description:No description available
OrganizationIDNonexistent in DB
int?-
Description:No description available
PayPeriodEndDateNonexistent in DB
DateTime?-
Description:No description available
PayPeriodStartDateNonexistent in DB
DateTime?-
Description:No description available
PayRunID
intPay run IDMPPayRun
Description:No description available
PayRunReportCDNonexistent in DB
stringPay Run ID-
Description:No description available
PayrollTaxExempt
bitExempt from Payroll Tax-
Description:No description available
PayrollTaxStateID
nvarchar(50)Payroll Tax State-
Description:No description available
PayslipFileIDNonexistent in DB
Guid?Payslip FileID-
Description:No description available
PayslipGenerated
bitPayslip Generated-
Description:No description available
PayslipMessage
nvarchar(1000)Payslip Message-
Description:No description available
QualifyingEarningsAmount
decimalQualifying Earnings Amount-
Description:No description available
ResponseAccLevyThreshold
decimalAcc Threshold-
Description:No description available
ResponseAccPerPay
decimalAcc Per Pay-
Description:No description available
ResponseCalculationErrorFlag
bitResponse Calculation Error Flag-
Description:No description available
ResponseCalculationErrorMessage
nvarchar(250)Response Calculation Error Message-
Description:No description available
ResponseCalculationTaxBenefit
decimalTax Benefit-
Description:No description available
ResponseESCT
decimalResponseESCT-
Description:No description available
ResponseEmployeeSuperPay
decimalEmployee Super-
Description:No description available
ResponseEmployerSuperPay
decimalEmployer Super-
Description:No description available
ResponseHELPDeduction
decimalHELPDeduction-
Description:No description available
ResponseMedicareAdjustmentPerPay
decimalMedicare Adjustment Per Pay-
Description:No description available
ResponseNetPay
decimalNet Pay-
Description:No description available
ResponseNetPayYTDAmount
decimalNet Pay YTD Amount-
Description:No description available
ResponseOverrideEmployeeTaxRate
decimalResponse Override Employee Tax Rate-
Description:No description available
ResponseOverridePayProcessTag
nvarchar(100)Response Override Pay Process Tag-
Description:No description available
ResponsePAYEPerPay
decimalPAYE Per Pay-
Description:No description available
ResponsePAYGPerPay
decimalPAYG Per Pay-
Description:No description available
ResponsePAYWPerPay
decimalPAYW Per Pay-
Description:No description available
ResponsePAYWPerPayYTDAmount
decimalPAYW Per Pay YTD Amount-
Description:No description available
ResponsePostTaxDeductions
decimalDeductions-
Description:No description available
ResponsePostTaxDeductionsYTDAmount
decimalDeductions YTD Amount-
Description:No description available
ResponsePostTaxIncome
decimalTax free Income-
Description:No description available
ResponsePostTaxIncomeYTDAmount
decimalTax free Income YTD Amount-
Description:No description available
ResponsePostTaxPayAmount
decimalPostTax Pay Amount-
Description:No description available
ResponsePreTaxDeductions
decimalPre-tax Deductions-
Description:No description available
ResponsePreTaxDeductionsYTDAmount
decimalPre-tax Deductions YTD Amount-
Description:No description available
ResponsePreTaxIncome
decimalGross Income-
Description:No description available
ResponsePreTaxIncomeYTDAmount
decimalTaxable Income YTD Amount-
Description:No description available
ResponseSFSSDeduction
decimalSFSSDeduction-
Description:No description available
ResponseSLBOR
decimalResponse SLBOR-
Description:No description available
ResponseSLBORYTDAmount
decimalResponse SLBOR YTD Amount-
Description:No description available
ResponseSLCIR
decimalResponse SLCIR-
Description:No description available
ResponseSLCIRYTDAmount
decimalResponse SLCIR YTD Amount-
Description:No description available
ResponseSLStandard
decimalResponse SLStandard-
Description:No description available
ResponseSLStandardYTDAmount
decimalResponse SLStandard YTD Amount-
Description:No description available
ResponseStudentLoanDeduction
decimalStudent Loan Deduction-
Description:No description available
ResponseTaxRegionCode
nvarchar(2)Tax Region Code-
Description:No description available
ResponseTaxableIncome
decimalGross Taxable-
Description:No description available
ResponseTaxableIncomeNoBonus
decimalGross Taxable No Bonus-
Description:No description available
ResponseTaxableIncomeYTDAmount
decimalResponse Taxable Income YTD Amount-
Description:No description available
ResponseUsedLowRate
bitUsed Low Rate-
Description:No description available
RoleAttendanceBasis
nvarchar(60)Attendance Basis-
Description:No description available
RoleBranchCD
nvarchar(30)Branch-
Description:No description available
RoleBranchID
intBranch-
Description:No description available
RoleDepartmentDescription
nvarchar(60)Department-
Description:No description available
RoleDepartmentExpenseAccountID
intExpense Account ID-
Description:No description available
RoleDepartmentExpenseSubID
intExpense Sub ID-
Description:No description available
RoleDepartmentID
nvarchar(10)Department ID-
Description:No description available
RoleEmploymentBasis
nvarchar(60)Employment Basis-
Description:No description available
RoleEndDate
datetimeEnd Date-
Description:No description available
RoleExpenseAccountCD
nvarchar(30)Expense A/c-
Description:No description available
RoleExpenseAccountID
intExpense Account ID-
Description:No description available
RoleIsApprentice
bitIs Apprentice-
Description:No description available
RoleManager
intManager-
Description:No description available
RoleNoteID
uniqueidentifierNote ID-
Description:No description available
RoleNoteText
nvarcharNote-
Description:No description available
RoleParentBAccountID
intParent BAccount ID-
Description:No description available
RolePositionDescription
nvarchar(60)Position-
Description:No description available
RolePositionID
nvarchar(10)Position ID-
Description:No description available
RoleReportGroupDescription
nvarchar(255)Report Group-
Description:No description available
RoleReportGroupID
intReport Group ID-
Description:No description available
RoleReportGroupName
nvarchar(15)Report Group-
Description:No description available
RoleStartDate
datetimeStart Date-
Description:No description available
RoleWorksOnStatutoryHolidays
bitWorks On Statutory Holidays-
Description:No description available
SelectPayRunEmployeeNonexistent in DB
bool?Selected-
Description:No description available
SettingEmailPayslip
bitEmail Payslip-
Description:No description available
SettingEmailPayslipNotification
bitEmail Payslip Notification-
Description:No description available
SettingEmailPayslipNotificationRecipient
nvarchar(255)Email Payslip Notification Recipient-
Description:No description available
SettingEmailPayslipRecipient
nvarchar(255)Email Payslip Recipient-
Description:No description available
SettingLastEmailedByIDNonexistent in DB
Guid?Last Emailed by ID-
Description:No description available
SettingLastEmailedByName
nvarchar(255)Last Emailed By Name-
Description:No description available
SettingLastEmailedDate
datetimeLast Emailed Date-
Description:No description available
SettingLastNotifiedByIDNonexistent in DB
Guid?Last Notified by ID-
Description:No description available
SettingLastNotifiedByName
nvarchar(255)Last Notified By Name-
Description:No description available
SettingLastNotifiedDate
datetimeLast Notified Date-
Description:No description available
SettingLastPrintedByIDNonexistent in DB
Guid?Last Printed by ID-
Description:No description available
SettingLastPrintedByName
nvarchar(255)Last Printed By Name-
Description:No description available
SettingLastPrintedDate
datetimeLast Printed Date-
Description:No description available
SettingPaymentSummaryType
nvarchar(100)Payment Summary Type-
Description:No description available
SettingPrintPayslip
bitPrint Payslip-
Description:No description available
SettingUseDefaultEmailForNotification
bitUse Default Email For Notification-
Description:No description available
SettingUseDefaultEmailForPayslip
bitUse Default Email For Payslip-
Description:No description available
SortOrderNonexistent in DB
int?-
Description:No description available
StandardPayAnnualSalary
decimalAnnual Salary-
Description:No description available
StandardPayDefaultPayGroup
bit-
Description:No description available
StandardPayDescription
nvarchar(60)Pay Group Description-
Description:No description available
StandardPayEffectiveDate
datetimeEffective Date-
Description:No description available
StandardPayExpiryDate
datetimeExpiry Date-
Description:No description available
StandardPayHoursPerDay
decimalHrs / Day-
Description:No description available
StandardPayHoursPerPay
decimalHrs / Pay-
Description:No description available
StandardPayHoursPerYear
decimalHours Per Year-
Description:No description available
StandardPayNoteID
uniqueidentifierNote ID-
Description:No description available
StandardPayNoteText
nvarcharNote-
Description:No description available
StandardPayPayGroupCD
nvarchar(60)Pay Group-
Description:No description available
StandardPayPayGroupID
int-
Description:No description available
SuperFundJurisdictionCode
nvarchar(10)Jurisdiction-
Description:No description available
SuperFundMemberID
nvarchar(20)Member ID-
Description:No description available
SuperFundMemberName
nvarchar(50)Member-
Description:No description available
SuperFundNoteID
uniqueidentifierNote ID-
Description:No description available
SuperFundNoteText
nvarcharNote-
Description:No description available
SuperFundPayAmountValue
decimalPay Amount Value-
Description:No description available
SuperFundPayPercentValue
decimalPay Percent Value-
Description:No description available
SuperFundPayType
nvarchar(20)Pay Type-
Description:No description available
SuperFundRowIndex
intRow Index-
Description:No description available
SuperFundSuperFundID
intSuper FundID-
Description:No description available
SuperannuationAmount
decimalSuperannuation Amount-
Description:No description available
SuperannuationYTDAmount
decimalSuperannuation YTD Amount-
Description:No description available
TStamp
timestampTStamp-
Description:No description available
TaxableIncomeYTDAmountNonexistent in DB
decimal?Taxable Income YTD Amount Except Current Pay-
Description:No description available
TaxableIncomeYTDAmountForWHM
decimalTaxable Income YTD Amount For WHM-
Description:No description available
TaxationAUABN
nvarchar(15)ABN-
Description:No description available
TaxationAUAdditionalLevyPercentage
decimalAdditional Levy Percentage-
Description:No description available
TaxationAUAtoDefinedCircumstance
nvarchar(2)ATO-defined circumstance-
Description:No description available
TaxationAUCountryID
nvarchar(2)-
Description:No description available
TaxationAUFlatTaxPercentage
decimal-
Description:No description available
TaxationAUHasASpouse
bitHas ASpouse-
Description:No description available
TaxationAUHasCIR
bitCommissioner's Instalment Rate (CIR)-
Description:No description available
TaxationAUHasDependentChildren
bitHas Dependent Children-
Description:No description available
TaxationAUIsATODefinedDownwardVariance
bit-
Description:No description available
TaxationAUIsAdditionalLevy
bitAdditional Levy-
Description:No description available
TaxationAUIsAustralianResident
bitResidency-
Description:No description available
TaxationAUIsDailyCasual
bit-
Description:No description available
TaxationAUIsFullExemption
bitFull Exemption-
Description:No description available
TaxationAUIsHalfExemption
bitHalf Exemption-
Description:No description available
TaxationAUIsHelp
bitHelp-
Description:No description available
TaxationAUIsLevyExemption
bitLevy Exemption-
Description:No description available
TaxationAUIsLevyReduction
bitLevy Reduction-
Description:No description available
TaxationAUIsLowIncome
bitLow Income-
Description:No description available
TaxationAUIsMedicareAdjustment
bitMedicare Adjustment-
Description:No description available
TaxationAUIsMedicareSignedByPayee
bitMedicare Signed By Payee-
Description:No description available
TaxationAUIsSFSS
bitSFSS-
Description:No description available
TaxationAUIsSeniorsTaxOffset
bitSeniors Tax Offset-
Description:No description available
TaxationAUIsSpecialTaxOffset
bitSpecial Tax Offset-
Description:No description available
TaxationAUIsTFNSignedByPayee
bitTFN Signed By Payee-
Description:No description available
TaxationAUIsTSL
bitTSL-
Description:No description available
TaxationAUIsTaxFreeThreshold
bitTFT-
Description:No description available
TaxationAUIsUpwardWithholdingVariation
bitUpward Withholding Variation-
Description:No description available
TaxationAUIsWHM
bitWorking Holiday Maker-
Description:No description available
TaxationAUIsWithholdingSignedByPayee
bitWithholding Signed By Payee-
Description:No description available
TaxationAUIsZoneOrSpecialTaxOffset
bitZone Or Special Tax Offset-
Description:No description available
TaxationAUMedicareLevySurchargeTier
nvarchar(1)-
Description:No description available
TaxationAUMedicareSignatureDate
datetimeMedicare Signature Date-
Description:No description available
TaxationAUNumDependentChildren
intNum of Dependent Children-
Description:No description available
TaxationAUPayBasis
nvarchar(40)Pay Basis-
Description:No description available
TaxationAUPreviousName
nvarchar(100)Previous Name-
Description:No description available
TaxationAUSeniorTaxOffsetType
nvarchar(50)Senior Tax Offset Type-
Description:No description available
TaxationAUStudyDebtDescription
nvarchar(100)Study Debt-
Description:No description available
TaxationAUTFNDescription
nvarcharTFN Description-
Description:No description available
TaxationAUTFNSignatureDate
datetimeTFN Signature Date-
Description:No description available
TaxationAUTaxCode
nvarchar(64)Tax Scale-
Description:No description available
TaxationAUTaxFileNumber
nvarcharTFN-
Description:No description available
TaxationAUTaxFileNumberStatus
nvarchar(40)TFN Status-
Description:No description available
TaxationAUTaxFreeThresholdDescription
nvarchar(100)TFT-
Description:No description available
TaxationAUTaxScale
intTax Scale-
Description:No description available
TaxationAUTaxTreatmentCode
nvarchar(6)Tax Treatment Code-
Description:No description available
TaxationAUTotalTaxOffsets
decimalTotal Tax Offsets-
Description:No description available
TaxationAUUpwardsWithholdingVariationAmount
decimalUpwards Withholding Variation Amount-
Description:No description available
TaxationAUUpwardsWithholdingVariationEffectiveDate
datetimeWithholding Variation Effective Signature Date-
Description:No description available
TaxationAUUpwardsWithholdingVariationPercentage
decimalUpwards Withholding Variation Percentage-
Description:No description available
TaxationAUWithholdingSignedDate
datetimeWithholding Signed Date-
Description:No description available
TaxationNZESCIsManualOverride
bitManual Override-
Description:No description available
TaxationNZESCIsNZSuperGrossedUp
bitSuper Contribution is Grossed Up-
Description:No description available
TaxationNZESCTRate
nvarchar(8)ESCT Rate-
Description:No description available
TaxationNZESCTaxMethod
nvarchar(8)Taxation Method-
Description:No description available
TaxationNZIRDNumber
nvarchar(15)IRD Number-
Description:No description available
TaxationNZIsLegislatedInfoOverriden
bitLegislated Info Overridden-
Description:No description available
TaxationNZIsSLBOR
bitSLBOR-
Description:No description available
TaxationNZIsSLCIR
bitSLCIR-
Description:No description available
TaxationNZSLBORAdditionalPerPay
decimalSLBOR Additional Per Pay-
Description:No description available
TaxationNZSLBORAllowPartialDeduction
bitSLBOR Allow Partial Deduction-
Description:No description available
TaxationNZSLBORAmountRepaidToDate
decimalSLBOR Amount Repaid To Date-
Description:No description available
TaxationNZSLBORAmountToExcludePerpay
decimalGross Income, excluding the first-
Description:No description available
TaxationNZSLBORMaxAmountPerPay
decimalSLBOR Max Amount Per Pay-
Description:No description available
TaxationNZSLBORPercentage
decimalSLBOR-
Description:No description available
TaxationNZSLCIRAmountRecovered
decimalSLCIR Amount Recovered-
Description:No description available
TaxationNZSLCIRAmountToRecover
decimalSLCIR Amount To Recover-
Description:No description available
TaxationNZSLCIRBalance
decimalSLCIR Balance-
Description:No description available
TaxationNZSLCIRDate
datetimeSLCIR Date-
Description:No description available
TaxationNZSLCIRPercentage
decimalSLCIR-
Description:No description available
TaxationNZSLStandardRatePercentage
decimalSL Std Rate-
Description:No description available
TaxationNZSLStandardThresholdPerWeek
decimalSL Std Threshold Per Week-
Description:No description available
TaxationNZTaxCode
nvarchar(8)Tax Code-
Description:No description available
TaxationNZTaxCodeDisplayNonexistent in DB
stringTax Code-
Description:No description available
TaxationNZTaxPercentage
decimalSpecial Tax Rate-
Description:No description available
TerminationDateNonexistent in DB
DateTime?Termination Date-
Description:No description available
TotalEmployeePayDistributionAmountNonexistent in DB
decimal?Total Employee PayDistribution Amount-
Description:No description available
TotalEmployeePayDistributionPercentNonexistent in DB
decimal?Total Employee PayDistribution Percent-
Description:No description available