PaymentScheduleDetailPaymentStatus Table

PaymentScheduleDetailPaymentStatus is a static table listing the possible status values for payment schedules.

Table 1. Database columns for PaymentScheduleDetailPaymentStatus table

Database Column

Details

PaymentScheduleDetail PaymentStatusID

Type: integer. Key. Generated ID

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

  • 1 = Complete
  • 2 = Incomplete
  • 3 = Not going to pay.
ResourceName

Type: text (max 256 characters). Key

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

DefaultValue

Type: text (max 256 characters)

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