PaymentScheduleDetail Table

PaymentScheduleDetail lists all individual periods of a payment schedule.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for PaymentScheduleDetail table

Database Column

Details

PaymentScheduleDetailID

Type: integer. Key. Generated ID

Uniquely identifies this payment schedule period.

PaymentScheduleID

Type: integer. Key

Identifies the payment schedule to which this period applies. Foreign key to the PaymentSchedule table.

PeriodCovered

Type: text (max 50 characters)

A string describing the period to which this payment schedule period is applicable. This is a calculated field.

PeriodStartDate

Type: datetime. Key

The date on which this payment schedule period starts.

PeriodEndDate

Type: datetime

The date on which this payment schedule period ends.

DueDate

Type: datetime. Key. Nullable

The date on which this payment is due.

PaymentScheduleDetail PaymentStatusID

Type: integer. Key

Identifies the state type of this payment schedule.The default value 2 corresponds to an Incomplete status. Foreign key to the PaymentScheduleDetailPaymentStatus table.

PaymentDate

Type: datetime. Nullable

Records the date the payment was made.

ActualAmount

Type: currency. Nullable

The actual amount paid in this payment schedule period.

ActualAmountRateID

Type: integer. Nullable

Identifies the currency rate to be applied to the amount paid in this payment schedule period. Foreign key to the CurrencyRate table.

EstimatedAmount

Type: currency. Nullable

The estimated amount for this payment schedule period.

EstimatedAmountRateID

Type: integer. Nullable

Identifies the currency rate to be applied to the estimated amount for this payment schedule period. Foreign key to the CurrencyRate table.

BudgetedAmount

Type: currency. Nullable

The budgeted amount for this payment schedule period.

BudgetedAmountRateID

Type: integer. Nullable

Identifies the currency rate to be applied to the budgeted amount for this payment schedule period. Foreign key to the CurrencyRate table.

Obligated

Type: boolean

If this field is set to True, the payee is obligated to pay during this payment schedule period. If this bit is False (the default), payment can presumably be deferred.

Quantity

Type: integer. Nullable

The quantity for this payment schedule period.

UnitPrice

Type: currency. Nullable

The unit price for this payment schedule period.

UnitPriceRateID

Type: integer. Nullable

Identifies the currency rate to be applied to the unit price for this payment schedule period. Foreign key to the CurrencyRate table.

SoftwareAssuranceUnit Price

Type: currency. Nullable

The unit price for support (Software Assurance) for this payment schedule period.

SoftwareAssuranceUnit PriceRateID

Type: integer. Nullable

Identifies the currency rate to be applied to the unit price for support in this payment schedule period. Foreign key to the CurrencyRate table.

Notes

Type: text. Nullable

The notes field.

PeriodCoveredResourceName

Type: text (max 256 characters). Nullable

The resource name used to describe the period to which this payment schedule period is applicable.

PeriodCoveredResource Parameters

Type: text (max 256 characters). Nullable

The parameters used by the resource name used to describe the period to which this payment schedule period is applicable.