LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rqs Table: CCA Notional Loan

Description Column Datatype
Lease lse_s char (10)
Oracle row stamp stamp_l number (10)
Canada government bond rate effective date d_bond_s date
CCA fixed rate (Y/N) cca_fix_c char (1)
CCA accrual method cca_acc_s char (4)
Canada government bond rate p_bond_d number (15,5)
Notional interest rate p_notional_rent_d number (15,5)
CCA capital cost cap_cost_d number (15,2)
Accrued principal prn_d number (15,2)
CCA accrued principal amount (not due) pmt_prn_d number (15,2)

rqs Indexes:

Index name Piece 1
rqs_idx0 lse_s


HomeTableIndexes