| Description | Column | Datatype |
|---|---|---|
| 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 |
rnm_flg_s | char (2) |
| Name key
Company - port(2)/comp(2)/blank(5) Region - port(2)/comp(2)/region(2)/blank(3) Office - port(2)/comp(2)/region(2)/office(3) County/City - location code(4)/blank(5) Salesperson - salesperson(4)/blank(5) Lending officer - lending officer(9) Financial institution - financial institution(4)/blank(5) Portfolio - port(2)/blank(7) Tax entity - tax entity(4)/blank(5) |
rnm_key_s | char (9) |
| Oracle row stamp | stamp_l | number (10) |
| Name | nam_s | char (36) |
| Default application | def_app_s | char (10) |
| Portfolio or state | por_st_s | char (2) |
| Company | com_s | char (2) |
| Region | reg_s | char (2) |
| Office | off_s | char (3) |
| Name code - officer
Only applicable for credit, funding or document approval records. |
officer_s | char (9) |
| Name codes
Only applicable for financial institution, CCA tax entity or salesperson records. |
dnm_code_s | char (4) |
| Collection team | col_team_s | char (4) |
| Collateral team | kol_team_s | char (4) |
| Maturing lease team | ml_team_s | char (4) |
| 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) |
def_ent_s | char (4) |
| Company code | com_code_s | char (4) |
| Cost center | cost_ctr_s | char (4) |
| Group code | grp_code_s | char (2) |
| Insurance team | ins_team_s | char (4) |
| Index name | Piece 1 | Piece 2 | Piece 3 |
|---|---|---|---|
| rnm_idx0 | rnm_flg_s | rnm_key_s | |
| rnm_idx1 | nam_s | rnm_flg_s | rnm_key_s |
LeasePak Database Reference
©
by McCue Systems Incorporated. All rights reserved.
The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, 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 McCue Systems, Inc. is prohibited.