rcfa Table: Custom Letter 2
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rcfa Table: Custom Letter 2

Parent Table

Name Description
rcf Custom Letter

Indexes

Name Segment 1 Segment 2
rcfa_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_text21_s
Letter text [21]
VARCHAR2(80) yes
let_text22_s
Letter text [22]
VARCHAR2(80) yes
let_text23_s
Letter text [23]
VARCHAR2(80) yes
let_text24_s
Letter text [24]
VARCHAR2(80) yes
let_text25_s
Letter text [25]
VARCHAR2(80) yes
let_text26_s
Letter text [26]
VARCHAR2(80) yes
let_text27_s
Letter text [27]
VARCHAR2(80) yes
let_text28_s
Letter text [28]
VARCHAR2(80) yes
let_text29_s
Letter text [29]
VARCHAR2(80) yes
let_text30_s
Letter text [30]
VARCHAR2(80) yes
let_text31_s
Letter text [31]
VARCHAR2(80) yes
let_text32_s
Letter text [32]
VARCHAR2(80) yes
let_text33_s
Letter text [33]
VARCHAR2(80) yes
let_text34_s
Letter text [34]
VARCHAR2(80) yes
let_text35_s
Letter text [35]
VARCHAR2(80) yes
let_text36_s
Letter text [36]
VARCHAR2(80) yes
let_text37_s
Letter text [37]
VARCHAR2(80) yes
let_text38_s
Letter text [38]
VARCHAR2(80) yes
let_text39_s
Letter text [39]
VARCHAR2(80) yes
let_text40_s
Letter text [40]
VARCHAR2(80) yes