REVENUEPOSTED

Fields

Field	Field Type	Null
ID	uniqueidentifier
ADDEDBYID	uniqueidentifier
CHANGEDBYID	uniqueidentifier
DATEADDED	datetime	yes
DATECHANGED	datetime
TS	timestamp
TSLONG	bigint	yes

Definition

Copy


CREATE view dbo.REVENUEPOSTED with schemabinding as 
    select 
        FINANCIALTRANSACTION.ID,
        FINANCIALTRANSACTION.ADDEDBYID, 
        FINANCIALTRANSACTION.CHANGEDBYID, 
        COALESCE
        (REVENUEPOSTEDTEMP.DATEADDED,
        (select top 1 AUDITDATE from dbo.FINANCIALTRANSACTIONAUDIT where FINANCIALTRANSACTION.ID = FINANCIALTRANSACTIONAUDIT.AUDITRECORDID and FINANCIALTRANSACTIONAUDIT.POSTSTATUSCODE = 2 order by FINANCIALTRANSACTIONAUDIT.AUDITDATE  asc )
        ,FINANCIALTRANSACTION.DATEADDED
        ) as DATEADDED,
        FINANCIALTRANSACTION.DATECHANGED, 
        FINANCIALTRANSACTION.TS, 
        FINANCIALTRANSACTION.TSLONG
    from dbo.FINANCIALTRANSACTION
    left outer join dbo.REVENUEPOSTEDTEMP on FINANCIALTRANSACTION.ID = REVENUEPOSTEDTEMP.ID   
    where FINANCIALTRANSACTION.POSTSTATUSCODE = 2 and FINANCIALTRANSACTION.TYPECODE in (0,1,2,3,4,5,6,7,8,9,15) and FINANCIALTRANSACTION.DELETEDON is null