rpr Table: Daily Base Rate
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference

rpr Table: Daily Base Rate

Indexes

Name Segment 1 Segment 2
rpr_idx0 prim_num_s ym_prim_s


Columns
Name DescriptionDatatype ¿? Allow Null
prim_num_s
Prime rate bank number
ym_prim_s
Prime year and month (YYYYMM)
  There are two special records for each prime rate bank
  number. One has ".00000" in ym_prim_s, representing the
  day before the first date. The other has ".00001" in
  ym_prim_s, representing the day after the last update.
Record modification stamp
d_lup_s
Date of last update
p_avg_d
Average prime rate
p_prim1_d
Daily prime rates array [1]
p_prim2_d
Daily prime rates array [2]
p_prim3_d
Daily prime rates array [3]
p_prim4_d
Daily prime rates array [4]
p_prim5_d
Daily prime rates array [5]
p_prim6_d
Daily prime rates array [6]
p_prim7_d
Daily prime rates array [7]
p_prim8_d
Daily prime rates array [8]
p_prim9_d
Daily prime rates array [9]
p_prim10_d
Daily prime rates array [10]
p_prim11_d
Daily prime rates array [11]
p_prim12_d
Daily prime rates array [12]
p_prim13_d
Daily prime rates array [13]
p_prim14_d
Daily prime rates array [14]
p_prim15_d
Daily prime rates array [15]
p_prim16_d
Daily prime rates array [16]
p_prim17_d
Daily prime rates array [17]
p_prim18_d
Daily prime rates array [18]
p_prim19_d
Daily prime rates array [19]
p_prim20_d
Daily prime rates array [20]
p_prim21_d
Daily prime rates array [21]
p_prim22_d
Daily prime rates array [22]
p_prim23_d
Daily prime rates array [23]
p_prim24_d
Daily prime rates array [24]
p_prim25_d
Daily prime rates array [25]
p_prim26_d
Daily prime rates array [26]
p_prim27_d
Daily prime rates array [27]
p_prim28_d
Daily prime rates array [28]
p_prim29_d
Daily prime rates array [29]
p_prim30_d
Daily prime rates array [30]
p_prim31_d
Daily prime rates array [31]