set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO







create PROCEDURE [dbo].[STPGridList_DocDetailChange]
AS
SELECT     ChangeDocDetailTbl.Syscode, ChangeDocDetailTbl.Fk_docSysCode AS DocumentCode, ChangeDocDetailTbl.Fk_AccountSyscode, 
                      ChangeDocDetailTbl.AmmountIN, ChangeDocDetailTbl.AmmountOUT, ChangeDocDetailTbl.UserRowNo, ChangeDocDetailTbl.ArchiveName, 
                      CodeMNGDWNTbl_1.Title AS SndTitle, CodeMNGDWNTbl.Title AS AccountTitle, Users_1.UName AS OnChangeUName, 
                      ChangeDocDetailTbl.OnChangeUserId, ChangeDocDetailTbl.IsUpDated, ChangeDocDetailTbl.OnChangeSysDate, ChangeDocDetailTbl.Comment, 
                      CodeMNGUPTbl.Title AS AccountUpTitle
FROM         CodeMNGDWNTbl AS CodeMNGDWNTbl_1 RIGHT OUTER JOIN
                      CodeMNGUPTbl RIGHT OUTER JOIN
                      CodeMNGDWNTbl ON CodeMNGUPTbl.AccountSysCode0 = CodeMNGDWNTbl.FK_AccountSysCode0 RIGHT OUTER JOIN
                      ChangeDocDetailTbl ON CodeMNGDWNTbl.AccountSysCode = ChangeDocDetailTbl.Fk_AccountSyscode ON 
                      CodeMNGDWNTbl_1.AccountSysCode = ChangeDocDetailTbl.SndFk_AccountSyscode LEFT OUTER JOIN
                      Users AS Users_1 ON ChangeDocDetailTbl.OnChangeUserId = Users_1.UID