rha Table: Historical Accounts Receivable
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rha Table: Historical Accounts Receivable

Child Tables

Name Description
rhab Historical Accounts Receivable Assessment

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6 Segment 7
rha_idx0 por_s com_s reg_s off_s lse_s d_pmtdu_s ar_typ_c
rha_idx1 invo_s            

    
Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
CHAR(2) no
com_s
Company
CHAR(2) no
reg_s
Region
CHAR(2) no
off_s
Office
CHAR(3) no
lse_s
Lease
CHAR(10) no
d_pmtdu_s
Payment due date
DATE no
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) no
stamp_l
Record modification stamp
NUMBER(10) no
invo_s
Invoice number
CHAR(8) no
d_last_s
Date of last update
DATE yes
bank_s
Bank account GL vector
  '  1' - If multiple banks module is purchased
  '   ' - multiple banks module is not purchased
CHAR(3) yes
ptax_desc_s
Property tax description code
CHAR(4) yes
fhut_desc_s
Federal highway use tax (FHUT) description code
CHAR(4) yes
grp_c
Group switch (Y/N)
CHAR(1) yes
pay_c
A/R payoff switch (Y/N)
CHAR(1) yes
prin_bill_c
Principal bill switch (B/N)
CHAR(1) yes
int_bill_c
Interest bill switch (B/N)
CHAR(1) yes
auto_ltch_assessed_c
Automatic late charges assessed (Y/N)
CHAR(1) yes
car_d
Interest carryover
NUMBER(15,2) yes
tamt_p_d
Total amount paid
NUMBER(15,2) yes
pamt_b_d
Payment amount billed
NUMBER(15,2) yes
pamt_p_d
Payment amount paid
NUMBER(15,2) yes
iamt_b_d
Interest amount billed
NUMBER(15,2) yes
iamt_p_d
Interest amount paid
NUMBER(15,2) yes
int_d
Interest portion - memo account
NUMBER(15,2) yes
int_adj_d
Interest adjustment
NUMBER(15,2) yes
prin_stax_c
Principal sales tax (Y/N)
CHAR(1) yes
int_stax_c
Interest sales tax (Y/N)
CHAR(1) yes
org_iamt_b_d
Interest amount billed when invoice 1st created
NUMBER(15,2) yes
delq_category_l
Current delinquency category
NUMBER(10) yes
late_int_d
Interest paid after due date
NUMBER(15,2) yes
olb_payoff_c
Off lease billing payoff/termination flag (T/P/' ')
  T   - Termination and off lease billing P or Q invoice
  P   - Payoff and off lease billing P or Q invoice
  ' ' - not off lease billing P or Q invoice
CHAR(1) yes
tamt_p_after_payoff_d
Total amount paid after payoff
NUMBER(15,2) yes
pamt_p_after_payoff_d
Payment amount paid after payoff
NUMBER(15,2) yes
iamt_p_after_payoff_d
Interest amount paid after payoff
NUMBER(15,2) yes
vtx_o_c
Use Vertex O (Y/N/NULL)
  Y - Vertex O is used
  N or NULL - Vertex O is not used
CHAR(1) yes
paid_off_ck_c
Lease change-keyed after payoff (Y/' ')
  Y - Lease was change-keyed
  ' ' - Lease was not change-keyed
CHAR(1) yes