rcfb Table: Custom Letter 3
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rcfb Table: Custom Letter 3

Parent Table

Name Description
rcf Custom Letter

Indexes

Name Segment 1 Segment 2
rcfb_idx0 lt_cd_s unique_l

   
Columns
Name DescriptionDatatype ¿? Allow Null
lt_cd_s
Letter code
  100 - New lease letter
  300 - Closed lease letter
CHAR(3) no
unique_l
Record number (value is always 1)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
let_text41_s
Letter text [41]
VARCHAR2(80) yes
let_text42_s
Letter text [42]
VARCHAR2(80) yes
let_text43_s
Letter text [43]
VARCHAR2(80) yes
let_text44_s
Letter text [44]
VARCHAR2(80) yes
let_text45_s
Letter text [45]
VARCHAR2(80) yes
let_text46_s
Letter text [46]
VARCHAR2(80) yes
let_text47_s
Letter text [47]
VARCHAR2(80) yes
let_text48_s
Letter text [48]
VARCHAR2(80) yes
let_text49_s
Letter text [49]
VARCHAR2(80) yes
let_text50_s
Letter text [50]
VARCHAR2(80) yes
let_text51_s
Letter text [51]
VARCHAR2(80) yes
let_text52_s
Letter text [52]
VARCHAR2(80) yes
let_text53_s
Letter text [53]
VARCHAR2(80) yes
let_text54_s
Letter text [54]
VARCHAR2(80) yes
let_text55_s
Letter text [55]
VARCHAR2(80) yes
let_text56_s
Letter text [56]
VARCHAR2(80) yes
let_text57_s
Letter text [57]
VARCHAR2(80) yes
let_text58_s
Letter text [58]
VARCHAR2(80) yes
let_text59_s
Letter text [59]
VARCHAR2(80) yes
let_text60_s
Letter text [60]
VARCHAR2(80) yes
let_text61_s
Letter text [61]
VARCHAR2(80) yes