LeasePak 5.2a Database Reference (Sybase)

HomeTableIndexes

rfs Table: Application Field Security

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

rfs Indexes:

Index name Piece 1
rfs_idx0 fsec_cd_s


HomeTableIndexes