Database Reference Oracle DBMS
rru Table: Recovery User Profile
Indexes
| Name | Segment 1 |
|---|---|
| rru_idx0 | opr_s |
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null |
| opr_s | Operator initials |
CHAR(3) | no |
| stamp_l | Record modification stamp |
NUMBER(10) | no |
| s_new_note_first_c | Display newer follow-up dates before old dates (Y/N) |
CHAR(1) | yes |
| call_c | Display accounts legal to call only (Y/N) |
CHAR(1) | yes |
| supervisor_c | Supervisor (Y/N) |
CHAR(1) | yes |
| bankruptcy_c | Bankruptcy (Y/N) |
CHAR(1) | yes |
| all_rec_c | Access all recovery accounts (Y/N) |
CHAR(1) | yes |
| s_rec_mod_c | User has access to corresponding recovery menu option (Y/N) |
VARCHAR2(30) | yes |
| ws_def_all_c | WS default for ALL (X/' ') |
CHAR(1) | yes |
| ws_def_team_s | WS default team |
CHAR(4) | yes |
| ws_def_user_s | WS default user initials |
CHAR(3) | yes |
| ws_def_queue_s | WS default queue number |
CHAR(4) | yes |
| ws_col_stat_l | WS sort order - collection status |
NUMBER(10) | yes |
| ws_shrt_name_l | WS sort order - short name |
NUMBER(10) | yes |
| ws_lse_num_l | WS sort order - lease number |
NUMBER(10) | yes |
| ws_amt_l | WS sort order - application amount |
NUMBER(10) | yes |
| ws_folw_l | WS sort order - follow-up date |
NUMBER(10) | yes |
| ws_prior_l | WS sort order - note priority |
NUMBER(10) | yes |
| ws_weight_l | WS sort order weight |
NUMBER(10) | yes |
| xsl_filename_s | XSL file name |
VARCHAR2(25) | yes |
| email_s | Email address |
VARCHAR2(50) | yes |
| fax_s | Fax dial number |
CHAR(10) | yes |
| phn_s | Phone number |
CHAR(10) | yes |
DBMS Platform Selector |
Database Reference |
LeasePak Database Objects |
Data Model |
Additional Information
© 2025 NETSOL Technologies. All rights reserved.
The information contained in this document is the sole 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 nor does it have the obligation to update any of the information contained herein; 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.
The information contained in this document is the sole 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 nor does it have the obligation to update any of the information contained herein; 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.