Columns |
Name |
Description |
Datatype ¿? |
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 |