| Name | Segment 1 |
|---|---|
| rpo_idx0 | unit_s |
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | 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) |
||