Name | Description |
---|---|
rqdp | Asset Payoff/Termination Payment Schedule |
Name | Segment 1 | Segment 2 | Segment 3 | Segment 4 | Segment 5 |
---|---|---|---|---|---|
rqd_idx0 | lse_s | d_run_s | t_run_s | batch_num_s | unit_s |
rqd_idx1 | batch_num_s | unit_s | lse_s | d_run_s | t_run_s |
rqd_idx2 | unit_s | lse_s | d_run_s | t_run_s | batch_num_s |
Columns | |||
---|---|---|---|
Name | Description | Datatype ¿? | Allow Null |
lse_s | Lease |
||
d_run_s | Run date |
||
t_run_s | Run time |
||
batch_num_s | Batch number |
||
unit_s | Asset |
||
Record modification stamp |
|||
p_typ_c | Payoff transaction type P - Payoff T - Termination |
||
eqt_s | Equipment activity status |
||
opr_s | Operator initials |
||
sec_status_c | Security deposit disbursal status (P/U/N) P - processed U - unprocessed N - n/a |
||
trn_s | Transaction code |
||
d_rev_s | Reversal date |
||
add_d | Additional charges |
||
allow_d | Allowance for bad debt |
||
asm_pay_d | Assessments outstanding for payoff |
||
base_d | Base payoff amount |
||
payoff_chk_d | Payoff check amount |
||
fee_d | Fee/penalty |
||
fmv_d | Fair market value |
||
gnls_d | Gain/Loss on termination |
||
pmt_amt_d | Asset payment amount |
||
pmt_pay_d | Payments outstanding for payoff |
||
refund_d | Refund check amount |
||
res_d | Residual amount |
||
sec_d | Security deposit |
||
total_rec_d | Total amount received |
||
valuat_res_d | Valuation reserve |