FACT_REVENUESPLITSMARTFIELD

Contains information from Revenue Detail Split smart fields.

Primary Key

Primary Key	Field Type
REVENUESPLITSMARTFIELDFACTID	bigint

Fields

Field	Field Type	Null	Notes	Description
SMARTFIELDDIMID	int	yes		Reference key to the Smart Field dimension, derived from dbo.[SMARTFIELD].[ID] and the smart field's [GROUPNAME] column
SMARTFIELDSYSTEMID	uniqueidentifier	yes		dbo.[SMARTFIELD].[ID]
REVENUEFACTID	int	yes		Reference key to the Revenue fact, derived from the smart field's [ID] column
REVENUESPLITSYSTEMID	uniqueidentifier	yes		The smart field's [ID] column
SMARTFIELDVALUE	nvarchar(255)	yes		The smart field's [VALUE] column
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.
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]

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_FACT_REVENUESPLITSMARTFIELD	REVENUESPLITSMARTFIELDFACTID	yes	yes	yes