LeasePak 5.2a Database Reference (Sybase)

HomeTableIndexes

rnp Table: Note Payable Payment

Description Column Datatype
Note attached to lease note_s char (10)
Payment due date d_pmtdu_s datetime
Sybase timestamp timestamp timestamp
Date of last update d_last_s datetime
Effective date of last payment d_eff_s datetime
Total amount due tamt_d_d double precision
Total amount paid tamt_p_d double precision
Principal amount due pamt_d_d double precision
Principal amount paid pamt_p_d double precision
Interest amount due iamt_d_d double precision
Interest amount paid iamt_p_d double precision
Interest carry over int_car_d double precision
Interest adjustment int_adj_d double precision
Interest portion - memo amount int_memo_d double precision

rnp Indexes:

Index name Piece 1 Piece 2
rnp_idx0 note_s d_pmtdu_s


HomeTableIndexes