LeasePak 5.1a Database Reference (Sybase)
Home
Table
Indexes
| Description |
Column |
Datatype |
| Lease
|
lse_s |
char (10) |
| Sybase timestamp
|
timestamp |
timestamp |
| Date last update
|
d_last_s |
datetime |
| Date opened
|
d_opened_s |
datetime |
| Date closed
|
d_closed_s |
datetime |
| Date billed
|
d_bill_s |
datetime |
| Balloon payment due date
|
d_bln_pmt_s |
datetime |
| Date delinquent
|
d_delq_s |
datetime |
| Last payment date
|
d_pay_s |
datetime |
| Cycle identifier
|
cycle_id_s |
char (2) |
| Credit Bureau account type
|
cb_type_s |
char (2) |
| Credit Bureau status
|
cb_stat_s |
char (2) |
| Lease term
|
trm_s |
char (3) |
| 24 month payment history
|
pmt_hist24_s |
char (24) |
| Compliance condition
|
compliance_cond_s |
char (2) |
| Consumer information
|
consumer_info_s |
char (2) |
| Address indicator
|
add_ind_c |
char (1) |
| Payment rating
|
pmt_rate_c |
char (1) |
| Flag to report K4
|
rpt_k4_c |
char (1) |
| Original acquisition cost
|
org_d |
double precision |
| Monthly payment
|
mon_pmt_d |
double precision |
| Actual payment amount received
|
act_pmt_rcv_d |
double precision |
| Current balance
|
curr_bal_d |
double precision |
| Amount due
|
amt_due_d |
double precision |
| Charge off amount
|
chrg_off_amt_d |
double precision |
| Balloon payment amount
|
bln_pmt_amt_d |
double precision |
| Times reported
|
times_rptd_l |
integer |
| Index name |
Piece 1 |
| rex_idx0 |
lse_s |
Home
Table
Indexes
(c) Copyright 2004 McCue Systems, Inc.