LeasePak 5.1a Database Reference (Sybase)

rbs Table: Batch Assessment

Description	Column	Datatype
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)
Run date	d_run_s	datetime
Run time	t_run_s	char (6)
Unique portion for key	unique_s	char (5)
Sybase timestamp	timestamp	timestamp
Asset	unit_s	char (10)
Assessment type	a_typ_s	char (4)
Invoice number	invo_s	char (8)
Transaction reason code	trn_rsn_s	char (4)
Property tax description code	ptax_desc_s	char (4)
Federal highway use tax (FHUT) description code	fhut_desc_s	char (4)
Assessment level L=Lease A=Asset	a_lvl_c	char (1)
Payment due date	d_pmtdu_s	datetime
Last lien date	d_lien_s	datetime
Assessment amount billed	aamt_b_d	double precision

Index name	Piece 1	Piece 2	Piece 3	Piece 4	Piece 5	Piece 6	Piece 7	Piece 8
rbs_idx0	por_s	com_s	reg_s	off_s	lse_s	d_run_s	t_run_s	unique_s