tPayrollEmployeePaysHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tPayrollEmployeePaysHistorySeq int identity 4 √ null
PayrollYear smallint 2 √ null
PostingNumber int 4 √ null
ID int 4 √ null
FrequencyCode varchar 5 √ null
PayPeriods decimal 10,4 √ null
OverridePayMethodCode varchar 5 √ null
GrossPay varchar 80 √ null
HECS varchar 80 √ null
TotalTaxation varchar 80 √ null
TaxationOverrideFlag bit 1 √ null
NettPay varchar 80 √ null
ChequeNumber varchar 80 √ null
EmployerSuperannuation varchar 80 √ null
Description varchar 255 √ null
NormalPay varchar 80 √ null
SalarySacrifice varchar 80 √ null
TaxableAllowances varchar 80 √ null
NonTaxableAllowances varchar 80 √ null
Deductions varchar 80 √ null
EmployeeSuperannuation varchar 80 √ null
TerminationPay varchar 80 √ null
ChequeDate datetime 16,3 √ null
PayrollEmployeePayGUID int 4 √ null
OverrideBankDetailsFlag bit 1 √ null
LeaveByHoursCalculatedFlag bit 1 √ null
PayrollEmployeeDocumentsSeq int 4 √ null
BackPayTax varchar 80 √ null
BackPayHECS varchar 80 √ null
SuperContributionTax varchar 80 √ null
CreatedDate datetime 16,3 √ null
CreatedBy varchar 30 √ null
ModifiedDate datetime 16,3 √ null
ModifiedByID int 4 √ null
DeleteFlag bit 1 √ null
OtherPaymentGross varchar 80 √ null
OtherPaymentWithholding varchar 80 √ null
SalarySacrificeSuperannuation varchar 80 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_tPayrollEmployeePaysHistory Primary key Asc tPayrollEmployeePaysHistorySeq
AK_tPayrollEmployeePaysHistory_PayrollEmployeePayGUID Performance Asc PayrollEmployeePayGUID