PayrollPostingControlHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PayrollPostingControlHistorySeq int identity 4 √ null
PostingNumber int 4 √ null
PayGroup varchar 5 √ null
JournalPrintedFlag bit 1 √ null
PayslipPrintedFlag bit 1 √ null
BankDepositPrintedFlag bit 1 √ null
PaymentAvailableDate datetime 16,3 √ null
LeaveCalcDateTime datetime 16,3 √ null
LeaveCalcRequiredFlag bit 1 √ null
PayStartDate datetime 16,3 √ null
PayEndDate datetime 16,3 √ null
SuperPaymentDate datetime 16,3 √ null
JournalPrintedDate datetime 16,3 √ null
JournalPrintedByID int 4 √ null
PayslipPrintedDate datetime 16,3 √ null
PayslipPrintedByID int 4 √ null
BankDepositPrintedDate datetime 16,3 √ null
BankDepositPrintedByID int 4 √ null
ChequePrintedFlag bit 1 null
ChequePrintedDate datetime 16,3 √ null
ChequePrintedByID int 4 √ null
PayLockedFlag bit 1 null
PayLockedDate datetime 16,3 √ null
PayLockedByID int 4 √ null
GovernmentSentFlag bit 1 null
GovernmentSentDate datetime 16,3 √ null
GovernmentSentByID int 4 √ null
ModifiedDate datetime 16,3 √ null
ModifiedByID int 4 √ null
DeleteFlag bit 1 √ null
SpecialPayRunFlag bit 1 ((0))
GovernmentSendEnabledFlag bit 1 √ ((0))
BASPostingNumber int 4 √ null
GovernmentSendEnabledChangeReason varchar 500 √ ('')
GLDate datetime 16,3 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_PayrollPostingControlHistory Primary key Asc PayrollPostingControlHistorySeq