LeasePak 5.1a Database Reference (Sybase)

rsu Table: Suspense

Description	Column	Datatype
Suspense number	susp_num_s	char (6)
Sybase timestamp	timestamp	timestamp
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)
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)
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)
Amount	amt_d	double precision
Remaining check balance	bal_d	double precision
Batch mumber	batch_s	char (20)
Original check amount	orig_check_d	double precision
Payment effective date	d_pmt_eff_s	datetime
Clearing indicator (Y/N)	clearing_c	char (1)
Automatically apply suspense to IBL (Y/N)	auto_ibl_pmt_c	char (1)
Payment origination code	orig_s	char (4)
Check number	chk_num_s	char (10)
Amount from auction	auction_amt_c	char (1)

Index name	Piece 1	Piece 2	Piece 3	Piece 4	Piece 5	Piece 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