/*

This view pulls accounting information from a SQLServer 2000 database.

February 12, 2003

Tony

*/

CREATE VIEW dbo.SPARS2_TitleIncome_Forward_vw

AS

SELECT ARTran.RefNbr, ARTran.TranAmt, ARTran.Acct, Account.User6, ARDoc.DocType, ARDoc.OrigDocAmt, ARDoc.Rlsed, ardoc.user7

FROM ARTran

INNER JOIN Account ON ARTran.Acct = Account.Acct

INNER JOIN ARDoc ON ARTran.RefNbr = ARDoc.RefNbr

WHERE (Account.User6 = 'TI') AND (ARDoc.DocType = 'IN' OR

ARDoc.DocType = 'DM') AND (ARDoc.Rlsed = '1') and (ardoc.user7 BETWEEN (CAST(STR(MONTH(GETDATE())) + '/' + STR(01) + '/' + STR(YEAR(GETDATE())) AS DateTime)) AND

GETDATE())

UNION

SELECT ARTran.RefNbr, ARTran.TranAmt*-1, ARTran.Acct, Account.User6, ARDoc.DocType, ARDoc.OrigDocAmt, ARDoc.Rlsed, ardoc.user7

FROM ARTran INNER JOIN

Account ON ARTran.Acct = Account.Acct INNER JOIN

ARDoc ON ARTran.RefNbr = ARDoc.RefNbr

WHERE (Account.User6 = 'TI') AND (ARDoc.DocType = 'CM' OR

ARDoc.DocType = 'PA') AND (ARDoc.Rlsed = '1') and (ardoc.user7 BETWEEN (CAST(STR(MONTH(GETDATE())) + '/' + STR(01) + '/' + STR(YEAR(GETDATE())) AS DateTime)) AND

GETDATE())