PaymentScheduleType Table

PaymentScheduleType is a static table listing possible payment schedule types.

Table 1. Database columns for PaymentScheduleType table

Database Column

Details
PaymentScheduleTypeID

Type: integer. Key. Generated ID

A unique identifier for each PaymentScheduleType. Possible values and the corresponding default strings are:

  • 1 = General
  • 2 = Lease
  • 3 = Hardware maintenance and support
  • 4 = Software license
  • 5 = Software maintenance and support
  • 6 = Consulting services
  • 7 = Insurance
  • 8 = Rent
  • 9 = Subscription
  • 10 = EA professional platform
  • 11 = EA other application.
ResourceString

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing a payment schedule type. Foreign key to the ComplianceResourceString table.
DefaultValue

Type: text (max 100 characters)

The text to display if the type resource string has no translation.
XMLFile

Type: text. Nullable

The layout of the property dialog for this type of payment schedule, stored in XML format.