rpz Table: Payoff Assessment History
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rpz Table: Payoff Assessment History

Indexes

Name Segment 1
rpz_idx0 lse_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
CHAR(10) no
stamp_l
Record modification stamp
NUMBER(10) no
late_d
Late charges
NUMBER(15,2) yes
col_fee_d
Collection fees
NUMBER(15,2) yes
ass_fee_d
Assumption fees
NUMBER(15,2) yes
leg_fee_d
Legal fees
NUMBER(15,2) yes
pmt_ext_fee_d
Payment extension fees
NUMBER(15,2) yes
lse_ext_fee_d
Lease extension fees
NUMBER(15,2) yes
itc_d
ITC recaptured
NUMBER(15,2) yes
lsrw_fee_d
Lease rewrite fees
NUMBER(15,2) yes
other_d
Other charges
NUMBER(15,2) yes
maint_d
Maintenance fee
NUMBER(15,2) yes
prop_tax_d
Property tax
NUMBER(15,2) yes
fhut_fee_d
Federal highway use tax fee
NUMBER(15,2) yes
sales_tax_d
Sales tax
NUMBER(15,2) yes
adj_payoff_asm_c
Adjust payoff assessments (Y/N)
CHAR(1) yes
rcr1_d
Recurring charge [1]
NUMBER(15,2) yes
rcr2_d
Recurring charge [2]
NUMBER(15,2) yes
rcr3_d
Recurring charge [3]
NUMBER(15,2) yes
rcr4_d
Recurring charge [4]
NUMBER(15,2) yes
rcr5_d
Recurring charge [5]
NUMBER(15,2) yes
rcr6_d
Recurring charge [6]
NUMBER(15,2) yes
rcr7_d
Recurring charge [7]
NUMBER(15,2) yes
rcr8_d
Recurring charge [8]
NUMBER(15,2) yes
rcr9_d
Recurring charge [9]
NUMBER(15,2) yes
rcr10_d
Recurring charge [10]
NUMBER(15,2) yes
rcr11_d
Recurring charge [11]
NUMBER(15,2) yes
rcr12_d
Recurring charge [12]
NUMBER(15,2) yes
rcr13_d
Recurring charge [13]
NUMBER(15,2) yes
rcr14_d
Recurring charge [14]
NUMBER(15,2) yes
rcr15_d
Recurring charge [15]
NUMBER(15,2) yes
rcr16_d
Recurring charge [16]
NUMBER(15,2) yes
rcr17_d
Recurring charge [17]
NUMBER(15,2) yes
rcr18_d
Recurring charge [18]
NUMBER(15,2) yes
rcr19_d
Recurring charge [19]
NUMBER(15,2) yes
rcr20_d
Recurring charge [20]
NUMBER(15,2) yes
rcr21_d
Recurring charge [21]
NUMBER(15,2) yes
rcr22_d
Recurring charge [22]
NUMBER(15,2) yes
rcr23_d
Recurring charge [23]
NUMBER(15,2) yes
rcr24_d
Recurring charge [24]
NUMBER(15,2) yes
rcr25_d
Recurring charge [25]
NUMBER(15,2) yes
rcr26_d
Recurring charge [26]
NUMBER(15,2) yes
rcr27_d
Recurring charge [27]
NUMBER(15,2) yes
rcr28_d
Recurring charge [28]
NUMBER(15,2) yes
rcr29_d
Recurring charge [29]
NUMBER(15,2) yes
rcr30_d
Recurring charge [30]
NUMBER(15,2) yes
rcr31_d
Recurring charge [31]
NUMBER(15,2) yes
rcr32_d
Recurring charge [32]
NUMBER(15,2) yes
rcr33_d
Recurring charge [33]
NUMBER(15,2) yes
rcr34_d
Recurring charge [34]
NUMBER(15,2) yes
rcr35_d
Recurring charge [35]
NUMBER(15,2) yes
lse_fee1_d
Lease fee [1]
NUMBER(15,2) yes
lse_fee2_d
Lease fee [2]
NUMBER(15,2) yes
lse_fee3_d
Lease fee [3]
NUMBER(15,2) yes
lse_fee4_d
Lease fee [4]
NUMBER(15,2) yes
lse_fee5_d
Lease fee [5]
NUMBER(15,2) yes
lse_fee6_d
Lease fee [6]
NUMBER(15,2) yes
lse_fee7_d
Lease fee [7]
NUMBER(15,2) yes
lse_fee8_d
Lease fee [8]
NUMBER(15,2) yes
lse_fee9_d
Lease fee [9]
NUMBER(15,2) yes
lse_fee10_d
Lease fee [10]
NUMBER(15,2) yes
lse_fee11_d
Lease fee [11]
NUMBER(15,2) yes
lse_fee12_d
Lease fee [12]
NUMBER(15,2) yes
lse_fee13_d
Lease fee [13]
NUMBER(15,2) yes
lse_fee14_d
Lease fee [14]
NUMBER(15,2) yes
lse_fee15_d
Lease fee [15]
NUMBER(15,2) yes
lse_fee16_d
Lease fee [16]
NUMBER(15,2) yes
lse_fee17_d
Lease fee [17]
NUMBER(15,2) yes
lse_fee18_d
Lease fee [18]
NUMBER(15,2) yes
lse_fee19_d
Lease fee [19]
NUMBER(15,2) yes
lse_fee20_d
Lease fee [20]
NUMBER(15,2) yes
unit_fee1_d
Asset fee [1]
NUMBER(15,2) yes
unit_fee2_d
Asset fee [2]
NUMBER(15,2) yes
unit_fee3_d
Asset fee [3]
NUMBER(15,2) yes
unit_fee4_d
Asset fee [4]
NUMBER(15,2) yes
unit_fee5_d
Asset fee [5]
NUMBER(15,2) yes
unit_fee6_d
Asset fee [6]
NUMBER(15,2) yes
unit_fee7_d
Asset fee [7]
NUMBER(15,2) yes
unit_fee8_d
Asset fee [8]
NUMBER(15,2) yes
unit_fee9_d
Asset fee [9]
NUMBER(15,2) yes
unit_fee10_d
Asset fee [10]
NUMBER(15,2) yes