LeasePak 5.1a Database Reference (Sybase)

rhe Table: Historical Credit Bureau Extract

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
rhe_idx0	lse_s