rhx Table: Historical Transaction for Lease Extension/Reversal
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference

rhx Table: Historical Transaction for Lease Extension/Reversal

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5
rhx_idx0 lse_s ext_num_s d_run_s t_run_s trn_count_s


Columns
Name DescriptionDatatype ¿? Allow Null
ext_num_s
Extension
por_s
Portfolio
com_s
Company
reg_s
Region
off_s
Office
lse_s
Lease
d_run_s
Run date
t_run_s
Run time
trn_count_s
Transaction counter
Record modification stamp
d_eff_s
Effective date
d_indu_s
Invoice due date
trn_s
Transaction code
ptrn_s
Payoff transaction code
skip_c
Skip transfer to historical (Y/N)
ar_typ_c
A/R type flag (I/J/M/P/Q)
  I - Invoice
  J - Overlapped due dates
  M - Credit memo
  P - Off Lease Billing of asset payoff
  Q - Off Lease Billing of lease payoff
late_c
Late charges calculated (Y/N)
opr_s
Operator initials
invo_s
Invoice number
unit_s
Asset
num_s
Suspense number
chk_num_s
Check number
crdt_l
Account credit vector
dbt_l
Account debit vector
chg_d
Amount of money change
trn_rsn_s
Transaction reason code (TRN.RSN code)
comments_s
Comments
waive_c
Waived Principal/payment interest record (Y/N)