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

Database Reference

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
ext_num_s
Extension
por_s
Portfolio
com_s
Company
reg_s
Region
off_s
Office
Record modification stamp
d_orig_lsd_s
Original lease date
d_orig_mat_s
Original maturity date
d_com_s
Extension commencement date
d_mat_s
Extension maturity date
d_lup_s
Date of last update
t_lup_s
Time of last update
d_boo_s
System booking date
t_boo_s
System booking time
act_s
Activity status
acc_l_s
Accrual method lessor
ls_typ_s
Lease type code
ext_incm_ca_c
Cash/accrual basis for extension income (C/A)
extended_c
Extended flag
trm_l
Lease term
n_unt_l
Number of assets on this lease
org_d
Original acquisition cost
res_d
Residual amount
p_rent_d
Lessor rental simple rate
ext_s
Extension method
bkd_s
Book depreciation method
sal_bkd_d
Book value salvage value
adv_inv_c
Advance invoicing (Y/N)
d_pmt_s
Next payment due date
pmt_l
Number of payments accrued
due_overlap_c
Invoice due date overlap (Y/N)
rcr_pmt_sched_c
Has recurring charge payment schedule (Y/N)
rcr_synch_c
Recurring charge payment schedule in synch with lease (Y/N)
res_guar_d
Guaranteed portion of residual