LeasePak 5.1a Database Reference (Sybase)
Home
Table
Indexes
Children
Description |
Column |
Datatype |
Lender
|
len_s |
char (9) |
Sybase timestamp
|
timestamp |
timestamp |
Relationship established date
|
d_est_s |
datetime |
Status date
|
d_stat_s |
datetime |
Activity status
|
stat_s |
char (4) |
Remittance type
|
rmt_type_s |
char (4) |
Recourse type
|
rec_s |
char (4) |
Letter version code
|
lt_version_s |
char (4) |
Default portfolio
|
def_por_s |
char (2) |
Default company
|
def_com_s |
char (2) |
Default region
|
def_reg_s |
char (2) |
Default office
|
def_off_s |
char (3) |
Name
|
nam_s |
char (36) |
Address
|
add_s |
char (36) |
Address 2
|
add2_s |
char (36) |
City
|
cty_s |
char (25) |
State
|
st_s |
char (2) |
Zip code
|
zip_s |
char (9) |
Phone number
|
phn_s |
char (10) |
Remittance name
|
rmt_nam_s |
char (36) |
Remittance address
|
rmt_add_s |
char (36) |
Remittance address 2
|
rmt_add2_s |
char (36) |
Remittance city
|
rmt_cty_s |
char (25) |
Remittance state
|
rmt_st_s |
char (2) |
Remittance zip code
|
rmt_zip_s |
char (9) |
Contact name
|
cont_nam_s |
char (36) |
Contact title
|
cont_title_s |
char (25) |
Comments [1]
|
commt1_s |
char (80) |
Comments [2]
|
commt2_s |
char (80) |
Email address
|
email_s |
char (50) |
Index name |
Piece 1 |
rle_idx0 |
len_s |
Table |
Description |
rlec |
Lender Credit Line |
Home
Table
Indexes
Children
(c) Copyright 2004 McCue Systems, Inc.