LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexesParent

rhsr Table: Historical Lease Recurring Charge for Lease Extension/Reversal

Description Column Datatype
Extension ext_num_s char (2)
Lease lse_s char (10)
Record number unique_l number (10)
Oracle row stamp stamp_l number (10)
Portfolio por_s char (2)
Recurring charge code rcr_s char (4)
Recurring charge start date d_srcr_s date
Recurring charge maturity date d_mrcr_s date
Recurring charge payable to broker rcr_pay_brk_s char (9)
Recurring charge payable to dealer rcr_pay_dlr_s char (9)
Recurring charge amount rcr_amt_d number (15,2)
Bundle recurring charge on invoice bundle_rcr_c char (1)

rhsr Indexes:

Index name Piece 1 Piece 2 Piece 3
rhsr_idx0 lse_s ext_num_s unique_l


HomeTableIndexesParent