rhb Table: Historical Client Billing Receivable
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rhb Table: Historical Client Billing Receivable

Child Tables

Name Description
rhba Historical Client Billing Receivable Assessment

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6 Segment 7
rhb_idx0 por_s com_s reg_s off_s client_id_s client_rel_s d_pmtdu_s
rhb_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
client_id_s
Client
char(9) no
client_rel_s
Client relation
  LES - Lessee/Co-lessee
char(3) no
d_pmtdu_s
Payment due date
datetime no
invo_s
Invoice number
char(8) no
timestamp
Record modification stamp
timestamp yes
bank_s
Bank account GL vector
  '  1' - If multiple banks module is purchased
  '   ' - multiple banks module is not purchased
char(3) yes
tamt_b_d
Total amount billed
double precision yes
tamt_p_d
Total amount paid
double precision yes