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

Database Reference Sybase 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
timestamp
Record modification stamp
timestamp yes
d_ent_s
Date entered
datetime yes
d_clr_s
Clearing date
datetime 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
char(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
char(20) yes
chk_num_s
Check number
char(10) yes
amt_d
Amount
double precision yes
bal_d
Remaining check balance
double precision 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
datetime yes