rqd Table: Asset Payoff/Termination
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference

rqd Table: Asset Payoff/Termination

Child Tables

Name Description
rqdp Asset Payoff/Termination Payment Schedule

Indexes

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 DescriptionDatatype ¿? 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