FACT_INSTALLMENTPAYMENT

Contains information about installment payments.

Primary Key

Primary Key Field Type
INSTALLMENTPAYMENTFACTID int

Fields

Field Field Type Null Notes Description
INSTALLMENTSPLITPAYMENTSYSTEMID uniqueidentifier yes [dbo].[INSTALLMENTSPLITPAYMENT].[ID]
INSTALLMENTFACTID int yes Reference key to the installment fact, derived from [dbo].[INSTALLMENTSPLITPAYMENT].[INSTALLMENTID]
REVENUEFACTID int yes Reference key to the revenue fact, derived from [BBDW].[FACT_REVENUE].[REVENUEFACTID]
INSTALLMENTPAYMENTAMOUNT money yes [dbo].[INSTALLMENTSPLITPAYMENT].[AMOUNT]
ISINCLUDED bit yes Flag indicating when data should be included in results.
ETLCONTROLID int yes ID generated through the ETL process.
SOURCEDIMID int yes Source system used.
BASECURRENCYDIMID int yes Reference key to the currency dimension, derived from dbo.[INSTALLMENTSPLITPAYMENT].[BASECURRENCYID]
BASEINSTALLMENTPAYMENTAMOUNT money yes dbo.[INSTALLMENTSPLITPAYMENT].[AMOUNT]
FINANCIALTRANSACTIONFACTID int yes Reference key to financial transaction fact table, derived from [dbo].[FINANCIALTRANSACTION].[ID]
FINANCIALTRANSACTIONLINEITEMFACTID int yes Reference key to financial transaction line item fact table, derived from [dbo].[FINANCIALTRANSACTIONLINEITEM].[ID]
ORGINSTALLMENTPAYMENTAMOUNT money yes Calculated column. Transaction Amount currency converted to organisation amount.

Indexes

Index Name Fields Unique Primary Clustered
PK_FACT_INSTALLMENTPAYMENT INSTALLMENTPAYMENTFACTID yes yes yes