Updated: 2009-09-21

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is …

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 16100 - Payment Plan

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
PaymentPlan.ClassTypeID int Identifier for the Type of Object
PaymentPlan.FirstPaymentType int
PaymentPlan.ID int Primary Key for the Table
PaymentPlan.interval int
PaymentPlan.IsActive bit Indicates if Enabled. 1Record is Active, 0Record is Not Active
PaymentPlan.IsSystem bit Used to Mark Required Records
PaymentPlan.ModifiedByComputer varchar(25) HostName of computer that last modified this record
PaymentPlan.ModifiedByUser varchar(25) Windows User who last modified this record
PaymentPlan.ModifiedDate datetime DateTime this Record was last modified
PaymentPlan.NextOccurence int
PaymentPlan.PaymentCount int
PaymentPlan.PlanName varchar(50)
PaymentPlan.RolloverDaysAway int
PaymentPlan.RolloverPayment bit
PaymentPlan.SeqID int
PaymentPlan.StoreID int Not Used.

Related Tables

You could leave a comment if you were logged in.