rht Table: Historical Payment
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rht Table: Historical Payment

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4
rht_idx0 lse_s d_run_s t_run_s trn_count_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
trn_count_s
Transaction counter
char(2) no
timestamp
Record modification stamp
timestamp yes
d_eff_s
Effective date of payment
datetime yes
d_due_s
Payment due date
datetime yes
trn_s
Transaction code
char(4) yes
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
char(1) yes
opr_s
Operator initials
char(3) yes
invo_s
Invoice number
char(8) yes
chk_num_s
Check number
char(10) yes
amt_d
Amount
double precision yes
comments_s
Comments
char(36) yes
bank_s
Bank account GL vector
  '  1' - If multiple banks module is purchased
  '   ' - multiple banks module is not purchased
char(3) yes