LeasePak 5.2a Database Reference (Sybase)

HomeTableIndexes

rtl Table: Loan Transaction

Description Column Datatype
Lease lse_s char (10)
End date d_end_s datetime
Reversal date (YYYYMMDD) ymd_rev_s char (8)
Run date d_run_s datetime
Run time t_run_s char (6)
Sybase timestamp timestamp timestamp
Start date d_strt_s datetime
Effective date of payment d_eff_s datetime
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 double precision
Interest for the period period_int_d double precision
Interest carryover car_d double precision
Last partial month interest partial_d double precision
Capitalized interest amount cap_int_d double precision

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