FACT_FINANCIALTRANSACTIONLINEITEM_STAGE

Contains information about financialtransactionlineitem.

Fields

Field	Field Type	Null	Notes	Description
FINANCIALTRANSACTIONLINEITEMSYSTEMID	uniqueidentifier	yes		dbo.[FINANCIALTRANSACTIONLINEITEM].[ID]
FINANCIALTRANSACTIONSYSTEMID	uniqueidentifier	yes		dbo.[FINANCIALTRANSACTION].[ID]
FINANCIALTRANSACTIONSEQUENCEID	int	yes		dbo.[FINANCIALTRANSACTION].[SEQUENCEGENERATORID]
FINANCIALTRANSACTIONLOOKUPID	nvarchar(100)	yes		dbo.[FINANCIALTRANSACTION].[USERDEFINEDID]
REVENUEFLAGDIMID	int	yes		Reference key to the revenue flag dimension, derived from the boolean fields on dbo.[REVENUE_EXT]
REVENUECHANNELDIMID	int	yes		Reference key to the appeal dimension, derived from dbo.[REVENUE_EXT].[CHANNELCODEID]
FINANCIALTRANSACTIONDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[FINANCIALTRANSACTION].[DATE]
FINANCIALTRANSACTIONDATE	datetime	yes		dbo.[FINANCIALTRANSACTION].[DATE]
FINANCIALTRANSACTIONPOSTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[FINANCIALTRANSACTION].[POSTDATE]
FINANCIALTRANSACTIONPOSTDATE	datetime	yes		dbo.[FINANCIALTRANSACTION].[POSTDATE]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[FINANCIALTRANSACTION].[CONSTITUENTID]
APPEALDIMID	int	yes		Reference key to the appeal dimension, derived from dbo.[REVENUE_EXT].[APPEALID]
MARKETINGSEGMENTDIMID	int	yes		Reference key to the marketing segment dimension, derived from dbo.[REVENUESEGMENT].[SEGMENTID] and dbo.[REVENUESEGMENT].[TESTSEGMENTID]
MARKETINGSOURCECODEDIMID	int	yes		Reference key to the marketing source code dimension, derived from dbo.[REVENUESEGMENT].[SOURCECODEMAPID]
FINANCIALTRANSACTIONAMOUNT	money	yes		dbo.[FINANCIALTRANSACTION].[ORGAMOUNT]
FINANCIALTRANSACTIONRECEIPTAMOUNT	money	yes		dbo.[REVENUE_EXT].[RECEIPTAMOUNT]
BASECURRENCYDIMID	int	yes		Reference key to the currency dimension, derived from dbo.[PDACCOUNTSYSTEM].[CURRENCYID]
FINANCIALTRANSACTIONBASEAMOUNT	money	yes		dbo.[FINANCIALTRANSACTION].[BASEAMOUNT]
PAYMENTMETHODCODE	int	yes		[dbo].[REVENUEPAYMENTMETHOD].[PAYMENTMETHODCODE]
PAYMENTMETHOD	nvarchar(50)	yes		[dbo].[REVENUEPAYMENTMETHOD].[PAYMENTMETHOD]
FINANCIALTRANSACTIONTRANSACTIONTYPECODE	int	yes		[dbo].[FINANCIALTRANSACTION].[TYPECODE]
FINANCIALTRANSACTIONTRANSACTIONTYPE	nvarchar(50)	yes		[dbo].[FINANCIALTRANSACTION].[TYPE]
FINANCIALTRANSACTIONPOSTSTATUSCODE	int	yes		[dbo].[FINANCIALTRANSACTION].[POSTSTATUSCODE]
FINANCIALTRANSACTIONPOSTSTATUS	nvarchar(50)	yes		[dbo].[FINANCIALTRANSACTION].[POSTSTATUS]
RECEIPTTYPECODE	int	yes		[dbo].[REVENUE_EXT].[RECEIPTTYPECODE]
RECEIPTTYPE	nvarchar(50)	yes		dbo.[REVENUE_EXT].[RECEIPTTYPE]
FINANCIALTRANSACTIONDATETIMEOFFSET	datetimeoffset	yes		dbo.[FINANCIALTRANSACTION].[DATE]
ACCOUNTSYSTEMDIMID	int	yes		Reference key to the account system dimension, derived from dbo.[FINANCIALTRANSACTION].[PDACCOUNTSYSTEMID]
APPUSERDIMID	int	yes		Reference key to appuser dimension, derived from [dbo].[APPUSER][ID]
CHECKNUMBER	nvarchar(50)	yes		dbo.[CHECKPAYMENTMETHODDETAIL].[CHECKNUMBER]
CREDITCARDTYPEDIMID	int	yes		Reference key to creditcardtype dimension, derived from [dbo].[CREDITCARDTYPE][ID]
CHECKFUZZYDATE	char(8)	yes		[CHECKPAYMENTMETHODDETAIL].[CHECKDATE]
GLREVENUECATEGORYDIMID	int	yes		Reference key to the GL revenue category dimension, derived from dbo.[REVENUECATEGORY].[GLREVENUECATEGORYID]
FINANCIALTRANSACTIONLINEITEMPOSTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[FINANCIALTRANSACTIONLINEITEM].[POSTDATE]
FINANCIALTRANSACTIONLINEITEMPOSTDATE	datetime	yes		dbo.[FINANCIALTRANSACTIONLINEITEM].[POSTDATE]
FINANCIALTRANSACTIONLINEITEMPOSTSTATUSCODE	tinyint	yes		[dbo].[FINANCIALTRANSACTIONLINEITEM].[POSTSTATUSCODE]
FINANCIALTRANSACTIONLINEITEMPOSTSTATUS	nvarchar(50)	yes		[dbo].[FINANCIALTRANSACTIONLINEITEM].[POSTSTATUS]
DESIGNATIONDIMID	int	yes		Reference key to the designation dimension, derived from dbo.[REVENUESPLIT_EXT].[DESIGNATIONID]
PURPOSELEVEL1DIMID	int	yes		Reference key to the purpose level dimension, derived from dbo.[DESIGNATION].[DESIGNATIONLEVEL1ID]
PURPOSELEVEL2DIMID	int	yes		Reference key to the purpose level dimension, derived from dbo.[DESIGNATION].[DESIGNATIONLEVEL2ID]
PURPOSELEVEL3DIMID	int	yes		Reference key to the purpose level dimension, derived from dbo.[DESIGNATION].[DESIGNATIONLEVEL3ID]
PURPOSELEVEL4DIMID	int	yes		Reference key to the purpose level dimension, derived from dbo.[DESIGNATION].[DESIGNATIONLEVEL4ID]
PURPOSELEVEL5DIMID	int	yes		Reference key to the purpose level dimension, derived from dbo.[DESIGNATION].[DESIGNATIONLEVEL5ID]
EVENTREGISTRANTSYSTEMID	uniqueidentifier	yes		dbo.[EVENTREGISTRANTPAYMENT].[REGISTRANTID]
FINANCIALTRANSACTIONLINEITEMAMOUNT	money	yes		dbo.[FINANCIALTRANSACTIONLINEITEM].[ORGAMOUNT]
FINANCIALTRANSACTIONLINEITEMBASEAMOUNT	money	yes		dbo.[FINANCIALTRANSACTION].[BASEAMOUNT]
FINANCIALTRANSACTIONLINEITEMAPPLICATIONTYPECODE	int	yes		[dbo].[REVENUESPLIT_EXT].[TYPECODE]
FINANCIALTRANSACTIONLINEITEMAPPLICATIONTYPE	nvarchar(50)	yes		[dbo].[REVENUESPLIT_EXT].[TYPE]
FINANCIALTRANSACTIONLINEITEMAPPLICATIONCODE	int	yes		[dbo].[REVENUESPLIT_EXT].[APPLICATIONCODE]
FINANCIALTRANSACTIONLINEITEMAPPLICATION	nvarchar(50)	yes		[dbo].[REVENUESPLIT_EXT].[APPLICATION]
FINANCIALTRANSACTIONLINEITEMTYPECODE	int	yes		[dbo].[FINANCIALTRANSACTIONLINEITEM].[TYPECODE]
FINANCIALTRANSACTIONLINEITEMTYPE	nvarchar(50)	yes		[dbo].[FINANCIALTRANSACTIONLINEITEM].[TYPE]
CHANGEDDATEDIMID	int	yes		Reference key to date dimension, derived from [dbo].[REVENUE].[DATECHANGED]
CHANGEDDATE	datetime	yes		dbo.[FINANCIALTRANSACTION].[DATECHANGED]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
SOURCEDIMID	int	yes		Source system used.
ETLCONTROLID	int	yes		ID generated through the ETL process.
BATCHNUMBER	nvarchar(100)	yes		dbo.[REVENUE_EXT].[BATCHNUMBER]
SOURCELINEITEMSYSTEMID	uniqueidentifier	yes		dbo.[FINANCIALTRANSACTIONLINEITEM].[SOURCELINEITEMID]
FINANCIALTRANSACTIONLINEITEMADJUSTMENTSYSTEMID	uniqueidentifier	yes		dbo.[FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLINEITEMADJUSTMENTID]
ADJUSTMENTCONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[FINANCIALTRANSACTIONLINEITEMADJUSTMENT].[CONSTITUENTID]
ADJUSTMENTDATEDIMID	int	yes		Reference key to date dimension, derived from [dbo].[FINANCIALTRANSACTIONLINEITEMADJUSTMENT].[DATE]
ADJUSTMENTDATE	datetime	yes		dbo.[FINANCIALTRANSACTIONLINEITEMADJUSTMENT].[DATE]
ADJUSTMENTREASONDIMID	int	yes		Reference key to adjustment reason dimension, derived from [dbo].[FINANCIALTRANSACTIONLINEITEMADJUSTMENT].[ADJUSTMENTREASONCODEID]
TRANSACTIONCURRENCYDIMID	int	yes		Reference key to the currency dimension, derived from dbo.[FINANCIALTRANSACTION].[TRANSACTIONCURRENCYID]
MARKETINGSEGMENTATIONDIMID	int	yes		Reference key to the marketing effort dimension, derived from dbo.[MKTSEGMENTATION].[ID]
FINANCIALTRANSACTIONLINEITEMTRANSACTIONAMOUNT	money	yes		dbo.[FINANCIALTRANSACTIONLINEITEM].[TRANSACTIONAMOUNT]
REVENUESCHEDULEDIMID	int	yes		Reference key to the revenue schedule dimension, derived using the combination flags and codes on [dbo].[REVENUESCHEDULE]
ADDEDDATE	datetime	yes		[dbo].[FINANCIALTRANSACTION].[DATEADDED]
ADDEDDATEDIMID	int	yes		Reference key to the date dimension, derived using [dbo].[FINANCIALTRANSACTION].[DATEADDED]
OTHERPAYMENTMETHODDIMID	int	yes		Reference key to other payment method dimension, derived from [dbo].[OTHERPAYMENTMETHODDETAIL].[OTHERPAYMENTMETHODCODEID]
PLANNEDGIFTSYSTEMID	uniqueidentifier	yes		dbo.[PLANNEDGIFTREVENUESPLIT].[PLANNEDGIFTID]
REVERSEDFINANCIALTRANSACTIONLINEITEMSYSTEMID	uniqueidentifier	yes		dbo.[FINANCIALTRANSACTIONLINEITEM].[REVERSEDLINEITEMID]
SOURCECODE	nvarchar(50)	yes		dbo.[REVENUE_EXT].[SOURCECODE]
OTHERREVENUETYPEDIMID	int	yes		Reference key to other revenue type dimension, derived from [dbo].[REVENUESPLITOTHER].[OTHERTYPECODEID]