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

Database Reference

rufc Table: User Defined Fields Description 4

Parent Table

Name Description
ruf User Defined Fields Description

Indexes

Name Segment 1 Segment 2 Segment 3
rufc_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
fcod4_s 
User defined field code check (Y/N) [151-200]
fir4_s 
User defined field input required (Y/N) [151-200]
fedt4_s 
User defined field edit check (D/N/$/0-7/' ') [151-200]
  D - date
  N - integer
  $ - dollar amount
  0-7 - number of decimal places
  ' ' - no edit check
fxfer4_s 
Transfer user defined app field to lease (Y/N) [151-200]
fhed151_s 
User defined field header [151]
fhed152_s 
User defined field header [152]
fhed153_s 
User defined field header [153]
fhed154_s 
User defined field header [154]
fhed155_s 
User defined field header [155]
fhed156_s 
User defined field header [156]
fhed157_s 
User defined field header [157]
fhed158_s 
User defined field header [158]
fhed159_s 
User defined field header [159]
fhed160_s 
User defined field header [160]
fhed161_s 
User defined field header [161]
fhed162_s 
User defined field header [162]
fhed163_s 
User defined field header [163]
fhed164_s 
User defined field header [164]
fhed165_s 
User defined field header [165]
fhed166_s 
User defined field header [166]
fhed167_s 
User defined field header [167]
fhed168_s 
User defined field header [168]
fhed169_s 
User defined field header [169]
fhed170_s 
User defined field header [170]
fhed171_s 
User defined field header [171]
fhed172_s 
User defined field header [172]
fhed173_s 
User defined field header [173]
fhed174_s 
User defined field header [174]
fhed175_s 
User defined field header [175]
fhed176_s 
User defined field header [176]
fhed177_s 
User defined field header [177]
fhed178_s 
User defined field header [178]
fhed179_s 
User defined field header [179]
fhed180_s 
User defined field header [180]
fhed181_s 
User defined field header [181]
fhed182_s 
User defined field header [182]
fhed183_s 
User defined field header [183]
fhed184_s 
User defined field header [184]
fhed185_s 
User defined field header [185]
fhed186_s 
User defined field header [186]
fhed187_s 
User defined field header [187]
fhed188_s 
User defined field header [188]
fhed189_s 
User defined field header [189]
fhed190_s 
User defined field header [190]
fhed191_s 
User defined field header [191]
fhed192_s 
User defined field header [192]
fhed193_s 
User defined field header [193]
fhed194_s 
User defined field header [194]
fhed195_s 
User defined field header [195]
fhed196_s 
User defined field header [196]
fhed197_s 
User defined field header [197]
fhed198_s 
User defined field header [198]
fhed199_s 
User defined field header [199]
fhed200_s 
User defined field header [200]