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

Database Reference Sybase DBMS

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