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

Database Reference

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
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
unique_l 
Record number (value is always 1)
 
Record modification stamp
fcod5_s 
User defined field code check (Y/N) [201-250]
fir5_s 
User defined field input required (Y/N) [201-250]
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
fxfer5_s 
Transfer user defined app field to lease (Y/N) [201-250]
fhed201_s 
User defined field header [201]
fhed202_s 
User defined field header [202]
fhed203_s 
User defined field header [203]
fhed204_s 
User defined field header [204]
fhed205_s 
User defined field header [205]
fhed206_s 
User defined field header [206]
fhed207_s 
User defined field header [207]
fhed208_s 
User defined field header [208]
fhed209_s 
User defined field header [209]
fhed210_s 
User defined field header [210]
fhed211_s 
User defined field header [211]
fhed212_s 
User defined field header [212]
fhed213_s 
User defined field header [213]
fhed214_s 
User defined field header [214]
fhed215_s 
User defined field header [215]
fhed216_s 
User defined field header [216]
fhed217_s 
User defined field header [217]
fhed218_s 
User defined field header [218]
fhed219_s 
User defined field header [219]
fhed220_s 
User defined field header [220]
fhed221_s 
User defined field header [221]
fhed222_s 
User defined field header [222]
fhed223_s 
User defined field header [223]
fhed224_s 
User defined field header [224]
fhed225_s 
User defined field header [225]
fhed226_s 
User defined field header [226]
fhed227_s 
User defined field header [227]
fhed228_s 
User defined field header [228]
fhed229_s 
User defined field header [229]
fhed230_s 
User defined field header [230]
fhed231_s 
User defined field header [231]
fhed232_s 
User defined field header [232]
fhed233_s 
User defined field header [233]
fhed234_s 
User defined field header [234]
fhed235_s 
User defined field header [235]
fhed236_s 
User defined field header [236]
fhed237_s 
User defined field header [237]
fhed238_s 
User defined field header [238]
fhed239_s 
User defined field header [239]
fhed240_s 
User defined field header [240]
fhed241_s 
User defined field header [241]
fhed242_s 
User defined field header [242]
fhed243_s 
User defined field header [243]
fhed244_s 
User defined field header [244]
fhed245_s 
User defined field header [245]
fhed246_s 
User defined field header [246]
fhed247_s 
User defined field header [247]
fhed248_s 
User defined field header [248]
fhed249_s 
User defined field header [249]
fhed250_s 
User defined field header [250]