LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

roa Table: Dead Application

Description Column Datatype
Application app_s char (10)
Oracle row stamp stamp_l number (10)
Lessee number les_s char (9)
Application entry date d_ent_s date
Rejected/withdrawn date d_rem_s date
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 varchar2 (36)
Rejection/withdrawal operator initials opr_s char (3)
Original acquisition cost org_d number (15,2)
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 date

roa Indexes:

Index name Piece 1 Piece 2
roa_idx0 app_s
roa_idx1 les_s app_s


HomeTableIndexes