rpo Table: Repo Asset
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rpo Table: Repo Asset

Indexes

Name Segment 1
rpo_idx0 unit_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
unit_s
Asset
char(10) no
timestamp
Record modification stamp
timestamp yes
red_hold_c
Hold till redemption
char(1) yes
sale_rel_c
Release for sale
char(1) yes
spec_hndl_c
Special handling
char(1) yes
redeem_c
Able to redeem (Y/N)
char(1) yes
lh_claim_stat_s
Lien holders claim status
char(4) yes
repo_reason_s
Repossesion reason
char(4) yes
nam_s
Repossesion location name
char(36) yes
contact_name_s
Contact name
char(25) yes
add_s
Address
char(36) yes
add2_s
Address 2
char(36) yes
cty_s
City
char(25) yes
st_s
State code (RST.ST_S code)
char(2) yes
zip_s
Zip code
char(9) yes
phn_long_s
Phone number and extension
char(14) yes
alt_nam_s
Alternate location name
char(36) yes
alt_cont_name_s
Alternate contact name
char(25) yes
alt_add_s
Alternate address
char(36) yes
alt_add2_s
Alternate address 2
char(36) yes
alt_cty_s
Alternate city
char(25) yes
alt_st_s
Alternate state
char(2) yes
alt_zip_s
Alternate zip
char(9) yes
alt_phn_long_s
Alternate phone and extension
char(14) yes
rec_add_s
Recovery address
char(36) yes
rec_add2_s
Recovery address 2
char(36) yes
rec_cty_s
Recovery city
char(25) yes
rec_st_s
Recovery state
char(2) yes
rec_zip_s
Recovery zip
char(9) yes
str_nam_s
Storage name
char(36) yes
str_cont_name_s
Storage contact name
char(25) yes
str_add_s
Storage address
char(36) yes
str_add2_s
Storage address 2
char(36) yes
str_cty_s
Storage city
char(25) yes
str_st_s
Storage state
char(2) yes
str_zip_s
Storage zip
char(9) yes
str_phn_long_s
Storage phone and extension
char(14) yes
spec_instr_s
Special instructions
char(220) yes
spec_hndl_instr_s
Special handling instructions
char(220) yes
repo_instr_s
Repossesion instructions
char(4) yes
repo_ref_s
Referred for repossesion by
char(3) yes
repo_aprv_s
Approved for repossesion by
char(3) yes
d_repo_s
Repossession date
datetime yes
d_sale_rdy_s
Available for sale date
datetime yes
d_sale_rel_s
Release for sale date
datetime yes
d_sale_s
Sale date of vehicle/asset
datetime yes
d_payoff_s
Payoff quote date
datetime yes
repo_miles_l
Mileage of repossessed vehicle
integer yes
avg_exp_d
Average recovery expense
double precision yes
avg_whlsl_d
Average wholesale value
double precision yes
claim_filed_c
Lien claim filed (Y/N)
char(1) yes