LeasePak 5.2a Database Reference (Sybase)

HomeTableIndexes

rex Table: Credit Bureau Extract

Description Column Datatype
Lease lse_s char (10)
Sybase timestamp timestamp timestamp
Date of 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
Metro2 file format code metro2_s char (4)

rex Indexes:

Index name Piece 1
rex_idx0 lse_s


HomeTableIndexes