| Description |
*ISSUE:*
!pastedImage_d39494_0.png! *FINDINGS:*
CREATE VIEW [dbo].[vyuPRPaycheckHistory]
AS
SELECT PC.intPaycheckId,
PC.strPaycheckId,
PC.intEmployeeId,
PC.dtmPayDate,
PC.intBankAccountId,
{color:#b22222} CM.strBankAccountNo, --Paycheck Check No should be coming from tblCMBankTransaction.strReferenceNo{color}
PC.dblGross,
PC.dblNetPayTotal,
PC.dblTaxTotal,
PC.db
lDeductionTotal,
PC.ysnPosted
FROM dbo.tblPRPaycheck PC
INNER JOIN dbo.tblCMBankAccount CM ON PC.intBankAccountId = CM.intBankAccountId
*ACCEPTANCE:*
It should display the Paycheck Check No under the Check No column of the Paycheck > History tab
|