FACT_REVENUE

CREATE view [BBDW].[FACT_REVENUE]
as
select 
  [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLINEITEMFACTID] as [REVENUEFACTID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLINEITEMSYSTEMID] as [REVENUEAPPLICATIONSYSTEMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONSYSTEMID] as [REVENUESYSTEMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONSEQUENCEID] as [REVENUESEQUENCEID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLOOKUPID] as [REVENUELOOKUPID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[REVENUECODEDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[REVENUEFLAGDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[REVENUECHANNELDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[GLREVENUECATEGORYDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONDATEDIMID] as [REVENUEDATEDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONDATE] as [REVENUEDATE],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONPOSTDATEDIMID] as [POSTDATEDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONPOSTDATE] as [POSTDATE],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[DESIGNATIONDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[PURPOSELEVEL1DIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[PURPOSELEVEL2DIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[PURPOSELEVEL3DIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[PURPOSELEVEL4DIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[PURPOSELEVEL5DIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[CONSTITUENTDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[CONSTITUENTSYSTEMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[APPEALDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[MARKETINGSEGMENTDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[MARKETINGSOURCECODEDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[MARKETINGCONSTITUENTFACTID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[EVENTREGISTRANTFACTID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLINEITEMAMOUNT] as [REVENUEAPPLICATIONAMOUNT],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONAMOUNT] as [TOTALREVENUEAMOUNT],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONRECEIPTAMOUNT] as [TOTALREVENUERECEIPTAMOUNT],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[ISINCLUDED],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[SOURCEDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[ETLCONTROLID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[BASECURRENCYDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONBASEAMOUNT] as [BASETOTALREVENUEAMOUNT],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLINEITEMBASEAMOUNT] as [BASEREVENUEAPPLICATIONAMOUNT],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONDATETIMEOFFSET] as [REVENUEDATETIMEOFFSET],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[ACCOUNTSYSTEMDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[CHANGEDDATEDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[CHANGEDDATE],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[APPUSERDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[CHECKNUMBER],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[CREDITCARDTYPEDIMID],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[CHECKFUZZYDATE],
  [FACT_FINANCIALTRANSACTIONLINEITEM].[MARKETINGSEGMENTATIONDIMID]
from
  [BBDW].[FACT_FINANCIALTRANSACTIONLINEITEM] 
  inner join [BBDW].[DIM_REVENUECODE] on [FACT_FINANCIALTRANSACTIONLINEITEM].[REVENUECODEDIMID] = [DIM_REVENUECODE].[REVENUECODEDIMID]
  inner join [BBDW].[DIM_REVENUEFLAG] on [FACT_FINANCIALTRANSACTIONLINEITEM].[REVENUEFLAGDIMID] = [DIM_REVENUEFLAG].[REVENUEFLAGDIMID]
where    
  [DIM_REVENUECODE].[REVENUETRANSACTIONTYPECODE] in (0,1,2,3,4,5,6,7,8,9,15)
  and [DIM_REVENUECODE].[REVENUEAPPLICATIONTYPECODE] > -1    
  and [DIM_REVENUECODE].[FINANCIALTRANSACTIONLINEITEMTYPECODE] != 1
  and [DIM_REVENUEFLAG].[ISDELETEDFINANCIALTRANSACTIONLINEITEM] = 0