| INSTALLMENTSPLITSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[INSTALLMENTSPLIT].[ID] |
| INSTALLMENTDIMID |
int |
yes |
|
Reference key to the installment dimension, derived from [dbo].[INSTALLMENTSPLIT].[INSTALLMENTID] |
| REVENUEFACTID |
int |
yes |
|
Reference key to the revenue fact, derived from [BBDW].[FACT_REVENUE].[REVENUEFACTID] |
| REVENUESCHEDULEDIMID |
int |
yes |
|
Reference key to the revenue schedule dimension, derived using the combination flags and codes on [dbo].[REVENUESCHEDULE] |
| REVENUESCHEDULESTARTDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[INSTALLMENT].[DATE] |
| REVENUESCHEDULESTARTDATE |
datetime |
yes |
|
dbo.[INSTALLMENT].[DATE] |
| REVENUESCHEDULEENDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[INSTALLMENT].[DATE] |
| REVENUESCHEDULEENDDATE |
datetime |
yes |
|
dbo.[INSTALLMENT].[DATE] |
| INSTALLMENTDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[INSTALLMENT].[DATE] |
| INSTALLMENTDATE |
datetime |
yes |
|
dbo.[INSTALLMENT].[DATE] |
| INSTALLMENTAMOUNT |
money |
yes |
|
[dbo].[INSTALLMENTSPLIT].[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.[INSTALLMENTSPLIT].[BASECURRENCYID] |
| BASEINSTALLMENTAMOUNT |
money |
yes |
|
dbo.[INSTALLMENTSPLIT].[AMOUNT] |
| SOURCEREVENUESEQUENCEID |
int |
yes |
|
A reference key to revenue sequenceID,derived from dbo.[REVENUEMATCHINGGIFT].[MGSOURCEREVENUEID] |
| 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] |
| INSTALLMENTBALANCE |
money |
yes |
|
Remaining balance on the installment |
| ISFIRSTINSTALLMENT |
bit |
yes |
|
First installment for the pledge order by [dbo].[INSTALLMENT].[SEQUENCE] |
| ISNEXTINSTALLMENT |
bit |
yes |
|
Next installment for the pledge order by [dbo].[INSTALLMENT].[SEQUENCE] |
| ISLASTINSTALLMENT |
bit |
yes |
|
Last installment for the pledge order by [dbo].[INSTALLMENT].[SEQUENCE] |