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