RPT_GIVINGLISTDETAIL_RECOGNITION
Intermediate storage table for RPT_GIVINGLISTDETAIL
Primary Key
| Primary Key | Field Type |
|---|---|
| FINANCIALTRANSACTIONLINEITEMFACTID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| RECOGNITION | nvarchar(4000) | yes | Derived from [BBDW].[DIM_CONSTITUENT].[FULLNAME] and BBDW.[REVENUERECOGNITION].[AMOUNT] using [BBDW].[FACT_REVENUERECOGNTION] | |
| ISDELETED | bit | yes | Denotes that the row has a deleted value. | |
| ETLCONTROLID | int | yes | ID generated through the ETL process. |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| PK_RPT_GIVINGLISTDETAIL_RECOGNITIONS | FINANCIALTRANSACTIONLINEITEMFACTID | yes | yes | yes |