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

Database Reference Sybase DBMS

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