rarb Table: Accounts Receivable Assessment
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rarb Table: Accounts Receivable Assessment

Parent Table

Name Description
rar Accounts Receivable

Indexes

Name Segment 1 Segment 2
rarb_idx0 invo_s unique_l

    
Columns
Name DescriptionDatatype ¿? Allow Null
invo_s
Invoice number
CHAR(8) no
unique_l
Record number (possible values are 1 to 25)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
por_s
Portfolio
CHAR(2) yes
a_typ_s
Assessment type
CHAR(4) yes
bill_c
Assessment bill switch (B/N)
CHAR(1) yes
asm_stax_c
Sales tax on assessment (Y/N)
CHAR(1) yes
aamt_b_d
Assessment amount billed
NUMBER(15,2) yes
aamt_p_d
Assessment amount paid
NUMBER(15,2) yes
d_assmt_bill_s
Date assessment billed
DATE yes
aamt_p_after_payoff_d
Assessment amount paid after payoff
NUMBER(15,2) yes