Information for the AnalyticsSourceFinancialTransaction

Columns

• Id (datatype: int) Required Primary Key
• TransactionKey (datatype: nvarchar(40)) Required Primary Key
• TransactionDateKey (datatype: int) Required Primary Key
• AuthorizedPersonKey (datatype: int) Required Primary Key
• AuthorizedCurrentPersonKey (datatype: int) Required Primary Key
• DaysSinceLastTransactionOfType (datatype: int) Required Primary Key
• IsFirstTransactionOfType (datatype: bit) Required Primary Key
• AuthorizedFamilyId (datatype: int) Required Primary Key
• IsScheduled (datatype: bit) Required Primary Key
• TransactionFrequency (datatype: nvarchar(250)) Required Primary Key
• GivingGroupId (datatype: int) Required Primary Key
• GivingId (datatype: nvarchar(20)) Required Primary Key
• Count (datatype: int) Required Primary Key
• TransactionDateTime (datatype: datetime) Required Primary Key
• TransactionCode (datatype: nvarchar(50)) Required Primary Key
• Summary (datatype: nvarchar(max)) Required Primary Key
• TransactionTypeValueId (datatype: int) Required Primary Key
• SourceTypeValueId (datatype: int) Required Primary Key
• AuthorizedPersonAliasId (datatype: int) Required Primary Key
• ProcessedByPersonAliasId (datatype: int) Required Primary Key
• ProcessedDateTime (datatype: datetime) Required Primary Key
• BatchId (datatype: int) Required Primary Key
• FinancialGatewayId (datatype: int) Required Primary Key
• EntityTypeId (datatype: int) Required Primary Key
• EntityId (datatype: int) Required Primary Key
• TransactionId (datatype: int) Required Primary Key
• TransactionDetailId (datatype: int) Required Primary Key
• AccountId (datatype: int) Required Primary Key
• CurrencyTypeValueId (datatype: int) Required Primary Key
• CreditCardTypeValueId (datatype: int) Required Primary Key
• Amount (datatype: decimal(18, 2)) Required Primary Key
• ModifiedDateTime (datatype: datetime) Required Primary Key
• Guid (datatype: uniqueidentifier) Required Primary Key
• ForeignId (datatype: int) Required Primary Key
• ForeignGuid (datatype: uniqueidentifier) Required Primary Key
• ForeignKey (datatype: nvarchar(100)) Required Primary Key