rcgb Table: Custom General 2
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rcgb Table: Custom General 2

Parent Table

Name Description
rcg Custom General

Indexes

Name Segment 1 Segment 2
rcgb_idx0 cntl_rec_s unique_l

   
Columns
Name DescriptionDatatype ¿? Allow Null
cntl_rec_s
00 - Dummy key
CHAR(2) no
unique_l
Record number (value is always 1)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
mb_pwd_s
Microbilt password
CHAR(10) yes
mb_id_s
Microbilt user id
CHAR(10) yes
mb_server_s
Microbilt server
VARCHAR2(36) yes
mb_post_s
Microbilt post
VARCHAR2(36) yes
second_due_1_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_2_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_3_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_4_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_5_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_6_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_7_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_8_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_9_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_10_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_11_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_12_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_13_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_14_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_15_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_16_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_17_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_18_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_19_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_20_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_21_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_22_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_23_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_24_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_25_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_26_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_27_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_28_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_29_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_30_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
second_due_31_l
Second payment due day for semi-monthly accrual cycle when
  first due day is %d
NUMBER(10) yes
docgen_attach_dir_s
DocGen file attachment directory (PDF)
VARCHAR2(80) yes
docgen_template_dir_s
DocGen document template directory (MS Word)
VARCHAR2(80) yes
wm_url_s
WebMerge URL (Uniform Resource Locator)
VARCHAR2(80) yes
wm_encr_api_key_s
WebMerge encrypted API key
VARCHAR2(50) yes
wm_encr_api_secret_s
WebMerge encrypted API secret
VARCHAR2(50) yes
mpower_url_s
URL for connecting to mPower Services
VARCHAR2(80) yes