LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rdh Table: Dealer Transaction History

Description Column Datatype
Disbursement date d_dis_s date
Portfolio por_s char (2)
Vendor dlr_s char (9)
Lease lse_s char (10)
Run date d_run_s date
Run time t_run_s char (6)
Unique portion for key unique_s char (5)
Oracle row stamp stamp_l number (10)
Transaction type tran_s char (4)
Transaction reason code trn_rsn_s char (4)
Disbursement time t_dis_s char (6)
Date cashier's check was printed d_printed_s date
Time cashier's check was printed t_printed_s char (6)
Reversal date d_rev_s date
Check number chk_s char (6)
Transaction amount tx_d number (15,2)

rdh Indexes:

Index name Piece 1 Piece 2 Piece 3 Piece 4 Piece 5 Piece 6 Piece 7
rdh_idx0 d_dis_s por_s dlr_s lse_s d_run_s t_run_s unique_s


HomeTableIndexes