rcc Table: Custom Code
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rcc Table: Custom Code

Indexes

Name Segment 1 Segment 2 Segment 3
rcc_idx0 rcc_flg_c cd_type_s cd_shrt_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
rcc_flg_c
Custom code flag
CHAR(1) no
cd_type_s
Custom/LeasePak code type
CHAR(10) no
cd_shrt_s
Custom/LeasePak code short symbol
  If code flag = '1' then cd_shrt_s is blank
  If code flag = '2' then cd_shrt_s = code short symbol
CHAR(4) no
stamp_l
Record modification stamp
NUMBER(10) no
cd_long_s
Custom/LeasePak code long name
VARCHAR2(20) yes
security_l
Security options (bit flags)
  0 - disallow additions, modifications, and deletions
      of codes in this category
  1 - allow codes to be added to this category
  2 - allow codes to be deleted from this category
  4 - allow descriptions of codes in this category to be
      modified
NUMBER(10) yes