LeasePak 5.1a Database Reference (Sybase)

rax Table: Automatic Lease Extension

Description	Column	Datatype
Lease	lse_s	char (10)
Extension	ext_num_s	char (2)
Portfolio	por_s	char (2)
Company	com_s	char (2)
Region	reg_s	char (2)
Office	off_s	char (3)
Sybase timestamp	timestamp	timestamp
Original lease date	d_orig_lsd_s	datetime
Original maturity date	d_orig_mat_s	datetime
Extension commencement date	d_com_s	datetime
Extension maturity date	d_mat_s	datetime
Date of last update	d_lup_s	datetime
Time of last update	t_lup_s	char (6)
System booking date	d_boo_s	datetime
System booking time	t_boo_s	char (6)
Activity status	act_s	char (4)
Accrual method lessor	acc_l_s	char (4)
Lease type code	ls_typ_s	char (4)
Cash/accrual basis for extension income (C/A)	ext_incm_ca_c	char (1)
Extended flag	extended_c	char (1)
Lease term	trm_l	integer
Number of assets on this lease	n_unt_l	integer
Original acquisition cost	org_d	double precision
Residual amount	res_d	double precision
Lessor rental simple rate	p_rent_d	double precision
Extension method	ext_s	char (4)
Book depreciation method	bkd_s	char (4)
Book value salvage value	sal_bkd_d	double precision
Advance invoicing (Y/N)	adv_inv_c	char (1)
Next payment due date	d_pmt_s	datetime
Number of payments accrued	pmt_l	integer
Invoice due date overlap (Y/N)	due_overlap_c	char (1)

Index name	Piece 1	Piece 2	Piece 3	Piece 4	Piece 5	Piece 6
rax_idx0	lse_s	ext_num_s
rax_idx1	por_s	com_s	reg_s	off_s	lse_s	ext_num_s

Table	Description
raxp	Automatic Lease Extension Payment Schedule
raxr	Automatic Lease Extension Recurring Charge