LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rpz Table: Payoff Assessment History

Description Column Datatype
Lease lse_s char (10)
Oracle row stamp stamp_l number (10)
Late charges late_d number (15,2)
Collection fees col_fee_d number (15,2)
Assumption fees ass_fee_d number (15,2)
Legal fees leg_fee_d number (15,2)
Payment extension fees pmt_ext_fee_d number (15,2)
Lease extension fees lse_ext_fee_d number (15,2)
ITC recaptured itc_d number (15,2)
Lease rewrite fees lsrw_fee_d number (15,2)
Other charges other_d number (15,2)
Maintenance fee maint_d number (15,2)
Property tax prop_tax_d number (15,2)
Federal highway use tax fee fhut_fee_d number (15,2)
Sales tax sales_tax_d number (15,2)
Adjust payoff assessments (Y/N) adj_payoff_asm_c char (1)
Recurring charge [1] rcr1_d number (15,2)
Recurring charge [2] rcr2_d number (15,2)
Recurring charge [3] rcr3_d number (15,2)
Recurring charge [4] rcr4_d number (15,2)
Recurring charge [5] rcr5_d number (15,2)
Recurring charge [6] rcr6_d number (15,2)
Recurring charge [7] rcr7_d number (15,2)
Recurring charge [8] rcr8_d number (15,2)
Recurring charge [9] rcr9_d number (15,2)
Recurring charge [10] rcr10_d number (15,2)
Recurring charge [11] rcr11_d number (15,2)
Recurring charge [12] rcr12_d number (15,2)
Recurring charge [13] rcr13_d number (15,2)
Recurring charge [14] rcr14_d number (15,2)
Recurring charge [15] rcr15_d number (15,2)

rpz Indexes:

Index name Piece 1
rpz_idx0 lse_s


HomeTableIndexes