Information for the FinancialTransaction

Columns

• Id (datatype: int) Required Primary Key
• BatchId (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
• CheckMicrEncrypted (datatype: nvarchar(max)) Required Primary Key
• ScheduledTransactionId (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
• ProcessedByPersonAliasId (datatype: int) Required Primary Key
• ProcessedDateTime (datatype: datetime) Required Primary Key
• CheckMicrHash (datatype: nvarchar(128)) Required Primary Key
• AuthorizedPersonAliasId (datatype: int) Required Primary Key
• FinancialGatewayId (datatype: int) Required Primary Key
• FinancialPaymentDetailId (datatype: int) Required Primary Key
• MICRStatus (datatype: int) Required Primary Key
• CheckMicrParts (datatype: nvarchar(max)) Required Primary Key
• ForeignGuid (datatype: uniqueidentifier) Required Primary Key
• ForeignId (datatype: int) Required Primary Key
• Status (datatype: nvarchar(50)) Required Primary Key
• StatusMessage (datatype: nvarchar(200)) Required Primary Key
• IsSettled (datatype: bit) Required Primary Key
• SettledGroupId (datatype: nvarchar(100)) Required Primary Key
• SettledDate (datatype: datetime) Required Primary Key
• IsReconciled (datatype: bit) Required Primary Key
• ShowAsAnonymous (datatype: bit) Required Primary Key
• FutureProcessingDateTime (datatype: datetime) Required Primary Key
• NonCashAssetTypeValueId (datatype: int) Required Primary Key
• SundayDate (datatype: date) Required Primary Key
• TransactionDateKey (datatype: int) Required Primary Key
• SettledDateKey (datatype: int) Required Primary Key
• ForeignCurrencyCodeValueId (datatype: int) Required Primary Key