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

Database Reference Sybase DBMS

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
char(4) no
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.
char(6) no
timestamp
Record modification stamp
timestamp yes
d_lup_s
Date of last update
datetime yes
p_avg_d
Average prime rate
double precision yes
p_prim1_d
Daily prime rates array [1]
double precision yes
p_prim2_d
Daily prime rates array [2]
double precision yes
p_prim3_d
Daily prime rates array [3]
double precision yes
p_prim4_d
Daily prime rates array [4]
double precision yes
p_prim5_d
Daily prime rates array [5]
double precision yes
p_prim6_d
Daily prime rates array [6]
double precision yes
p_prim7_d
Daily prime rates array [7]
double precision yes
p_prim8_d
Daily prime rates array [8]
double precision yes
p_prim9_d
Daily prime rates array [9]
double precision yes
p_prim10_d
Daily prime rates array [10]
double precision yes
p_prim11_d
Daily prime rates array [11]
double precision yes
p_prim12_d
Daily prime rates array [12]
double precision yes
p_prim13_d
Daily prime rates array [13]
double precision yes
p_prim14_d
Daily prime rates array [14]
double precision yes
p_prim15_d
Daily prime rates array [15]
double precision yes
p_prim16_d
Daily prime rates array [16]
double precision yes
p_prim17_d
Daily prime rates array [17]
double precision yes
p_prim18_d
Daily prime rates array [18]
double precision yes
p_prim19_d
Daily prime rates array [19]
double precision yes
p_prim20_d
Daily prime rates array [20]
double precision yes
p_prim21_d
Daily prime rates array [21]
double precision yes
p_prim22_d
Daily prime rates array [22]
double precision yes
p_prim23_d
Daily prime rates array [23]
double precision yes
p_prim24_d
Daily prime rates array [24]
double precision yes
p_prim25_d
Daily prime rates array [25]
double precision yes
p_prim26_d
Daily prime rates array [26]
double precision yes
p_prim27_d
Daily prime rates array [27]
double precision yes
p_prim28_d
Daily prime rates array [28]
double precision yes
p_prim29_d
Daily prime rates array [29]
double precision yes
p_prim30_d
Daily prime rates array [30]
double precision yes
p_prim31_d
Daily prime rates array [31]
double precision yes