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

Database Reference Oracle DBMS

ruf Table: User Defined Fields Description

Child Tables

Name Description
rufa User Defined Fields Description 2
rufb User Defined Fields Description 3
rufc User Defined Fields Description 4
rufd User Defined Fields Description 5

Indexes

Name Segment 1 Segment 2
ruf_idx0 por_s udf_type_s

   
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
stamp_l 
Record modification stamp
NUMBER(10) no
fcod_s 
User defined field code check (Y/N)
VARCHAR2(51) yes
fir_s 
User defined field input required (Y/N)
 VARCHAR2(51) yes
fedt_s 
User defined field edit check (D/N/$/0-7/' ')
  D - date
  N - integer
  $ - dollar amount
  0-7 - number of decimal places
  ' ' - no edit check
 VARCHAR2(51) yes
fxfer_s 
Transfer user defined application field to lease (Y/N)
 VARCHAR2(51) yes
fhed1_s 
User defined field header [1]
 VARCHAR2(25) yes
fhed2_s 
User defined field header [2]
 VARCHAR2(25) yes
fhed3_s 
User defined field header [3]
 VARCHAR2(25) yes
fhed4_s 
User defined field header [4]
 VARCHAR2(25) yes
fhed5_s 
User defined field header [5]
 VARCHAR2(25) yes
fhed6_s 
User defined field header [6]
 VARCHAR2(25) yes
fhed7_s 
User defined field header [7]
 VARCHAR2(25) yes
fhed8_s 
User defined field header [8]
 VARCHAR2(25) yes
fhed9_s 
User defined field header [9]
 VARCHAR2(25) yes
fhed10_s 
User defined field header [10]
 VARCHAR2(25) yes
fhed11_s 
User defined field header [11]
 VARCHAR2(25) yes
fhed12_s 
User defined field header [12]
 VARCHAR2(25) yes
fhed13_s 
User defined field header [13]
 VARCHAR2(25) yes
fhed14_s 
User defined field header [14]
 VARCHAR2(25) yes
fhed15_s 
User defined field header [15]
 VARCHAR2(25) yes
fhed16_s 
User defined field header [16]
 VARCHAR2(25) yes
fhed17_s 
User defined field header [17]
 VARCHAR2(25) yes
fhed18_s 
User defined field header [18]
 VARCHAR2(25) yes
fhed19_s 
User defined field header [19]
 VARCHAR2(25) yes
fhed20_s 
User defined field header [20]
 VARCHAR2(25) yes
fhed21_s 
User defined field header [21]
 VARCHAR2(25) yes
fhed22_s 
User defined field header [22]
 VARCHAR2(25) yes
fhed23_s 
User defined field header [23]
 VARCHAR2(25) yes
fhed24_s 
User defined field header [24]
 VARCHAR2(25) yes
fhed25_s 
User defined field header [25]
 VARCHAR2(25) yes
fhed26_s 
User defined field header [26]
 VARCHAR2(25) yes
fhed27_s 
User defined field header [27]
 VARCHAR2(25) yes
fhed28_s 
User defined field header [28]
 VARCHAR2(25) yes
fhed29_s 
User defined field header [29]
 VARCHAR2(25) yes
fhed30_s 
User defined field header [30]
 VARCHAR2(25) yes
fhed31_s 
User defined field header [31]
 VARCHAR2(25) yes
fhed32_s 
User defined field header [32]
 VARCHAR2(25) yes
fhed33_s 
User defined field header [33]
 VARCHAR2(25) yes
fhed34_s 
User defined field header [34]
 VARCHAR2(25) yes
fhed35_s 
User defined field header [35]
 VARCHAR2(25) yes
fhed36_s 
User defined field header [36]
 VARCHAR2(25) yes
fhed37_s 
User defined field header [37]
 VARCHAR2(25) yes
fhed38_s 
User defined field header [38]
 VARCHAR2(25) yes
fhed39_s 
User defined field header [39]
 VARCHAR2(25) yes
fhed40_s 
User defined field header [40]
 VARCHAR2(25) yes
fhed41_s 
User defined field header [41]
 VARCHAR2(25) yes
fhed42_s 
User defined field header [42]
 VARCHAR2(25) yes
fhed43_s 
User defined field header [43]
 VARCHAR2(25) yes
fhed44_s 
User defined field header [44]
 VARCHAR2(25) yes
fhed45_s 
User defined field header [45]
 VARCHAR2(25) yes
fhed46_s 
User defined field header [46]
 VARCHAR2(25) yes
fhed47_s 
User defined field header [47]
 VARCHAR2(25) yes
fhed48_s 
User defined field header [48]
 VARCHAR2(25) yes
fhed49_s 
User defined field header [49]
 VARCHAR2(25) yes
fhed50_s 
User defined field header [50]
 VARCHAR2(25) yes
fhed51_s 
User defined field header [51]
 VARCHAR2(25) yes