set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go







ALTER PROCEDURE [dbo].[STPGridList_Account_DocDetail_ByArchiveFromDate]
	@AccountCode int ,
	@archiveName nvarchar(1000)=null,
	@FromDate varChar(8)=''
AS

SELECT     FunDocumentDetail_ByAcc_Archive_FromDate_1.DetailCode, FunDocumentDetail_ByAcc_Archive_FromDate_1.AmmountIn, 
                      FunDocumentDetail_ByAcc_Archive_FromDate_1.AmmountOut, FunDocumentDetail_ByAcc_Archive_FromDate_1.UserRowNo, 
                      FunDocumentDetail_ByAcc_Archive_FromDate_1.DocDate, FunDocumentDetail_ByAcc_Archive_FromDate_1.Comment, 
                      FunDocumentDetail_ByAcc_Archive_FromDate_1.ArchiveName, FunDocumentDetail_ByAcc_Archive_FromDate_1.SysDate, 
                      CodeMNGDWNTbl.Title AS Snd_Tilte, FunDocumentDetail_ByAcc_Archive_FromDate_1.AmmountIn * 0 AS Remain, Users.UName
FROM         CodeMNGDWNTbl RIGHT OUTER JOIN
                      dbo.FunDocumentDetail_ByAcc_Archive_FromDate(@AccountCode, @archiveName, @FromDate) 
                      AS FunDocumentDetail_ByAcc_Archive_FromDate_1 LEFT OUTER JOIN
                      Users INNER JOIN
                      DocTbl ON Users.UID = DocTbl.UserIDNO ON FunDocumentDetail_ByAcc_Archive_FromDate_1.DocCode = DocTbl.SysCode ON 
                      CodeMNGDWNTbl.AccountSysCode = FunDocumentDetail_ByAcc_Archive_FromDate_1.SndFk_AccountSyscode