LeasePak 5.1a Database Reference (Sybase)
Home •
Table •
Indexes •
Children
| Description |
Column |
Datatype |
| Financial institution
|
fin_inst_s |
char (4) |
| Loan number
|
loan_s |
char (7) |
| Sybase timestamp
|
timestamp |
timestamp |
| Portfolio
|
por_s |
char (2) |
| Inception date
|
d_inc_s |
datetime |
| Activity date
|
d_act_s |
datetime |
| Loan accrued to date
|
d_loan_acc_s |
datetime |
| Activity status
|
act_ln_s |
char (4) |
| Accrual method
|
acc_ln_s |
char (4) |
| Loan type
|
typ_ln_s |
char (4) |
| Recourse/non-recourse (R/N)
|
recour_c |
char (1) |
| First asset in loan
|
frst_unit_s |
char (10) |
| Last asset in loan
|
last_unit_s |
char (10) |
| Next loan for equipment
|
next_loan_s |
char (11) |
| Previous loan for equipment
|
prev_loan_s |
char (11) |
| Prime rate bank number
|
prim_num_s |
char (4) |
| Comments [1]
|
commt1_s |
char (80) |
| Comments [2]
|
commt2_s |
char (80) |
| Number of payments accrued
|
pmt_l |
integer |
| Loan term
|
loan_trm_l |
integer |
| Interest rate / APR
|
p_int_d |
double precision |
| Original amount
|
orig_d |
double precision |
| Down payment
|
down_d |
double precision |
| Current principal balance
|
cur_prn_d |
double precision |
| Current month interest
|
int_cur_d |
double precision |
| Interest Y-T-D
|
int_ytd_d |
double precision |
| Interest previous year
|
int_prv_d |
double precision |
| Interest L-T-D
|
int_ltd1_d |
double precision |
| Original cost of attached assets
|
loan_org_d |
double precision |
| Index name |
Piece 1 |
Piece 2 |
Piece 3 |
| rmf_idx0 |
fin_inst_s |
loan_s |
| rmf_idx1 |
por_s |
fin_inst_s |
loan_s |
| Table |
Description |
| rmfp |
Loan Payment Schedule |
Home •
Table •
Indexes •
Children
(c) Copyright 2004 McCue Systems, Inc.