rtx Table: Monthly Transaction
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference

rtx Table: Monthly Transaction

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6 Segment 7 Segment 8
rtx_idx0 por_s com_s reg_s off_s lse_s d_run_s t_run_s trn_count_s


Columns
Name DescriptionDatatype ¿? Allow Null
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)