rufd Table: User Defined Fields Description 5
LeasePak Documentation Suite NETSOL website
Home Search Help
LeasePak Database Objects
Return to Top

Database Reference Oracle DBMS

rufd Table: User Defined Fields Description 5

Parent Table

Name Description
ruf User Defined Fields Description

Indexes

Name Segment 1 Segment 2 Segment 3
rufd_idx0 por_s udf_type_s unique_l

   
Columns
Name DescriptionDatatype ¿? Allow Null
por_s 
Portfolio
CHAR(2) no
udf_type_s 
User defined field type (APP/CUS/LES/LSE/UNI/VND)
  APP - Application fields
  CUS - Customer fields
  LES - Lessee fields
  LSE - Lease fields
  UNI - Asset fields
  VND - Vendor fields
 CHAR(3) no
unique_l 
Record number (value is always 1)
NUMBER(10) no
stamp_l 
Record modification stamp
 NUMBER(10) no
fcod5_s 
User defined field code check (Y/N) [201-250]
VARCHAR2(50) yes
fir5_s 
User defined field input required (Y/N) [201-250]
 VARCHAR2(50) yes
fedt5_s 
User defined field edit check (D/N/$/0-7/' ') [201-250]
  D - date
  N - integer
  $ - dollar amount
  0-7 - number of decimal places
  ' ' - no edit check
 VARCHAR2(50) yes
fxfer5_s 
Transfer user defined app field to lease (Y/N) [201-250]
 VARCHAR2(50) yes
fhed201_s 
User defined field header [201]
 VARCHAR2(25) yes
fhed202_s 
User defined field header [202]
 VARCHAR2(25) yes
fhed203_s 
User defined field header [203]
 VARCHAR2(25) yes
fhed204_s 
User defined field header [204]
 VARCHAR2(25) yes
fhed205_s 
User defined field header [205]
 VARCHAR2(25) yes
fhed206_s 
User defined field header [206]
 VARCHAR2(25) yes
fhed207_s 
User defined field header [207]
 VARCHAR2(25) yes
fhed208_s 
User defined field header [208]
 VARCHAR2(25) yes
fhed209_s 
User defined field header [209]
 VARCHAR2(25) yes
fhed210_s 
User defined field header [210]
 VARCHAR2(25) yes
fhed211_s 
User defined field header [211]
 VARCHAR2(25) yes
fhed212_s 
User defined field header [212]
 VARCHAR2(25) yes
fhed213_s 
User defined field header [213]
 VARCHAR2(25) yes
fhed214_s 
User defined field header [214]
 VARCHAR2(25) yes
fhed215_s 
User defined field header [215]
 VARCHAR2(25) yes
fhed216_s 
User defined field header [216]
 VARCHAR2(25) yes
fhed217_s 
User defined field header [217]
 VARCHAR2(25) yes
fhed218_s 
User defined field header [218]
 VARCHAR2(25) yes
fhed219_s 
User defined field header [219]
 VARCHAR2(25) yes
fhed220_s 
User defined field header [220]
 VARCHAR2(25) yes
fhed221_s 
User defined field header [221]
 VARCHAR2(25) yes
fhed222_s 
User defined field header [222]
 VARCHAR2(25) yes
fhed223_s 
User defined field header [223]
 VARCHAR2(25) yes
fhed224_s 
User defined field header [224]
 VARCHAR2(25) yes
fhed225_s 
User defined field header [225]
 VARCHAR2(25) yes
fhed226_s 
User defined field header [226]
 VARCHAR2(25) yes
fhed227_s 
User defined field header [227]
 VARCHAR2(25) yes
fhed228_s 
User defined field header [228]
 VARCHAR2(25) yes
fhed229_s 
User defined field header [229]
 VARCHAR2(25) yes
fhed230_s 
User defined field header [230]
 VARCHAR2(25) yes
fhed231_s 
User defined field header [231]
 VARCHAR2(25) yes
fhed232_s 
User defined field header [232]
 VARCHAR2(25) yes
fhed233_s 
User defined field header [233]
 VARCHAR2(25) yes
fhed234_s 
User defined field header [234]
 VARCHAR2(25) yes
fhed235_s 
User defined field header [235]
 VARCHAR2(25) yes
fhed236_s 
User defined field header [236]
 VARCHAR2(25) yes
fhed237_s 
User defined field header [237]
 VARCHAR2(25) yes
fhed238_s 
User defined field header [238]
 VARCHAR2(25) yes
fhed239_s 
User defined field header [239]
 VARCHAR2(25) yes
fhed240_s 
User defined field header [240]
 VARCHAR2(25) yes
fhed241_s 
User defined field header [241]
 VARCHAR2(25) yes
fhed242_s 
User defined field header [242]
 VARCHAR2(25) yes
fhed243_s 
User defined field header [243]
 VARCHAR2(25) yes
fhed244_s 
User defined field header [244]
 VARCHAR2(25) yes
fhed245_s 
User defined field header [245]
 VARCHAR2(25) yes
fhed246_s 
User defined field header [246]
 VARCHAR2(25) yes
fhed247_s 
User defined field header [247]
 VARCHAR2(25) yes
fhed248_s 
User defined field header [248]
 VARCHAR2(25) yes
fhed249_s 
User defined field header [249]
 VARCHAR2(25) yes
fhed250_s 
User defined field header [250]
 VARCHAR2(25) yes