---

LeasePak 5.1a Database Reference (Sybase)

Home • Table • Indexes

---

rtn Table: Note Payable General Ledger Transaction

Description	Column	Datatype
Portfolio	por_s	char (2)
Company	com_s	char (2)
Region	reg_s	char (2)
Office	off_s	char (3)
Note attached to lease	note_s	char (10)
Run date	d_run_s	datetime
Run time	t_run_s	char (6)
Transaction counter	trn_count_s	char (2)
Sybase timestamp	timestamp	timestamp
Effective date of payment	d_eff_s	datetime
Payment due date	d_pmtdu_s	datetime
Transaction code	trn_s	char (4)
Payoff transaction code	ptrn_s	char (4)
Operator initials	opr_s	char (3)
Account credit vector	crdt_l	integer
Account debit vector	dbt_l	integer
Amount of money change	chg_d	double precision

rtn Indexes:

Index name	Piece 1	Piece 2	Piece 3	Piece 4	Piece 5	Piece 6	Piece 7	Piece 8
rtn_idx0	por_s	com_s	reg_s	off_s	note_s	d_run_s	t_run_s	trn_count_s

---

Home • Table • Indexes

(c) Copyright 2004 McCue Systems, Inc.