LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rtl Table: Loan Transaction

Description Column Datatype
Lease lse_s char (10)
End date d_end_s date
Reversal date (YYYYMMDD) ymd_rev_s char (8)
Run date d_run_s date
Run time t_run_s char (6)
Oracle row stamp stamp_l number (10)
Start date d_strt_s date
Effective date of payment d_eff_s date
Accrual description tl_typ_a_s char (4)
Reversal description tl_typ_r_s char (4)
Accrual operator initials opr_a_s char (3)
Reversal operator initials opr_r_s char (3)
Principal outstanding prn_out_d number (15,2)
Interest for the period period_int_d number (15,2)
Interest carryover car_d number (15,2)
Last partial month interest partial_d number (15,2)
Capitalized interest amount cap_int_d number (15,2)

rtl Indexes:

Index name Piece 1 Piece 2 Piece 3 Piece 4 Piece 5
rtl_idx0 lse_s d_end_s ymd_rev_s d_run_s t_run_s


HomeTableIndexes