LeasePak 5.1a Database Reference (Sybase)

rpn Table: Check Payment Detail

Description	Column	Datatype
Batch date	d_batch_s	datetime
Batch number	batch_num_s	char (6)
Batch sequence number	batch_seq_num_s	char (8)
Batch payment number	batch_pmt_num_s	char (4)
Sybase timestamp	timestamp	timestamp
Lease	lse_s	char (10)
Posting date	d_post_s	datetime
Transfer/reversal date	d_out_s	datetime
Assessment type	a_typ_s	char (4)
Transaction type (type of transfer/reversal)	trn_type_s	char (4)
Invoice number	invo_s	char (8)
Operator initials	opr_s	char (3)
Reversal operator initials	opr_r_s	char (3)
Transfer payment number	tran_pmt_s	char (4)
Amount	amt_d	double precision
Transaction reason code	trn_rsn_s	char (4)
Payoff transaction type (P/T)	payoff_tran_typ_c	char (1)
Payment origination code	orig_s	char (4)
Payment reversal origination code	orig_r_s	char (4)
Invoice due date	d_invo_s	datetime

Index name	Piece 1	Piece 2	Piece 3	Piece 4	Piece 5
rpn_idx0	d_batch_s	batch_num_s	batch_seq_num_s	batch_pmt_num_s
rpn_idx1	lse_s	d_batch_s	batch_num_s	batch_seq_num_s	batch_pmt_num_s