rhqu Table: Historical Asset UCC for Lease Extension/Reversal
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rhqu Table: Historical Asset UCC for Lease Extension/Reversal

Parent Table

Name Description
rhq Historical Asset for Lease Extension/Reversal

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4
rhqu_idx0 lse_s ext_num_s unit_s unique_l

    
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
CHAR(10) no
ext_num_s
Extension
CHAR(2) no
unit_s
Asset
CHAR(10) no
unique_l
Record number (possible values are 1 to 5)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
d_ucc_s
Title filings - filing date
DATE yes
ucc_st_s
Title filings - state of filing
CHAR(2) yes
ucc_s
Title filings - filing code
CHAR(4) yes
ucc_typ_s
Title filing type
CHAR(4) yes
ucc_cnty_s
Title county of filing
CHAR(4) yes
ucc_num_s
Title file number
VARCHAR2(25) yes
ucc_trm_l
Title filings - term
NUMBER(10) yes