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

Database Reference

rufa Table: User Defined Fields Description 2

Parent Table

Name Description
ruf User Defined Fields Description

Indexes

Name Segment 1 Segment 2 Segment 3
rufa_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
fcod2_s 
User defined field code check (Y/N) [52-100]
fir2_s 
User defined field input required (Y/N) [52-100]
fedt2_s 
User defined field edit check (D/N/$/0-7/' ') [52-100]
  D - date
  N - integer
  $ - dollar amount
  0-7 - number of decimal places
  ' ' - no edit check
fxfer2_s 
Transfer user defined app field to lease (Y/N) [52-100]
fhed52_s 
User defined field header [52]
fhed53_s 
User defined field header [53]
fhed54_s 
User defined field header [54]
fhed55_s 
User defined field header [55]
fhed56_s 
User defined field header [56]
fhed57_s 
User defined field header [57]
fhed58_s 
User defined field header [58]
fhed59_s 
User defined field header [59]
fhed60_s 
User defined field header [60]
fhed61_s 
User defined field header [61]
fhed62_s 
User defined field header [62]
fhed63_s 
User defined field header [63]
fhed64_s 
User defined field header [64]
fhed65_s 
User defined field header [65]
fhed66_s 
User defined field header [66]
fhed67_s 
User defined field header [67]
fhed68_s 
User defined field header [68]
fhed69_s 
User defined field header [69]
fhed70_s 
User defined field header [70]
fhed71_s 
User defined field header [71]
fhed72_s 
User defined field header [72]
fhed73_s 
User defined field header [73]
fhed74_s 
User defined field header [74]
fhed75_s 
User defined field header [75]
fhed76_s 
User defined field header [76]
fhed77_s 
User defined field header [77]
fhed78_s 
User defined field header [78]
fhed79_s 
User defined field header [79]
fhed80_s 
User defined field header [80]
fhed81_s 
User defined field header [81]
fhed82_s 
User defined field header [82]
fhed83_s 
User defined field header [83]
fhed84_s 
User defined field header [84]
fhed85_s 
User defined field header [85]
fhed86_s 
User defined field header [86]
fhed87_s 
User defined field header [87]
fhed88_s 
User defined field header [88]
fhed89_s 
User defined field header [89]
fhed90_s 
User defined field header [90]
fhed91_s 
User defined field header [91]
fhed92_s 
User defined field header [92]
fhed93_s 
User defined field header [93]
fhed94_s 
User defined field header [94]
fhed95_s 
User defined field header [95]
fhed96_s 
User defined field header [96]
fhed97_s 
User defined field header [97]
fhed98_s 
User defined field header [98]
fhed99_s 
User defined field header [99]
fhed100_s 
User defined field header [100]