Debt Instrument Registries: BOND, LOAN, and LEASE

The Debt Instrument Registry pages display the Debt Instrument records and supporting details that are specific to one Major Type of Debt. The majority of fields are the same ones shown earlier in the Debt Transaction topic. Please see the "Transaction Information" topic of this user guide for each transaction. This topic will focus on those registry fields not found on transactions and the actions available on the page.

The Debt Instrument Registry pages contain the following actions: (The actions that create transactions with information pre-populated for you are the easiest way to start many Debt Management tasks.)

The Debt Instrument tabs of the Debt Instrument Registry pages contain the following fields not found on transactions. For the amount fields, it is important to understand that all schedules are not included in these totals. Schedules that are not flagged as the Historical Schedule or Selected Schedule are not considered.

Field Name

Field Description

Total Debt Costs

A system-calculated amount that is the sum of all Debt Cost records with a Debt Cost Type of Actual Cost.

Initial Accounting Recorded Date

The population of this date signifies the debt instrument has been processed successfully by the Initial Debt Accounting Chain. When populated, it prevents selection by the next run of the chain.

If the Record Initial Accounting flag was selected when creating a debt instrument, then the instrument will be selected by the Initial Debt Accounting Chain. The first transaction generated for the instrument by that chain will update the Initial Accounting Recorded Date on the Debt Instrument Registry with the Application Date when the transaction processed to Final. If the transaction is cancelled, the Initial Accounting Recorded Date is cleared. A modification does not change the Initial Accounting Recorded Date.

Operating leases will never have this date populated because there is no initial accounting for that type of debt. Any other debt instruments with the Record Initial Accounting flag unchecked will never have an update to this date either.

Last Long Term Account Reclass

The population of this date signifies the debt instrument has been processed successfully by the Long Term Account Reclass Chain. If the chain is run again for the same selection criteria, the earlier update will prevent selection a second time.

If the Record Initial Accounting flag was selected when creating a debt instrument, then the instrument will be selected by the chain when run at the start of a new year if there is any portion of principal for the debt instrument that is due in that year. The first transaction generated for the instrument by that chain will update the Last Long Term Account Reclass field on the Debt Registry with the Application Date when the transaction processed to Final. If the transaction is cancelled, the Last Long Term Account Reclass field is cleared. A modification does not change the Last Long Term Account Reclass field.

Last Accrual FY

The population of this year signifies the debt instrument has been processed successfully by the Periodic Debt Accounting Chain. If the chain is run again for the same selection criteria, the earlier update will prevent selection a second time.

If the associated Debt Type for the instrument has the Interest Accrual Event Type populated and that instrument has a payment record that spanned an accrual period, that instrument will be selected for accrual. The first transaction generated for the instrument by the chain will update the Last Accrual FY field on the Debt Instrument Registry with the Accrual FY parameter value when the transaction processed to Final. If the transaction is cancelled, the Last Accrual FY field is cleared. A modification does not change the Last Accrual FY field.

Last Accrual APD

The population of this accounting period signifies the debt instrument has been processed successfully by the Periodic Debt Accounting Chain. If the chain is run again for the same selection criteria, the earlier update will prevent selection a second time

If the associated Debt Type for the instrument has the Interest Accrual Event Type populated and that instrument has a payment record that spanned an accrual period, that instrument will be selected for accrual. The first transaction generated for the instrument by the chain will update the Last Accrual APD field on the Debt Instrument Registry with the Accrual APD parameter value when the transaction processed to Final. If the transaction is cancelled, the Last Accrual APD field is cleared. A modification does not change the Last Accrual APD field.

Total Principal

Paid Principal

Unpaid Principal

These three amounts track the principal for the debt instrument in the selected schedule as well as any historical schedules.

Total Interest

Interest Paid

Unpaid Interest

These three amounts track the interest for the debt instrument in the selected schedule as well as any historical schedules.

Total Compound Interest

Compounded Interest

Uncompounded Interest

These three amounts track the compounding interest for the debt instrument in the selected schedule as well as any historical schedules.

These three amounts are only found on the Bond Registry page because only bonds support compounding interest. The interest in the final payment is not included in these compounding amounts but in the ‘regular’ interest amounts.

Total Other Amount 1-5

Other Amount 1-5 Paid/Amortized

Remaining Other Amount 1-5

These three amounts track the other amount 1 for the debt instrument in the selected schedule as well as any historical schedules. As other amounts can be an additional payment or an amortization, these amounts change after the Debt Payment & Billing Chain or the Periodic Debt Accounting is run, respectively.

The Schedule tabs of the Debt Instrument Registry pages contain the following fields not found on transactions:

Field Name

Field Description

Total Principal

Paid Principal

Unpaid Principal

These three amounts track the principal for an individual schedule. When a schedule is made the historical schedule, the Total Principal amount is set to equal the Paid Principal amount.

Total Interest

Interest Paid

Unpaid Interest

These three amounts track the interest for an individual schedule.

Total Compound Interest

Compounded Interest

Uncompounded Interest

These three amounts track the compounded interest for an individual schedule.

These three amounts are only found on the Bond Registry page because only bonds support compounding interest. The interest in the final payment is not included in these compounding amounts but in the ‘regular’ interest amounts.

The Schedule Details tabs of the Debt Instrument Registry pages contain the following fields not found on transactions:

Field Name

Field Description

Processed On

The population of this date signifies the schedule detail has been processed successfully by either the Debt Payment & Billing Chain or the Periodic Debt Accounting Chain in non-accrual mode. When populated, it prevents selection by the chains should there be a subsequent time to process records added since the last run.

The first transaction generated for the instrument by either chain will update the Processed On date on the Debt Instrument Registry with the Application Date when the transaction processed to Final. If the transaction is cancelled, the Processed On date is cleared. A modification does not change the Processed On date.

Transaction 1

The population of this column signifies the schedule detail has been processed successfully by either the Debt Payment & Billing Chain or the Periodic Debt Accounting Chain in non-accrual mode.

Clicking on the link will open the transaction for review. To return to the schedule detail, simply close the transaction.

The first transaction generated for the instrument by either chain will update the Transaction 1 link when the transaction processed to Final. If the transaction is cancelled, the Transaction 1 cell is cleared. A modification does not change the Transaction 1 field.

Transactions found in this column will be:

  • Debt Accounting (DA) transactions recording

  • Compounding Interest

  • Residual Value Adjustments

  • Amortizations

  • Accruals

  • Internal Debt Accounting (IDA) transactions recording:

  • Payments

  • Accruals

  • Payment Requests (GAX or PRC) transactions recording:

  • Regular Payments

  • Purchase Payments

  • Refunding Payments

  • Down Payments

  • Renewal Penalty Payments

  • Purchased Interest

  • Receivables (RE) transactions recording:

  • Regular Payments

  • Purchase Payments

  • Down Payments

  • Renewal Penalty Payments

Transaction 2

The population of this column signifies any second transaction required to complete the payment or billing of the debt instrument has processed.

Clicking on the link will open the transaction for review.  To return to the schedule detail, simply close the transaction.

The first transaction will update the Transaction 2 link when the transaction processed to Final.  If the transaction is cancelled, the Transaction 2 cell is cleared. A modification does not change the Transaction 2 field.

Transactions found in this column will be:

  • Manual and Automatic Disbursement (MD & AD) transactions

  • Cash Receipt (CR) transactions