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

Database Reference

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