rcx Table: Client Search
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference

rcx Table: Client Search

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4
rcx_idx0 client_s_name_s client_id_s client_rel_s client_dba_c
rcx_idx1 client_id_s client_rel_s client_dba_c  
rcx_idx2 ss_s client_id_s client_rel_s client_dba_c


Columns
Name DescriptionDatatype ¿? Allow Null
client_s_name_s
Client short name
Record modification stamp
client_id_s
Client
client_rel_s
Client relation
  CUS - Customer
  LES - Lessee/Co-lessee
  HLS - Historical Lessee/Co-lessee
  INV - Investor
  BRK - Broker
  VND - Vendor
  GRT - Guarantor
  LEN - Lender
  *** - User-defined
client_dba_c
Client DBA indicator (' '/'D')
ss_s
SS/Bus ID
short_add_s
Compacted address1
short_cty_s
Compacted city
st_s
State code (RST.ST_S code)
bus_phn_s
Business phone