FACT_FINANCIALTRANSACTION_STAGE

Contains information about financialtransaction.

Fields

Field	Field Type	Null	Notes	Description
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]
POSTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[FINANCIALTRANSACTION].[POSTDATE]
POSTDATE	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]
AMOUNT	money	yes		dbo.[FINANCIALTRANSACTION].[ORGAMOUNT]
RECEIPTAMOUNT	money	yes		dbo.[REVENUE_EXT].[RECEIPTAMOUNT]
BASECURRENCYDIMID	int	yes		Reference key to the currency dimension, derived from dbo.[PDACCOUNTSYSTEM].[CURRENCYID]
BASEAMOUNT	money	yes		dbo.[FINANCIALTRANSACTION].[BASEAMOUNT]
PAYMENTMETHODCODE	int	yes		[dbo].[REVENUEPAYMENTMETHOD].[PAYMENTMETHODCODE]
PAYMENTMETHOD	nvarchar(50)	yes		[dbo].[REVENUEPAYMENTMETHOD].[PAYMENTMETHOD]
TRANSACTIONTYPECODE	int	yes		[dbo].[FINANCIALTRANSACTION].[TYPECODE]
TRANSACTIONTYPE	nvarchar(50)	yes		[dbo].[FINANCIALTRANSACTION].[TYPE]
POSTSTATUSCODE	int	yes		[dbo].[FINANCIALTRANSACTION].[POSTSTATUSCODE]
POSTSTATUS	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]
CHANGEDDATEDIMID	int	yes		Reference key to date dimension, derived from [dbo].[REVENUE].[DATECHANGED]
CHANGEDDATE	datetime	yes		dbo.[FINANCIALTRANSACTION].[DATECHANGED]
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]
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]
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]
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]
CREDITCARDEXPIRESON	UDT_FUZZYDATE	yes		[dbo].[CREDITCARDPAYMENTMETHODDETAIL].[EXPIRESON] or [dbo].[CREDITCARD].[EXPIRESON]
SOURCECODE	nvarchar(50)	yes		dbo.[REVENUE_EXT].[SOURCECODE]