rsr Table: Suspense Reversal
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rsr Table: Suspense Reversal

Indexes

Name Segment 1 Segment 2
rsr_idx0 susp_num_s  
rsr_idx1 lse_s susp_num_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
susp_num_s
Suspense number
CHAR(6) no
stamp_l
Record modification stamp
NUMBER(10) no
d_ent_s
Date entered
DATE yes
d_clr_s
Clearing date
DATE yes
sus_type_s
Type of suspense item
CHAR(4) yes
sus_rsn_s
Deletion reason
CHAR(4) yes
opr_s
Operator initials
CHAR(3) yes
sus_comments_s
Suspense comments
VARCHAR2(100) yes
por_s
Portfolio
CHAR(2) yes
com_s
Company
CHAR(2) yes
reg_s
Region
CHAR(2) yes
off_s
Office
CHAR(3) yes
lse_s
Lease
CHAR(10) no
asg_s
Assigned to operator
CHAR(3) yes
recv_bank_s
Receivable bank account GL vector
CHAR(3) yes
disb_bank_s
Disbursal bank account GL vector
CHAR(3) yes
clr_accnt_s
Clear suspend GL account
CHAR(3) yes
rev_orig_s
Reversal origination code
CHAR(4) yes
rev_batch_s
Reversal batch number
VARCHAR2(20) yes
chk_num_s
Check number
CHAR(10) yes
amt_d
Amount
NUMBER(15,2) yes
bal_d
Remaining check balance
NUMBER(15,2) yes
rev_rsn_s
Reversal reason code
CHAR(4) yes
ud_sus_type_s
User defined suspense type (SUS.UD code)
CHAR(4) yes
d_fol_s
Follow-up date
DATE yes