LeasePak 5.2a Database Reference (Sybase)

HomeTableIndexes

rut Table: User Defined Tables Description

Description Column Datatype
Portfolio por_s char (2)
User-defined table type (APP/CUS/LES/LSE/UNI/VND)
  APP - Application tables
  CUS - Customer tables
  LES - Lessee tables
  LSE - Lease tables
  UNI - Asset tables
  VND - Vendor tables
udt_type_s char (3)
Sybase timestamp timestamp timestamp
User-defined table code check (Y/N) tcod_s char (12)
User-defined table input required (Y/N) tir_s char (12)
User-defined table edit check (N/D)
   N - numeric
   D - date
tedt_s char (12)
User-defined application table to transfer to lease (Y/N) txfer_s char (12)
User-defined table header [1] thed1_s char (12)
User-defined table header [2] thed2_s char (12)
User-defined table header [3] thed3_s char (12)
User-defined table header [4] thed4_s char (12)
User-defined table header [5] thed5_s char (12)
User-defined table header [6] thed6_s char (12)
User-defined table header [7] thed7_s char (12)
User-defined table header [8] thed8_s char (12)
User-defined table header [9] thed9_s char (12)
User-defined table header [10] thed10_s char (12)
User-defined table header [11] thed11_s char (12)
User-defined table header [12] thed12_s char (12)

rut Indexes:

Index name Piece 1 Piece 2
rut_idx0 por_s udt_type_s


HomeTableIndexes