rtl Table: Loan Transaction
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rtl Table: Loan Transaction

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5
rtl_idx0 lse_s d_end_s ymd_rev_s d_run_s t_run_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
char(10) no
d_end_s
End date
datetime no
ymd_rev_s
Reversal date (YYYYMMDD)
char(8) no
d_run_s
Run date
datetime no
t_run_s
Run time
char(6) no
timestamp
Record modification stamp
timestamp yes
d_strt_s
Start date
datetime yes
d_eff_s
Effective date of payment
datetime yes
tl_typ_a_s
Accrual description
char(4) yes
tl_typ_r_s
Reversal description
char(4) yes
opr_a_s
Accrual operator initials
char(3) yes
opr_r_s
Reversal operator initials
char(3) yes
prn_out_d
Principal outstanding
double precision yes
period_int_d
Interest for the period
double precision yes
car_d
Interest carryover
double precision yes
partial_d
Last partial month interest
double precision yes
cap_int_d
Capitalized interest amount
double precision yes