Columns |
Name |
Description |
Datatype ¿? |
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 |