LeasePak 5.2a Database Reference (Sybase)

HomeTableIndexes

rnt Table: Note Payable Transaction

Description Column Datatype
Note attached to lease note_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 nt_typ_a_s char (4)
Reversal description nt_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

rnt Indexes:

Index name Piece 1 Piece 2 Piece 3 Piece 4 Piece 5
rnt_idx0 note_s d_end_s ymd_rev_s d_run_s t_run_s


HomeTableIndexes