ColumnsIndexessp1

rsc Table: Operator Security
Sybase DBMS

Specifies the columns and rows with Sybase data type information for the rsc Operator Security table.

rsc Columns

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

rsc Indexes

Index Name	Piece 1
rsc_idx0	user_name_s
rsc_idx1	opr_s

Data Type Definitions and Characteristics

Following are descriptions of the Sybase data types used in the LeasePak database. Note that LeasePak does not use all the Sybase data types.

char

Sybase fixed length character string. Typically used to store short and medium-length string data such as keys, names, addresses, descriptions, four-character codes, and single-character switch values.
Characteristics:

• length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.

datetime

Sybase date and time, containing century, year, month, day, hour, minute, second, and second fraction (to 1/300 second) information.
Characteristics:

• format - The date format for the LeasePak database. For example, format YYYYMMDD is the 4-digit year number followed by the 2-digit month number followed by the 2-digit day number with no intervening punctuation.

double

Sybase numeric data type. Typically used to store percentage, rate, and dollar amount information.
Characteristics:

• precision - The magnitude and fractional granularity together, meaning the maximum number of places available to both the left and right of the decimal point. Use precision minus scale to determine the maximum number of places available to the left of the decimal point.
• scale - The fractional granularity, meaning the number of places available to the right of the decimal point.

integer

Sybase numeric data type. Typically used to store counter and whole number information--term length, payment due day, number of units on lease, number of times delinquent, etc.

timestamp

Sybase data type based on the varbinary data type storing raw binary data. Whenever a table includes a timestamp column, Sybase updates the information in timestamp each time a user inserts or updates a record, preventing multiple-user cross-update data corruption.

text

Sybase expandable character data type. Typically used to store long-length string data such as notebook entries.

LeasePak Documentation Suite

© by NetSol Technologies Inc. All rights reserved.

The information contained in this document is the property of NetSol Technologies Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NetSol Technologies Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NetSol Technologies Inc. is prohibited.

Your document is loading...

This message should disappear within 5-15 seconds, depending on the size of the document and the speed of your connection to the Documentation Suite.

If you can still see this message after 20 seconds, try clicking the Refresh or Reload button on your Web browser.

If your document still does not load, refer to Document Load Troubleshooting for instructions on how to fix possible problems with either your Documentation Suite installation or Web browser setup.

If you do not have read access to the parent docsuite directory, you will not be able to load the Document Load Troubleshooting document. In this case, contact your network administrator for assistance.