LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexesParent

rpha Table: Payment History Assessment

Description Column Datatype
Lease lse_s char (10)
Payment number pmt_num_s char (3)
Reversal date (YYYYMMDD) ymd_rev_s char (8)
Payment run date d_pmt_run_s date
Payment run time t_pmt_run_s char (6)
Record number unique_l number (10)
Oracle row stamp stamp_l number (10)
Assessment type a_typ_s char (4)
Assessment amount paid aamt_p_d number (15,2)

rpha Indexes:

Index name Piece 1 Piece 2 Piece 3 Piece 4 Piece 5 Piece 6
rpha_idx0 lse_s pmt_num_s ymd_rev_s d_pmt_run_s t_pmt_run_s unique_l


HomeTableIndexesParent