PayrollPostingControl


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PostingNumber int 4 null
PayrollInUseRegister.PostingNumber FK_PayrollInUseRegister_PayrollPostingControl R
PayrollUpdatePostingEmployee.PostingNumber FK_PayrollUpdatePostingEmployee_PostingNumber R
tPayrollGovtSubmission.PostingNumber FK_tPayrollGovtSubmission_PayrollPostingControl R
PayGroup varchar 5 ('')
JournalPrintedFlag bit 1 ((0))
PayslipPrintedFlag bit 1 ((0))
BankDepositPrintedFlag bit 1 ((0))
PaymentAvailableDate datetime 16,3 √ null
LeaveCalcDateTime datetime 16,3 √ null
LeaveCalcRequiredFlag bit 1 ((0))
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 ((0))
ChequePrintedDate datetime 16,3 √ null
ChequePrintedByID int 4 √ null
PayLockedFlag bit 1 ((0))
PayLockedDate datetime 16,3 √ null
PayLockedByID int 4 √ null
GovernmentSentFlag bit 1 ((0))
GovernmentSentDate datetime 16,3 √ null
GovernmentSentByID int 4 √ null
GovernmentSendEnabledFlag bit 1 ((0))
SpecialPayRunFlag 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_PayrollPostingControl_PostingNumber Primary key Asc PostingNumber
AK_PayrollPostingControl_BASPostingNumber Performance Asc BASPostingNumber

Relationships

Close relationships within degrees of separation