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.