FACT_REVENUESPLITSMARTFIELD_STAGE
Contains information from Revenue Detail Split smart fields.
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] | |
| 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. |