tPayrollEmployeeStandardPayMethodsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tPayrollEmployeeStandardPayMethodsHistorySeq int identity 4 √ null
PayrollYear smallint 2 √ null
ID int 4 √ null
PayMethodSeq tinyint 1 √ null
ModifiedBy varchar 50 √ null
ModifiedDate datetime 16,3 √ null
PayMethodCode varchar 5 √ null
SplitPercent decimal 7,2 √ null
SplitAmount varchar 80 √ null
BankBSB varchar 80 √ null
BankAccount varchar 80 √ null
BankReference varchar 32 √ null
PayrollEmployeeStandardPayMethodGUID int 4 √ null
DeleteFlag bit 1 ((0))

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
AK_tPayrollEmployeeStandardPayMethodsHistory_ID Performance Asc/Asc PayrollYear + ID