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

Database Reference Oracle DBMS

rcb Table: Client Billing Receivable

Child Tables

Name Description
rcba Client Billing Receivable Assessment

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6 Segment 7
rcb_idx0 por_s com_s reg_s off_s client_id_s client_rel_s d_pmtdu_s
rcb_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
DATE no
invo_s
Invoice number
CHAR(8) no
stamp_l
Record modification stamp
NUMBER(10) no
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
NUMBER(15,2) yes
tamt_p_d
Total amount paid
NUMBER(15,2) yes