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

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