Columns |
Name |
Description |
Datatype ¿? |
Allow Null |
user_name_s |
Username (uppercase) |
CHAR(12) |
no |
stamp_l |
Record modification stamp |
NUMBER(10) |
no |
opr_s |
Operator initials |
CHAR(3) |
no |
s_mod1_c |
Modules (Y/N) |
VARCHAR2(250) |
yes |
s_mod2_c |
Modules (Y/N) |
VARCHAR2(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. |
VARCHAR2(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 |
VARCHAR2(20) |
yes |
xpr_sym_s |
Default 'X' printer symbol |
VARCHAR2(20) |
yes |
def_note_type_s |
Default note type |
CHAR(4) |
yes |
copies_l |
Report copies |
NUMBER(10) |
yes |
term_sz_l |
Terminal page size |
NUMBER(10) |
yes |
allow_mf_del_priv_c |
Allow master file delete privilege (Y/N) |
CHAR(1) |
yes |
s_mod3_c |
Modules (Y/N) |
VARCHAR2(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) |
NUMBER(10) |
yes |
ltch_waive_limit_d |
Late charges waived limit |
NUMBER(15,2) |
yes |
coll_waive_limit_d |
Collection fees waived limit |
NUMBER(15,2) |
yes |
asmf_waive_limit_d |
Assumption fees waived limit |
NUMBER(15,2) |
yes |
prtx_waive_limit_d |
Property tax waived limit |
NUMBER(15,2) |
yes |
legf_waive_limit_d |
Legal fees waived limit |
NUMBER(15,2) |
yes |
pext_waive_limit_d |
Payment extension fees waived limit |
NUMBER(15,2) |
yes |
lext_waive_limit_d |
Lease extension fees waived limit |
NUMBER(15,2) |
yes |
itcf_waive_limit_d |
ITC fees waived limit |
NUMBER(15,2) |
yes |
fhut_waive_limit_d |
Federal highway use tax waived limit |
NUMBER(15,2) |
yes |
lsrw_waive_limit_d |
Lease re-write fees waived limit |
NUMBER(15,2) |
yes |
othf_waive_limit_d |
Other fees waived limit |
NUMBER(15,2) |
yes |
stax_waive_limit_d |
Sales/Use tax waived limit |
NUMBER(15,2) |
yes |
rcr_waive_limit1_d |
Recurring charge waived limit [1] |
NUMBER(15,2) |
yes |
rcr_waive_limit2_d |
Recurring charge waived limit [2] |
NUMBER(15,2) |
yes |
rcr_waive_limit3_d |
Recurring charge waived limit [3] |
NUMBER(15,2) |
yes |
rcr_waive_limit4_d |
Recurring charge waived limit [4] |
NUMBER(15,2) |
yes |
rcr_waive_limit5_d |
Recurring charge waived limit [5] |
NUMBER(15,2) |
yes |
rcr_waive_limit6_d |
Recurring charge waived limit [6] |
NUMBER(15,2) |
yes |
rcr_waive_limit7_d |
Recurring charge waived limit [7] |
NUMBER(15,2) |
yes |
rcr_waive_limit8_d |
Recurring charge waived limit [8] |
NUMBER(15,2) |
yes |
rcr_waive_limit9_d |
Recurring charge waived limit [9] |
NUMBER(15,2) |
yes |
rcr_waive_limit10_d |
Recurring charge waived limit [10] |
NUMBER(15,2) |
yes |
rcr_waive_limit11_d |
Recurring charge waived limit [11] |
NUMBER(15,2) |
yes |
rcr_waive_limit12_d |
Recurring charge waived limit [12] |
NUMBER(15,2) |
yes |
rcr_waive_limit13_d |
Recurring charge waived limit [13] |
NUMBER(15,2) |
yes |
rcr_waive_limit14_d |
Recurring charge waived limit [14] |
NUMBER(15,2) |
yes |
rcr_waive_limit15_d |
Recurring charge waived limit [15] |
NUMBER(15,2) |
yes |
pmt_waive_limit_d |
Payment waived limit |
NUMBER(15,2) |
yes |
prn_waive_limit_d |
Principal waived limit |
NUMBER(15,2) |
yes |
int_waive_limit_d |
Interest waived limit |
NUMBER(15,2) |
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 |
NUMBER(10) |
yes |
d_pwd_chg_s |
Date password last changed |
DATE |
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 |
VARCHAR2(25) |
yes |
launch_pad_xsl_filename_s |
Launch Pad XSL fle name |
VARCHAR2(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 |
NUMBER(10) |
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 |
NUMBER(15,2) |
yes |
coll_man_limit_d |
Collection fees manual limit |
NUMBER(15,2) |
yes |
fhut_man_limit_d |
Federal highway use tax manual limit |
NUMBER(15,2) |
yes |
itcf_man_limit_d |
ITC fees manual limit |
NUMBER(15,2) |
yes |
legf_man_limit_d |
Legal fees manual limit |
NUMBER(15,2) |
yes |
lext_man_limit_d |
Lease extension fees manual limit |
NUMBER(15,2) |
yes |
lsrw_man_limit_d |
Lease re-write fees manual limit |
NUMBER(15,2) |
yes |
ltch_man_limit_d |
Late charges manual limit |
NUMBER(15,2) |
yes |
othf_man_limit_d |
Other fees manual limit |
NUMBER(15,2) |
yes |
pext_man_limit_d |
Payment extension fees manual limit |
NUMBER(15,2) |
yes |
prtx_man_limit_d |
Property tax manual limit |
NUMBER(15,2) |
yes |
stax_man_limit_d |
Sales/Use tax manual limit |
NUMBER(15,2) |
yes |
rcr_man_limit1_d |
Recurring charge manual limit [1] |
NUMBER(15,2) |
yes |
rcr_man_limit2_d |
Recurring charge manual limit [2] |
NUMBER(15,2) |
yes |
rcr_man_limit3_d |
Recurring charge manual limit [3] |
NUMBER(15,2) |
yes |
rcr_man_limit4_d |
Recurring charge manual limit [4] |
NUMBER(15,2) |
yes |
rcr_man_limit5_d |
Recurring charge manual limit [5] |
NUMBER(15,2) |
yes |
rcr_man_limit6_d |
Recurring charge manual limit [6] |
NUMBER(15,2) |
yes |
rcr_man_limit7_d |
Recurring charge manual limit [7] |
NUMBER(15,2) |
yes |
rcr_man_limit8_d |
Recurring charge manual limit [8] |
NUMBER(15,2) |
yes |
rcr_man_limit9_d |
Recurring charge manual limit [9] |
NUMBER(15,2) |
yes |
rcr_man_limit10_d |
Recurring charge manual limit [10] |
NUMBER(15,2) |
yes |
rcr_man_limit11_d |
Recurring charge manual limit [11] |
NUMBER(15,2) |
yes |
rcr_man_limit12_d |
Recurring charge manual limit [12] |
NUMBER(15,2) |
yes |
rcr_man_limit13_d |
Recurring charge manual limit [13] |
NUMBER(15,2) |
yes |
rcr_man_limit14_d |
Recurring charge manual limit [14] |
NUMBER(15,2) |
yes |
rcr_man_limit15_d |
Recurring charge manual limit [15] |
NUMBER(15,2) |
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 |
NUMBER(10) |
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 |