LeasePak 5.2a Database Reference (Sybase)

HomeTableIndexes

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


HomeTableIndexes