set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go






ALTER PROCEDURE [dbo].[STPGridList_CheckIn]
	@AccountCode int,
	@archiveName nvarchar(100)=null
AS
SELECT     CheckInTBL.SerialNo, CheckInTBL.Comment AS CheckComment, CheckInTBL.ACCNo, CheckInTBL.CheckDate, CheckInTBL.BankName, 
                      CASE WHEN [VW_LinkTo_Account&Title].linkto IS NULL THEN codemngdwntbl.Title ELSE NULL END AS BankToName, 
                      FunDocumentDetail_ByAcc_Archive_1.DetailCode, FunDocumentDetail_ByAcc_Archive_1.AmmountIn, 
                      FunDocumentDetail_ByAcc_Archive_1.UserRowNo, FunDocumentDetail_ByAcc_Archive_1.DocDate, FunDocumentDetail_ByAcc_Archive_1.Comment, 
                      FunDocumentDetail_ByAcc_Archive_1.ArchiveName, FunDocumentDetail_ByAcc_Archive_1.SysDate, CodeMNGDWNTbl_1.Title AS Snd_Title, 
                      [VW_LinkTo_Account&Title].LinkToTitle
FROM         dbo.FunDocumentDetail_ByAcc_Archive_FromDate(@AccountCode, @archiveName, '') AS FunDocumentDetail_ByAcc_Archive_1 LEFT OUTER JOIN
                      CheckInTBL ON FunDocumentDetail_ByAcc_Archive_1.DetailCode = CheckInTBL.FK_DocSysCode LEFT OUTER JOIN
                      [VW_LinkTo_Account&Title] ON CheckInTBL.FK_DocSysCode = [VW_LinkTo_Account&Title].LinkFrom LEFT OUTER JOIN
                      CodeMNGDWNTbl AS CodeMNGDWNTbl ON CheckInTBL.BankAccountCode = CodeMNGDWNTbl.AccountSysCode LEFT OUTER JOIN
                      CodeMNGDWNTbl AS CodeMNGDWNTbl_1 ON FunDocumentDetail_ByAcc_Archive_1.SndFk_AccountSyscode = CodeMNGDWNTbl_1.AccountSysCode