set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO



ALTER PROCEDURE [dbo].[STPGetCheckOut_Print]
	/*
	*/
		@DetailCode int
AS
SELECT     CheckOUTTBL.SerialNo, CheckOUTTBL.Comment AS CheckComment, CheckOUTTBL.CheckDate, CheckOUTTBL.FK_DocSysCode, 
                      dbo.FunConvDateToString(CheckOUTTBL.CheckDate) AS CheckDateString, DocDetailTbl.AmmountOUT AS Amount, 
                      DocDetailTbl.Comment AS DocComment, VWCompleteCode.Title AS To_AccountTitle, BanksTbl.AccountNo, 
                      dbo.FunConvCurToString(DocDetailTbl.AmmountOUT) AS AmountString, floor(DocDetailTbl.AmmountOUT / 10) AS Amount_Toman, 
                      dbo.FunConvCurToString(floor(DocDetailTbl.AmmountOUT / 10)) AS Amount_TomanString
FROM         CheckOUTTBL INNER JOIN
                      DocDetailTbl ON CheckOUTTBL.FK_DocSysCode = DocDetailTbl.Syscode INNER JOIN
                      BanksTbl ON CheckOUTTBL.FK_BankAccount = BanksTbl.Fk_AccountSyscode LEFT OUTER JOIN
                      VWCompleteCode ON DocDetailTbl.SndFk_AccountSyscode = VWCompleteCode.AccountSysCode
WHERE     (CheckOUTTBL.FK_DocSysCode = @DetailCode)