rce Table: Custom Edit Check Codes
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rce Table: Custom Edit Check Codes

Indexes

Name Segment 1 Segment 2 Segment 3
rce_idx0 rce_flg_c cd_type_s cd_med_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
rce_flg_c
Custom code flag
CHAR(1) no
cd_type_s
Custom/LeasePak code type
CHAR(10) no
cd_med_s
Custom/LeasePak code short symbol
  If code flag = '1' then cd_med_s is blank
  If code flag = '2' then cd_med_s = code short symbol
CHAR(8) no
stamp_l
Record modification stamp
NUMBER(10) no
cd_long_s
Custom/LeasePak code long name
VARCHAR2(20) yes
ir_date_c
Input required date (Y/N)
CHAR(1) yes
ir_amount_c
Input required amount (Y/N)
CHAR(1) yes
chk_stats_c
Check status (Y/N)
CHAR(1) yes
switches_s
Custom switches
VARCHAR2(20) yes