LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rid Table: Invoice Interest Detail

Description Column Datatype
Lease lse_s char (10)
Payment due date d_pmtdu_s date
Start date d_strt_s date
Oracle row stamp stamp_l number (10)
Invoice number invo_s char (8)
Detail number of days dtl_days_l number (10)
Interest rate p_int_rt_d number (15,5)
Principal outstanding prn_out_d number (15,2)
Capitalized interest amount cap_int_d number (15,2)
Interest amount billed iamt_b_d number (15,2)
Interest carryover car_d number (15,2)

rid Indexes:

Index name Piece 1 Piece 2 Piece 3
rid_idx0 lse_s d_pmtdu_s d_strt_s


HomeTableIndexes