LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rfs Table: Application Field Security

Description Column Datatype
Field security code fsec_cd_s char (4)
Oracle row stamp stamp_l number (10)
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
updt1_s varchar2 (200)
Allow update (Y/N/T) updt2_s varchar2 (200)
Allow update (Y/N/T) updt3_s varchar2 (200)
Field security description fsec_desc_s varchar2 (20)
Percent tolerance of approved application value [1] p_tolpct1_d number (15,1)
Percent tolerance of approved application value [2] p_tolpct2_d number (15,1)
Percent tolerance of approved application value [3] p_tolpct3_d number (15,1)
Percent tolerance of approved application value [4] p_tolpct4_d number (15,1)
Percent tolerance of approved application value [5] p_tolpct5_d number (15,1)
Percent tolerance of approved application value [6] p_tolpct6_d number (15,1)
Percent tolerance of approved application value [7] p_tolpct7_d number (15,1)
Percent tolerance of approved application value [8] p_tolpct8_d number (15,1)
Percent tolerance of approved application value [9] p_tolpct9_d number (15,1)
Percent tolerance of approved application value [10] p_tolpct10_d number (15,1)
Percent tolerance of approved application value [11] p_tolpct11_d number (15,1)
Percent tolerance of approved application value [12] p_tolpct12_d number (15,1)
Percent tolerance of approved application value [13] p_tolpct13_d number (15,1)
Percent tolerance of approved application value [14] p_tolpct14_d number (15,1)
Percent tolerance of approved application value [15] p_tolpct15_d number (15,1)
Percent tolerance of approved application value [16] p_tolpct16_d number (15,1)
Percent tolerance of approved application value [17] p_tolpct17_d number (15,1)
Percent tolerance of approved application value [18] p_tolpct18_d number (15,1)
Percent tolerance of approved application value [19] p_tolpct19_d number (15,1)
Percent tolerance of approved application value [20] p_tolpct20_d number (15,1)
Tolerance amount allowed to exceed approved value [1] tolamt1_l number (10)
Tolerance amount allowed to exceed approved value [2] tolamt2_l number (10)
Tolerance amount allowed to exceed approved value [3] tolamt3_l number (10)
Tolerance amount allowed to exceed approved value [4] tolamt4_l number (10)
Tolerance amount allowed to exceed approved value [5] tolamt5_l number (10)
Tolerance amount allowed to exceed approved value [6] tolamt6_l number (10)
Tolerance amount allowed to exceed approved value [7] tolamt7_l number (10)
Tolerance amount allowed to exceed approved value [8] tolamt8_l number (10)
Tolerance amount allowed to exceed approved value [9] tolamt9_l number (10)
Tolerance amount allowed to exceed approved value [10] tolamt10_l number (10)
Tolerance amount allowed to exceed approved value [11] tolamt11_l number (10)
Tolerance amount allowed to exceed approved value [12] tolamt12_l number (10)
Tolerance amount allowed to exceed approved value [13] tolamt13_l number (10)
Tolerance amount allowed to exceed approved value [14] tolamt14_l number (10)
Tolerance amount allowed to exceed approved value [15] tolamt15_l number (10)
Tolerance amount allowed to exceed approved value [16] tolamt16_l number (10)
Tolerance amount allowed to exceed approved value [17] tolamt17_l number (10)
Tolerance amount allowed to exceed approved value [18] tolamt18_l number (10)
Tolerance amount allowed to exceed approved value [19] tolamt19_l number (10)
Tolerance amount allowed to exceed approved value [20] tolamt20_l number (10)
Highlighted field hilight1_s varchar2 (200)
Highlighted field hilight2_s varchar2 (200)
Highlighted field hilight3_s varchar2 (200)

rfs Indexes:

Index name Piece 1
rfs_idx0 fsec_cd_s


HomeTableIndexes