rna Table: Non-Lease Address
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rna Table: Non-Lease Address

Indexes

Name Segment 1 Segment 2
rna_idx0 rna_flg_c rna_code_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
rna_flg_c
Key flag
  1 - Collection agency
  3 - Credit bureau
  4 - Legal firm
  8 - Remittance address
  9 - Regional code
CHAR(1) no
rna_code_s
Non lease code
CHAR(4) no
stamp_l
Record modification stamp
NUMBER(10) no
nam_s
Name
VARCHAR2(36) yes
long_add1_s
Address 1
VARCHAR2(36) yes
add2_s
Address 2
VARCHAR2(36) yes
cty_s
City
VARCHAR2(25) yes
st_s
State code (RST.ST_S code)
CHAR(2) yes
zip_s
Zip code
CHAR(9) yes
phn_s
Phone number
CHAR(10) yes
cont_nam_s
Contact name
VARCHAR2(36) yes
cont_title_s
Contact title
VARCHAR2(25) yes