Information for the FinancialScheduledTransaction

Columns

• Id (datatype: int) Required Primary Key
• TransactionFrequencyValueId (datatype: int) Required Primary Key
• StartDate (datatype: date) Required Primary Key
• EndDate (datatype: date) Required Primary Key
• NumberOfPayments (datatype: int) Required Primary Key
• NextPaymentDate (datatype: date) Required Primary Key
• LastStatusUpdateDateTime (datatype: datetime) Required Primary Key
• IsActive (datatype: bit) Required Primary Key
• TransactionCode (datatype: nvarchar(50)) Required Primary Key
• GatewayScheduleId (datatype: nvarchar(max)) Required Primary Key
• CardReminderDate (datatype: date) Required Primary Key
• LastRemindedDate (datatype: date) 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
• AuthorizedPersonAliasId (datatype: int) Required Primary Key
• FinancialGatewayId (datatype: int) Required Primary Key
• FinancialPaymentDetailId (datatype: int) Required Primary Key
• ForeignGuid (datatype: uniqueidentifier) Required Primary Key
• ForeignId (datatype: int) Required Primary Key
• SourceTypeValueId (datatype: int) Required Primary Key
• TransactionTypeValueId (datatype: int) Required Primary Key
• Summary (datatype: nvarchar(max)) Required Primary Key
• ForeignCurrencyCodeValueId (datatype: int) Required Primary Key
• InactivateDateTime (datatype: datetime) Required Primary Key
• Status (datatype: int) Required Primary Key
• StatusMessage (datatype: nvarchar(200)) Required Primary Key
• PreviousGatewayScheduleIdsJson (datatype: nvarchar(max)) Required Primary Key