Table: AnalyticsSourceFinancialTransaction

Database schema and system attributes for AnalyticsSourceFinancialTransaction.

---

AccountId

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

Amount

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: decimal
• Property Values:
  • MaxLength = 9

AuthorizedCurrentPersonKey

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

AuthorizedFamilyId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

AuthorizedPersonAliasId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

AuthorizedPersonKey

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

BatchId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

Count

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

CreditCardTypeValueId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

CurrencyTypeValueId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

DaysSinceLastTransactionOfType

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

EntityId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

EntityTypeId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

FinancialGatewayId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ForeignGuid

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: uniqueidentifier
• Property Values:
  • MaxLength = 16

ForeignId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ForeignKey

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 200

GivingGroupId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

GivingId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 40

Guid

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: uniqueidentifier
• Property Values:
  • MaxLength = 16

Id

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

IsFirstTransactionOfType

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: bit
• Property Values:
  • MaxLength = 1

IsScheduled

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: bit
• Property Values:
  • MaxLength = 1

ModifiedDateTime

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8

ProcessedByPersonAliasId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ProcessedDateTime

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8

SourceTypeValueId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

Summary

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = -1

TransactionCode

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 100

TransactionDateKey

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

TransactionDateTime

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8

TransactionDetailId

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

TransactionFrequency

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 500

TransactionId

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

TransactionKey

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 80

TransactionTypeValueId

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4