Information for the FinancialTransactionDetail

Columns

  • Id (datatype: int) Required Primary Key
  • TransactionId (datatype: int) Required Primary Key
  • AccountId (datatype: int) Required Primary Key
  • Amount (datatype: decimal(18, 2)) Required Primary Key
  • Summary (datatype: nvarchar(500)) Required Primary Key
  • EntityTypeId (datatype: int) Required Primary Key
  • EntityId (datatype: int) Required Primary Key
  • Guid (datatype: uniqueidentifier) Required Primary Key
  • CreatedDateTime (datatype: datetime) Required Primary Key
  • ModifiedDateTime (datatype: datetime) Required Primary Key
  • CreatedByPersonAliasId (datatype: int) Required Primary Key
  • ModifiedByPersonAliasId (datatype: int) Required Primary Key
  • ForeignKey (datatype: nvarchar(100)) Required Primary Key
  • ForeignGuid (datatype: uniqueidentifier) Required Primary Key
  • ForeignId (datatype: int) Required Primary Key
  • FeeAmount (datatype: decimal(18, 2)) Required Primary Key
  • FeeCoverageAmount (datatype: decimal(18, 2)) Required Primary Key
  • ForeignCurrencyAmount (datatype: decimal(18, 2)) Required Primary Key