LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexesParent

rapa Table: Application 2

Description Column Datatype
Application app_s char (10)
Record number unique_l number (10)
Oracle row stamp stamp_l number (10)
Staged equity amount stg_eqty_d number (15,2)
Leveraged (Y/N) lvr_c char (1)
Leveraged commencement date d_lvr_com_s date
Date of last leveraged table download d_lst_lvr_s date
Leveraged term lvr_trm_l number (10)
Staged equity fund payable to stg_eqty_pay_to_s char (9)
Non-pyramiding late charge minimum payment due npyr_min_d number (15,2)
Notebook follow-up days note_follow_up_l number (10)
FASB 13 test date d_fasb13_test_s date
FASB 13 test result (P/F/' ')
  P - Pass
  F - Fail
  ' ' - Untested
fasb13_test_c char (1)
Originating interface (MBT / MPR / STM)
   MBT - Microbilt
   MPR - mPower
   STM - SuperTrump
orig_intfc_s char (3)
Metro2 file format code metro2_s char (4)
Invoice format code invo_format_s char (4)
Non commission amount non_comm_d number (15,2)
Optional residual opt_res_d number (15,2)
Optional residual percentage p_opt_res_d number (15,5)

rapa Indexes:

Index name Piece 1 Piece 2
rapa_idx0 app_s unique_l


HomeTableIndexesParent