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

Database Reference Oracle DBMS

rufb Table: User Defined Fields Description 3

Parent Table

Name Description
ruf User Defined Fields Description

Indexes

Name Segment 1 Segment 2 Segment 3
rufb_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
fcod3_s 
User defined field code check (Y/N) [101-150]
VARCHAR2(50) yes
fir3_s 
User defined field input required (Y/N) [101-150]
 VARCHAR2(50) yes
fedt3_s 
User defined field edit check (D/N/$/0-7/' ') [101-150]
  D - date
  N - integer
  $ - dollar amount
  0-7 - number of decimal places
  ' ' - no edit check
 VARCHAR2(50) yes
fxfer3_s 
Transfer user defined app field to lease (Y/N) [101-150]
 VARCHAR2(50) yes
fhed101_s 
User defined field header [101]
 VARCHAR2(25) yes
fhed102_s 
User defined field header [102]
 VARCHAR2(25) yes
fhed103_s 
User defined field header [103]
 VARCHAR2(25) yes
fhed104_s 
User defined field header [104]
 VARCHAR2(25) yes
fhed105_s 
User defined field header [105]
 VARCHAR2(25) yes
fhed106_s 
User defined field header [106]
 VARCHAR2(25) yes
fhed107_s 
User defined field header [107]
 VARCHAR2(25) yes
fhed108_s 
User defined field header [108]
 VARCHAR2(25) yes
fhed109_s 
User defined field header [109]
 VARCHAR2(25) yes
fhed110_s 
User defined field header [110]
 VARCHAR2(25) yes
fhed111_s 
User defined field header [111]
 VARCHAR2(25) yes
fhed112_s 
User defined field header [112]
 VARCHAR2(25) yes
fhed113_s 
User defined field header [113]
 VARCHAR2(25) yes
fhed114_s 
User defined field header [114]
 VARCHAR2(25) yes
fhed115_s 
User defined field header [115]
 VARCHAR2(25) yes
fhed116_s 
User defined field header [116]
 VARCHAR2(25) yes
fhed117_s 
User defined field header [117]
 VARCHAR2(25) yes
fhed118_s 
User defined field header [118]
 VARCHAR2(25) yes
fhed119_s 
User defined field header [119]
 VARCHAR2(25) yes
fhed120_s 
User defined field header [120]
 VARCHAR2(25) yes
fhed121_s 
User defined field header [121]
 VARCHAR2(25) yes
fhed122_s 
User defined field header [122]
 VARCHAR2(25) yes
fhed123_s 
User defined field header [123]
 VARCHAR2(25) yes
fhed124_s 
User defined field header [124]
 VARCHAR2(25) yes
fhed125_s 
User defined field header [125]
 VARCHAR2(25) yes
fhed126_s 
User defined field header [126]
 VARCHAR2(25) yes
fhed127_s 
User defined field header [127]
 VARCHAR2(25) yes
fhed128_s 
User defined field header [128]
 VARCHAR2(25) yes
fhed129_s 
User defined field header [129]
 VARCHAR2(25) yes
fhed130_s 
User defined field header [130]
 VARCHAR2(25) yes
fhed131_s 
User defined field header [131]
 VARCHAR2(25) yes
fhed132_s 
User defined field header [132]
 VARCHAR2(25) yes
fhed133_s 
User defined field header [133]
 VARCHAR2(25) yes
fhed134_s 
User defined field header [134]
 VARCHAR2(25) yes
fhed135_s 
User defined field header [135]
 VARCHAR2(25) yes
fhed136_s 
User defined field header [136]
 VARCHAR2(25) yes
fhed137_s 
User defined field header [137]
 VARCHAR2(25) yes
fhed138_s 
User defined field header [138]
 VARCHAR2(25) yes
fhed139_s 
User defined field header [139]
 VARCHAR2(25) yes
fhed140_s 
User defined field header [140]
 VARCHAR2(25) yes
fhed141_s 
User defined field header [141]
 VARCHAR2(25) yes
fhed142_s 
User defined field header [142]
 VARCHAR2(25) yes
fhed143_s 
User defined field header [143]
 VARCHAR2(25) yes
fhed144_s 
User defined field header [144]
 VARCHAR2(25) yes
fhed145_s 
User defined field header [145]
 VARCHAR2(25) yes
fhed146_s 
User defined field header [146]
 VARCHAR2(25) yes
fhed147_s 
User defined field header [147]
 VARCHAR2(25) yes
fhed148_s 
User defined field header [148]
 VARCHAR2(25) yes
fhed149_s 
User defined field header [149]
 VARCHAR2(25) yes
fhed150_s 
User defined field header [150]
 VARCHAR2(25) yes