Updated: 2009-09-21

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is …

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 16110 - Scheduled Payment

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
ScheduledPayment.Amount float
ScheduledPayment.Attempts int
ScheduledPayment.ClassTypeID int Identifier for the Type of Object
ScheduledPayment.CompletedDate datetime
ScheduledPayment.CompletedPaymentID int
ScheduledPayment.Description text
ScheduledPayment.ID int Primary Key for the Table
ScheduledPayment.IsActive bit Not Used for This Table
ScheduledPayment.IsComplete bit
ScheduledPayment.IsSystem bit Used to Mark Required Records
ScheduledPayment.ModifiedByComputer varchar(25) HostName of computer that last modified this record
ScheduledPayment.ModifiedByUser varchar(25) Windows User who last modified this record
ScheduledPayment.ModifiedDate datetime DateTime this Record was last modified
ScheduledPayment.Results text
ScheduledPayment.ScheduledDate datetime
ScheduledPayment.SeqID int
ScheduledPayment.StoreID int Not Used.
ScheduledPayment.TransactionID int
ScheduledPayment.TransactionNumber int

Related Tables

You could leave a comment if you were logged in.