LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

res Table: Equity Movement Status

Description Column Datatype
Asset unit_s char (10)
Equipment movement status date d_eqt_move_s date
Run time t_run_s char (6)
Oracle row stamp stamp_l number (10)
Equipment activity status date d_eqt_s date
Movement code mov_s char (4)
Equipment activity status eqt_s char (4)
Equipment state st_s char (2)
Equipment county ct_s char (4)
Equipment city cy_s char (4)
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)
Equipment street address add_s varchar2 (36)
Equipment zip code zip_s char (9)
Equipment starting cost eq_strt_d number (15,2)
Residual amount res_d number (15,2)
Federal book value fd_book_d number (15,2)
State book value st_book_d number (15,2)

res Indexes:

Index name Piece 1 Piece 2 Piece 3
res_idx0 unit_s d_eqt_move_s t_run_s


HomeTableIndexes