pvPayrollPostingControl


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PostingNumber int 4 null
PostingSource varchar 10 null
PayGroup varchar 5 null
PostingDescription varchar 60 null
BankCode varchar 15 null
PostingDate datetime 16,3 √ null
PayDate datetime 16,3 √ null
GLDate datetime 16,3 √ null
PayStartDate datetime 16,3 √ null
PayEndDate datetime 16,3 √ null
SuperPaymentDate datetime 16,3 √ null
PaymentAvailableDate datetime 16,3 √ null
SuperCalcDate datetime 16,3 √ null
SuperCalcMonthEndDate date 20 √ null
SuperCalcBasedOn char 1 null
SupercalcBasedOnDescription varchar 22 √ null
LeaveCalcDate datetime 16,3 √ null
LeaveCalcBasedOn char 1 null
LeavecalcBasedOnDescription varchar 22 √ null
LeaveCalcDateTime datetime 16,3 √ null
LeaveCalcRequiredFlag bit 1 null
PayLockedFlag bit 1 null
PayLockedDate datetime 16,3 √ null
PayLockedByID int 4 √ null
PayLockedBy varchar 100 √ null
JournalPrintedFlag bit 1 null
JournalPrintedDate datetime 16,3 √ null
JournalPrintedByID int 4 √ null
JournalPrintedBy varchar 100 √ null
BankDepositRequiredFlag bit 1 √ null
BankDepositPrintedFlag bit 1 null
BankDepositPrintedDate datetime 16,3 √ null
BankDepositPrintedByID int 4 √ null
BankDepositPrintedBy varchar 100 √ null
ChequePrintRequiredFlag bit 1 √ null
ChequePrintedFlag bit 1 null
ChequePrintedDate datetime 16,3 √ null
ChequePrintedByID int 4 √ null
ChequePrintedBy varchar 100 √ null
PayslipPrintedFlag bit 1 null
PayslipPrintedDate datetime 16,3 √ null
PayslipPrintedByID int 4 √ null
PayslipPrintedBy varchar 100 √ null
GovernmentSendEnabledFlag bit 1 null
GovernmentSendRequiredFlag bit 1 √ null
GovernmentSendRequiredComment varchar 88 null
GovernmentSendNormallyRequiredFlag bit 1 null
GovernmentSendInProcessFlag bit 1 √ null
GovernmentSendInProcessDate datetime 16,3 √ null
GovernmentSendInProcessByID varchar 100 √ null
GovernmentSendInProcessBy varchar 100 √ null
GovernmentSendInProcessStatus varchar 50 √ null
GovernmentSendInProcessSubStatus varchar 50 √ null
GovernmentSendInProcessShortDescription varchar 100 √ null
GovernmentSendInProcessrefPayrollGovtSubmissionStatusSeq int 4 √ null
GovernmentSendCantTouchFlag bit 1 √ null
GovernmentSendCompleteFlag bit 1 √ null
GovernmentSendStatusShort varchar 21 null
PayrollGovtSubmissionSeq int 4 √ null
PayrollGovtSubmissionSeqAmend int 4 √ null
GovernmentSentFlag bit 1 null
GovernmentSentDate datetime 16,3 √ null
GovernmentSentByID int 4 √ null
GovernmentSentBy varchar 100 √ null
PayrollClosedFlag bit 1 null
PayrollClosedDate datetime 16,3 √ null
PayrollClosedByID int 4 √ null
PayrollClosedBy varchar 100 √ null
PostingCompleteFlag bit 1 √ null
PostingModifiedFlag bit 1 null
LumpSumDOnlyFlag bit 1 null
BASPostingNumber int 4 √ null
NewZealandFlag bit 1 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views