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