rhfc Table: Historical Lease Partial Deduction for Accrual/Billing Cycle Change/Reversal
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rhfc Table: Historical Lease Partial Deduction for Accrual/Billing Cycle Change/Reversal

Parent Table

Name Description
rhf Historical Lease for Accrual/Billing Cycle Change/Reversal

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4
rhfc_idx0 lse_s ext_num_s cycle_num_s unique_l

   
Columns
Name DescriptionDatatype ¿? Allow Null
ext_num_s
Extension
CHAR(2) no
cycle_num_s
Accrual/billing cycle change number in a given lease period
  The first lease period is from book lease to maturity.
  Each subsequent lease extension (if any) represents a
  new and separate lease period.
CHAR(2) no
lse_s
Lease
CHAR(10) no
unique_l
Record number (possible values are 1 to 81)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
rec_cd_s
Payment received code
CHAR(4) yes
received_d
Amount received
NUMBER(15,2) yes
due_comm_d
Amount due at commencement
NUMBER(15,2) yes
inv_comm_d
Amount invoiced at commencement
NUMBER(15,2) yes
ap_comm_d
Amount A/P reduced at commencement
NUMBER(15,2) yes
susp_comm_d
Amount in suspend at commencement
NUMBER(15,2) yes