rsu Table: Suspense
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rsu Table: Suspense

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6
rsu_idx0 susp_num_s          
rsu_idx1 lse_s susp_num_s        
rsu_idx2 por_s com_s reg_s off_s lse_s susp_num_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
susp_num_s
Suspense number
char(6) no
timestamp
Record modification stamp
timestamp yes
por_s
Portfolio
char(2) no
com_s
Company
char(2) no
reg_s
Region
char(2) no
off_s
Office
char(3) no
lse_s
Lease
char(10) no
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
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
amt_d
Amount
double precision yes
bal_d
Remaining check balance
double precision yes
batch_s
Cash control batch number
char(20) yes
orig_check_d
Original check amount
double precision yes
d_pmt_eff_s
Payment effective date
datetime yes
clearing_c
Clearing indicator (Y/N)
char(1) yes
auto_ibl_pmt_c
Automatically apply suspense to IBL (Y/N)
char(1) yes
orig_s
Payment origination code
char(4) yes
chk_num_s
Check number
char(10) yes
auction_amt_c
Amount from auction
char(1) yes
ud_sus_type_s
User defined suspense type (SUS.UD code)
char(4) yes
d_fol_s
Follow-up date
datetime yes