Database Reference Oracle DBMS
rnm Table: Name
Indexes
| Name | Segment 1 | Segment 2 | Segment 3 |
|---|---|---|---|
| rnm_idx0 | rnm_flg_s | rnm_key_s | |
| rnm_idx1 | nam_s | rnm_flg_s | rnm_key_s |
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null |
| rnm_flg_s | Name code 02 - Company 03 - Region 04 - Office 06 - County 07 - City 08 - Salesperson 09 - Credit approval officer 09 - Funding approval officer 09 - Document approval officer 10 - Financial institution 14 - Portfolio 15 - Tax Entity |
CHAR(2) | no |
| rnm_key_s | Name key for each Name code 02 - portfolio(2)/company(2)/blank(5) 03 - portfolio(2)/company(2)/region(2)/blank(3) 04 - portfolio(2)/company(2)/region(2)/office(3) 06 - non-Vertex: county(4)/blank(5) 06 - Vertex: county(3)/blank(1)/state(2)/blank(3) 07 - non-Vertex: city(4)/blank(5) 07 - Vertex: city(4)/county(3)/state(2) 08 - salesperson(4)/blank(5) 09 - lending officer(9) 10 - financial institution(4)/blank(5) 14 - portfolio(2)/blank(7) 15 - tax entity(4)/blank(5) |
CHAR(9) | no |
| stamp_l | Record modification stamp |
NUMBER(10) | no |
| nam_s | Name for each Name code 02, 03, 04 - Name(36) 06 - Name(34)/state(2) 07 - '07'(2)/Name(25)/blank(7)/state(2) 08, 09, 10, 14, 15 - Name(36) |
CHAR(36) | no |
| def_app_s | Default application |
CHAR(10) | yes |
| por_st_s | Portfolio or state |
CHAR(2) | yes |
| com_s | Company |
CHAR(2) | yes |
| reg_s | Region |
CHAR(2) | yes |
| off_s | Office |
CHAR(3) | yes |
| officer_s | Name code - officer Only applicable for credit, funding or document approval records. |
CHAR(9) | yes |
| dnm_code_s | Name codes Only applicable for financial institution, CCA tax entity or salesperson records. |
CHAR(4) | yes |
| col_team_s | Collection team |
CHAR(4) | yes |
| kol_team_s | Collateral team |
CHAR(4) | yes |
| ml_team_s | Maturing lease team |
CHAR(4) | yes |
| def_ent_s | CCA default tax entity
Only applicable for company, region, and office
or
CCA default portfolio for tax entity
(only the first 2 bytes are used) |
CHAR(4) | yes |
| com_code_s | Company code |
CHAR(4) | yes |
| cost_ctr_s | Cost center |
CHAR(4) | yes |
| grp_code_s | Group code |
CHAR(2) | yes |
| ins_team_s | Insurance team |
CHAR(4) | 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.