rfs Table: Application Field Security
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rfs Table: Application Field Security

Indexes

Name Segment 1
rfs_idx0 fsec_cd_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
fsec_cd_s
Field security code
CHAR(4) no
stamp_l
Record modification stamp
NUMBER(10) no
updt1_s
Allow update (Y/N/T)
  Y - application field may be modified
  N - application field may not be modified
  T - application field may be modified within
      certain tolerance percent or amount of
      the approved application value
VARCHAR2(200) yes
updt2_s
Allow update (Y/N/T)
VARCHAR2(200) yes
updt3_s
Allow update (Y/N/T)
VARCHAR2(200) yes
fsec_desc_s
Field security description
VARCHAR2(20) yes
p_tolpct1_d
Percent tolerance of approved application value [1]
NUMBER(15,1) yes
p_tolpct2_d
Percent tolerance of approved application value [2]
NUMBER(15,1) yes
p_tolpct3_d
Percent tolerance of approved application value [3]
NUMBER(15,1) yes
p_tolpct4_d
Percent tolerance of approved application value [4]
NUMBER(15,1) yes
p_tolpct5_d
Percent tolerance of approved application value [5]
NUMBER(15,1) yes
p_tolpct6_d
Percent tolerance of approved application value [6]
NUMBER(15,1) yes
p_tolpct7_d
Percent tolerance of approved application value [7]
NUMBER(15,1) yes
p_tolpct8_d
Percent tolerance of approved application value [8]
NUMBER(15,1) yes
p_tolpct9_d
Percent tolerance of approved application value [9]
NUMBER(15,1) yes
p_tolpct10_d
Percent tolerance of approved application value [10]
NUMBER(15,1) yes
p_tolpct11_d
Percent tolerance of approved application value [11]
NUMBER(15,1) yes
p_tolpct12_d
Percent tolerance of approved application value [12]
NUMBER(15,1) yes
p_tolpct13_d
Percent tolerance of approved application value [13]
NUMBER(15,1) yes
p_tolpct14_d
Percent tolerance of approved application value [14]
NUMBER(15,1) yes
p_tolpct15_d
Percent tolerance of approved application value [15]
NUMBER(15,1) yes
p_tolpct16_d
Percent tolerance of approved application value [16]
NUMBER(15,1) yes
p_tolpct17_d
Percent tolerance of approved application value [17]
NUMBER(15,1) yes
p_tolpct18_d
Percent tolerance of approved application value [18]
NUMBER(15,1) yes
p_tolpct19_d
Percent tolerance of approved application value [19]
NUMBER(15,1) yes
p_tolpct20_d
Percent tolerance of approved application value [20]
NUMBER(15,1) yes
tolamt1_l
Tolerance amount allowed to exceed approved value [1]
NUMBER(10) yes
tolamt2_l
Tolerance amount allowed to exceed approved value [2]
NUMBER(10) yes
tolamt3_l
Tolerance amount allowed to exceed approved value [3]
NUMBER(10) yes
tolamt4_l
Tolerance amount allowed to exceed approved value [4]
NUMBER(10) yes
tolamt5_l
Tolerance amount allowed to exceed approved value [5]
NUMBER(10) yes
tolamt6_l
Tolerance amount allowed to exceed approved value [6]
NUMBER(10) yes
tolamt7_l
Tolerance amount allowed to exceed approved value [7]
NUMBER(10) yes
tolamt8_l
Tolerance amount allowed to exceed approved value [8]
NUMBER(10) yes
tolamt9_l
Tolerance amount allowed to exceed approved value [9]
NUMBER(10) yes
tolamt10_l
Tolerance amount allowed to exceed approved value [10]
NUMBER(10) yes
tolamt11_l
Tolerance amount allowed to exceed approved value [11]
NUMBER(10) yes
tolamt12_l
Tolerance amount allowed to exceed approved value [12]
NUMBER(10) yes
tolamt13_l
Tolerance amount allowed to exceed approved value [13]
NUMBER(10) yes
tolamt14_l
Tolerance amount allowed to exceed approved value [14]
NUMBER(10) yes
tolamt15_l
Tolerance amount allowed to exceed approved value [15]
NUMBER(10) yes
tolamt16_l
Tolerance amount allowed to exceed approved value [16]
NUMBER(10) yes
tolamt17_l
Tolerance amount allowed to exceed approved value [17]
NUMBER(10) yes
tolamt18_l
Tolerance amount allowed to exceed approved value [18]
NUMBER(10) yes
tolamt19_l
Tolerance amount allowed to exceed approved value [19]
NUMBER(10) yes
tolamt20_l
Tolerance amount allowed to exceed approved value [20]
NUMBER(10) yes
hilight1_s
Highlighted field
VARCHAR2(200) yes
hilight2_s
Highlighted field
VARCHAR2(200) yes
hilight3_s
Highlighted field
VARCHAR2(200) yes