set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go








ALTER PROCEDURE [dbo].[STPGridList_CheckOut]
	@AccountCode int,
	@archiveName nvarchar(1000)=null
AS
SELECT     CheckOUTTBL.SerialNo, CheckOUTTBL.Comment AS CheckComment, CheckOUTTBL.CheckDate, FunDocumentDetail_ByAcc_Archive_1.DetailCode, 
                      FunDocumentDetail_ByAcc_Archive_1.AmmountOut, 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, 
                      CodeMNGDWNTbl.Title AS BankName, CheckOUTTBL.FK_BankAccount, Users.UName
FROM         CodeMNGDWNTbl AS CodeMNGDWNTbl_1 RIGHT OUTER JOIN
                      CodeMNGDWNTbl AS CodeMNGDWNTbl INNER JOIN
                      CheckOUTTBL ON CodeMNGDWNTbl.AccountSysCode = CheckOUTTBL.FK_BankAccount INNER JOIN
                      dbo.FunDocumentDetail_ByAcc_Archive_FromDate(@AccountCode, @archiveName, NULL) AS FunDocumentDetail_ByAcc_Archive_1 ON 
                      CheckOUTTBL.FK_DocSysCode = FunDocumentDetail_ByAcc_Archive_1.DetailCode LEFT OUTER JOIN
                      Users INNER JOIN
                      DocTbl ON Users.UID = DocTbl.UserIDNO ON FunDocumentDetail_ByAcc_Archive_1.DocCode = DocTbl.SysCode LEFT OUTER JOIN
                      [VW_LinkTo_Account&Title] ON CheckOUTTBL.FK_DocSysCode = [VW_LinkTo_Account&Title].LinkFrom ON 
                      CodeMNGDWNTbl_1.AccountSysCode = FunDocumentDetail_ByAcc_Archive_1.SndFk_AccountSyscode