set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO







create PROCEDURE [dbo].[STPGridList_InvoiceChange]
AS
SELECT     Users_1.UName AS OnChangeUName, Users.UName, CodeMNGDWNTbl.Title AS AccountTitle, ChangeInvoiceTbl.CustomerName, 
                      ChangeInvoiceTbl.FK_AccountSysCode, ChangeInvoiceTbl.Comment, ChangeInvoiceTbl.InvoiceSerialNo, ChangeInvoiceTbl.RecivedDate, 
                      ChangeInvoiceTbl.DelivaredDate, ChangeInvoiceTbl.PaymentDate, ChangeInvoiceTbl.InvoiceDate, 
                      ChangeInvoiceTbl.FK_DocsysCode AS DetailSysCode, ChangeInvoiceTbl.ArchiveName, ChangeInvoiceTbl.UserNo, ChangeInvoiceTbl.InvoiceNo, 
                      ChangeInvoiceTbl.VisitorSyscode, CodeMNGDWNTbl_1.Title AS Visitor, ChangeInvoiceTbl.SysDate, InfoInvoiceType.Caption AS Type, 
                      ChangeInvoiceTbl.Amani, ChangeInvoiceTbl.OnChangeUserId, ChangeInvoiceTbl.OnChangeSysDate, ChangeInvoiceTbl.IsUpDated
FROM         InfoInvoiceType RIGHT OUTER JOIN
                      ChangeInvoiceTbl ON InfoInvoiceType.Value = ChangeInvoiceTbl.Type LEFT OUTER JOIN
                      CodeMNGDWNTbl AS CodeMNGDWNTbl_1 ON ChangeInvoiceTbl.VisitorSyscode = CodeMNGDWNTbl_1.AccountSysCode LEFT OUTER JOIN
                      CodeMNGDWNTbl ON ChangeInvoiceTbl.FK_AccountSysCode = CodeMNGDWNTbl.AccountSysCode LEFT OUTER JOIN
                      Users ON ChangeInvoiceTbl.UserNo = Users.UID LEFT OUTER JOIN
                      Users AS Users_1 ON ChangeInvoiceTbl.OnChangeUserId = Users_1.UID