LeasePak 5.1a Database Reference (Sybase)

HomeTableIndexes

rhp Table: Historical Note Payable

Description Column Datatype
Note attached to lease note_s char (10)
Payment due date d_pmtdu_s datetime
Sybase timestamp timestamp timestamp
Date 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

rhp Indexes:

Index name Piece 1 Piece 2
rhp_idx0 note_s d_pmtdu_s


HomeTableIndexes

(c) Copyright 2004 McCue Systems, Inc.