| Columns | 
| Name | 
Description | 
Datatype ¿? | 
Allow Null | 
| user_name_s | 
Username (uppercase)  | 
char(12) | 
no | 
| timestamp | 
Record modification stamp  | 
timestamp | 
yes | 
| opr_s | 
Operator initials  | 
char(3) | 
no | 
| s_mod1_c | 
Modules (Y/N)  | 
char(250) | 
yes | 
| s_mod2_c | 
Modules (Y/N)  | 
char(250) | 
yes | 
| s_dtl_c | 
Print report detail (Y/N)  | 
char(1) | 
yes | 
| s_sum_c | 
Print summary totals (Y/N)  | 
char(1) | 
yes | 
| s_last_c | 
Print last version (Y/N)  | 
char(1) | 
yes | 
| s_btch_c | 
Process report in batch (Y/N)  | 
char(1) | 
yes | 
| s_subtl_c | 
Subtotals (Y/N)  | 
char(1) | 
yes | 
| s_por_sub_c | 
Subtotals by portfolio (Y/N)  | 
char(1) | 
yes | 
| s_com_sub_c | 
Subtotals by company (Y/N)  | 
char(1) | 
yes | 
| s_reg_sub_c | 
Subtotals by region (Y/N)  | 
char(1) | 
yes | 
| s_off_sub_c | 
Subtotals by office (Y/N)  | 
char(1) | 
yes | 
| s_cus_sub_c | 
Subtotals by customer (Y/N)  | 
char(1) | 
yes | 
| s_les_sub_c | 
Subtotals by lessee (Y/N)  | 
char(1) | 
yes | 
| s_grnd_c | 
Grand totals (Y/N)  | 
char(1) | 
yes | 
| s_por_grnd_c | 
Grand totals by portfolio (Y/N)  | 
char(1) | 
yes | 
| s_com_grnd_c | 
Grand totals by company (Y/N)  | 
char(1) | 
yes | 
| s_reg_grnd_c | 
Grand totals by region (Y/N)  | 
char(1) | 
yes | 
| s_off_grnd_c | 
Grand totals by office (Y/N)  | 
char(1) | 
yes | 
| s_cus_grnd_c | 
Grand totals by customer (Y/N)  | 
char(1) | 
yes | 
| s_les_grnd_c | 
Grand totals by lessee (Y/N)  | 
char(1) | 
yes | 
| s_ovr_appl_c | 
Override auto-assigned application/lease number (Y/N)  | 
char(1) | 
yes | 
| s_ovr_clnt_c | 
Override auto-assigned client number (Y/N)  | 
char(1) | 
yes | 
| s_ntf_note_c | 
New note notification (Y/N)  | 
char(1) | 
yes | 
| s_del_own_c | 
Ability to delete own notes (Y/N)  | 
char(1) | 
yes | 
| s_del_all_c | 
Ability to delete all notes (Y/N)  | 
char(1) | 
yes | 
| s_ntbk_accs_c | 
Allow access to Notebook (Y/N)  | 
char(1) | 
yes | 
| s_grp_sub_c | 
Subtotals by group (Y/N)  | 
char(1) | 
yes | 
| s_grp_grnd_c | 
Grand totals by group (Y/N)  | 
char(1) | 
yes | 
| s_upd_crdt_lmt_c | 
Update client credit limit (Y/N)  | 
char(1) | 
yes | 
| s_old_note_first_c | 
Display older follow-up dates before new dates (Y/N)  | 
char(1) | 
yes | 
| por_array_c | 
Portfolio access array (Y/N)
  If the array element is 'Y' then the index of this
  element is the accessible portfolio.  | 
char(99) | 
yes | 
| por_s | 
Portfolio
  If non-blank, the user may only access this portfolio.  | 
char(2) | 
yes | 
| com_s | 
Company
  If non-blank, the user may only access this company.  | 
char(2) | 
yes | 
| reg_s | 
Region
  If non-blank, the user may only access this region.  | 
char(2) | 
yes | 
| off_s | 
Office
  If non-blank, the user may only access this office.  | 
char(3) | 
yes | 
| dlr_s | 
Vendor
  If non-blank, the user may only access this vendor.  | 
char(9) | 
yes | 
| plain_s | 
Plain paper form type  | 
char(4) | 
yes | 
| lpr_sym_s | 
Default 'L' printer symbol  | 
char(20) | 
yes | 
| xpr_sym_s | 
Default 'X' printer symbol  | 
char(20) | 
yes | 
| def_note_type_s | 
Default note type  | 
char(4) | 
yes | 
| copies_l | 
Report copies  | 
integer | 
yes | 
| term_sz_l | 
Terminal page size  | 
integer | 
yes | 
| allow_mf_del_priv_c | 
Allow master file delete privilege (Y/N)  | 
char(1) | 
yes | 
| s_mod3_c | 
Modules (Y/N)  | 
char(200) | 
yes | 
| s_ux_credit_scan_c | 
Access to lessee credit scan (Y/N)  | 
char(1) | 
yes | 
| s_ntbk_private_l | 
Private note access level in Notebook
  0 - No access
  1 - Read access
  2 - Read and create access
        (Notebook screen does not default to private)
  3 - Read and create access
        (Notebook screen defaults to private)
  4 - Read, create, edit, and delete access
        (Notebook screen defaults to private) | 
integer | 
yes | 
| ltch_waive_limit_d | 
Late charges waived limit  | 
double precision | 
yes | 
| coll_waive_limit_d | 
Collection fees waived limit  | 
double precision | 
yes | 
| asmf_waive_limit_d | 
Assumption fees waived limit  | 
double precision | 
yes | 
| prtx_waive_limit_d | 
Property tax waived limit  | 
double precision | 
yes | 
| legf_waive_limit_d | 
Legal fees waived limit  | 
double precision | 
yes | 
| pext_waive_limit_d | 
Payment extension fees waived limit  | 
double precision | 
yes | 
| lext_waive_limit_d | 
Lease extension fees waived limit  | 
double precision | 
yes | 
| itcf_waive_limit_d | 
ITC fees waived limit  | 
double precision | 
yes | 
| fhut_waive_limit_d | 
Federal highway use tax waived limit  | 
double precision | 
yes | 
| lsrw_waive_limit_d | 
Lease re-write fees waived limit  | 
double precision | 
yes | 
| othf_waive_limit_d | 
Other fees waived limit  | 
double precision | 
yes | 
| stax_waive_limit_d | 
Sales/Use tax waived limit  | 
double precision | 
yes | 
| rcr_waive_limit1_d | 
Recurring charge waived limit [1]  | 
double precision | 
yes | 
| rcr_waive_limit2_d | 
Recurring charge waived limit [2]  | 
double precision | 
yes | 
| rcr_waive_limit3_d | 
Recurring charge waived limit [3]  | 
double precision | 
yes | 
| rcr_waive_limit4_d | 
Recurring charge waived limit [4]  | 
double precision | 
yes | 
| rcr_waive_limit5_d | 
Recurring charge waived limit [5]  | 
double precision | 
yes | 
| rcr_waive_limit6_d | 
Recurring charge waived limit [6]  | 
double precision | 
yes | 
| rcr_waive_limit7_d | 
Recurring charge waived limit [7]  | 
double precision | 
yes | 
| rcr_waive_limit8_d | 
Recurring charge waived limit [8]  | 
double precision | 
yes | 
| rcr_waive_limit9_d | 
Recurring charge waived limit [9]  | 
double precision | 
yes | 
| rcr_waive_limit10_d | 
Recurring charge waived limit [10]  | 
double precision | 
yes | 
| rcr_waive_limit11_d | 
Recurring charge waived limit [11]  | 
double precision | 
yes | 
| rcr_waive_limit12_d | 
Recurring charge waived limit [12]  | 
double precision | 
yes | 
| rcr_waive_limit13_d | 
Recurring charge waived limit [13]  | 
double precision | 
yes | 
| rcr_waive_limit14_d | 
Recurring charge waived limit [14]  | 
double precision | 
yes | 
| rcr_waive_limit15_d | 
Recurring charge waived limit [15]  | 
double precision | 
yes | 
| pmt_waive_limit_d | 
Payment waived limit  | 
double precision | 
yes | 
| prn_waive_limit_d | 
Principal waived limit  | 
double precision | 
yes | 
| int_waive_limit_d | 
Interest waived limit  | 
double precision | 
yes | 
| enable_c | 
User account status (Y/P/R/N)
  Y - User account is enabled as a regular update user
  P - User account is enabled as a partial update user
  R - User account is enabled as a report only user
  N - User account is disabled  | 
char(1) | 
yes | 
| date_format_pref_s | 
Date display format preference
  MMDDYY - Mon Day Year
  DDMMYY - Day Mon Year
  YYMMDD - Year Mon Day  | 
char(6) | 
yes | 
| s_chg_client_name_c | 
Allow client record name change (Y/N)  | 
char(1) | 
yes | 
| phn_format_pref_s | 
Phone number mask preference  | 
char(16) | 
yes | 
| pwd_expires_l | 
Days before password expires  | 
integer | 
yes | 
| d_pwd_chg_s | 
Date password last changed  | 
datetime | 
yes | 
| chg_all_pwd_c | 
Can change all users passwords (Y/N)  | 
char(1) | 
yes | 
| dlr_alrt_chg_s | 
Can change dealer alert switches (Y/N)  | 
char(6) | 
yes | 
| dlr_alrt_susp_ovr_c | 
Dealer alert suspense override (Y/N)  | 
char(1) | 
yes | 
| file_attach_del_c | 
Allow file attachment delete (Y/N)  | 
char(1) | 
yes | 
| auto_refresh_nbws_c | 
Automatic refresh of notebook work schedule (Y/N)  | 
char(1) | 
yes | 
| por_ovr_lse_summ_c | 
Override portfolio security on Lease Summary (Y/N)  | 
char(1) | 
yes | 
| xml_rpts_c | 
XML reports (Y/N)  | 
char(1) | 
yes | 
| output_device_selection_c | 
Output device selection (Y/N)  | 
char(1) | 
yes | 
| terminal_only_c | 
Terminal output only (Y/N)  | 
char(1) | 
yes | 
| force_pwd_chg_c | 
Force password change at next login (Y/N)  | 
char(1) | 
yes | 
| lse_summ_xsl_filename_s | 
Lease Summary XSL file name  | 
char(25) | 
yes | 
| launch_pad_xsl_filename_s | 
Launch Pad XSL fle name  | 
char(25) | 
yes | 
| allow_ud_access_c | 
Allow access to user defined fields and tables (Y/N)  | 
char(1) | 
yes | 
| auto_logout_l | 
Automatic logout time period
  # - automatically logout an idle user after # seconds
  0 - disable automatic logout  | 
integer | 
yes | 
| assmt_desc_chg_c | 
Allow assessment description change (Y/N)  | 
char(1) | 
yes | 
| ss_disp_mask_s | 
Mask type to apply to SSN/Business ID numbers (DISP.MASK
  code)  | 
char(4) | 
yes | 
| pap_disp_mask_s | 
Mask type to apply to PAP-ACH transit ids and account
  numbers (DISP.MASK code)  | 
char(4) | 
yes | 
| asmf_man_limit_d | 
Assumption fees manual limit  | 
double precision | 
yes | 
| coll_man_limit_d | 
Collection fees manual limit  | 
double precision | 
yes | 
| fhut_man_limit_d | 
Federal highway use tax manual limit  | 
double precision | 
yes | 
| itcf_man_limit_d | 
ITC fees manual limit  | 
double precision | 
yes | 
| legf_man_limit_d | 
Legal fees manual limit  | 
double precision | 
yes | 
| lext_man_limit_d | 
Lease extension fees manual limit  | 
double precision | 
yes | 
| lsrw_man_limit_d | 
Lease re-write fees manual limit  | 
double precision | 
yes | 
| ltch_man_limit_d | 
Late charges manual limit  | 
double precision | 
yes | 
| othf_man_limit_d | 
Other fees manual limit  | 
double precision | 
yes | 
| pext_man_limit_d | 
Payment extension fees manual limit  | 
double precision | 
yes | 
| prtx_man_limit_d | 
Property tax manual limit  | 
double precision | 
yes | 
| stax_man_limit_d | 
Sales/Use tax manual limit  | 
double precision | 
yes | 
| rcr_man_limit1_d | 
Recurring charge manual limit [1]  | 
double precision | 
yes | 
| rcr_man_limit2_d | 
Recurring charge manual limit [2]  | 
double precision | 
yes | 
| rcr_man_limit3_d | 
Recurring charge manual limit [3]  | 
double precision | 
yes | 
| rcr_man_limit4_d | 
Recurring charge manual limit [4]  | 
double precision | 
yes | 
| rcr_man_limit5_d | 
Recurring charge manual limit [5]  | 
double precision | 
yes | 
| rcr_man_limit6_d | 
Recurring charge manual limit [6]  | 
double precision | 
yes | 
| rcr_man_limit7_d | 
Recurring charge manual limit [7]  | 
double precision | 
yes | 
| rcr_man_limit8_d | 
Recurring charge manual limit [8]  | 
double precision | 
yes | 
| rcr_man_limit9_d | 
Recurring charge manual limit [9]  | 
double precision | 
yes | 
| rcr_man_limit10_d | 
Recurring charge manual limit [10]  | 
double precision | 
yes | 
| rcr_man_limit11_d | 
Recurring charge manual limit [11]  | 
double precision | 
yes | 
| rcr_man_limit12_d | 
Recurring charge manual limit [12]  | 
double precision | 
yes | 
| rcr_man_limit13_d | 
Recurring charge manual limit [13]  | 
double precision | 
yes | 
| rcr_man_limit14_d | 
Recurring charge manual limit [14]  | 
double precision | 
yes | 
| rcr_man_limit15_d | 
Recurring charge manual limit [15]  | 
double precision | 
yes | 
| reltree_opt_l | 
Relationship Tree options (bit flags)
  1 - Customer/Group/Lessee/Lease/Asset
  2 - Customer/Lessee/Group/Lease/Asset
  4 - Customer/Lessee/Lease/Asset
  8 - Lessee/Lease/Asset
  16 - Vendor/Lease/Asset  | 
integer | 
yes | 
| reltree_disp_grp_c | 
Display group number with lease on Relationship Tree (Y/N)  | 
char(1) | 
yes | 
| rsc_flg_c | 
RSC flag (O/R/S)
  O - operator with own credentials
  R - role with no credentials
  S - shared credentials operator  | 
char(1) | 
yes | 
| role_s | 
Role  | 
char(12) | 
yes | 
| credent_user_pwd_s | 
Hashed key for user of shared credentials  | 
char(18) | 
yes | 
| allow_lpak_api_access_c | 
Allow LeasePak API access (Y/N)  | 
char(1) | 
yes |