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

Database Reference Oracle DBMS

rpo Table: Repo Asset

Indexes

Name Segment 1
rpo_idx0 unit_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
unit_s
Asset
CHAR(10) no
stamp_l
Record modification stamp
NUMBER(10) no
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
VARCHAR2(36) yes
contact_name_s
Contact name
VARCHAR2(25) yes
add_s
Address
VARCHAR2(36) yes
add2_s
Address 2
VARCHAR2(36) yes
cty_s
City
VARCHAR2(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
VARCHAR2(36) yes
alt_cont_name_s
Alternate contact name
VARCHAR2(25) yes
alt_add_s
Alternate address
VARCHAR2(36) yes
alt_add2_s
Alternate address 2
VARCHAR2(36) yes
alt_cty_s
Alternate city
VARCHAR2(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
VARCHAR2(36) yes
rec_add2_s
Recovery address 2
VARCHAR2(36) yes
rec_cty_s
Recovery city
VARCHAR2(25) yes
rec_st_s
Recovery state
CHAR(2) yes
rec_zip_s
Recovery zip
CHAR(9) yes
str_nam_s
Storage name
VARCHAR2(36) yes
str_cont_name_s
Storage contact name
VARCHAR2(25) yes
str_add_s
Storage address
VARCHAR2(36) yes
str_add2_s
Storage address 2
VARCHAR2(36) yes
str_cty_s
Storage city
VARCHAR2(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
VARCHAR2(220) yes
spec_hndl_instr_s
Special handling instructions
VARCHAR2(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
DATE yes
d_sale_rdy_s
Available for sale date
DATE yes
d_sale_rel_s
Release for sale date
DATE yes
d_sale_s
Sale date of vehicle/asset
DATE yes
d_payoff_s
Payoff quote date
DATE yes
repo_miles_l
Mileage of repossessed vehicle
NUMBER(10) yes
avg_exp_d
Average recovery expense
NUMBER(15,2) yes
avg_whlsl_d
Average wholesale value
NUMBER(15,2) yes
claim_filed_c
Lien claim filed (Y/N)
CHAR(1) yes