rid Table: Invoice Interest Detail
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rid Table: Invoice Interest Detail

Indexes

Name Segment 1 Segment 2 Segment 3
rid_idx0 lse_s d_pmtdu_s d_strt_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
CHAR(10) no
d_pmtdu_s
Payment due date
DATE no
d_strt_s
Start date
DATE no
stamp_l
Record modification stamp
NUMBER(10) no
invo_s
Invoice number
CHAR(8) yes
dtl_days_l
Detail number of days
NUMBER(10) yes
p_int_rt_d
Interest rate
NUMBER(15,5) yes
prn_out_d
Principal outstanding
NUMBER(15,2) yes
cap_int_d
Capitalized interest amount
NUMBER(15,2) yes
iamt_b_d
Interest amount billed
NUMBER(15,2) yes
car_d
Interest carryover
NUMBER(15,2) yes