rax Table: Automatic Lease Extension
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rax Table: Automatic Lease Extension

Child Tables

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

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6
rax_idx0 lse_s ext_num_s        
rax_idx1 por_s com_s reg_s off_s lse_s ext_num_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
char(10) no
ext_num_s
Extension
char(2) no
por_s
Portfolio
char(2) no
com_s
Company
char(2) no
reg_s
Region
char(2) no
off_s
Office
char(3) no
timestamp
Record modification stamp
timestamp yes
d_orig_lsd_s
Original lease date
datetime yes
d_orig_mat_s
Original maturity date
datetime yes
d_com_s
Extension commencement date
datetime yes
d_mat_s
Extension maturity date
datetime yes
d_lup_s
Date of last update
datetime yes
t_lup_s
Time of last update
char(6) yes
d_boo_s
System booking date
datetime yes
t_boo_s
System booking time
char(6) yes
act_s
Activity status
char(4) yes
acc_l_s
Accrual method lessor
char(4) yes
ls_typ_s
Lease type code
char(4) yes
ext_incm_ca_c
Cash/accrual basis for extension income (C/A)
char(1) yes
extended_c
Extended flag
char(1) yes
trm_l
Lease term
integer yes
n_unt_l
Number of assets on this lease
integer yes
org_d
Original acquisition cost
double precision yes
res_d
Residual amount
double precision yes
p_rent_d
Lessor rental simple rate
double precision yes
ext_s
Extension method
char(4) yes
bkd_s
Book depreciation method
char(4) yes
sal_bkd_d
Book value salvage value
double precision yes
adv_inv_c
Advance invoicing (Y/N)
char(1) yes
d_pmt_s
Next payment due date
datetime yes
pmt_l
Number of payments accrued
integer yes
due_overlap_c
Invoice due date overlap (Y/N)
char(1) yes
rcr_pmt_sched_c
Has recurring charge payment schedule (Y/N)
char(1) yes
rcr_synch_c
Recurring charge payment schedule in synch with lease (Y/N)
char(1) yes
res_guar_d
Guaranteed portion of residual
double precision yes