vPayrollPaydayEmploymentInformation


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PayrollGovtSubmissionSeq int 4 null
PostingNumber int 4 null
PayType varchar 10 √ null
HeaderEmployerIRDNumber varchar 9 √ null
HeaderPayDate datetime 16,3 √ null
HeaderFinalReturnIndicator varchar 1 √ null
HeaderNilReturnIndicator varchar 1 √ null
HeaderIntermediaryIRD varchar 9 √ null
HeaderContactName varchar 20 √ null
HeaderContactPhone varchar 12 √ null
HeaderContactEmail varchar 60 √ null
HeaderTotalEmployeeLines int 4 √ null
HeaderTotalTax money 21,4 √ null
HeaderTotalChildSupport money 21,4 √ null
HeaderTotalStudentLoan money 21,4 √ null
HeaderTotalKiwiSaverEmployee money 21,4 √ null
HeaderTotalKiwisaverEmployer money 21,4 √ null
HeaderTotalESCT money 21,4 √ null
HeaderTotalDeductions money 21,4 √ null
HeaderTotalTaxCreditsForDonations money 21,4 √ null
HeaderTotalFamilyTaxCredits money 21,4 √ null
HeaderTotalGross money 21,4 √ null
HeaderTotalNotLiableEarnersLevy money 21,4 √ null
HeaderPayrollPackageVersion varchar 80 √ null
HeaderIRFormVersion varchar 4 √ null
PayrollGovtSubmissionEmployeeSeq int 4 √ null
EmployeeID int 4 √ null
EmployeeIRDNumber varchar 9 √ null
EmployeeName varchar 20 √ null
EmployeeTaxCode varchar 5 √ null
EmployeeEmploymentStartDate datetime 16,3 √ null
EmployeeEmploymentFinishDate datetime 16,3 √ null
EmployeePayPeriodStartDate datetime 16,3 √ null
EmployeePayPeriodEndDate datetime 16,3 √ null
EmployeePayCycle varchar 2 √ null
EmployeeGross money 21,4 √ null
EmployeeNotLiableEarnersLevy money 21,4 √ null
EmployeeLumpSumIndicator int 4 √ null
EmployeeTax money 21,4 √ null
EmployeeChildSupport money 21,4 √ null
EmployeeChildSupportCode varchar 1 √ null
EmployeeStudentLoanMain money 21,4 √ null
EmployeeStudentLoanSLBOR money 21,4 √ null
EmployeeStudentLoanSLCIR money 21,4 √ null
EmployeeKiwiSaverEmployee money 21,4 √ null
EmployeeKiwisaverEmployer money 21,4 √ null
EmployeeESCT money 21,4 √ null
EmployeeTaxCreditsForDonations money 21,4 √ null
EmployeeFamilyTaxCredits money 21,4 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views