| REVENUERECOGNITIONSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[REVENUERECOGNITION].[ID] |
| REVENUERECOGNITIONAMOUNT |
money |
yes |
|
dbo.[REVENUERECOGNITION].[AMOUNT] |
| EFFECTIVEDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from [dbo].[REVENUERECOGNITION].[EFFECTIVEDATE] |
| EFFECTIVEDATE |
datetime |
yes |
|
dbo.[REVENUERECOGNITION].[EFFECTIVEDATE] |
| REVENUERECOGNITIONTYPEDIMID |
int |
yes |
|
Reference key to the revenue recognition type dimension, derived from [dbo].[REVENUERECOGNITION].[REVENUERECOGNITIONTYPEID] |
| REVENUEFACTID |
int |
yes |
|
Reference key to the revenue fact, derived from [dbo].[REVENUERECOGNITION].[REVENUESPLITID] |
| CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from [dbo].[REVENUERECOGNITION].[CONSTITUENTID] |
| CONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[REVENUERECOGNITION].[CONSTITUENTID] |
| 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 |
| BASECURRENCYDIMID |
int |
yes |
|
Reference key to the currency dimension, derived from dbo.[REVENUERECOGNITION].[BASECURRENCYID] |
| BASEREVENUERECOGNITIONAMOUNT |
money |
yes |
|
dbo.[REVENUERECOGNITION].[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] |
| ADDEDDATE |
datetime |
yes |
|
[dbo].[REVENUERECOGNITION].[DATEADDED] |
| ADDEDDATEDIMID |
int |
yes |
|
Reference to the date dimension, derived from [dbo].[REVENUERECOGNITION].[DATEADDED] |
| CHANGEDDATE |
datetime |
yes |
|
[dbo].[REVENUERECOGNITION].[DATECHANGED] |
| CHANGEDDATEDIMID |
int |
yes |
|
Reference to the date dimension, derived from [dbo].[REVENUERECOGNITION].[DATECHANGED] |