set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go







ALTER PROCEDURE [dbo].[STPGridList_DocDetail_ByArchiveFromDate]
	@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_1.Title AS Snd_Tilte, FunDocumentDetail_ByAcc_Archive_FromDate_1.AccountCode, VWCompleteCode.Title, 
                      VWCompleteCode.Title0, FunDocumentDetail_ByAcc_Archive_FromDate_1.AmmountIn * 0 AS Remain, 
                      FunDocumentDetail_ByAcc_Archive_FromDate_1.DocCode, Users.UName
FROM         CodeMNGDWNTbl AS CodeMNGDWNTbl_1 RIGHT OUTER JOIN
                      dbo.FunDocumentDetail_Archive_FromDate(NULL, @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 LEFT OUTER JOIN
                      VWCompleteCode ON FunDocumentDetail_ByAcc_Archive_FromDate_1.AccountCode = VWCompleteCode.AccountSysCode ON 
                      CodeMNGDWNTbl_1.AccountSysCode = FunDocumentDetail_ByAcc_Archive_FromDate_1.SndFk_AccountSyscode