PaymentScheduleDetail Table
PaymentScheduleDetail
lists all individual periods of a payment schedule.
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.
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 |
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
|
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 |
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 |
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 |
Obligated
|
Type: boolean If this field is set to |
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 |
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 |
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. |