PP
MPCurrentPayPayItem
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ActualItemRate | decimal | - | ||
Description:No description available | ||||
ActualItemRateBeforeTimesheetImport | decimal | - | ||
Description:No description available | ||||
AmountToRecover | decimal | Amount To Recover | - | |
Description:No description available | ||||
ApplyGrossedUpMultiplier | bit | Apply grossed-up multiplier | - | |
Description:No description available | ||||
AutoloadPayItemID | int | Pay Item | - | |
Description:No description available | ||||
CalculatedUnitsDisplayTextNonexistent in DB | string | Item Units | - | |
Description:No description available | ||||
CalculatedValueDisplayTextNonexistent in DB | string | Calculated Value | - | |
Description:No description available | ||||
CalculationAmountFreqPerAnnum | int | per | - | |
Description:No description available | ||||
CalculationEntitlementAccrualMethod | nvarchar(20) | - | ||
Description:No description available | ||||
CalculationExcludeAmount | decimal | Excluding the first $ | - | |
Description:No description available | ||||
CalculationExcludeFrequency | nvarchar(20) | Exclude Frequency | - | |
Description:No description available | ||||
CalculationMethodType | nvarchar(10) | Calculation Method | - | |
Description:No description available | ||||
CalculationPrecisionType | nvarchar(10) | PrecisionType | - | |
Description:No description available | ||||
CalculationRateType | char(1) | RateType | - | |
Description:No description available | ||||
CalculationRateValueType | char(1) | RateValueType | - | |
Description:No description available | ||||
CalculationSystemRollupCode | nvarchar(50) | System Rollup Code | - | |
Description:No description available | ||||
CalculationSystemRollupDescription | nvarchar(50) | System Rollup Description | - | |
Description:No description available | ||||
CalculationUnitType | nvarchar(10) | Units | - | |
Description:No description available | ||||
CalculationUseDerivedAmount | bit | Use Derived Amount | - | |
Description:No description available | ||||
CalculationUseDerivedUnit | bit | UseDerivedUnit | - | |
Description:No description available | ||||
ChildSupportCode | nvarchar(2) | Variation Code | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CustomTaxAmount | decimal | Custom Tax Amount | - | |
Description:No description available | ||||
ETPCode | nvarchar(20) | ETP Code | - | |
Description:No description available | ||||
ETPTaxWithheld | decimal | ETP Tax withheld | - | |
Description:No description available | ||||
ETPTaxation | nvarchar(30) | ETP Taxation | - | |
Description:No description available | ||||
EmployeeID | int | EmployeeID | MPCurrentPay | |
Description:No description available | ||||
EmployeeNameNonexistent in DB | string | Employee name | - | |
Description:No description available | ||||
ExcludeFromLeaveReductionNonexistent in DB | bool? | Exclude from Reduction | - | |
Description:No description available | ||||
ExternalSubAccountCDNonexistent in DB | string | Subaccount | - | |
Description:No description available | ||||
ExtraPayAnnualisedIncome | decimal | - | ||
Description:No description available | ||||
ExtraPayAverageGrossPerPay | decimal | Average Gross Per Pay | - | |
Description:No description available | ||||
ExtraPayElectedTaxRate | decimal | Elected Tax % | - | |
Description:No description available | ||||
ExtraPayIsExemptOfACCLevy | bit | Exempt of ACC Earner's Levy | - | |
Description:No description available | ||||
ExtraPayNumberOfPays | int | Taxed Over No. of Pay Periods | - | |
Description:No description available | ||||
ExtraPayOverrideNumPays | bit | Override Values | - | |
Description:No description available | ||||
ExtraPayPeriodEndDate | datetime | To Physical Pay Date | - | |
Description:No description available | ||||
ExtraPayPeriodStartDate | datetime | From Physical Pay Date | - | |
Description:No description available | ||||
ExtraPayTaxClassification | nvarchar(50) | - | ||
Description:No description available | ||||
ExtraPayTotalHistoricalPay | decimal | Total Gross Pay Per Year | - | |
Description:No description available | ||||
FrequencyNonexistent in DB | string | per | - | |
Description:No description available | ||||
GLAccountCDNonexistent in DB | string | GL Account | - | |
Description:No description available | ||||
GLAccountDescriptionNonexistent in DB | string | GL Account Description | - | |
Description:No description available | ||||
GLAccountIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
GLSubAccountCDNonexistent in DB | string | Subaccount | Sub | |
Description:No description available | ||||
GeneralLedgerPurposeGroupCD | nvarchar(15) | GeneralLedgerPurposeGroupCD | - | |
Description:No description available | ||||
ImportingFromTimesheetNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IncludeInPayRun | bit | Include in Pay | - | |
Description:No description available | ||||
IsAULegislatedReturnToWork | bit | Legislated 'Return to Work' | - | |
Description:No description available | ||||
IsAutoload | bit | Autoload the below pay item when transacted in current pay | - | |
Description:No description available | ||||
IsCompleteIconNonexistent in DB | string | - | ||
Description:No description available | ||||
IsFBTExempt | bit | Fringe Benefits are exempt from Fringe Benefit Tax under section 57A of the Fringe Benefits Tax Assessment Act 1986 | - | |
Description:No description available | ||||
IsImportedPayHistory | bit | Is Imported Pay History | - | |
Description:No description available | ||||
IsMaxThresholdAppliedNonexistent in DB | bool? | Max Threshold(s) applies | - | |
Description:No description available | ||||
IsMaximumLimitAppliedNonexistent in DB | bool? | Limit Applies | - | |
Description:No description available | ||||
IsMinThresholdAppliedNonexistent in DB | bool? | Min Threshold(s) applies | - | |
Description:No description available | ||||
IsReducingBalance | bit | Reducing Balance | - | |
Description:No description available | ||||
ItemAmount | decimal | Amount | - | |
Description:No description available | ||||
ItemAmountBeforeTimesheetImport | decimal | - | ||
Description:No description available | ||||
ItemRate | decimal | Rate | - | |
Description:No description available | ||||
ItemRateBeforeTimesheetImport | decimal | - | ||
Description:No description available | ||||
ItemUnits | decimal | Quantity | - | |
Description:No description available | ||||
ItemUnitsBeforeTimesheetImport | decimal | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LeaveDisplayTextNonexistent in DB | string | Leave | - | |
Description:No description available | ||||
LeaveReductionDisplayTextNonexistent in DB | string | - | ||
Description:No description available | ||||
LeaveValue | decimal | Leave Value | - | |
Description:No description available | ||||
LimitCustomRate | decimal | Rate | - | |
Description:No description available | ||||
LimitDollarAmount | decimal | Excluding the first $ | - | |
Description:No description available | ||||
LimitFrequency | int | Limit Fequency | - | |
Description:No description available | ||||
LimitPercentage | decimal | Percentage | - | |
Description:No description available | ||||
LimitType | nvarchar(10) | LimitType | - | |
Description:No description available | ||||
LimitUnits | nvarchar | Limit is | - | |
Description:No description available | ||||
LocationID | int | Location | LocationExtAddress | |
Description:No description available | ||||
LumpSumFinancialYear | int | Financial Year | - | |
Description:No description available | ||||
MarginalRate | decimal | MarginalRate | - | |
Description:No description available | ||||
MarginalRateBasis | nvarchar(1) | MarginalRateBasis | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | NoteID | - | |
Description:No description available | ||||
PayItemAccrualIncludeInGL | bit | - | ||
Description:No description available | ||||
PayItemAccrualValuationPercent | decimal | - | ||
Description:No description available | ||||
PayItemAccrualValuationRate | decimal | - | ||
Description:No description available | ||||
PayItemAllowPartialDeductions | bit | Allow Partial Deductions | - | |
Description:No description available | ||||
PayItemAllowValueOverridesInPayRuns | bit | Allow Value Overrides in Pay Runs (Current Pay) | - | |
Description:No description available | ||||
PayItemAttachmentOrderCategory | nvarchar(10) | Attachment Order Type | - | |
Description:No description available | ||||
PayItemCD | nvarchar(10) | Pay Item ID | - | |
Description:No description available | ||||
PayItemCashAccountID | int | Cash Account ID | - | |
Description:No description available | ||||
PayItemCashUp | bit | Cash Up | - | |
Description:No description available | ||||
PayItemChildSupport | bit | Child Support | - | |
Description:No description available | ||||
PayItemCode | nvarchar(16) | Code | - | |
Description:No description available | ||||
PayItemCustomTaxRate | decimal | CustomTaxRate | - | |
Description:No description available | ||||
PayItemDeductionCategory | nvarchar(25) | PayItemDeductionCategory | - | |
Description:No description available | ||||
PayItemDescription | nvarchar(60) | Pay Item | - | |
Description:No description available | ||||
PayItemEntitlement | nvarchar(16) | Ent. | - | |
Description:No description available | ||||
PayItemEntitlementID | int | Entitlement ID | - | |
Description:No description available | ||||
PayItemGeneralLedgerAccount | int | General Ledger Account | - | |
Description:No description available | ||||
PayItemID | int | - | ||
Description:No description available | ||||
PayItemIsDeductSSFromSG | bit | Deduct SS From SG | - | |
Description:No description available | ||||
PayItemIsEligibleForFourWeekOWP | bit | Is eligible for four week OWP pay calcualtion | - | |
Description:No description available | ||||
PayItemIsEligibleForHolidayPay | bit | Is eligible for holiday pay calcualtion | - | |
Description:No description available | ||||
PayItemIsEligibleForOWP | bit | Is eligible for ordinary weekly pay calcualtion | - | |
Description:No description available | ||||
PayItemIsEligibleForQualifyingEarnings | bit | - | ||
Description:No description available | ||||
PayItemIsEligibleForRDP | bit | Is eligible for RDP | - | |
Description:No description available | ||||
PayItemIsEligibleForRelevantPay | bit | Is eligible for relevant pay calcualtion | - | |
Description:No description available | ||||
PayItemIsEligibleForSuperannuation | bit | - | ||
Description:No description available | ||||
PayItemIsEntitlement | bit | Is Entitlement | - | |
Description:No description available | ||||
PayItemIsLiableForLevy | bit | Is Liable for Levy | - | |
Description:No description available | ||||
PayItemIsNZDefinedFund | bit | IsNZDefined Fund | - | |
Description:No description available | ||||
PayItemIsNZOverrideLegislatedRates | bit | Override legislated KiwiSaver Employer Super Contribution rate | - | |
Description:No description available | ||||
PayItemIsNZSuperGrossedUp | bit | IsNZSuper Grossed Up | - | |
Description:No description available | ||||
PayItemIsOverrideLegislatedRates | bit | Override Legislated Rate | - | |
Description:No description available | ||||
PayItemIsPublicHolidayWorked | bit | - | ||
Description:No description available | ||||
PayItemIsSuper | bit | Is Super | - | |
Description:No description available | ||||
PayItemNZSuperType | nvarchar(20) | NZ Super Type | - | |
Description:No description available | ||||
PayItemNarration | nvarchar(60) | Payslip label | - | |
Description:No description available | ||||
PayItemParticulars | nvarchar(255) | Particulars | - | |
Description:No description available | ||||
PayItemPayImpact | nvarchar(50) | Pay Impact | - | |
Description:No description available | ||||
PayItemPaymentMethodID | nvarchar(10) | Payment Method | - | |
Description:No description available | ||||
PayItemPaymentReference | nvarchar(18) | Payment Reference | - | |
Description:No description available | ||||
PayItemShowCalculatedUnits | bit | Show Calculated Units | - | |
Description:No description available | ||||
PayItemShowCalculatedValues | bit | Show Calculated Values | - | |
Description:No description available | ||||
PayItemShowOnPaySlip | bit | Show On Pay Slip | - | |
Description:No description available | ||||
PayItemTaxTreatment | nvarchar(50) | Taxation | - | |
Description:No description available | ||||
PayItemTypeCD | nvarchar(32) | Pay Item Type ID | - | |
Description:No description available | ||||
PayItemTypeDescription | nvarchar(60) | Pay Item Type Description | - | |
Description:No description available | ||||
PayItemTypeID | int | - | ||
Description:No description available | ||||
PayItemTypeName | nvarchar(32) | Type | - | |
Description:No description available | ||||
PayItemValueMultiplier | decimal | Rate Multiplier | - | |
Description:No description available | ||||
PayItemVendorCD | nvarchar(30) | Supplier ID | - | |
Description:No description available | ||||
PayItemVendorID | int | Supplier ID | - | |
Description:No description available | ||||
PayItemVendorName | nvarchar(60) | Supplier Name | - | |
Description:No description available | ||||
PayPeriodEndDateNonexistent in DB | DateTime? | - | ||
Description:No description available | ||||
PayPeriodStartDateNonexistent in DB | DateTime? | - | ||
Description:No description available | ||||
PayRunCDNonexistent in DB | string | - | ||
Description:No description available | ||||
PayRunID | int | PayRunID | MPCurrentPay | |
Description:No description available | ||||
PaymentHoursNonexistent in DB | decimal? | PaymentHours | - | |
Description:No description available | ||||
PaymentSummaryCategory | nvarchar(100) | ATO category | - | |
Description:No description available | ||||
PayrollTaxCategory | nvarchar(50) | Payroll Tax Category | - | |
Description:No description available | ||||
PayrollTaxLiable | bit | Payroll Tax Liable | - | |
Description:No description available | ||||
PhysicalPayDateNonexistent in DB | DateTime? | - | ||
Description:No description available | ||||
ProtectedEarningAmount | decimal | Amount | - | |
Description:No description available | ||||
ProtectedEarningCustomRuleCD | nvarchar(15) | Protected Earnings rule | - | |
Description:No description available | ||||
ProtectedEarningFrequency | int | Frequency | - | |
Description:No description available | ||||
ProtectedEarningPercentage | decimal | Rate | - | |
Description:No description available | ||||
ProtectedEarningType | nvarchar(20) | Type | - | |
Description:No description available | ||||
RecoveredToDate | decimal | Recovered To Date | - | |
Description:No description available | ||||
ReduceLeave | bit | Allow Leave Reduction | - | |
Description:No description available | ||||
ReducingBalanceLastResetDate | datetime | - | ||
Description:No description available | ||||
ResponseCalculatedRate | decimal | Calculated Rate | - | |
Description:No description available | ||||
ResponseCalculatedUnits | decimal | Calculated units | - | |
Description:No description available | ||||
ResponseCalculatedValue | decimal | Calculated Value | - | |
Description:No description available | ||||
ResponseIsMaxThresholdApplied | bit | Max Threshold(s) applies | - | |
Description:No description available | ||||
ResponseIsMinThresholdApplied | bit | Min Threshold(s) applies | - | |
Description:No description available | ||||
ResponseLimitImposed | bit | Limit Imposed | - | |
Description:No description available | ||||
ResponseOriginalValue | decimal | Original Value | - | |
Description:No description available | ||||
ResponseRawCalculatedValue | decimal | Raw Calculated Value | - | |
Description:No description available | ||||
ResponseReasonCode | nvarchar(100) | Reason Code | - | |
Description:No description available | ||||
ResponseReducedDeduction | bit | Reduced Deduction | - | |
Description:No description available | ||||
ResponseValueBeforeThreshold | decimal | Value Before Threshold | - | |
Description:No description available | ||||
StandardPayDerivationPercent | decimal | Percent | - | |
Description:No description available | ||||
StandardPayKiwisaverRateReductionEndDate | datetime | - | ||
Description:No description available | ||||
StandardPayResponseOriginalValue | decimal | Original Standard Pay Value | - | |
Description:No description available | ||||
StandardPayRowIndex | int | - | ||
Description:No description available | ||||
StandardPaySortOrder | int | - | ||
Description:No description available | ||||
SuperCategoryAUCD | nvarchar | Category | - | |
Description:No description available | ||||
SuperFundID | int | Superannuation Fund | - | |
Description:No description available | ||||
SuperFundMembershipNbr | nvarchar | Member ID | - | |
Description:No description available | ||||
SuperFundName | nvarchar | Fund Name | - | |
Description:No description available | ||||
SuperPaymentBatchID | int | - | ||
Description:No description available | ||||
SuperPaymentBatchNbr | nvarchar(25) | Super Batch Nbr | - | |
Description:No description available | ||||
SuppressRecalculateEventNonexistent in DB | bool? | - | ||
Description:No description available | ||||
TStamp | timestamp | - | ||
Description:No description available | ||||
TaxTypeDisplayTextNonexistent in DB | string | Taxation | - | |
Description:No description available | ||||
ThresholdEligibleEarningsPayItemCD | nvarchar | ThresholdEligibleEarningsPayItemCD | - | |
Description:No description available | ||||
ThresholdEligibleEarningsPayItemID | int | ThresholdEligibleEarningsPayItemID | - | |
Description:No description available | ||||
ThresholdEligibleEarningsRollupID | int | ThresholdEligibleEarningsRollupID | - | |
Description:No description available | ||||
ThresholdEligibleEarningsType | nvarchar | - | ||
Description:No description available | ||||
ThresholdIsEligibleEarningsDefined | bit | Eligible Earnings as defined | - | |
Description:No description available | ||||
ThresholdIsMinValueInclusive | bit | >= | - | |
Description:No description available | ||||
ThresholdMaxFrequency | int | Max frequency | - | |
Description:No description available | ||||
ThresholdMaxValue | decimal | Max Value | - | |
Description:No description available | ||||
ThresholdMaxValueType | int | Threshold is | - | |
Description:No description available | ||||
ThresholdMinFrequency | int | Min frequency | - | |
Description:No description available | ||||
ThresholdMinValue | decimal | Min Value | - | |
Description:No description available | ||||
ThresholdMinValueType | int | Threshold is | - | |
Description:No description available | ||||
ThresholdUseMaxSuperGuarantee | bit | ThresholdUseMaxSuperGuarantee | - | |
Description:No description available | ||||
ThresholdUseMinSuperGuarantee | bit | ThresholdUseMinSuperGuarantee | - | |
Description:No description available | ||||
UseRate | bit | UseRate | - | |
Description:No description available | ||||
ValueMultiplierDisplayTextNonexistent in DB | string | x | - | |
Description:No description available | ||||
YTDAmount | decimal | YTD Amount | - | |
Description:No description available | ||||