LeasePak 5.2a Database Reference (Sybase)

HomeTableIndexes

roa Table: Dead Application

Description Column Datatype
Application app_s char (10)
Sybase timestamp timestamp timestamp
Lessee number les_s char (9)
Application entry date d_ent_s datetime
Rejected/withdrawn date d_rem_s datetime
Last application status lst_app_stat_s char (4)
Rejection reason [1] reason1_s char (4)
Rejection reason [2] reason2_s char (4)
Rejection reason [3] reason3_s char (4)
Rejection reason [4] reason4_s char (4)
Rejection reason [5] reason5_s char (4)
Rejection reason [6] reason6_s char (4)
Application description desc_s char (36)
Rejection/withdrawal operator initials opr_s char (3)
Original acquisition cost org_d double precision
Portfolio por_s char (2)
Company com_s char (2)
Region reg_s char (2)
Office off_s char (3)
Date created d_create_s datetime

roa Indexes:

Index name Piece 1 Piece 2
roa_idx0 app_s
roa_idx1 les_s app_s


HomeTableIndexes