LeasePak 5.2a Database Reference (Sybase)

HomeTableIndexes

ruc Table: User Defined Client

Description Column Datatype
Client client_id_s char (9)
Client relation
  CUS - Customer
  LES - Lessee/Co-lessee
  HLS - Historical Lessee/Co-lessee
  INV - Investor
  BRK - Broker
  VND - Vendor
  GRT - Guarantor
  LEN - Lender
client_rel_s char (3)
Sybase timestamp timestamp timestamp
Activity status stat_s char (4)
Default portfolio def_por_s char (2)
Default company def_com_s char (2)
Default region def_reg_s char (2)
Default office def_off_s char (3)
Name nam_s char (36)
Address add_s char (36)
Address 2 add2_s char (36)
City cty_s char (25)
State st_s char (2)
Zip code zip_s char (9)
Phone number phn_s char (10)
Contact name cont_nam_s char (36)
Contact title cont_title_s char (25)
Letter version code lt_version_s char (4)
Email address email_s char (50)

ruc Indexes:

Index name Piece 1 Piece 2
ruc_idx0 client_id_s client_rel_s


HomeTableIndexes