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

Database Reference

rpo Table: Repo Asset

Indexes

Name Segment 1
rpo_idx0 unit_s


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