LeasePak 5.1a Database Reference (Sybase)
Home
Table
Indexes
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 |
Index name |
Piece 1 |
Piece 2 |
rhp_idx0 |
note_s |
d_pmtdu_s |
Home
Table
Indexes
(c) Copyright 2004 McCue Systems, Inc.