LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rcc Table: Custom Code

Description Column Datatype
Custom code flag rcc_flg_c char (1)
Custom/LeasePak code type cd_type_s char (10)
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
cd_shrt_s char (4)
Oracle row stamp stamp_l number (10)
Custom/LeasePak code long name cd_long_s varchar2 (20)
Security bit mask
  0 - no security access allowed to codes in this category
  1 - new codes may be added to this code category
  2 - existing codes may be deleted from this code category
  4 - descriptions of existing codes may be modified in this
    code category
security_l number (10)

rcc Indexes:

Index name Piece 1 Piece 2 Piece 3
rcc_idx0 rcc_flg_c cd_type_s cd_shrt_s


HomeTableIndexes