LeasePak 5.1a Database Reference (Sybase)
Home •
Table •
Indexes
| Description |
Column |
Datatype |
| Asset
|
unit_s |
char (10) |
| Sybase timestamp
|
timestamp |
timestamp |
| Hold till redemption
|
red_hold_c |
char (1) |
| Release for sale
|
sale_rel_c |
char (1) |
| Special handling
|
spec_hndl_c |
char (1) |
| Able to redeem (Y/N)
|
redeem_c |
char (1) |
| Lien holders claim status
|
lh_claim_stat_s |
char (4) |
| Repossesion reason
|
repo_reason_s |
char (4) |
| Repossesion location name
|
nam_s |
char (36) |
| Contact name
|
contact_name_s |
char (25) |
| 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 and extension
|
phn_long_s |
char (14) |
| Alternate location name
|
alt_nam_s |
char (36) |
| Alternate contact name
|
alt_cont_name_s |
char (25) |
| Alternate address
|
alt_add_s |
char (36) |
| Alternate address 2
|
alt_add2_s |
char (36) |
| Alternate city
|
alt_cty_s |
char (25) |
| Alternate state
|
alt_st_s |
char (2) |
| Alternate zip
|
alt_zip_s |
char (9) |
| Alternate phone and extension
|
alt_phn_long_s |
char (14) |
| Recovery address
|
rec_add_s |
char (36) |
| Recovery address 2
|
rec_add2_s |
char (36) |
| Recovery city
|
rec_cty_s |
char (25) |
| Recovery state
|
rec_st_s |
char (2) |
| Recovery zip
|
rec_zip_s |
char (9) |
| Storage name
|
str_nam_s |
char (36) |
| Storage contact name
|
str_cont_name_s |
char (25) |
| Storage address
|
str_add_s |
char (36) |
| Storage address 2
|
str_add2_s |
char (36) |
| Storage city
|
str_cty_s |
char (25) |
| Storage state
|
str_st_s |
char (2) |
| Storage zip
|
str_zip_s |
char (9) |
| Storage phone and extension
|
str_phn_long_s |
char (14) |
| Special instructions
|
spec_instr_s |
char (220) |
| Special handling instructions
|
spec_hndl_instr_s |
char (220) |
| Repossesion instructions
|
repo_instr_s |
char (4) |
| Referred for repossesion by
|
repo_ref_s |
char (3) |
| Approved for repossesion by
|
repo_aprv_s |
char (3) |
| Repossession date
|
d_repo_s |
datetime |
| Available for sale date
|
d_sale_rdy_s |
datetime |
| Release for sale date
|
d_sale_rel_s |
datetime |
| Sale date of vehicle/asset
|
d_sale_s |
datetime |
| Payoff quote date
|
d_payoff_s |
datetime |
| Mileage of repossessed vehicle
|
repo_miles_l |
integer |
| Average recovery expense
|
avg_exp_d |
double precision |
| Average wholesale value
|
avg_whlsl_d |
double precision |
| Lien claim filed (Y/N)
|
claim_filed_c |
char (1) |
| Index name |
Piece 1 |
| rpo_idx0 |
unit_s |
Home •
Table •
Indexes
(c) Copyright 2004 McCue Systems, Inc.