LeasePak 5.1a Database Reference (Sybase)

rsr Table: Suspense Reversal

Description	Column	Datatype
Suspense number	susp_num_s	char (6)
Sybase timestamp	timestamp	timestamp
Date entered	d_ent_s	datetime
Clearing date	d_clr_s	datetime
Type of suspense item	sus_type_s	char (4)
Deletion reason	sus_rsn_s	char (4)
Operator initials	opr_s	char (3)
Comments	comments_s	char (36)
Portfolio	por_s	char (2)
Company	com_s	char (2)
Region	reg_s	char (2)
Office	off_s	char (3)
Lease	lse_s	char (10)
Assigned to operator	asg_s	char (3)
Receivable bank account G/L vector	recv_bank_s	char (3)
Disbursal bank account G/L vector	disb_bank_s	char (3)
Clear suspend G/L account	clr_accnt_s	char (3)
Reversal origination code	rev_orig_s	char (4)
Reversal batch number	rev_batch_s	char (20)
Check number	chk_num_s	char (10)
Amount	amt_d	double precision
Remaining check balance	bal_d	double precision
Reversal reason code	rev_rsn_s	char (4)

Index name	Piece 1	Piece 2
rsr_idx0	susp_num_s
rsr_idx1	lse_s	susp_num_s