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

Database Reference Sybase DBMS

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
char(10) no
d_run_s
Run date
datetime no
t_run_s
Run time
char(6) no
batch_num_s
Batch number
char(6) no
unit_s
Asset
char(10) no
timestamp
Record modification stamp
timestamp yes
p_typ_c
Payoff transaction type
  P - Payoff
  T - Termination
char(1) yes
eqt_s
Equipment activity status
char(4) yes
opr_s
Operator initials
char(3) yes
sec_status_c
Security deposit disbursal status (P/U/N)
  P - processed
  U - unprocessed
  N - n/a
char(1) yes
trn_s
Transaction code
char(4) yes
d_rev_s
Reversal date
datetime yes
add_d
Additional charges
double precision yes
allow_d
Allowance for bad debt
double precision yes
asm_pay_d
Assessments outstanding for payoff
double precision yes
base_d
Base payoff amount
double precision yes
payoff_chk_d
Payoff check amount
double precision yes
fee_d
Fee/penalty
double precision yes
fmv_d
Fair market value
double precision yes
gnls_d
Gain/Loss on termination
double precision yes
pmt_amt_d
Asset payment amount
double precision yes
pmt_pay_d
Payments outstanding for payoff
double precision yes
refund_d
Refund check amount
double precision yes
res_d
Residual amount
double precision yes
sec_d
Security deposit
double precision yes
total_rec_d
Total amount received
double precision yes
valuat_res_d
Valuation reserve
double precision yes