tPayrollEmployeePayMethodsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tPayrollEmployeePayMethodsHistorySeq int identity 4 √ null
PostingNumber int 4 √ null
ID int 4 √ null
PayMethodSeq tinyint 1 √ null
PayMethodCode varchar 5 √ null
PayAmount varchar 80 √ null
BankBSB varchar 80 √ null
BankAccount varchar 80 √ null
BankReference varchar 32 √ null
PayrollEmployeePayMethodGUID int 4 √ null
PayPercent decimal 7,2 √ null
ModifiedDate datetime 16,3 √ null
ModifiedByID int 4 √ null
DeleteFlag bit 1 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_tPayrollEmployeePayMethodsHistory Primary key Asc tPayrollEmployeePayMethodsHistorySeq
AK_tPayrollEmployeePayMethodsHistory_PayrollEmployeePayMethodGUID Performance Asc PayrollEmployeePayMethodGUID