tPayrollEmployeePayDetailsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tPayrollEmployeePayDetailsHistorySeq int identity 4 √ null
PayrollYear smallint 2 √ null
PostingNumber int 4 √ null
ID int 4 √ null
PayrollLineSeq smallint 2 √ null
PayCode varchar 10 √ null
GLCode varchar 15 √ null
GLSubAllocationCode varchar 15 √ null
PayRate varchar 80 √ null
PayUnits decimal 12,5 √ null
PayFactor decimal 12,8 √ null
PayAmount varchar 80 √ null
Description varchar 50 √ null
LeaveHistorySeq int 4 √ null
PayrollEmployeePayDetailGUID int 4 √ null
LeaveTransactionsSeq int 4 √ null
tPayrollEmployeePayDetailBackPaysSeq int 4 √ null
SuperContributionTax varchar 80 √ null
tPayrollEmployeeSuperannuationFundSeq int 4 √ null
ModifiedDate datetime 16,3 √ null
ModifiedByID int 4 √ null
DeleteFlag bit 1 √ null
ETPReasonCode varchar 15 √ null
PayrollEmployeeStandardPayDetailGUID int 4 √ null
ChildSupportPaymentCode varchar 15 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_tPayrollEmployeePayDetailsHistory Primary key Asc tPayrollEmployeePayDetailsHistorySeq
AK_tPayrollEmployeePayDetailsHistory_PayrollEmployeePayDetailGUID Performance Asc PayrollEmployeePayDetailGUID