rsc Table: Operator Security
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference

rsc Table: Operator Security

Child Tables

Name Description
rsca Operator Security 2

Indexes

Name Segment 1
rsc_idx0 user_name_s
rsc_idx1 opr_s


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