LeasePak 5.1a Database Reference (Sybase)
Home •
Table •
Indexes
| Description |
Column |
Datatype |
| Customer number
|
cus_s |
char (9) |
| Group number
|
grp_s |
char (3) |
| Sybase timestamp
|
timestamp |
timestamp |
| Last payment date
|
d_pay_s |
datetime |
| Financial statement date
|
d_fin_s |
datetime |
| Accrual type
|
acc_typ_s |
char (4) |
| Delinquency watch code
|
del_s |
char (4) |
| Credit status code
|
crd_s |
char (4) |
| Bankruptcy filed (Y/N)
|
bnkr_c |
char (1) |
| Group payment due day
|
pmt_s |
char (2) |
| First lease in group
|
first_grp_lse_s |
char (10) |
| Last lease in group
|
last_grp_lse_s |
char (10) |
| Total number of leases (as of previous EOD)
|
totl_lse_l |
integer |
| Index name |
Piece 1 |
Piece 2 |
| rfl_idx0 |
cus_s |
grp_s |
Home •
Table •
Indexes
(c) Copyright 2004 McCue Systems, Inc.